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, 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
• 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.
• Using Conditional Formatting
• Using Conditional Formatting with Multiple Cell Rules
• Creating New Rules and Managing Existing Rules
• Sorting Data A-Z and Z-A
• Using Filters to Sort Data
• Advance Filtering Options
• Creating Pivot Tables
• Using Pivot Table Options
• Changing and Updating Data Range
• Formatting Pivot Table and Making Dynamic Pivot Tables
• 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
×

Checkout

Course Name: Excel Analytics

9990