MS Excel - Basic to Advanced - three days intensive Excel program

Loading Map....

Date/Time
Date(s) - 18/05/2018 - 20/05/2018
9:00 am - 6:00 pm

Location
Delhi

Categories


Lear MS Excel in a three days intensive program.

If you are a new to Excel, you can opt for two days session and and come back for advanced in future session.

Fee:

For first two days (Basic and Intermediate level) – INR 4500

For Last day (Advanced) – INR 3500 (To attend this session only, you need to appear in our online test that we take to test your knowledge of basic and intermediate excel.

 

Program Structure

Basic Excel (Day 1) 

  •  Introduction to MS Excel
    • Excel user interface
    • Insert new column and row
    • Delete column and row
    • Insert a new sheet and Delete a sheet
  • Formatting of data
    • Basic formatting of text
    • Alignment of data
    • Wrap text and Cell merging
    • Number formatting
  • Conditional formatting
    • Highlight cell rule
    • Manage conditional formatting
  • Sorting
    • Simple sorting
  • Filter
    • record based on one column
    • based on multiple column
  • Page setting for printout
    • Margin of page
    • Header and footer setting
  • Chart
    • Create chart
    • Change chart type
    • Modify chart
    • Add labels on chart
  • Formulas
    • Basic of formula

 

 Intermediate Excel (Day 2) 

  •  Sorting
    • Multilevel Sorting
  • Pivot table
    • Create pivot table
    • Modify pivot table
    • Designing of pivot table
    • Refresh pivot table
  • Page setting for printout
    • Repeat heading on every page
    • Print on single page
  • Formulas
    • User defined formula
    • Built-in function
    • Text functions
    • Date & time functions
    • Lookup & Reference functions
    • Logical functions
    • Financial functions
    • Math & trig functions
    • Statistical functions
  • Formula Auditing
    • Trace precedent
    • Trace dependent
    • Evaluate formula
    • Assign a name to a range
  • Data tools
    • Text to column
    • Remove duplicates record

 

Advance Excel (Day 3) 

  •  Conditional formatting
    • Apply Highlight cell rule on entire row
  • Sorting
    • Custom list based sorting
  • Filter
    • Advance filter for complex conditions
  • Protection
    • Protect workbook
    • Entire Sheet protection
    • Partial sheet protection
  • Data tools
    • validation for making dynamic drop down list
    • consolidate
    • Goal seek
    • Scenario manager
  • Pivot table
    • Create Calculated item and field
    • Report Filter
  • Chart
    • Create double Y axis chart
  • Macros
    • Record macro
    • Relative reference macro
    • View available macro
    • Edit macro
    • Delete macro
    • Assign a shortcut key to macro

Trainer’s Profile – MS Excel Expert

Bookings

Bookings are closed for this event.

Leave a Reply

Save Filter
×