Microsoft Advanced Excel Training

Jon an A-Z Microsoft Advanced Excel Training & acquire the necessary skill sets to work with Microsoft Excel sheets.

  • Duration : 3 Weekend
  • English


Microsoft Advanced Excel Training
  • Online Bootcamp

    Learners

    2540+

  • Online Bootcamp

    Companies

    760+

  • Online Bootcamp

    No. of Openings

    4300+

  • Online Bootcamp

    Ranking

    1

Course Overview

Microsoft Advanced Excel Training Certification will get you an in-depth knowledge of the Microsoft Excel Spreadsheets with a real-time and practical experience. Gaining mastery in Excel is an authentic credential in your resume which helps in prioritizing the profile during your interview. This course enables you to use the spreadsheets with functions, formulas, charts, data validation, data lists, record macro, pivot table, pivot charts, sampling, and Excel VBA.

For more information

Inquiry for:

Course Content

  • Lecture: 01
    Excel menu button
  • Lecture: 02
    Excel settings
  • Lecture: 03
    Shortcut Keys
  • Lecture: 04
    Excel Tricks
  • Lecture: 01
    Absolute, Relative, Mixed Reference
  • Lecture: 02
    Format as Currency, Comma Separator
  • Lecture: 03
    Format as Date
  • Lecture: 04
    Custom Format – Currency, Date & Other
  • Lecture: 01
    Naming Cells and Ranges
  • Lecture: 02
    Using named ranges in formulas
  • Lecture: 03
    Creating tables in excel
  • Lecture: 04
    Applying new style to tables
  • Lecture: 05
    Cell styles for titles & headings
  • Lecture: 01
    Cell Protection
  • Lecture: 02
    Worksheet Protection
  • Lecture: 03
    Workbook Protection
  • Lecture: 01
    Setting borders to present your work professionally
  • Lecture: 02
    Inserting Page breaker
  • Lecture: 03
    Custom Margin
  • Lecture: 04
    Page Orientation, Size
  • Lecture: 05
    Print Setup with specified Area, Print titles
  • Lecture: 06
    Print with sheet options, Custom print
  • Lecture: 01
    Excel workbook views
  • Lecture: 02
    Zoom selection of data
  • Lecture: 03
    Customize arrangement
  • Lecture: 04
    Comparison of two workbooks
  • Lecture: 05
    Freeze panes with top row and first column
  • Lecture: 06
    Customize Freeze panes
  • Lecture: 07
    Split and hide worksheets
  • Lecture: 01
    Creating Hyperlinks with web, sheet
  • Lecture: 02
    Inserting Objects
  • Lecture: 03
    Inserting Objects with link
  • Lecture: 01
    Spell Check, Thesaurus
  • Lecture: 02
    Smart lookup, Translate
  • Lecture: 03
    Adding new comments in a cell
  • Lecture: 01
    Highlighting the cells
  • Lecture: 02
    Includes icon sets, Data Bar
  • Lecture: 03
    Creating new rule
  • Lecture: 04
    Applying formula in new rule
  • Lecture: 05
    Highlight Cells – Single, Multiple Conditions
  • Lecture: 06
    Condition based on selection Referencing
  • Lecture: 01
    IF, Nested IF, AND, OR
  • Lecture: 02
    IF Condition with Text Contains
  • Lecture: 03
    Compound IF Function
  • Lecture: 01
    VLOOKUP, HLOOKUP
  • Lecture: 02
    MATCH, INDEX, INDIRECT
  • Lecture: 01
    COUNTIF, SUMIF
  • Lecture: 02
    COUNTIFS, SUMIFS
  • Lecture: 03
    COUNTA, COUNT, COUNTBLANK
  • Lecture: 01
    Setting Criteria - Text, Values and Dates
  • Lecture: 02
    Drop-Down List – Dependent
  • Lecture: 03
    Consolidation
  • Lecture: 04
    Advance filter
  • Lecture: 05
    Remove duplicates
  • Lecture: 06
    What IF Analysis with Goal Seek, data table
  • Lecture: 07
    Forecast Sheet
  • Lecture: 01
    Creating Pivot Table
  • Lecture: 02
    Filter Date Values as Month, Quarter, Years
  • Lecture: 03
    Classic pivot table
  • Lecture: 04
    Recommended pivot table
  • Lecture: 05
    Report Filter On Pages
  • Lecture: 06
    Pivot Chart with table
  • Lecture: 07
    Include Slicer & Creating Dashboard
  • Lecture: 01
    Sorting – Custom Sort, Multilevel
  • Lecture: 02
    Subtotals – Formula, Function
  • Lecture: 03
    Filtering – Advanced Filter
  • Lecture: 01
    Creating Multiple Chart Type
  • Lecture: 02
    Primary, Secondary Chart, Sparkline charts
  • Lecture: 01
    Grouping
  • Lecture: 02
    Import data from web
  • Lecture: 03
    Import from other sources like text file, access, Power Query
  • Lecture: 01
    LEFT, RIGHT, MID, UPPER, PROPER, LOWER
  • Lecture: 02
    EOMONTH, EDATE, NETWORKDAYS, WORKDAY
  • Lecture: 03
    DATE, TIME, TODAY, NOW, TEXT, SUBSTITUTE
  • Lecture: 04
    SEARCH, FIND, LEN, TRIM, SUBTOTAL, AVERAGE
  • Lecture: 05
    SUM, MIN, MAX, PMT, FORECAST, IFERROR, EXACT
  • Lecture: 01
    Record macros for automating tasks
  • Lecture: 02
    Creating Button to run a Macro
  • Lecture: 03
    Macro with Keyboard & its benefit
  • Lecture: 04
    Run / Delete a macro
  • Lecture: 01
    Introduction about VBA Scripts
  • Lecture: 02
    Advantages
  • Lecture: 03
    First Macro Creation

