Learn at Softlogic as our Advanced Excel Course Syllabus will help you to work efficiently on excel tasks using formulae, referencing, functions, pivot tables, logical functioning, statistical functioning, chart data techniques, validations, advanced filters, advanced sorting, data linking, trigonometry functions, data summarizing, outlining, consolidation, sharing worksheets, and protecting worksheets along with importing and exporting data. Get a free copy of our Advanced Excel Course Curriculum here.
Advanced Excel Course Syllabus
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
- 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
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
Download Advanced Excel Course Syllabus
Our Advanced Excel Course Syllabus is designed for learners who want to upskill with the latest updates of Microsoft Excel for their efficient work. Join our Advanced Excel Training in Chennai at SoftAlogic as we offer classroom and instructor-led live online classes with hands-on exposure.