Advanced Excel Training in Indore?

Get going from the basics of MS Excel to advanced Excel & VBA/Macros programming. Taught by professionals with a practical approach, we also pay attention to your unique needs. It is a 15 hours (Instructor-Led) activity-based program, covering core fundamentals of Excel to the most Advanced Level including 60+ Formulae, Dashboards, Pivots, Charting, What-If Analysis, Grouping, Data Protection, etc. coupled with 50+ real-time Assignments, 350+ Video Lessons (Study material), Excel Shortcut Tool and On-job post-training support.

Originally conceived as an institute dedicated to everything MS Excel, we have mastered the art of mentoring students and professionals in all aspects of Excel. We have by now trained 2000 students on Advanced Excel and VBA programming.

Advanced Excel

Course Duration 20 Day's

Course Content of Advanced Excel Training in Indore

    BASIC EXCEL

    Excel Introduction
  • A overview of the screen, navigation and basic spreadsheet concepts
  • Understanding workbooks, worksheets, rows, columns, cells
  • Various selection techniques
  • Entering Data
  • Entering, Editing and Deleting Text, Numbers, Dates
  • Using Auto Lists
  • Moving and Copying data
  • Inserting, Deleting and Hiding Rows & Columns
  • Inserting, Deleting, Moving and Copying Sheets
  • Using navigation techniques
  • Customizing Excel
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Creating a Custom AutoFill List
  • Creating a Custom Number Format
  • Customizing Excel Review
  • Managing and Vavigation Large Workbooks
  • Using Workbook Views
  • Selecting and Switching Between Worksheets
  • Splitting and Freezing a Window
  • Creating Headers and Footers
  • Hiding Rows, Columns, Worksheets, and Windows
  • Working with Multiple Workbook Windows
  • Creating a Template
  • Managing Workbooks Review
  • Creating and Editing Formulae
  • Concept of Formulae
  • Creating Formulae, Editing Formulae
  • Bodmas : Mathematical Order
  • Copying Formulae
  • Using Functions - Sum, Average, Max,Min, Count, Counta
  • Applying Absolute (Fixed) Referencing
  • Refencing Techniques
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
  • Moving Range Reference
  • Formatting and Proofing
  • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  • Basic conditional formatting
  • Copying and Clearing Formats
  • Working with Styles
  • Spell Check, Find & Replace and AutoCorrect

    INTERMEDIATE EXCEL

    Mathematical Function
  • SumIf, SumIfs
  • CountIf, CountIfs
  • AverageIf, AverageIfs
  • SumProduct, Subtotal
  • Lookup Functions
  • Vlookup / HLookup
  • Match
  • Dynamic Two Way Lookup
  • Creating Smooth User Interface Using Lookup
  • Offset
  • Index
  • Dynamic Worksheet linking using Indirect
  • Logical Functions
  • Nested If ( And Conditions , Or Conditions )
  • Alternative Solutions for Complex IF Conditions to make work simple
  • And, Or, Not
  • Text Functions
  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len
  • Concatenate
  • Find, Substitute
  • Date and Time Functions
  • Today, Now
  • Day, Month, Year
  • Date, DateDif, DateAdd
  • EOMonth, Weekday
  • Rounding Function
  • Round
  • RoundUp
  • RoundDown
  • MRound
  • Error Handling Functions
  • isNa
  • isErr
  • isError
  • Advanced Paste Special Techniques
  • Paste Formulas
  • Paste Formats
  • Paste Validations
  • Paste Conditional Formats
  • Add / Subtract / Multiply / Divide
  • Merging Data using Skip Blanks
  • Transpose Tables
  • Sorting
  • Sorting on Multiple Fields
  • Dynamic Sorting of Fields
  • Bring Back to Ground Zero after Multiple Sorts

    ADVANCED EXCEL

    Import &Export of Information
  • From Web Page
  • Exporting to XML
  • Creating Dynamic Dashboards and Reports Using Data on Other Applications
  • Using Text To Columns
  • What is Analysis
  • Goal Seek
  • Scenario Analysis
  • Data Tables
  • Grouping & Subtotals Data Validation
  • Number, Date & Time Validation
  • Text Validation
  • List Validation
  • Handling Invalid Inputs
  • Dynamic Dropdown List Creation using Data Validation
  • Protecting Excel
  • File Level Protection
  • Workbook Level Protection
  • Sheet & Cell Level Protection
  • Setting Permissions for Specific Tasks
  • Track changes
  • Consolidation
  • Consolidating data with identical layouts
  • Consolidating data with different layouts
  • Consolidating data with different Sheets
  • Conditional Formating
  • Creating Basic Conditional Formats
  • Managing Conditions Created
  • Dynamic Formatting using Formulas in Conditional Formatting
  • Pivot Tables
  • Creating Simple Pivot Tables
  • Basic and Advanced Value Field Setting
  • Sorting based on Labels and Values
  • Filtering based on Labels and Values
  • Grouping based on numbers and Dates
  • Drill-Down of Data
  • GetPivotData Function
  • Calculated Field & Calculated Items
  • Charts & Pivot Charts
  • Bar Charts / Pie Charts / Line Charts
  • Dual Axis Charts
  • Dynamic Charting
  • Other Advanced Charting Techniques
  • Excel Dashboard
  • Bar Charts / Pie Charts / Line Charts
  • Planning a Dashboard
  • Adding Tables to Dashboard
  • Adding Charts to Dashboard
  • Adding Dynamic Contents to Dashboard

Our Industry ready courses

Future Multimedia Offers 40+ Job Oriented Courses Discover the Best Course that Suits You

Join best Web Development Training in indore this programme to acquire practical knowledge and skill sets on.

Join best gst Training in indore this programme to acquire practical knowledge and skill sets on.

Join best Tally Training in indore this programme to acquire practical knowledge and skill sets on.

Join best Wordpress Training in indore this programme to acquire practical knowledge and skill sets on.