Beginner Excel Course
Or log in to access your purchased courses
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
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
