# Excel Analytics

Currency:

## Why this course ?

• Advanced Excel helps to clean,manipulate and visualize data properly
• Excel helps to design professional-level spreadsheets to lay out data intelligently and usefully
• It helps to solve business problems with the advanced application of data.
• Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells.

Excel

Program Duration
and Fees

24 Hours

# Price

9990

#### Features

• ###### Benefits of Joining the training
Join the hands-on based classroom or online training
###### Led by An Expert Instructor
Led by an expert instructor who can look into the individual problems of the students

#### Introduction to MS Excel and Understanding Basic Working with it

• Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
• Saving Excel File as PDF, CSV and Older versions
• Using Excel Shortcuts with Full List of Shortcuts
• Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
• Using Paste Special Options
• Formatting Cells, Rows, Columns and Sheets
• Protecting Sheets with or without Password

#### Working with Formulas/Functions

• Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, TRANSPOSE etc
• Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
• Math and Trigonometry Functions: ROUND, CEILING, FLOOR, INT, SUMIF, SUMIFS etc.
• Statistical Functions: AVERAGE, AVERAGEIF, COUNT, COUNTBLANK, COUNTIF, MAX, MIN, STDEVA etc.
• Text Functions: LEFT, RIGHT, TRIM, MID, REPLACE, TRIM, CONCATENATE, etc.

#### Conditional Formatting

• Using Conditional Formatting
• Using Conditional Formatting with Multiple Cell Rules
• Creating New Rules and Managing Existing Rules

#### Data Sorting and Filtering

• Sorting Data A-Z and Z-A
• Using Filters to Sort Data

#### Pivot Tables

• Creating Pivot Tables
• Using Pivot Table Options
• Changing and Updating Data Range
• Formatting Pivot Table and Making Dynamic Pivot Tables

#### Visual Basic For Applications

• Introduction to VBA Macro
• Recording Macro & Understanding Code Behind
• Editing, Writing VBA Code and Saving as Macro or Add-In
• VBA Programming Concept
• Decisions Making with Operators
• Repeating Actions with a Loops
• Functions

Learners

Learners

# Testimonials

×

#### Checkout

Course Name: Excel Analytics

9990