...

Master Advanced Functions – One Day (Code: 20170)

Brand New Course Exclusively by Office Instructor

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level (Code: 20135)

Course Overview

Clients will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets.

Instruction will be personalized by version (2016/2019/2021/365).

Goal

By the end of this course clients will be able to create reports using multiple levels of nested functions. They will be able to select the proper functions in building and entire project. This course is customised according to the version of Excel in use
(Office 365 has Dynamic Array functions)

Clients will learn over 100 examples of advanced uses of XLOOKUP ( VLOOKUP), SUMIFS, INDEX, MATCH,FILTER, UNIQUE, DATE, TEXT, CHOOSE, AGGREGATE, COLUMN, ROW, COUNTIF, IF, IFERROR and much more.

Among the Functions You Will Learn:

1. Advanced VLOOKUPs/ XLOOKUP
2. Extracting Records by Functions
3. Advanced Filter by Functions
4. Advanced SUMIFS function
5. SUMIFS with wild cards
6. Dependent Drop lists
7. Searchable drop lists
8. SUMPRODUCT function
9. INDEX and MATCH
10.AGGREGATE Function
11.TEXT Functions
12.Date Functions
13.Formula Auditing
14.Naming Cells and Ranges
15.Formula Text to document Functions
16.Print a list of all Named ranges in a Workbook
17.Comparing Lists
18.Using Controls with Functions
19.Important Shortcuts to save time.

Choose Another Popular Course

Choose Another Course
Share This Post
Have your say!
2 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Request a Quote

Request Quote Form

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.