Excel Advanced Course, Private 1-1, Online
Short course
Online
Description
-
Type
Short course
-
Level
Advanced
-
Methodology
Online
-
Duration
1 Day
-
Personal tutor
Yes
-
Virtual classes
Yes
This is online instructor-led training. Choose your topics, times and time zone, and dates.
This Excel Advanced Course is for professionals who would like to use Excel to an advanced level. You work daily demands an intensive use of Excel spreadsheets and Excel databases. We offer this Excel course on a one-to-one basis, to tailor the training style and pace to your own requirements.
Facilities
Location
Start date
Start date
About this course
To leave you with excellent, professional and in-depth Excel Skills
People who use spreadsheets daily for advanced calculations.
You need to have basic working knowledge of Excel.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Excel
- Budgeting
- Finance
- Private
- How to use Excel
- MS Excel
- Graphic representation
- Spreadsheets
- Charts
- Data Analytics
- Mathematical formulae
Teachers and trainers (1)
Sarah Barnard
Coder, Instructor
Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.
Course programme
Excel Course Outline
General
Editing Standard Formatting Rules
Input Validate rules
Using Formulas in Conditional Formatting
Group and Outline
Filter and Sorting
Excel Tables and Advanced Filter
Working with Excel tables
Copy specific datasets from sheets, workbooks or external data
Consilidate
Goal seek, consolidate and scenarios
Using Form Templates
Creating Templates
Advanced Excel Lookup Functions
VLookup Function
Hlookup Function
Using the Index Function, Using the Match Function, Index and Match Together
Using the Indirect Function
Excel Advanced Functions
Using Error, Logical, Array, Rounding Functions
Advanced Excel Pivot Table Tools
Importing Pivot Table Data,
Calculated Fields in Pivot Tables,
Showing Pivot Data as a Percentage,
Creating Custom Pivot Tables Styles
Pivot Charts
Excel Macros
Creating, amending and deleting macros
Running macros
Macro menus, toolbars and shortcuts
What is included:
Excel Course Certificate on completion (assessment based)
Excel Course notes
Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online via Skype or Teamviewer.
Additional information
Excel Advanced Course, Private 1-1, Online