Covid-19 Update

At Transform Learning Academy, we are determined to support your learning goals. Henceforth, all our programmes will be run interactively by our specialist team using remote webinar. Remote students will receive the same high-level of support we pride ourselves on.

Learn how to become a Project manager in less than 12 weeks

Excel for Experts

Home / Courses / Excel for Experts

Microsoft Excel is likely the most commonly used spreadsheet programme across the world. This course will help you learn the more advanced workings and features of Microsoft Excel 2016. You will look at functions such as macros, pivot tables, functions in formulas and more. The flexible nature of this course allows you to learn with ease and at your own pace or from home, addressing a variety of people’s needs regarding study time and the way in which you learn.

Powered By Pitman Training

REASONS TO CHOOSE

Excel for Experts

Applicable to numerous industries

Accredited and desired worldwide

Gain skills that can be implemented in real workplace situations

Save on costings

Attain a qualification employers are desperate for

Excel for Experts

Trusted & Accredited by CPD


Best Price in the Industry


Save on Costings


Available delivery methods for this course

COURSE INFORMATION

Is this for you?

The course is for anyone wanting to learn how to utilize the latest 2016 version of this powerful spreadsheet programme. As Excel is widely used in a variety of job roles such as finance and accounting, management and office administration roles, it is suitable for a wide audience.
The full course is suitable for both beginners and for those with intermediate-level skills; it will help you learn some of the fundamental actions you can carry out in Excel before advancing your knowledge to more in-depth features.

Career ladder

As Microsoft Excel is used across such a wide range of job roles, taking the time to learn the latest version of this spreadsheet programme will show your commitment to continuing professional development and help towards your career progression opportunities.

What does the Course cover

There are 17 modules in this course, below is a breakdown of what each one covers:

  1. Data calculations, watermarks, converting text to columns and flash fill.
  2. Consolidating data, paste special, custom formats and working with ranges.
  3. Hyperlinks and formatting charts.
  4. Applying functions in formulas.
  5. Conditional formatting.
  6. Sort and filter data, subtotals and database functions.
  7. Macros.
  8. Data validation, precedent/dependent cells, tracing errors, evaluating formulas and the watch window.
  9. Protecting worksheets and workbooks, passwords and file properties.
  10. Sharing and merging workbooks and grouping and ungrouping data.
  11. Pivot tables.
  12. Pivot charts.
  13. VLOOKUP, HLOOKUP, embedding and linking objects.
  14. Scenario manager and data tables.
  15. MATCH and INDEX, NOW and TODAY and COUNTA, COUNTBLANK and COUNTIF functions.
  16.  Using financial, nested and the CONCATENATE functions.
  17.  Create and modify custom workbook elements.

The course should take around 24 hours to complete, with every module taking around 30-45 minutes. At the end of each module, you’ll complete a consolidation exercise which will help you to summarise what you have learned and appraise your understanding.

Pre-Requisites

There are no pre-requisites.

Start Date

Flexible Date (You can start the course Anytime)

Study Type

Online

Training Type

Course

Duration

24 Hours

 

There are 17 modules in this course, below is a breakdown of what each one covers:

 

  1. Data calculations, watermarks, converting text to columns and flash fill.
  2. Consolidating data, paste special, custom formats and working with ranges.
  3. Hyperlinks and formatting charts.
  4. Applying functions in formulas.
  5. Conditional formatting.
  6. Sort and filter data, subtotals and database functions.
  7. Macros.
  8. Data validation, precedent/dependent cells, tracing errors, evaluating formulas and the watch window.
  9. Protecting worksheets and workbooks, passwords and file properties.
  10. Sharing and merging workbooks and grouping and ungrouping data.
  11. Pivot tables.
  12. Pivot charts.
  13. VLOOKUP, HLOOKUP, embedding and linking objects.
  14. Scenario manager and data tables.
  15. MATCH and INDEX, NOW and TODAY and COUNTA, COUNTBLANK and COUNTIF functions.
  16. Using financial, nested and the CONCATENATE functions.
  17. Create and modify custom workbook elements.
Key points about this course

Method: Online

Accredited: Yes

Start Date: Anytime

Dates & Prices

Select your course

Upon purchase of this course you will receive a series of emails which will provide access to your learning portal. All of your courses will appear here and you will have 4 weeks access.

Was
Now
Course Price
£650
£550
Add-on Features
£0
Total
£550
ENQUIRE

Choose a Month

How many employees need training

When would you like to take the course?

What is your name?
What is Your Job Title?*
Company Name*
Email Address*
Phone Number*
Additional Details*
The information you provide shall be processed by Transform Learning Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Why Choose

98% Exam Pass Rate We have managed to get our delegates into a job within a 4 month period. All we ask is for your full dedication.

Best Price in the Industry You won’t find better value in the marketplace for the full end-to-end career transformation.

Nationwide Training We constantly run classroom sessions from the North of England to London. Sessions run all year round!

Nationwide Training You can work on any of our projects, whilst working full time.

CONGRATULATIONS

You're On Your Way To Success

Full Name*
Email Address*
Phone Number*
PLEASE SCHEDULE AN APPLICATION CALL HERE

You Will Receive An Email

Please check your inbox and spam for further information on the programme and to schedule an application call.

LET US KNOW HERE WHEN IS A GOOD TIME TO TALK TO YOU