Advanced Excel

Advanced Excel courses are a most preferred choice for professionals looking to develop an edge over their peers. Microsoft Excel is everywhere in any professional & business environment, and advanced Excel skills are welcome in almost every

Duration - 2 Months

Course Fees: 7,000/- ( Inc. GST )

Installment: 5,000 + 2,000 = 7,000 k

Classes: 3day/week


Data Management and Analysis With Advanced Excel

Today Excel is a must know tool for any business. Programme is design to make you use Excel to solve complex problems, automate spreadsheets, and master graphs for presentations. The Advanced Excel course is guided by an Excel expert and trainer of 5+ years, whose experience with the platform will transform your Excel skills in under a week without the disappointment you are used to.

Upcoming Batches

Our Weekday batch (Monday to Friday):

  • Morning Batch 10:30 am to 12:30pm
  • Evening Batch 3:00 pm to 5:00pm

At the end of this course you will be able to:

  • Work with advanced lookup and reference functions
  • Create macros to automate common tasks
  • Use advanced techniques to analyse data
  • Create PivotTables and PivotCharts
  • Work with data validation tools
  • Import and export data

Advance Excel Course Highlights

  • Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar
  • Saving Excel File as CSV, Macro Enable Sheet, PDF and Older Versions
  • Using Excel Shortcuts with Full
  • List of Excel Shortcuts
  • Copy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets
  • Using Paste Special Options
  • Formatting Cells, Rows, Columns and Sheets
  • Protecting & Un protecting Cells, Rows, Columns and Sheets with or without Password
  • Page Layout, Themes, Background and Printer Properties
  • Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets
  • Using Conditional Formatting
  • Using Conditional Formatting with Multiple Cell Rules
  • Using Color Scales and Icon Sets in Conditional Formatting
  • Creating New Rules and Managing Existing Rules
  • 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
  • Adding Add-Ins in Excel
  • Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc
  • Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
  • Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc
  • Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
  • Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
  • Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
  • Sorting Data by Values, Colors, etc
  • Using Filters to Sort Data
  • Advance Filtering Options
  • Creating Pivot Charts
  • Types of Pivot Charts and Their Usage
  • Formatting Pivot Charts and Making Dynamic Pivot Charts

Get a Call Back

Submit

Quick Query

Submit
+91-9999553092
DTA Icon