Microsoft Excel Courses

What is Microsoft Excel?

Microsoft Excel is an application included in the Microsoft Office suite. It is used to create worksheets, which are documents in which data is laid out in rows and columns, in table format.  These worksheets are extraordinarily powerful tools, and are used frequently to store and manipulate data.

We offer 5 standard Excel courses and can also create custom sessions based on your requirements.

Basic - 1 day course

After completing this course, students will know how to:

• Get started with Microsoft Office Excel 2016
• Perform calculations
• Modify a worksheet
• Format a worksheet
• Print workbooks
• Manage workbooks

 Microsoft Tips to Click

Intermediate - 1 day course

After completing this course, students will know how to:

• Work with functions
• Work with lists
• Analyse data
• Visualise data with charts
• Use PivotTables and PivotCharts

Advanced - 1 day course

After completing this course, students will know how to:

• Work with multiple worksheets and workbooks
• Use Lookup functions and formula auditing Share and protect workbooks
• Automate workbook functionality
• Create sparklines and map data
• Forecast data

Data Analysis with PivotTables - 1 day course

After completing this course, students will know how to:

• Prepare data for PivotTable reporting and create PivotTables from various data sources
• Analyse Data Using PivotTables
• Work with PivotCharts

Data Analysis with Power Pivot - 1 day course

After completing this course, students will know how to:

• Get started with Power Pivot
• Visualise Power Pivot data
• Work with advanced functionality in Power Pivot

If you think your workforce may benefit from a training session, please contact us to discuss.

Other related courses:

Microsoft Word Courses

Office 365 Training