Course Objectives:
Our Microsoft
Advanced Excel training course will improve efficiency and productivity in the work
place with the use of advanced features such as Pivot Tables, Short
Cuts, Filters, Macro's and scenarios. This course is aimed at the everyday user. We will look at functions such as IF, Vlookup and Nested IF's.
Benefits
At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
Typically our courses are delivered in one day, to groups of upto 8 delegates, at your location. This keeps your costs down, and allows your staff to learn in a familiar environment. If you don't have your own training facility, then we can deliver training at a location to suit you, which you can arrange yourself or we can do that for you.
For more information please contact us at info@inspiresit.ie or call the senior trainer on 085 1055651
Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.
We will travel onsite anywhere in Ireland
Navigation
& Data input
- Quick Navigation
of spreadsheets
- Accurate
selection of large amounts of data
- Shortcut
Keys
- Named Ranges,
modifying & deleting
- Custom Lists,
creation & deleting
- Using AutoFill
to create numbered sequences
Functions:
IF & VLookups
- Absolute
Addressing
- Using the
IF Function – Using the Paste Function
- Using the
Vlookup & Hlookup
- Count IF
and Count A
- Sum IF
- Nested IF
- Shortcut
to view all formulaes
- Auditing
Toolbar
Advanced Filter
- Using the
AutoFilter
- Using the
Advanced Filter
- Filtering
Results to another area of spreadsheet
Auditing
Toolbar
- Using
the Auditing Toolbar
- Tracing
Precedents
- Tracing
Errors in Formulaes
Protection
- Protecting
Worksheets
- Protecting
Workbooks
- Protecting
parts of a spreadsheet
- Placing
a password on the file
Data Consolidation
|
Goal
Seek & Consolidation
- Using
the Goal Seek in Excel
- Consolidating
Data in a spreadsheet
Pivot
Tables
- Creating
Pivot Tables
- Modifying
Pivot Tables
- Formatting
data within Pivot Tables
- Refreshing
data in a Pivot Table
- Creating
a Pivot Chart
- Modifying
a Pivot Chart
- Grouping
Pivot Table
- Inserting Calculated Fields into a Pivot Table
Scenarios
- Creating
Scenarios
- Shortcuts
to viewing scenarios
Macros
- Recording
a Macro
- Running
a Macro
- Assigning
a Macro to a button in Toolbar
- Assigning
a Macro to a push button on spreadsheet
- Editing &
Deleting a Macro
Import
- Importing Data into Excel
- Importing a Text file into Excel
Data Validation
- Creating Drop Down Menu's in Excel
Charts
- Adding a Second Axis
- Formatting Axes
|
| Back to Main Excel Page>> |
|
|
