Excel and Tableau Certification Training

Jon an A-Z Microsoft Advanced Excel and Tableau  Training & acquire the necessary skill sets to work with Microsoft Excel sheets, and Tableau is widely used business intelligence (BI) and analytics software to explore, visualize, and securely share data in the form of Dashbaords and Worksheets.

  • Duration : 6 Weekend
  • English


Excel and Tableau Certification Training
  • Online Bootcamp

    Learners

    2345+

  • Online Bootcamp

    Companies

    213+

  • Online Bootcamp

    No. of Openings

    343+

  • 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.
  • Tableau is widely used business intelligence (BI) and analytics software to explore, visualize, and securely share data in the form of Dashbaords and Worksheets. With its user-friendly drag-and-drop functionality it can be used by everyone to quickly clean, analyze, and visualize your team’s data. Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms

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
  • Lecture: 01
    Data Extraction from various sources: Excel, Database and Online Websites
  • Lecture: 02
    Joining Logics in Tableau
  • Lecture: 03
    Data Cleansing
  • Lecture: 04
    Imputing Data
  • Lecture: 05
    Pivot and Unpivot the data in Tableau
  • Lecture: 01
    Bar chart
  • Lecture: 02
    Line Chart
  • Lecture: 03
    Combination Chart
  • Lecture: 04
    Pie Chart
  • Lecture: 05
    Heat Map
  • Lecture: 06
    Tree Map
  • Lecture: 07
    Bubble Chart
  • Lecture: 08
    Scatter Plot
  • Lecture: 09
    Histogram
  • Lecture: 10
    Box Plot
  • Lecture: 01
    String Functions
  • Lecture: 02
    Logical Operators
  • Lecture: 03
    Arithmetic Operations
  • Lecture: 01
    Dynamic Input through Parameters
  • Lecture: 02
    Forecasting Models
  • Lecture: 03
    Segmentation
  • Lecture: 01
    Creation of dashboard
  • Lecture: 02
    Flow of the dashboard
  • Lecture: 03
    Filters
  • Lecture: 04
    Formatting
  • Lecture: 05
    Groups
  • Lecture: 06
    Hierarchies
  • Lecture: 07
    Marks and Annotation
  • Lecture: 01
    Participants to present 15 mins on case studies
  • Lecture: 02
    Feedback
  • Lecture: 03
    Best practices in Data Visualization
  • Lecture: 04
    FAQ

Course Orientation Video

Who can Attend

  • Freshers
  • Business Analysts
  • Business Intelligence Manager
  • Statisticians and Analysts
  • Data Scientists
  • Project Managers
  • Data Analytics Practitioners
  • Any professional who is keen to step into Analytics domain

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
  • This course will enable professionals to create standalone dashboard on Tableau software
  • It will introduce them to various capabilities and functionalities available in Data Visualization within Data Analytics domain
  • Hands-on experience in visualization tools which will help the individual to build data insight and story telling through data visualization

Job Roles:

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

CourseCertificate

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

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
18000
GROUP ENROLLMENT
Customized to your team's needs