Microsoft Advanced Excel with Power BI

Learn how to use Excel and Power BI to provide business workflow and BI practices effectively.

  • Duration : 6 Weekend
  • English


Microsoft Advanced Excel with Power BI
  • Online Bootcamp

    Learners

    2540+

  • Online Bootcamp

    Companies

    760+

  • Online Bootcamp

    No. of Openings

    4300+

  • Online Bootcamp

    Ranking

    1

Course Overview

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. You’ll be able to visualize data by creating various charts and maps; like pie & donut chart, tree maps, funnel charts, waterfall charts scatter, etc. for each of your projects. This course will enable you to get mastery in working with tables, matrices, querying data, slicers, filters, and publishing data.

Featured Image

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
    Basic Data Importing
  • Lecture: 02
    Importing Data from other Sources CSV, Word
  • Lecture: 03
    Enter Data Directly
  • Lecture: 04
    Importing from Websites, SQL Servers
  • Lecture: 05
    Entering Data Directly Importing from SQL Servers
  • Lecture: 01
    Removing Totals
  • Lecture: 02
    Sorting Columns
  • Lecture: 03
    Re-ordering Columns
  • Lecture: 04
    Re-sizing columns
  • Lecture: 05
    Formatting columns Aggregating Data
  • Lecture: 01
    Pie & Donut Charts
  • Lecture: 02
    Formatting Charts Column & Bar Charts
  • Lecture: 03
    Tree Maps
  • Lecture: 04
    Funnel Charts
  • Lecture: 05
    Line Charts Area
  • Lecture: 06
    Charts Combined Charts
  • Lecture: 07
    Waterfall Charts Scatter / Bubble Charts Gauges Key Performance Indicators (KPIs) Cards
  • Lecture: 01
    Adding Conditional
  • Lecture: 02
    Columns Relationships
  • Lecture: 03
    Viewing Data Relationships
  • Lecture: 04
    Creating Relationships
  • Lecture: 05
    The Query Editor Applying Queries
  • Lecture: 06
    Renaming Columns
  • Lecture: 07
    Naming Applied
  • Lecture: 08
    Changes Undoing
  • Lecture: 09
    Applied Steps
  • Lecture: 10
    Sorting Rows
  • Lecture: 11
    Adding an Index Column
  • Lecture: 12
    Filtering Rows
  • Lecture: 13
    Splitting Columns by Numbers of Characters
  • Lecture: 01
    Opening the Query Editor
  • Lecture: 02
    Adding and Using Slicers
  • Lecture: 03
    Formatting Slicers
  • Lecture: 04
    Searching Slicers
  • Lecture: 05
    Cascading Slicers
  • Lecture: 06
    Horizontal Slicers
  • Lecture: 01
    Hierarchies
  • Lecture: 02
    Drilling Down
  • Lecture: 03
    Creating Columns
  • Lecture: 01
    Introduction to DAX and its Syntax
  • Lecture: 02
    Calculated Columns
  • Lecture: 01
    Page Level
  • Lecture: 02
    All Page level
  • Lecture: 03
    Visual Level Filters
  • Lecture: 01
    Power BI Files (PBIX) and the Power BI Service Publish to Web Feature

Course Orientation Video

Please, Fill in the details to download syllabus

Batch Details

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

Who can Attend

  Freshers & Any Graduates

  Business Analysts

  Business Intelligence Manager

  Statisticians and Analysts

  Data Scientists

  Project Managers

  Professionals in Marketing, Finance, and Sales domains

Pre-requisites

  Fundamental understanding of Microsoft Excel

  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 absolute references

  Create and modify charts

  Preview and print worksheets

  Data discovery and exploration

  Insights from any device

  Navigate between different Power BI tools and their functionality

  Build informative dashboards

  Create, edit and format interactive visuals

  Create multiple levels of filters

  Create and use custom slices

  Learn Dashboards, and Power BI DAX commands and functions

  Learn how to experiment, fix, prepare and present data quickly and easily

  Create a sales analysis report and a project management report

  Form relationships in your data model and learn data visualization best practices

Job Roles:

  • Retail Manager
  • Cost Estimator
  • Financial Analyst
  • Project Manager
  • Business Analyst
  • Data Journalist
  • Power BI Data Analyst
  • Power BI Developer
  • Power BI Software Engineer

CourseCertificate

Skills Covered

  Data Forecasting

  Data Analysis

  Excel Functions

  Charts

  Dashboard

  Data Visualization

  Reporting and Productivity in work

  DAX Functions

   Charts Preparing

  Dashboard Reporting

  Data Modelling and Connectivity

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

  Introduction to Power BI

 Working with Tables

Matrices

  Querying Data

  Slicers

  Parameters

  DAX Language

  Filters

  Publishing data

Tools Used

  What IF analysis

  Data Forecast

  Charts

  POWER BI DESKTOP

  Data Modelling

  Data connectivity

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