Download Syllabus




    Advanced Excel Course Syllabus | Advanced Excel Syllabus

    Advanced Excel Course Syllabus

    Have you been looking for a Professional Training Institute where you can learn Microsoft Excel in depth? Join Softlogic’s Advanced Excel Training in Chennai to learn Excel from scratch or brush up on your skills with the help of our seasoned professionals. Our Advanced Excel Course Syllabus  will teach you everything you need to know to analyze data at any level.

    We at Softlogic offer an application-oriented Advanced Excel Course Syllabus that has been expertly crafted by subject matter specialists to meet the needs of the international corporate sector. Our Advanced Excel course curriculum, which is put together by industry experts, includes an understanding of how to set up Excel sheets with various functions and formulas, pivot tables, and data visualization. Explore our comprehensive Advanced Excel training in Chennai whose courseware covers everything from the fundamentals to advanced skills.

     

     

     

    Advanced Excel Course Syllabus | Advanced Excel Syllabus

    • Font formatting
    • Number formatting
    • Table formatting
    • Conditional formatting
    • Hide / Unhide
    • Sort/filter
    • Paste special
    • Find and select

    Insert

    • Illustrations
    • Charts
    • Tex

    Page Layout 

    Basic Functions

    • Sum / Average / Count / Max / Min
    • Basic Text / date / time / lookup / information functions
    • Name manager
    • Formula Auditing

    Data

    • Import from web
    • Import from text
    • Text to columns
    • Remove duplicates
    • Grouping and ungrouping

     

    Review

    • Proofing
    • Comments
    • Protection

    Views

    • Types of views
    • Zoom
    • Windows

    Developer

    • Enable developer
    • Using checkbox/option buttons

    Advanced Excel Course Syllabus

    Excel 2007 & 2010, 2013, 2016 Quick Overview

    Basic Formula

    • Formulae that Add / Subtract / Multiply / Divide
    • BODMAS / Formula Error Checking
    • The Sum Function

    Absolute Referencing

    • Problems with Absolute / Relative Cell Referencing
    • Creating Absolute / Mixed References

    LOOKUP Functions

    • The VLOOKUP/ HLOOKUP Functions

    PivotTables

    • Creating, Formatting Simple PivotTables
    • Page Field in a PivotTable
    • Formatting a PivotTable
    • Creating / Modifying a PivotChart

    Logical Functions 

    • IFs and Nested IF Functions
    • Using AND / OR / NOT Functions

    Statistical Functions 

    • Using The SUMIF / COUNTIF Functions
    • Using The AVERAGE / COUNT / LARGER / SMALLER Functions

    Pivot Tables – Advance

    • Adding new calculated Fields / Items
    • Changing the Summary Function
    • Consolidate Pivot table

    LOOKUP Functions – Advance 

    • MATCH with VLOOKUP Functions
    • INDEX & MATCH Functions
    • OFFSET / INDIRECT functions

    Logical Functions – Advance

    • If Loop and Nested IF Loop Functions
    • Using IF / ISERROR Functions

    Chart Data Techniques 

    • The Chart Wizard
    • Chart Types
    • Adding Title / Legends / Labels
    • Printing Charts
    • Adding Data to a Chart
    • Formatting / Renaming / Deleting Data Series
    • Changing the Order of Data Series

    Date / Time Functions

    • Using The Today
    • Now & Date Functions
    • Using The Datedif / Networkdays / Eomonth Functions 
    • Using The Weeknum Functions
    • Using The Edate / Networkdays. Intl / Weekdays.Intl Functions

    Text Functions Using

    • The Mid / Search / Left / Right Functions
    • Using The Trim / Clean / Upper/ Lower Functions
    • Using The Substitute / Text Functions
    • Using The Trim / Clean / Proper / Dollar Function

    Validations

    • Input Messages / Error Alerts / Drop-Down Lists
    • Conditional Formatting

    Advanced Filters 

    • Extracting Records with Advanced Filter
    • Using Formulas in Criteria

    Advanced Sorting

    • Sorting by Top to Bottom / Left to Right
    • Creating / Deleting Custom List
    • Sort by using Custom List

    Hyper / Data Linking

    • Hyper linking data, within sheet / workbook
    • Linking & Updating links between workbooks & application

    Math & Trigonometry Functions

    • Using SUMPRODUCT Functions
    • Using FLOOR / CEILING/ MROUND / MOD / QUOTIENT Functions

    Summarizing Data

    • Creating Subtotals / Nested Subtotals
    • SUBTOTALS Formula

    Outlining

    • Creating / Working with an Automatic / Manual Outline
    • Grouping / Ungrouping

    Consolidation

    • Consolidating Data with Identical / Different Layout

    Using Auditing Tools

    • Displaying / Removing Dependent & Precedent Arrows
    • Evaluate Formula – Step IN / Step Out

    Custom Views

    • Creating Custom Views
    • Displaying Custom Views
    • Deleting Custom Views

    Sharing and Protecting Workbooks

    • Sharing Workbooks & Tracking Changes
    • Protecting sheets/workbooks / Files

    Importing & Exporting Data

    • Importing Data from Database / Text Files /  Web
    • Exporting Data
    • Changing External Data Range

    Our detailed Advanced Excel Course Syllabus  must have impressed you and instilled a strong hope in our Advanced Excel training in Chennai. Our curriculum includes extensive training along with its exhaustive Advanced Excel Course Syllabus  under the inspiring guidance of industry experts. Wait not. Act immediately. Enroll Now.