Scribd
Upload
90 views1 page

Excel Mastery for Analysts

This document provides an overview of various Excel topics including working with formulae and functions, organizing data using sorting and filtering, conditional formatting, data analysis tools like pivot tables and what-if analysis, and macros. It covers statistical, logical, and database functions as well as functions for dates, lookups, and indexing data. The document also discusses naming cell ranges, conditional formatting, auditing formulas, and creating scenarios and pivot tables to analyze and present data.

Uploaded by

Ashish Kolambkar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
90 views1 page

Excel Mastery for Analysts

This document provides an overview of various Excel topics including working with formulae and functions, organizing data using sorting and filtering, conditional formatting, data analysis tools like pivot tables and what-if analysis, and macros. It covers statistical, logical, and database functions as well as functions for dates, lookups, and indexing data. The document also discusses naming cell ranges, conditional formatting, auditing formulas, and creating scenarios and pivot tables to analyze and present data.

Uploaded by

Ashish Kolambkar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

1) Working with Formulae / Functions Using

5) Organizing Data and Worksheet


Statistical Functions Multi-level Sorting
Large, Small Advance Filter
Countif, Countifs, Nested Subtotal
Sumif, Sumifs
Logical Functions
6) Pivot Table and Dashboard
IF, Nested IF, AND, OR
Recommended Pivot Table
Database Function Creating a PivotTable
Dsum, Daverage, DMax, Dmin Placing Fields into the Pivot Table
Modifying data and refreshing the Pivot
2) Named Ranges Table
What does naming a cell range mean? grouping data within a Pivot table Use
Rules for naming cells and ranges
of Slicer
Naming cell range(s) in a worksheet
Creating named ranges automatically 7) Auditing Formulas
based on cell values Tracing precedent cells
Tracing dependents of a cell
3) Conditional Formatting Displaying all formulas within a worksheet
Built-In Conditional Formatting Add
Data Bars and Color Scales
8) Data Analysis
Convert Excel Data to Icon Sets
Custom Conditional Format Working with Goal seek
Expressions in a Custom Condition Working with Data Tables
Creating a scenario summary
4) More on Functions Creating named Scenarios from defned cell
1) Date Functions ranges
2) Lookup and Reference Function
VLOOKUP 9) Macros
HLOOKUP Recording and running a macro
MATCH Lowering your macro security level
INDEX Raising your macro security level
IFERROR Editing recorded Macros
INDIRECT Creating a User Defined Function
Use of Input and Message Box

You might also like