...

Excel Advanced – Getting Insights From Raw Data – One Day (Code: 20140)

Prerequisites

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

Course Overview

This course will teach you how to analyze and report on data frequently and keep and maintain workbooks for all manner of purposes. You will also learn how to automate repetitive tasks, and use conditional logic to construct and apply formulas and functions that will put the full power of Excel right at your fingertips.

Goal

Be able to extract information out of Raw data, get answers to business questions and make a better-informed business decision.

Excel Advanced Topics

1. Summarizing data using Outline
2. Summarizing data using Subtotal
3. Combining data using Consolidation
4. Pivot Tables Basics
5. Pivot Charts Basics
6. Filtering Pivot Tables
7. Using Slicers
8. Creating Sparklines
9. Create Scenarios
10.Using Goal Seek
11.Variable Data Tables
12.Using the Solver
13.Getting External Data
14.Sharing – Tracking Changes
15.Auditing Worksheets
16.Creating Macros
17.Running Macros
18.Creating Forms
19.Assign a Macro to a Control
20.Advanced Shortcuts

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.