Advanced Excel Course Syllabus

Introduction

Learning our advanced excel course syllabus could be an excellent way to hone your excel skills. Our syllabus focuses more on DCOUNT, DSUM, Pivot Chart, Pivot Table, Functions, Formulas, Macros etc. By mastering our course content, you can easily excel in your career. Our curriculum not just includes theoretical concepts, but also practical training, tutorials and workshops to level up your skills. By utilizing our advanced excel course syllabus to the fullest, you can become more than just a participant in this competitive world. You can be a front runner. With the help of our advanced excel course in Chennai, you can gain more knowledge about excel and become a desired professional in the industry.

Advanced Excel Course 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

Excel 2007 & 2010, 2013, 2016 Quick Overview

• Difference between Excel 2003, 2007 and 2010,2013,2016
• Use of Excel, its boundaries & features

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 – basic

• 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 / Lables
• 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

Working with Reports

• Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers ( Version 2010 & Above)

Text Functions Using

• The Mid/ Search/ Left/ Right Functions
• Using The Trim/ Clean/ Upper/ Lower Functions
• Using The Subsitute/ 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

Conclusion

When you dive deep into our advanced excel course syllabus, you can easily upskill yourself and get recognized for your unique abilities and skills to use Microsoft excel. Our course content would equip you with the knowledge necessary to make you stand out from the rest in the field. With the help of our easy-to-understand course curriculum, you can master the excel concepts. By taking advantage of our advanced excel training in Chennai, you can enhance your skills and flourish in your career.