Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster.
If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing!
We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects.
The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010.
Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along.
The course will take approx 7.5 hours to complete.
Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to the course and your tutor|
Please see lecture 2, to download the template that we'll work with. There are various templates to download. Normally, they're at the start of each section. Thanks.
|Section 2: Data|
Enter numbers and fractions
Dates and Times
Download the template workbook and have a go at the same examples as the tutor.
Validate Data entry using a pick listPreview
You can extend a time increment series an hour at a time. Type any number in the step value of the series dialog box.
Excel fonts are based on Unicode. To use a language other than English and set up the appropriate keyboard, click the Windows Start Menu, click Control Panel and click Regional and Language Options.
Compare multiple spreadsheets using freeze panels
Speech recognition is no longer in Excel 2007 ... use F1 to find out more. But there is Speak Cells. So excel can read your cells to you.
Find and replace data
|Section 3: Formulas and Functions|
Try rounding 2125.123 to -2 ... the answer is 2100.000. Note - the 2,1000.000 preserves the number of digits of the original number, but rounds two places to the left of the decimal point.
Formulas with commentsPreview
Define a constant
Apply names in functions
Figure out the best loan terms
Internal Rates of Return
Nth largest value
Large, Small, Max, Min
Conditional formula with names
Calculate the duration between two times
Calculate days between two dates
|Section 4: Copying Data, Formats etc.,|
Copy a range
Transpose a row into a columnPreview
Copy styles to another workbook
And copying sheets within the workbook
Track changes while Editing
|Section 5: Lists|
Enter list data using a form
Searching through a data list
Import a word list into excel
Sort a list
Filter a list
Sort by multiple criteria
Find averages in a sorted group
Filter by multiple criteriaPreview
Remove duplicate records from a list
Count filtered records
Filter by multiple criteria in the same column
Chart a filtered list
Look up information in a List
|Section 6: Data Patterns|
Create a PivotTable
Modify a PivotTable and layout
Find the average of a field
Create a calculated field
Calculated fields and chartsPreview
Hide rows and columns in a PivotTable
AutoFormat a PivotTable
Create a PivotChart
Turning on the Data Analysis function so that statistical information can be run
Describe Data with Statistics
Note - with correlations the answer is anywhere between -1 and +1. If its negative, the relationship is negative eg as age increases, batting averages decreases.... A Positive result (closer to +1) is that as the number of years in sales increases, sales increases.
|Section 7: Creating Charts|
Create a Chart
Modify Chart details
Change the Chart Type
Add a Trendline to a Chart
Remove Chart Data
Add chart data
Missing chart data
Pull a slice from a Pie Chart
Label slices of a Pie Chart
Paste a chart into Word
Amending a chart in Word
Paste-link a Chart into Word
|Section 8: Worksheets|
Format Numbers as Percentages
Format Currencies in Currency and Accounting Formats
Format Column Headings
Format Quickly with Format painterPreview
Insert a background image into your worksheet
Create a Transparent image
|Section 9: Saving and Printing Worksheets|
Save a workbook as a Template
Save a workbook as an XML spreadsheet
Print multiple cell ranges on One Page
Page set up, header, footer, margins - 1 page printing
Print multiple areas of a workbook
Print multiple worksheets of a workbook
Repeat Headings of a Row or Column
Print functions to show calculations & comments
Lisa Newton BA MSc FMAAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, software, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007 and in 2008 Enterprising Business Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award.
Lisa's books include: How to write a book in two weeks, Constant Cashflow, Make the most of your money, How to start your own bookkeeping business, Cosmic ordering with Vision Boards and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.
Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.
In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation and cosmic ordering.