Skip to main content

ARE YOU ADVANCED EXCEL USER? NO!!!!

Get Enrolled in Microsoft Excel Training and Become an Advanced Excel user! Discount: UP TO 10%

Learn The world’s most powerful business tool and Stop wasting valuable time doing manual work! BECOME EXPERT IN EXCEL and do wonders with the data. 99Excel.Com offer a free Skills Assessment demo class to make sure you get the correct level of Microsoft Excel Training.

Why you need to learn Microsoft excel! Click here to know more.

Schedule A Free Demo: Call : +91 9312580474, +91 9654421288, +91 120 4553178.

Book a Free Demo Today: Free Demo Registration 

Timing : 10:00 AM to 8:00PM, 2 hours Classes batched, 15 Days Course.

ADVANCE EXCEL COURSE CORPORATE

Advanced Features of Ms-Excel. Advanced Excel course also enables the student and working professional to utilize, the advanced features taught in this course in an office environment with maximum efficiency.

 

Formulas & Macros Formulas:

  • Use the Function Wizard, Common functions
  • (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas

DATA Analysis :

  •  Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt

Functions : LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF

  •  What-if-analysis
  • GOAL SEEK
  • NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation

PIVOT TABLES:

  •  Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze

MACRO’S ( Int ) :

  •  Macros
  • Definition and use, Record a macro
  • Assign a macro, Run a macro
  • Store a macro, Introduction to VBA Prog.

Develop the Worksheet :

  •  Plan a worksheet , Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars , Enhance worksheet Appearance

Special Operations :

  •  Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline
  • Graphic Operations:
  • Create charts , Enhance charts, Drawing toolbar features

Excel Formula Crash Course…..

Who is this course for?

If you use MS Excel to do data analysis, reporting, day to day tracking or project management then this is the right course for you. If you struggle with formulas or not sure which formula to use for any given occasion, then this is the perfect course for you. We will be introducing more than 40 different formulas with 100s of examples in this course. As we will be using realistic data & examples, you can very quickly apply the same to your day to day work and do so much more with ease & confidence.

What are the topics of this course?

This course has 6 topics or modules. See below:

Course Contents - Excel Formula Crash Course