In this Microsoft Excel training course, you will learn the skills required to use Excel to create and edit workbooks and spreadsheets effectively. This training course will show you how to unlock Excel’s powerful capabilities for sorting and manipulating data. Here you will also gain in-depth knowledge about the uses of Excel’s tab interface, and file tab and gain an understanding of how to add the command to the quick access toolbar.
This course is designed to give you an overview of Microsoft Excel essential topics, such as:
- Navigation of the Excel interface
- Excel workbook screen
- Use of lists and tables
- Producing Functions
- Producing Graphs
- Performing an alphabetical sort
- Conditional formatting
- Using formulas and creating Pivot tables
- Working with names and ranges
- VLOOKUP’s
After you have completed this Microsoft Excel training course, you will be able to generate equations to give you additional data on critical company functions. You will be able to create spreadsheets that better organise data and give you a clearer picture of what’s being input. You will also be able to interpret data at a far more advanced level, which will provide you with answers and solutions to some of the problems affecting the business you work for or your own business.
