0
Trainer Name

Alexandra Kropova

Skill Area

Education, Skills Development or Languages

Reviews

4.5 (20 Rating)

Course Requirements

A copy of Excel 2013, Excel 2016, Excel 2019 or Office 365 (now known as Microsoft 365) for Windows based computers A willingness to learn A Windows based PC A basic competence of Excel e.g. being able to launch it, open, save and close a workbook

Course Description

This comprehensive 38 hours+ Microsoft Excel and Excel VBA course includes content from our Mach 42 Productions Excel courses 1 through 11 and our IT careers course, to take you from beginner to expert level: Excel Course

1- Step By Step Beginners Excel Excel Course

2- How To Use Excel comments Excel Course

3- Excel Charts And Tips To Make Better Charts Excel Course

4- How To Make Waterfall Charts Excel Course

5 - Advanced Excel Charts Excel Course

6- Automated Excel Charts And Tables Excel Course

7- Learn How To Use Excel Text Functions Excel Course

8- Advanced Excel tips Excel Course

9- Quick Excel Tips For Excel Reports Excel Course

10- Advanced Excel Skills And Career Tips Excel Course

11- Spreadsheet Protection 8 Ways to Further your IT Career

Course Outcomes

Students will be able to use Excel to an expert level for their work
2.Students will be able to use formulas in all aspects- write them, edit them, fix them and know which ones to use
3.Students will be able to use Pivot Tables and build them to analyse their data
4.Students will be able to use Excel VBA to write macros to increase productivity
5.Students will be able to use Excel VBA to speed up data analysis of their work
6.Students will be able to quickly format cells, make tables and dynamic charts
7.Students will be able to sort, find and replace data in Excel quickly
8.Students will be able to navigate a spreadsheet without losing the context of their data
9.Students will be able apply these Excel skills to their CV/Resume
10.Students will be able to print spreadsheets properly with no cut offs
11.Students will be able to use Excel's security features to protect their spreadsheet reports
12.Students will learn essential tips to help them for their Excel reports
13.Students will be able to use conditional formatting to highlight entries e.g. top 10 performers

Course Curriculum

1 Topics Overview


2 Build a Table


3 Build a Table of Contents


4 Build a Table of Contents 2


5 Combine Worksheets


6 Combine Worksheets by Column


Learner Feedback

VBA Projects

4

Course Rating
100.00%
0.00%
0.00%
0.00%
0.00%

Log In or Sign Up as learner to post a review

Shopping Cart

Loading...