Elevate your Excel expertise with our personalized one-on-one training
In today’s data-driven world, mastering advanced Excel skills is essential for success in any industry. Our tailored one-on-one training program will equip you with the knowledge and skills to tackle complex data analysis tasks, create insightful visualizations, and automate routine processes.
Advanced Excel Course Syllabus
Introduction
* Quick Overview
* 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
* XLOOKUP
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
Macros and VBA
Any Required Special functions / formulas
* We will try to cover any special /specific requirement for your need.
We understand that every industry has its own unique data analysis challenges. Our trainers will work closely with you to identify and address specific requirements relevant to your field, ensuring that you gain the skills you need to excel in your professional role.
Invest in your future with advanced Excel proficiency
Enroll in our one-on-one Advanced Excel training today and embark on a journey to master the powerful tools that will elevate your data analysis skills and career prospects.
Total Training Fees: 20,000/=
Total Duration: 10 Hours (2 hours x 5 Classes)
Training Mode: Individual Training, Your own timetable
Live Online Classes or Face to Face Direct Classes with our expert trainers.
Call +94 (0) 722000999 / +94 (0) 755123111 www.iss.lk. Medium : සිංහල / தமிழ் / English