Excel Intermediate half-Day Course, Private 1-to-1, Manchester
Event Information
Event description
Learn Excel Intermediate in one day, Private 1-to-1, Online, Practical, Instructor-led. Many useful examples.
About this event
Excel Intermediate Course, Private 1-to-1
ONLINE in our Virtual Classroom. Connection Details provided upon booking. Read More
This Excel course is offered one-to-one, because we understand that professionals have varying skill levels and varying applications.
You already have the basic Excel skills would like to be more proficient.
Course Outline
Creating Formulas
- Creating Formulae in Excel, general calculations
- Copying formulae
Basic Functions
- The Function Wizard
- Sum, Average, Maximum, Minimum, Count Functions
- If- function
More Built-in Excel Functions
- Working with Names and Ranges
- Group and Outline
- Validation
- Vlookup, Hlookup,
- Index, Match
- Sumifs, Averageifs, Countifs
File Linking and Sheet Linking
- Referring to external files in a formula
- Referring to multiple sheets in a formula
- Consolidate
Pivot Tables
- Create Pivot-tables
- Amend pivot tables, amend formulae, custom fomulae
- Formatting Pivot-tables
- Grouping, Sorting , Filtering, Slicing Pivot Tables
Managing Tables
- Working with Tables
- Working with Records and Fields
- Filters and Sorting
- Freeze panes, split
- Protecting and unprotecting
- Using Excel as a Database - Advanced filter: copy only selected columns and selected rows from an Excel Database / list, by using the advanced filter
Charts and Sparklines
- Adding and Editing Charts
- Adding and Editing Sparklines
Included: Course Notes, Course exercises and examples, access to online materials, Certificate, 1-hour after-course online consultation.
