• LOGIN
  • No products in the basket.

Login

Excel 2016 Advanced

Excel 2016 Advanced

Course Description

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this [course_title] will be the perfect choice for you!

Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel’s many collaboration features, as well as how to import and export data to and from your workbooks.

What Will I Learn?

  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File

Requirements

  • Excel Introduction and Intermediate courses or equivalent experience.

Who is the target audience?

  • Students who want to expand their Excel knowledge.

  • video Introduction
    00:01:00

Course Reviews

4.8

4.8
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Comming Soon!
Original price was: £329.00.Current price is: £25.00.
TAKE THIS COURSE

or

Get all courses for only £49

2000+ Globally Recognised Premium Courses


This course includes:
access
01 Year of full Course access
cert
Endorsed Certificate of Compleiton
unit
65 Units
quiz
0 Quiz
duration
2 hours, 21 minutes of total Unit + Quiz duration
cpd
ciq
money-back-14days
money-back-14days
Select your currency
GBP Pound sterling