Beginner Excel Course
In this course you will learn how to start using MS Excel. Included in the course is how to:
- operate the Excel ribbon,
- customize the quick-access toolbar,
- format and set up personalized spreadsheets by using
- colours,
- spacing and
- lines.
- Time Req – 8 hrs
- Skill Score <3.5
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
You will also start to learn some Intermediate skills like
- doing simple calculations in Excel
- understanding the uses of the filter and pivot tables, and
- producing charts at the push of a few buttons.
The secret to success with Excel is application. Apply what you learn as you go along. For more details, see the About Beginner Excel below.
Modules
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