Microsoft Excel Training Course
Microsoft Excel is an electronic spreadsheet and it is mainly used for
manipulating numerical information. Among other things, spreadsheets
enable you to produce budget reports, financial plans and profit and loss
statements.
They re-calculate automatically, providing huge
savings in time, and their formatting tools allow you to present well laid
out reports
This is can be delivered as a
half-day or
full day
course.
Microsoft Excel Course ContentsThe following represents a typical
breakdown of our Microsoft Excel course, however we can tailor all our
courses to specific requirements as required.
Introduction to
Microsoft Excel
-
Get started with Excel
-
Enter, change and delete numbers and labels
-
Create and copy formulas
-
Move and copy ranges
-
Format cells to display decimals, currency and dates
-
Insert and delete rows and columns
-
Save and open spreadsheets
Advanced Microsoft Excel Consolidation, Names and
Protection Consolidate using 3D references Work with Names Protect
your Spreadsheet Freezing Panes, Comments, Styles and Templates
Freeze
Panes Insert Comments Save Styles and Templates What-If Analysis Track
a What-If Analysis with Scenario Manager Project figures using Data Tables
Use Goal Seek Set up a complex What-If Analysis with Solver Managing Data
Lists Plan a List Create a List Add, find and delete records Sort a List
Filtering and Validating Data Lists Retrieve records using AutoFilter
Create a Custom Filter Use the Advanced Filter Set up Subtotals Validate
Data. PivotTable Reports Create a PivotTable report Change the summary
function of a PivotTable report Change the structure of a PivotTable
report Update a PivotTable report Create a Chart from a PivotTable.
Functions Logical Functions Date & Time Functions Statistical Functions
Text Functions Database Functions Nested Functions Further Useful Tools
Import a text file Audit your Worksheet