Microsoft Excel
Contact us for dates, pricing and how we can customise courses to your requirements: contact us
Introduction Level Training
Duration: 1 day
Getting Started with Excel
- Introducing Excel, the screen and menus
- Creating a new Excel workbook
- Entering labels, values and formulas
- Saving a workbook
Copy and AutoFill
- Copy and Paste
- Cut and paste
- Drag and drop
- Using AutoFill
Using Functions
- Entering functions
- Using AutoSum
- Using AVERAGE, MIN, MAX and COUNT
Formatting Worksheets
- Formatting text
- Formatting rows and columns
- Formatting numbers
Modifying a Worksheet
- Inserting columns, rows and cells
- Deleting columns, rows and cells
Printing
- Page setup options
- Page break preview
Charts
- Creating a chart
- Formatting the chart
- Printing the charts
Intermediate Level Training
Duration: 1 day
Excel Revision
- Working with calculations and functions
- Formatting and AutoFormats
- Shortcuts and tips
Advanced Formatting
- Rotating and indenting
- Styles and custom formats
- Conditional formatting
Worksheet Templates
- Creating and managing templates
- Worksheet protection
Advanced Formulae
- Lookups
- Logical statements
- Text functions
- Absolute references
- Naming cells and ranges
- Named ranges in formulas
Working with large and multiple worksheets
- Freezing panes
- Hiding/displaying data
- Printing large worksheets
- Linking worksheets using 3-D formulas
- Consolidating data
Advanced Level Training
Duration: 1 day
Excel Revision
- Working with calculations and functions
- Formatting and AutoFormats
- Shortcuts and tips
What if Analysis
- Using Goal Seek
- Using Solver
- Scenarios and the Scenario Manager
- Data Validation
Advanced Output Features
- Custom views
- Report manager
Importing and Exporting Data
- Importing data
- Exporting data
Macros
- Introduction to macros
- Recording a macro
- Running a macro from a button, keystroke or menu
Data Management
- Creating lists
- Sorting and filtering lists
- Advanced filtering
- Subtotals
PivotTables and PivotCharts
- Using the PivotTable wizard
- Modifying the PivotTable
- Creating a PivotChart