EXCEL COMPLETE TRAINING (Basic to Advanced Level)

We teach Excel 2016 & 2019 Latest Version

Overview:

Our Complete Excel training will really show you how to make Excel work for you. The course is aimed for those who wants to learn Excel from basic to advanced level. It is completely designed to master Excel. This course will cover all aspects of creating Spreadsheets, Performing calculations,Data Validation, VLookup, HLookup, SumIf, CountIf, Ranges, Match, Index etc. It also guides you on data presentation using Conditional Formatting, Excel-Charts, Formatting and using page setup for printing. Our Complete Excel training teaches you not only basics of Microsoft Excel but also the application of it to your everyday problems. We evaluate candidate’s knowledge level, their problems and adjust our training to their specific needs. Getting Excel to make decisions using the IF function, You will learn how to create templates for commonly used worksheets. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper MS Excel tools to create a unique solution. This training will also enable you to create, build and customise graphs. Existing MS Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.

It also covers more complex functions, advanced IF conditions formulas, dashboards, pivot tables, pivot charts, goal seek, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. We also teach you how to develop these advanced solutions on the worksheet and to assemble the proper Excel tools in ways you have never thought of before. Find out how you can utilise advanced IF statements.

  • Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
  • Methods to Move, Copy & Paste data
  • All the Options in Paste Special and Go To
  • Insert, Delete and Hiding Rows & Columns
  • Inserting and Deleting ranges
  • Insert, Delete and Move Cells
  • Various Navigation techniques
  • Sheet tab formatting and Renaming
  • Copy and Clear Formats and Merge Cells
  • Methods to Move, Copy & Paste data
  • All Formate Cells Options
  • Uses of Toolbars and Formula Bar
  • Protecting and Sharing Workbook, Worksheet and Cell ranges
  • Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks
  • Methods to Move and Copy sheets
  • Uses of Hyperlinks and Define Name

Uses of Intermediate Excel Formulas

SUM, SUBTOTAL, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, EXACT, HYPERLINK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT, PROPER, MAX, MIN, TIME, DATE, DAY, MONTH, YEAR, ROUND, SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT, NETWORKDAYS, DATEDIF, NOW etc,

Various Methods and Uses of Advance Excel Formulas

VLOOKUP, HLOOKUP, SUMIF, SUMIFS, SUMPRODUCT, COUNTIF, COUNTIFS, IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT, GETPIVOTDATA, OR, AND, INDEX, MATCH etc,

Various Methods and Uses of IF Conditions
  • When should use the “IF” Conditions?
  • Creation of Multiple IF Conditions in One Cell
  • Use the IF Conditions with the Other Advance Functions

How to use nested IF statements in Excel with AND, OR Functions

  • Various Methods of Filter and Advance Filter options
  • Creating and Updating Subtotals
  • Various Methods of Text to Column options
  • Uses of Data Grouping and Consolidation options
  • Uses of Goal Seek and Scenarios Manager
  • Various Method of Sorting Data
  • Creating, Formatting and Modifying Chart
  • Data Validation, Creating drop down lists using different data sources
  • Linking Workbooks and Uses of Edit Link options
  • Excel Options, Customizing the Quick Access Tool Bar

Formula Auditing features and Trace formula error

Pivot Tables
  • Various Methods and Options of Pivot Table
  • Using the Pivot Table Wizard
  • Changing the Pivot Table Layout
  • Subtotal and Grandtotal Options
  • Formatting
  • Grouping items
  • Inserting calculated fields
  • Pivot Table Options
  • Display and hide data in fields
  • Select, Move & Clear  Pivot data

Creating and Modifying a PivotChart

Our session will not just stop with teaching you the above options, we go beyond to make you an expert in using the various options in real time scenario