Advanced Excel Training Course

Advanced Excel Training Course
Duration : 20 Hours

Excel is one of the most popular software applications in 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 much more. It’s no wonder why a working knowledge of this spreadsheet software is an essential skill for people who spend part of their workday in front of a computer, even for those that do not necessarily have an accounting or finance-related careers. Thus Excel skills are in demand, and its no surprise people with Excel knowledge are earning more money than their counterparts.
Advanced Excel Training Course is best customized for the needs of a professional.

Target Audience for Advanced Excel Training Course

  • Undergraduate, Graduates and Post-Graduates
  • Job aspirants

Pre-requisites for Advanced Excel Training Course

  • Basic Computer
  • Basic Internet
  • Basic Excel

Recommended Next Course

  • Commercial Accountant
  • Digital Marketing

Course Contents of Advanced Excel Training Course

Overview of the Basics
Working with Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets

Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell

Working with Templates
Sorting and Filtering Data

  • Sorting tables, Using multiple-level sorting, Using custom sorting
  • Filtering data for selected view (AutoFilter), Using advanced filter options

Working with Reports

  • Creating subtotals, Multiple-level subtotals
  • Creating Pivot tables, Formatting and customizing Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot

More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Formatting

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells

Macros

  • Relative & Absolute Macros, Editing Macro’s

WhatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager

Charts

  • Using Charts, Formatting Charts , Using 3D Graphs
  • Using Bar and Line Chart together , Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically
  • (Data Modified in Excel, Chart would automatically get updated)

Why SAMYAK ?

1. Registered LLC Company in Florida, USA
2. An ISO Certified Company
3. Corporate Division, Working on International Level Projects
4. HP Software University Partner
5. RKCL's (Rajasthan Govt) Training Partner
6. Govt. Approved Courses Provider
7. Authorized Microsoft Testing Centre
8. Authorized AutoDesk Testing Centre
9. Authorized Adobe Testing Centre
10. 10 Branches & Growing ...
11. Most Preferred Vendor working on Projects

Live Projects Based Professional Training

1. Samyak believes in employability and hence Samyak provides training with less theory and more of Practicals.

2. Samyak has 150+ Computers, Switches, Routers, PLCs, Hardware and supporting Software AND has enormous in-house projects to support the project based studies.

3. Students of Samyak get opportunity to avail internship and placements in and at partner companies of Samyak (in and out of India).

4. Samyak students have exclusive portal for placement, where companies exclusively request the quality students from SAMYAK only.

5. Being in multiple locations across the Globe, Samyak allows students to take transfer in needed circumstances.

6. Check student's reviews online at Justdial, Sulekha, Facebook, Google Pages etc.

7. Samyak is the fastest growing company in education / training domain, and provides all solutions through cutting edge technologies.

I want to meet SAMYAK Counselor & Faculty