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

Buy Now

Duration

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

Description

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
• Advance Filtering Options

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

Follow Us :

© KLMS HANDS-ON SYSTEMS PRIVATE LIMITED

×

Checkout

Course Name: Excel Analytics

9990