Course Orientation Video

Batch Details

  • Start date: 21-Aug, 2021
  • Days: Saturday and Sunday
  • Time: 10.00 AM to 1.00 PM

Who can Attend

  • Freshers
  • Business Analysts
  • Business Intelligence Manager
  • Statisticians and Analysts
  • Data Scientists
  • Project Managers

Pre-requisites

  • Any Bachelor’s Degree
  • PC/ Laptop with Internet Connection for online sessions

Training Outcome

  • Indicate the names and functions of the Excel interface components
  • Enter and edit data
  • Format data and cells
  • Construct formulas, including the use of built-in functions, and relative and absolute references
  • Create and modify charts
  • Preview and print worksheets

Job Roles:

  • Administrative Assistant
  • Accountants
  • Retail Manager
  • Cost Estimator
  • Financial Analyst
  • Project Manager
  • Business Analyst
  • Data Journalist

Skills Covered

  • Data Forecasting
  • Data Analysis
  • Excel Functions
  • Charts
  • Dashboard
  • Data Visualization
  • Reporting and Productivity in work

Learning path

  • Excel Introduction & Setting
  • Cell Referencing & Number Formatting
  • Named Ranges, Tables & Styles
  • Protection
  • Page Layout
  • Workbook View
  • Excel Hyperlinks & Objects
  • Excel Proofing & Comments
  • Conditional Formatting
  • Logical Functions
  • Lookup Functions
  • Statistical Functions
  • Data Validation & Forecasting
  • Pivot Tables and Pivot Charts
  • Working with Data Lists
  • Advanced Charting
  • Data Tools & External Data
  • Excel Advanced Formula’s
  • Record Macro
  • VBA Macro

Tools Used

  • What IF analysis
  • Data Forecast
  • Charts

Skilltechnika's Advantage

Live Interaction

Live Interaction Session

Hands-On Practice

Hands On Practice

Real Time Project

Real Time Project

Curriculum

Latest Curriculum

Recorded Session

Recorded Sessions

Industry Connects

Industry Connects

Peer Learning

Peer Learning

Mentor Support

Mentor Support

Assessments

Assessments

Training Options

Live Online Session
6000
QUICK ENROLLMENT
6000
GROUP ENROLLMENT
Customized to your team's needs