Microsoft Excel Advanced Course in Jaipur

 

Course Name – Advanced Excel Course

Duration – 1.5 Months

 

Excel is one of the most popular software applications within the world and is used by firms in almost every industry, from pizza parlors to private equity. Companies, educational institutions, and government agencies all use Excel to manage and analyze data, create spreadsheets and reports, print charts, and far more. It’s no wonder why a working knowledge of this spreadsheet software is an important skill for people that spend a part of their workday ahead of a computer, even for people who don’t necessarily have an accounting or finance-related careers. Thus Excel skills are in demand, and it’s no surprise people with Excel knowledge are earning extra money than their counterparts.

 

Advanced Excel Training Course is best customized for the requirements of a professional.

 

Target Audience for Advanced Excel Training Course

 

  • Undergraduate, Graduates and Postgraduates

  • Job aspirants

 

Prerequisites for Advanced Excel Training Course

 

  • Basic Computer

  • Basic Internet

  • Basic Excel

 

Recommended Next Course

 

  • Commercial Accountant

  • Digital Marketing

 

Microsoft Excel Advanced Syllabus

 

  •  Introduction of MS Excel

  •  Entering Data in MS Excel

      •   Sequential Data

      •  Independent Data

      •  Dependent Data

  •  Cell Reference Types in MS Excel

  •  Excel Table Format

  • Applying Conditional Formatting

  •  Graphing & Charting in MS excel

  •  Using Sparkline in MS Excel.

  •  Hyperlinks in MS Excel

  • Printing Configuration in MS Excel

  •  Managing Comments in MS Excel

  • Pivot Tables & Pivot Charts

      • Using Slicers & Timelines

  • Data Sorting in MS excel

  • Data Filtering in MS Excel

  • Using Text to Columns Tool

  • Using Remove Duplicates Tool

  • Data Validation in MS excel

  • Data Consolidation in MS Excel

  • What if Analysis Tools in MS Excel

      • Using Goal Seek

      • Using Data Table

      • Using Scenario Management

      • Using Solver

  • Grouping and Ungrouping Data

  • Summarizing Data by Data Subtotal Tool

  • Data Protection in MS Excel

  • Creating Data Custom Lists

  • Defining Names to Range

  • Formulas Auditing in MS Excel

  • Getting / Importing External Data in MS Excel

  • Using Predefined Formulas (Functions) in MS excel:

      •  Date and Time Functions

      • Text Functions

      •  Mathematical Functions

      • Statistical Functions

      • Logical Functions

      • Lookup Functions

      • Financial Functions

      • Database Functions

      • Information Functions