Advanced Excel Training - 1 day - £195 + vat - dates
Advanced Excel training uk
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.
Microsoft Excel Training Course Objectives
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.
Advanced Excel Training Course Content
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
Advanced Excel Training Course Prerequisites
Delegates attending this excel training course should understand the basic concepts of creating an Excel Spreadsheet, or have attended our Beginners Excel training course.
Excel Training Recommended Reading
Microsoft Excel 2000 Bible - John Walkenbach – buy from amazon
Office Excel 2003 – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.