Advanced Excel for Business

Simpliv

Course

Online

£ 50 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Advanced Excel for Business Level III is the last of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level II or already have a strong working knowledge of excel and would like to take their skills and efficiency to an advanced level. By the end of this course, you will feel confident using advanced formatting techniques, multi-input and conditional functions and recording basic macros. Additionally, you will gain experience with advanced excel features and plug-ins such as scenario management and solver. Your peers, colleagues and employers will be impressed with you ability to tackle complex problems in excel dynamically and efficiently after you take this course. The course comes with a revolutionary video tutorial suite, and is taught by engaging instructors with several years of in-field and training experience. 

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Gain experience on advanced excel features and plug-ins such as scenario management and solver
You will tackle complex problems in excel dynamically and efficiently

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

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 4 years

Subjects

  • MS Excel
  • Windows
  • Excel

Course programme

Introduction to Advanced Excel for Business Level III 22 lectures 02:48:10 Advanced Cell Locking Hot Keys Go To Special Date Functions Advanced Conditional Formatting Nested If Statements If with And & Or Goal Seek Data Table Conditional SumProduct Pivot Table Variances Pivot Table Calculations Pivot Charts Match Function Vlookup-Match Function Index-Match Index-Double Match Function Windows Working Across Sheets Macros Macro Report Data Consolidation Introduction to Advanced Excel for Business Level III 22 lectures 02:48:10 Advanced Cell Locking Hot Keys Go To Special Date Functions Advanced Conditional Formatting Nested If Statements If with And & Or Goal Seek Data Table Conditional SumProduct Pivot Table Variances Pivot Table Calculations Pivot Charts Match Function Vlookup-Match Function Index-Match Index-Double Match Function Windows Working Across Sheets Macros Macro Report Data Consolidation Advanced Cell Locking Advanced Cell Locking Advanced Cell Locking Advanced Cell Locking Hot Keys Hot Keys Hot Keys Hot Keys Go To Special Go To Special Go To Special Go To Special Date Functions Date Functions Date Functions Date Functions Advanced Conditional Formatting Advanced Conditional Formatting Advanced Conditional Formatting Advanced Conditional Formatting Nested If Statements Nested If Statements Nested If Statements Nested If Statements If with And & Or If with And & Or If with And & Or If with And & Or Goal Seek Goal Seek Goal Seek Goal Seek Data Table Data Table Data Table Data Table Conditional SumProduct Conditional SumProduct Conditional SumProduct Conditional SumProduct Pivot Table Variances Pivot Table Variances Pivot Table Variances Pivot Table Variances Pivot Table Calculations Pivot Table Calculations Pivot Table Calculations Pivot Table Calculations Pivot Charts Pivot Charts Pivot Charts Pivot Charts Match Function Match Function Match Function Match Function Vlookup-Match Function Vlookup-Match Function Vlookup-Match Function Vlookup-Match Function Index-Match Index-Match Index-Match Index-Match Index-Double Match Function Index-Double Match Function Index-Double Match Function Index-Double Match Function Windows Windows Windows Windows Working Across Sheets Working Across Sheets Working Across Sheets Working Across Sheets Macros Macros Macros Macros Macro Report Macro Report Macro Report Macro Report Data Consolidation Data Consolidation Data Consolidation Data Consolidation Bonus 8 lectures 48:50 Cell Auditing Custom Number Formats Custom Time & Date Formats Offset Function Scenario Manager Text Function Recording Macros Relative Reference Macros Bonus

Additional information

Strong working knowledge on Excel Go Through Excel for Business Level II Course

See related categories

Advanced Excel for Business

£ 50 + VAT

The best Excel courses

See all

See all