Microsoft Excel is one of the greatest, most powerful, most important software applications of all time. It provides enormous capacity to do quantitative analysis, letting you do anything from statistical analysis of databases with hundreds of thousands of records to complex estimation tools with user-friendly front ends.

MS Excel is everywhere you look in the business world especially in areas where people are adding up numbers a lot, like marketing, business development, sales, and, of course finance. Weather it is about extracting data from back-end systems and shoving it around in Excel spreadsheets, r compiling data from the field, it is there everywhere.

Ask any working professionals, person unaware of excel is just treated as Second Grade Citizen, In-spite of having all the experience you have gathered in the decades or the degrees you have earned over the years or of the matter of the fact all the awards lying in your showcase, all are worth less if you do not know speedy work on your workstation.

Reporting is the new dragon of the corporate world, no matter in which position you work, you have to report, may be to your boss, or to your stake holders, or to your clients, but have to report. No one allows you to sleep without reporting.

  • Speedy data analysis
  • Better Understanding of MIS
  • Time Saving in Office Work
  • Reaching deep into data and seeing the unseen truth of your business.
  • Learn to Create Smart Solution for your daily office work

MS Excel Training Program: MOD II – Advance Excel

MS Excel Training Course - Lesson 1: Excel Basics

  • Formatting & Managing your Worksheet & workbook
  • Basic Formulas, Number Formats & Working
  • Working with Menus Tabs & Excel Advance Options

MS Excel Training Course - Lesson 2: Formats, Conditional Formatting & Sorting

  • Cell Formatting
  • Data Bars, Colour Scales & Icon Sets,
  • Conditional formatting with formulas,
  • Sorting basic & advance
  • Filters Basic & Advance

MS Excel Training Course - Lesson 3: Data Management

  • Data from other Sources
  • Data Validation and dealing with Invalid Data
  • Group and Outline Data,
  • Data Consolidation
  • Text to Column.
  • Removing Duplicates

MS Excel Training Course - Lesson 4: Formulas & Functions

  • Text Formulas :Exact, Find,
  • Lookup Formulas :Vlookup, Hlookup, Lookup, Match etc..
  • Logical Formulas: If, AND, OR, NOR etc..
  • Date & Time Formulas : Today, Now, Years, etc..
  • Financial, Math ,Trig , Index, Formulas etc..
  • How & when to apply Nested Functions

MS Excel Training Course - Lesson 5 Chart & Graphs

  • Chart Basics: What, When & How
  • Why to use Line Chart
  • Most Commonly used: Column Chart
  • Typical Spark lines

MS Excel Training Course - Lesson 6 Data Analysis

  • Creating a PivotTable,
  • Specifying the Data a PivotTable Analyzes
  • Changing a PivotTable's Calculation
  • Selecting What Appears in a PivotTable
  • Grouping Dates in a PivotTable,
  • Updating a PivotTable
  • Formatting and Charting a PivotTable
  • Scenario Modelling
  • Goal Seek

MS Excel Training Course - Lesson 7: Automating your Work

  • Introduction to Form Controls,
  • Macros: Introduction to Form Controls,
  • Macros, Create and Edit a Macro.
  • Automating Tasks with Macros
  • Recording a Macro
  • Playing a Macro and Assigning a Macro a Shortcut Key
  • Adding a Macro to a Toolbar
  • Working with Other Programs
  • Inserting an Excel Worksheet into a Word Document
  • Modifying an Inserted Excel Worksheet
  • Inserting a Linked Excel Chart in a Word Document
  • Inserting a Graphic into a Worksheet

Other Related Excel Training Programs 

MS Excel Beginner Training MS Excel VBA Macro Training

 

2 Days of Training
6 Hours of Training Daily
English


Warning
The download files does not exist


Name (required)

Email (required)

Contact (required)

Subject

Your Message

Insert Code
captcha


Online Registration

Log In

The program was really very interactive

Vikas Narian
Bhavani NIketan Engineering College Jaipur

Categories