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)

Certifications & Affiliations

Image

Why SAMYAK ?

• Registered LLC Company in Florida, USA
• Presence in Dubai & Many States / Cities across India.
• An ISO 9001:2015 Certified Company
• GOOGLE & HP Certification Partner
• Authorized Tally Institution of Learning from Tally Company (HO)
• Authorized Microsoft, AutoDesk, Adobe, Apple, EC-Council & Unity Testing & Certification Partner
• Pearson Testing Centre – Oracle, Cisco, Salesforce, AWS, RedHat & ALL IT Giant’s Certification Partner.
• 17+ Branches Worldwide & Growing ...
• Dedicated IT team of 200+ working on International Level Projects

International CERTIFICATIONS with Live Projects

• Samyak believes in employability and hence Samyak provides training with less theory and more of Practical work.

• Course modules are prepared by Expert IT Professionals & HR.

• 100% Placement Assistance. We have good track record of placements.

• Samyak has 450+ Computers, Switches, Routers, PLCs, Hardware and Software AND has enormous in-house projects to support the project based training.

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

• Highest Rating ( Google, Facebook, Justdial & Others) & Global Rewards in Education Sector.

Click To Fix An Appointment