• New Announcement !!! Upcoming Batch Starting Soon                   Online-Offline Batch Available

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:

  • Increased productivity: Excel can help you automate repetitive tasks, such as data entry, calculations, and formatting, saving you time and increasing your productivity.
  • Improved analysis and decision-making: Excel offers powerful data analysis tools that can help you make informed decisions. With Excel, you can analyze large amounts of data, create charts and graphs, and perform complex calculations.
  • Better organization and data management: Excel can help you keep your data organized and easily accessible. You can sort, filter, and search data to find what you need quickly, and use features like conditional formatting to highlight important information.
  • Increased career opportunities: Excel is a widely used tool in many industries, and proficiency in Excel can be a valuable skill for job seekers. Many employers require or prefer candidates who have experience with Excel.
  • 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