Advanced Excel refers to a set of skills and techniques that go beyond the basic features of Microsoft Excel, which is a popular spreadsheet software used for data analysis and management. Advanced Excel skills can help users to automate complex tasks, analyse and visualize data more effectively, and create sophisticated reports and dashboards.
Advanced Excel skills are in high demand by many employers, so learning these skills can enhance career opportunities and earning potential.
Learning Excel can be beneficial for a variety of reasons. Some of the main reasons to learn Excel include:
4.9 Star from 900 ratings, 1500+ Students Enrolled
Per Sessions 3 Hours, Weekend & Weekday Both Available
CURRICULUM
Introduction to Excel
- Excel Limitation
- Ribbons Introduction
- Excel Setting & Custom list Creation
- Advanced Past Special
- Go to Special & Format painter Trick
- Link data range as picture Link
- Lookup Picture in Excel Worksheet
Data Formatting
- Excel Short Cut
- Important Tricks for data preparation
- Flash Fill, Justify, Series, Clipboard
- Advanced Custom Sorting Multiple Condition
- Format Cell (Number, Alignment, Font, Border, Fill)
- Advanced Custom Format
- Lower, Proper, Upper
- Row, Rows, Column, Columns, for data preparation
Logical Formulas
- Simple IF Condition
- Multiple or Nested IF Condition
- AND, OR Condition
- Multiple AND, OR Condition
- IFERROR, IFNA, XOR, TRUE, FALSE, NOT
- Basic Conditional Formatting
- Advanced Conditional Formatting with Formulas
- Hyperlink Method, Data Validation, Remove Duplicates
- Protection & Advanced Protection (Workbook, Cell, Sheets)
- Trace Precedents, Trace Dependents
- Track Changes for sheets, Complete Text to Column
- Filter & Advanced Filter
Text Formulas
- Char, Clean, Code, Concatenate, Dollar
- Exact, Find, Search, Fixed
- Left, Mid, Right, Len, T, Value, Rept
- Rept with Chart Example
- Text, Number value, Trim, Unichar, Unicode
- Replace, Substitute, Multiple Substitute
- Advanced Find & Search Example
- Data Preparation for important text formulas
Date & Time Formulas
- Today, Now, Date, Date value, Day, Days, Month, Year, Time, TimeValue
- Hour, Minute, Second, Days360, Edate, Eomonth, Weekday, Weeknum
- Workday, Workday.INTL, Network days, Networkdays.INTL, Isoweeknum
- How to create Dynamic Attendance using formula & conditional formatting
- Time Calculation & Trick Create Hourly Report & Day Wise Report
Lookup & References
- Address, Areas, Choose, Formula Text, Getpivotdata, Vlookup, Hlookup, Hyperlink
- Index, Match, Indirect, Lookup, Offset, RTD, Transpose, Advanced Vlookup & Hlookup
- Example Multiple Vlookup & IF Condition Vlookup & Indirect Condition Vlookup & Choose
- Index & Match Condition
Mathematics, Statistical & Information Formulas
- Countif, Countifs, Sumif, Sumifs, Averageif, Averageifs
- Most Powerfull functions Sum product
- ABS, Aggregate, Subtotal, Even, Odd, Exp, Fact, Int, Mod
- PI, Product, Power, Rand, Rand between, Round, Roundup, round down
- Min, Mina, Max, Maxa, Median, Growth, Trend
- All Information Formulas
- Data Analysis Solver and Goal Seek?
Complete Pivot Table & Power Pivot
- Create Pivot Table & Charts
- Data Sorting in pivot table
- Filter in pivot table Value field settings in pivot table
- Group & Ungroup, Report Layout, Subtotals & Grand Total Pivot Table
- Complete Example Calculated (Field & Item)
- Charts, Slicer, Timeline, Get pivot
- Power Pivot Example
Complete Charts & Tricks
- Fundamental Charts
- Waterfall Charts
- Pareto Charts for quality
- Dynamic Chart Using Offset Formula
- Dynamic Name Manager Using Offset Formula
- Important Infographic Charts for Dashboard
- Dynamic Sales Speedo Meter Chart's
- Analysis Chart for Comparison
- Forecast & Actual Chart with comparisons
My Favourite Example’s
- How to logic buildup in excel formula
- Basic to Complex Array 15 Example
- Advanced Vlookup, Choose, if, Left, Mid, Right Advanced Example
- Offset, Indirect, Hlookup, Address, Len, Advanced Example
- Advanced Sumproduct with multiple formula
- Dynamic Project with multiple formula
- Think and apply formula in excel
Corporate for Dashboard list
- Health Care Making Dashboard
- Hr Analytics Dashboard
- Sales Dashboard
- Finance Dashboard
- Logistics Dashboard
- My Special Trick for dashboard example’s