• (5.0 Star)

Advance Excel

Certification Training

We provide Online Instructor And Classroom Instructor led Live virtual classroom by certified trainers/ industry professionals

  • Get Up to 35% discount

About Course

This Advanced Excel Training program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2013. The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2013, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Key Features

You will get 100% job Assurance and life time e-placement support

classed taken by globally certified trainers

You will get 3 year Dedicated placement support

Courses are globally recognized & accredited

Advance Excel

Course Type:

Certification Training

Live virtual classroom:

3.199/-

3,999/-

Regular classroom:

3.199/-

3,999/-

  • Duration:

30 Hrs.

  • Enrolled:

108 Learners

  • Eligibility:

Fresher 10th/10+2 with Basic Excel

  • 5 Star:

15 Reviews

Share this Course

MODULE - I

  • Reasons for Using Custom Format
  • Understanding Conditional Formatting
  • Managing the Conditional Format Rules
  • Changing the Conditional Formatting Rules
  • Locating Cells with Conditional Formatting
  • Working with Conditional Formatting
  • Assigning Names to Groups of Cells
  • Managing Named Range
  • Using Names in Formulas
  • Understanding Formulas & Functions
  • Quick Way to Insert a Function
  • Viewing the Formulas (and not the results)
  • How to Delete Values and not Formulas
  • Create a Relative & Absolute Reference
  • Working with Logic Functions
  • Using SUMIF() and COUNTIF():
  • Adding and Counting only the Cells you Specify
  • Working with Text Functions
  • Using More Text Function
  • Working with Date and Time Functions
  • Working with Lookup Functions
  • Understanding VLOOKUP() Function
  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First or Last Column
  • Outline a List of Data
  • Validating Data During Entry
  • Working with Database Functions
  • How to Use Advance Filters in Excel
  • Summarizing Data Visually Using Charts
  • Creating a Chart Quickly
  • Changing the Chart Type
  • Customizing Chart Data
  • Altering Chart Options
  • Changing the Chart Body
  • Show or Hide Chart Gridlines
  • Creating a Pie Chart
  • Saving the Chart as a Template
  • Creating Combination Charts
  • What is a Pivot Table
  • Anatomy of a Pivot Table
  • How does a Pivot Table Works
  • Create a Basic Pivot Table Report
  • Rearranging a Pivot Table Report
  • Customizing a Pivot Table
  • Changing Summary Calculations
  • Adding and Removing Subtotals
  • Sorting in a Pivot Table
  • Filtering in a Pivot Table
  • Create Report Filter Pages
  • Using Slicers in Pivot Table
  • Working with Pivot Chart
  • Working in a Group Environment
  • Sharing Workbooks in Excel
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Accepting or Rejecting Changes
  • Keeping a Backup of your Changes
  • Linking to Other Workbook
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets
  • Protecting Your Worksheet
  • Protecting Your Formulas
  • Protecting Your Workbook
  • Save Your Workbook with Password
  • Encrypting your Workbook
  • Recording & Testing a Macro
  • Using the Developer Tab
  • Create a Macro
  • Relative and Absolute Recording
  • Testing the Macro
  • Running and Deleting Macros
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • A Quick Introduction to Macro Programming in Excel

Sent Us a Message