|
Provided by: silicon beach training Microsoft Excel Advanced TrainingTraining, Instruction and Documentation |
![]() |
Training
Provided by silicon beach training
Microsoft Excel is a very powerful spreadsheet application designed to save you time and make easy work of calculating, displaying and sharing data.
This advanced excel training course will introduce you to some of excels more powerful features.
This one-day Excel Training course shows how you can use Excel to manage a database, create advanced charts, use some of the advanced functions of MS Excel.
|
|
||||||||||||||||
Microsoft Excel Advanced Training Seminar Schedule
| Date | Location | |||
|---|---|---|---|---|
| [Register] | ||||
| [Register] | ||||
| [Register] | ||||
| [Register] |
Microsoft Excel Advanced Training
Absolute Cell Addressing
Using Absolute References
Naming Cells and Ranges
Using the Create Method to Name Cells
Using the Names Box to Name Cells
Using Insert Name Define
Working with Named Ranges
Data Consolidation
Consolidating Data across Worksheets
Consolidating Data across Workbooks
Conditional Functions
Introduction to If
Using Nested If's
Using SumIf and CountIf
Lookup Functions
Using Vlookup
Using Hlookup
Data Validation
Using the Data Validation feature
Finding Invalid Data
Conditional Formatting
Setting Up Conditional Formats
Using Formulae in Conditional Formats
Using Conditional Formats to find MIN and MAX
Working with Data Lists
Sorting
Subtotals
Filtering
Pivot Tables
Using the Pivot Table Wizard
Modifying the Pivot Table
Data Tables
Creating Data Tables
One Way and Two Way Tables
Using Absolute References
Naming Cells and Ranges
Using the Create Method to Name Cells
Using the Names Box to Name Cells
Using Insert Name Define
Working with Named Ranges
Data Consolidation
Consolidating Data across Worksheets
Consolidating Data across Workbooks
Conditional Functions
Introduction to If
Using Nested If's
Using SumIf and CountIf
Lookup Functions
Using Vlookup
Using Hlookup
Data Validation
Using the Data Validation feature
Finding Invalid Data
Conditional Formatting
Setting Up Conditional Formats
Using Formulae in Conditional Formats
Using Conditional Formats to find MIN and MAX
Working with Data Lists
Sorting
Subtotals
Filtering
Pivot Tables
Using the Pivot Table Wizard
Modifying the Pivot Table
Data Tables
Creating Data Tables
One Way and Two Way Tables
About The Training Provider: silicon beach training
silicon beach training - Silicon Beach Training is a recognised leader in IT, Design, Business and Management training courses throughout Europe. Our flexible, creative and innovative methods bring out the potential of your people and your organisation to achieve exceptional results.
Our comfortable training facilities are available in the UK, Brighton, 45 mins by rail from London.
Our clients tell us it"s...

