Excel Beginner to Pro

If you want to become an expert in Excel it will help you to become an advanced professional in Excel.

if you want to become a pro in Excel to boost your productivity, and efficiency in excel?

If you are struggling while working with the excel sheets and their data?

If you are not sure how you can improve your skills in excel?

If any of the above questions answer is Yes, then this is the right course for you, with more than 80 tips which are covered in this course, which will make you an expert in Microsoft excel.

The following topics are covered in this course:

• Productivity tips

  • Autofill & flash fill

  • CTRL + ALT shortcuts

  • cell protection and its usage

  • Advanced sorting & filtering

• Formatting tips

  • Invisible text

  • Frozen pens

  • Custom number formats

  • formula formatting

  • snap to grid example

• Formula tips

  • Unique & Duplicates

  • Formula auditing Tools

  • different Calculation Modes

  • Fuzzy-Match lookups

  • INDEX & MATCH with its example

• Visualization tips

  • Filled Maps

  • Sparklines

  • Dynamic Ranges

  • Form Controls

  • Custom Templates

• Pivot table tips

  • Custom Sort Lists

  • Date & Value Grouping

  • what are Slicers & Timelines and How to use them?

  • Cache Source Data

  • Conditional Formatting

• Analytics tips

  • Data Modeling

  • Goal Seek & Solver

  • Outlier Detection

    
    

    All these topics with a handful of examples with practical demonstrations.

  At the end of this course, you will become a confident excel professional (Power User) who can do most of your excel work so easily with advanced formulas, interactive visuals and charts, which will save your time and will help you to achieve your goals.

Having worked for more than 14 years in the IT industry on various projects in a multinational company for clients across the globe.

With rapidly changing technologies, I have always adopted new technologies.

Having started my professional career with Java technologies, I have worked on many technologies in Business Intelligence technologies.

Over the 14 years I have worked on the below tools:

- Java  ( Enterprise development)

BI Technologies

- WebFocus

- SAP Business Objects Reporting  (BI)

- SAP Design Studio (BI)

- SAP Lumira Designer (BI)

- SAP Analytics Cloud (BI)

- Microsoft Power BI Desktop/Microsoft Power BI Pro

ETL Technologies

            - Microsoft SQL Server Integration Service(SSIS)

            - SAP BusinessObjects Data Services(BODS)

            - Pentaho

Having been a quick learner of new technologies and passionate about working in these technologies I have always believed in sharing knowledge.

Sharing knowledge is one thing that gives immense satisfaction to me, that is why I started a Youtube channel ('Atul Kadlag') where I have been sharing my technical knowledge for more than 5 years.