Beginner Excel Course
Or log in to access your purchased courses
In this course you will learn how to
- operate the ribbon,
- customize the quick-access toolbar,
- format and set up personalized spreadsheets by using
- colours,
- spacing and
- lines,
- do calculations
- set up formulas for calculations and
- also produce graphs at the push of a few buttons.
The secret to success with Excel is application. Apply what you learn as you go along.
If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar
Modules
Downloads and Course introduction
What is a spreadsheet
Lessons
Basic workings of an Excel spreadsheet
Lessons
- Viewing many parts of the spreadsheet (at the same time) Free Preview
- Summary and Exercise- Wrong Name
- Create, Save and Open existing Excel files
- Navigation and Data entry
- Copy and paste and paste special
- Summary and Exercise- Copy and Paste
- Insert, delete, hide, and resize columns and rows
- Summary and Exercise- Columns and Rows
Formatting Essentials
Lessons
Calculations in Excel
Lessons
- BODMAS in Excel
- Create calculations in Excel (stop using your calculator)
- The SUM function
- Summary and Exercise- Entering Calculations
- Absolute / Relative referencing- $ signs
- Using the F4 shortcut for $ signs
- Summary and Exercise- $ Signs
- Linking cells in different sheets and workbooks Free Preview
- Summary and Exercise- Linking to other sheets
Useful Excel Tools
Lessons
Pivot Tables- A very special tool
Lessons
Excel Functions
Lessons
- Function Wizard
- Summary and Exercise- Function Wizard
- The basic “IF” function
- Summary and Exercise- IF Function
- Auditing Toolbar
- Summary and Exercise- Auditing Toolbar
- Formulas and the coloured boxes
- VLOOKUP explained in simple terms
- Build your first VLOOKUP Free Preview
- VLOOKUP Example- Join databases
- VLOOKUP Example- Find Missing Items
- Next Steps and Excel Training Coupons
