Advance MS Excel - APG Learning
nav-closed

Register for interview

advance ms excel

Write to us for more information

Advance MS Excel

The beauty of Excel lies in its ability to simplify various tasks like filling out the ledger sheets, calculating and recalculating totals, applying the formula and get desired results. You have a need to streamline repetitive tasks and display spreadsheet…

  • Please Login..review_star 123
  • student_enrolled 54 Student's Enrolled
  • best_selling Best Selling
Write to us for more information

Course Detail

Duration

2 Days

Modules

13

Hours

Start Date

29 Sep 2018

Course Provider:

APG Learning

2,550.00 3,200.00

Training 5 or more people?

Get your team access to APG Learning top 200+ courses anytime, anywhere.

Try APG Learning for Business

About Course

The beauty of Excel lies in its ability to simplify various tasks like filling out the ledger sheets, calculating and recalculating totals, applying the formula and get desired results. You have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis, and formulas. This Workshop will provide you an opportunity to get an overview of various features of MS Excel. The participants should be conversant with basic operations of MS Excel. The demonstration will be based on MS Office 2013 version.

Modules

  • Pivot Table
  • Conditional Formatting
  • Excel Charts
  • Data Sorting
  • Excel Security
  • Working with Formulas & Functions
  • Sorting & Filtering data
  • Formatting
  • Working with V lookup & Index and Match
  • Working with Range Names
  • Data Validation
  • Working with Templates
  • Working with Pivot Table, Power Pivot & Other Reporting Tools.

Learning Outcomes

This Excel training program will empower the participants to be able to do the following:

  • Organizing and analyzing large volumes of data.
  • Designing and using templates.
  • Consolidating and managing data from multiple workbooks.

Who Should Attend

This program is for anyone who would like to make better use of Microsoft Excel and would like to improve their efficiency in working with worksheets, analyzing data, and automating various tasks.

SIMILAR COURSES

nav-closed

Download Brochure