Course Length: 56 Lessons | 4 hours of Videos.
Total course duration: 6 to 8 hours
An introduction to Excel covering the basics, ranging from Data Input and Spreadsheet Navigation to Formatting and Printing.
There is a key focus on understanding how Excel works with different Data Types, using Excel Formulas as well as improving efficiencies when Entering and Editing Data.
We also look at managing a larger dataset by using Sort & Filter and take a sneak peek at the intermediate content of Graphs, Conditional Formatting and Absolute Cell References.
The basic operations of Adding, Subtracting, Multiplying and Dividing. Remember BODMAS? If not, we’ll remind you, it’s important! Explanation of the difference between Formulas and Functions. Intro to the 5 basic functions of Auto-Sum, Average, Count, Max and Min. Copying and Replicating Formula and understanding the critical difference between empty and zero value cells. Again, this is key to understanding calculations in Excel, which even many Advanced users get wrong…
Difference between using Page Layout and Print Preview to set and change Print settings. Details on adding Custom Headers / Footers, Repeating header Rows, printing gridlines, Page Numbers and Print Scaling, plus setting Print Areas and Printing Selection.
Using a combination of these features to make working with large spreadsheets a lot more manageable and easier. Using Filters to extract specific Data and copy this to a New Spreadsheet. (A combo of 4 shortcuts can do this in seconds!)
Intro to creating Graphs and using Conditional Formatting.
Intro to Excels Golden Rule and the subsequent requirement to lock a cell reference in a Formula by using Absolute Cell References. ($A$2)
A sneak peek at this most Powerful Excel Tool.
Over 25 Keyboard Shortcuts covered throughout the course to increase those efficiencies. A printable 1-pager, of all these shortcuts and more, is provided with the follow-along Workbook.
- A detailed follow-along Excel Workbook with Summary Notes
- Self-marking quick questions to test your progress as you learn
- Practical Tasks that will enable you to put your newly acquired Excel Skills into practice
- Course completion Certificates
- Lifetime access to course material and updates