Excel Reporting - Advanced

 Why take Basic to Advance Excel Training?

In present days each and every organization have their own data which has information regarding the activities in their organization. This asks for the necessity for getting deep insights from huge data that these companies have, to make better decisions for keeping their companies alive and ahead against their competitors.

Brief about topic

In Basic to Advance Excel course, you will be learning how to organize the data, analyzing the data using functions and others tools in Excel like pivot table. Also visualizing the data by inserting charts.

Course Content

Part-1

  • Introduction to Excel Components, Excel Basics.
  • Understanding worksheets, cells, rows & columns.
  • Cut, copy, paste, paste special cell contents.
  • Creating & Designing of tables.
  • Editing Workbook, Formatting Cells & Worksheets
  • Sorting & Filtering of data.
  • Creation of Charts.
  • Short-Cut keys for basic actions.

Part-2

  • Conditional formatting.
  • Working with Formulas
  • Formula Reference
  • Using Functions
  • Built In Functions
  • Advanced Filtering & Custom Sort.
  • Data Consolidation.
  • Data Validation.
  • Goal Seek.
  • Use of Solver Tool.
  • Dynamic Charts.

Part-3

  • Subtotals.
  • Text Functions.
  • Mathematical Functions.
  • Logical Functions.
  • Database Functions.
  • Date and Time Functions.
  • Lookup and Reference Functions.
  • Trace Precedents.
  • Trace Dependents.

Part-4

  • Data Filtering
  • Data Sorting
  • Using Range
  • Data Validation
  • Using Style
  • Using Templates
  • Using Macros
  • Adding Graphics
  • Cross Referencing
  • Printing Worksheet
  • Email Worksheet
  • Translate Worksheet
  • Workbook Security
  • Data Table
  • Pivot Table
  • Simple Charts:- Creation, Addition and Modification, Formatting of Charts
  • Pivot Charts         
  • Pivot slicer and timeline
  • Sparkline.
  • Name ranges
  • Remove Duplicates
  • Text to columns
  • What if analysis
  • Data analysis
  • Keyboard Shortcuts

 

  • Across the economic ecosystem, industries that rely most on data analysis include Retail Trade,Manufacturing,IT Services,Healthcare

  • Microsoft’s Excel leading the market share with over 750 million users worldwide – comScore.com

  • Excel is used by Finance, Sales, Marketing, HR among other departments

  • Deep Excel expertise is a much sought-after skill around the world

  • Get Certified, Earn Your Badge

Instructor-led live online classes

OFFER ! Pay an 'Early Bird' deposit now and save 10% on the final price!

Early Bird Offer

  • 07

    Jun

    Sat - Sun ( 5 Weeks )

    7:00 PM - 9:00 PM

    • 40% off

      18,334

    11,001
40% Off till 12-Jun
  • 08

    Jun

    Mon-Fri (3 Weeks)

    12:00 PM-2:00 PM(IST)

    • 40% off

      18,334

    11,001
40% Off till 12-Jun
  • 06

    Jun

    Sat- Sun (3 Weeks)

    4:00 PM-6:00 PM (IST)

    • 40% off

      18,334

    11,001
40% Off till 12-Jun

Live Classes

On-time scheduled virtual classes with limited trainer-student ratio.

Expert Trainers

Best industry experts with years of online training experience.

Tailored Course

Based on your expertise and goals we design course for you.

Flexible Schedule

Learn at your schedule , time zone and convenience.

Get Certified

Receive a certificate to confirm the level of your skills in a professional context.

Pallavi Verma

Overall satisfied with the course and feel that I have learned some good techniques for better time management. Thank you!

×

Get A Quote

Please fill your details. Fields marked with mandatory are mandatory

(Allowed types : PDF, DOC, XLS, JPEG, GIF, PNG )

Privacy Policy : We hate SPAM and promise to keep your email address safe.