Introduction to Course

Introduction to Course

Dashboard Layout Design 1:Create Sales Dashboard

Introduction to Sales Dashboard
Creating Dashboard Layout
Adding Shapes and Text Boxes in Each Widgets of Dashboard
Adding Icons in Each Widgets of Dashboard
Adding and Formatting Line Chart in the Dashboard
Overlap Two Line Charts in the Dashboard
Adding and Formatting Map Chart in the Dashboard
Adding and Formatting Waterfall Chart in the Dashboard
Adding and Formatting Donut Charts in the Dashboard
Adding Text Boxes Inside the Donut Charts and Extracting Numerical Values Inside
Adding and Formatting Bar Chart in the Dashboard
Creating Custom Slicers Style in the Dashboard
Creating Collapse and Toggle Buttons in the Dashboard Part 1
Creating Collapse and Toggle Buttons in the Dashboard Part 2
Creating Collapse and Toggle Buttons in the Dashboard Part 3
Creating Collapse and Toggle Buttons in the Dashboard Part 4
Creating Collapse and Toggle Buttons in the Dashboard Part 5
Removing Reference Errors from the Formulas

Dashboard Layout Design 2:Create Sales Dashboard

Introduction to Sales Dashboard
Creating Dashboard Layout
Creating Drop Down List and Linking Index and Match Functions with it
Adding and Formatting Donut Charts in the Dashboard
Adding and Formatting Text Boxes Inside the Donut Charts and Extracting % Value
Adding and Formatting Text Boxes & Extracting Revenue & Quantity Ordered Values
Creating and Formatting Column and Line Charts in the Dashboard
Creating Drop Down List in the Dashboard and Linking to the Data Source

Dashboard Layout Design 3:Create Sales Performance Dashboard

Introduction to Sales Performance Dashboard
Creating Pivot Tables and Progress Chart Part 1
Creating Pivot Tables and Progress Chart Part 2
Creating Layout of Dashboard
Inserting Text and Formulas Inside the Text Boxes
Inserting Icons inside the Dashboard Layout
Adding Progress Chart and Slicers in the Dashboard
Adding Column,Line and Pie Charts Inside the Dashboard
Removing Formula Errors from the Text Boxes

Dashboard Layout Design 4:Create Sales Dashboard

Introduction to Sales Dashboard
Creating Dashboard Layout
Adding Icons in the Dashboard Layout and Creating Line Chart
Creating Column and Bar Charts
Creating Map Chart
Inserting Formulas Inside the Text Boxes Part 1
Inserting Formulas Inside the Text Boxes Part 2
Adding Slicers in the Dashboard
Grouping the Layers and Removing Errors From Formulas

Dashboard Layout Design 5:Create Financial Dashboard

Introduction to Financial Dashboard
Creating Layout of Dashboard Part 1
Creating Layout of Dashboard Part 2
Calculating Financial Data
Connecting Drop Down List to the IF Function
Calculating Variation Values Between Months by Using IF Function
Adding Text Box and Inserting Formulas Inside
Applying Conditionally Formatting Rules on Variation Values
Using Camera Commands in Dashboard
Creating Donut Charts
Adding Donut Charts and Inserting Text Boxes Inside
Inserting Text Boxes Inside the Donut Charts
Adding Column and Line Charts in the Dashboard
Creating Drop Down List in the Dashboard
Removing Errors From Formulas

Dashboard Layout Design 6:Create KPIs Financial Dashboard

Introduction to KPIs Financial Dashboard
Creating Dashboard Layout
Calculating Financial Data
Creating and Linking Drop Down List to the Data Source
Calculating Variation Values
Applying Conditionally Formatting Rules
Creating Key Performance Indicators
Extracting Numerical Values in the Text Boxes
Adding Conditionally Formatted Values and KPIs in the Dashboard
Adding Line Charts in the Text Boxes
Adding Donut Charts in the Dashboard
Adding Text Boxes Inside Donut Charts
Adding Conditionally Formatted Values and Symbols Inside Donut Charts
Creating Income Statement in the Dashboard
Adding Column Charts in the Dashboard
Adding Line Chart in the Dashboard
Creating Drop Down List in the Dashboard and Linking to the Data Source
Removing Errors from Formulas

Dashboard Layout Design 7:Create KPIs Financial Dashboard (Navigation Pane)

Introduction to KPIs Financial Dashboard
Creating Navigation Pane
Creating Dashboard Layout
Adding All Data in the Dashboard

Dashboard Layout Design 8:Create Sales Dashboard

Introduction to Sales Dashboard
Loading Data in the Pivot Table and Creating Validation List
Inserting Index and Match Functions in the Data Validation List (Drop Down List)
Calculating Percentage Sales Values
Creating Layout of Dashboard
Adding and Formatting Donuts Charts in the Dashboard
Adding Text Box and Inserting Formulas inside
Linking Another Pivot Table to the Drop Down List
Adding and Formatting Line and Column Charts
Linking Drop Down List from Dashboard to the Data Source

Data Analysis in PivotTables (Creating Revenue Dashboard)

Introduction
Importing Access Database Data File
Adding and Formatting Column Chart
Adding and Formatting Donut Chart
Adding and Formatting Bar Chart and Creating Customer Revenue PivotTable
Creating Dashboard Part 1
Creating Dashboard (Adding Text Box) Part 2
Creating Dashboard (Adding Text Box) Part 3
Creating Dashboard (Adding Text Box) Part 4
Creating Connections between PivotTables and Slicers

Sparklines (Line,Column,Win or Loss) and Data Bars

Sparklines (Line,Column,Win or Loss)
Data Bars

Waterfall Chart,Funnel Chart and Map Chart

Waterfall Chart,Funnel Chart and Map Chart

People Graph,Sunburst Chart,Treemap and Bubble Charts

People Graph,Sunburst Chart,Treemap and Bubble Charts

Stocks and Geography,Progress Chart

Stocks and Geography,Progress Chart Part 1
Stocks and Geography,Progress Chart Part 2

Analyzing Sales Data in Pivot Tables and Pivot Charts

Adding Data in Excel Table
Adding and Formatting First Chart in Pivot Table
Adding and Formatting Second Chart in Pivot Table
Adding and Formatting Third Chart in Pivot Table
Adding and Formatting Fourth Chart in Pivot Table
Adding and Formatting Fifth Chart in Pivot Table
Adding and Formatting Sixth Chart in Pivot Table
Adding Chart in Excel Dashboard
Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box
Inserting Slicers in the Dashboard for Analyzing Sales Data

Creating Excel Tables,PivotTables and PivotCharts

Freezing Header or Row
Converting Data in an Excel Table
Adding Records in an Excel Table
Renaming and Finding Records in an Excel Table
Editing and Deleting Records in an Excel Table
Remove Duplicates
Sorting Date Column in an Excel Table
Sorting Multiple Columns
Filtering Data in an Excel Worksheet and Deleting an Excel Table
Filtering Data by Creating Criteria
Filtering Data in an Excel Table by Using Slicer
Splitting the Worksheet into Panes
Calculating Records in an Excel Table
Inserting Subtotals
Creating and Adding Data in a Pivot Table
Filtering Data in a Pivot Table
Adding Pivot Chart in a Pivot Table
Home Work

Data Validation and Inserting Comments

Specifying a Validation Rule by Using List
Show an Input Message on an Active Cell
Displaying Error Alert Message
Circle Invalid Data
Inserting Comments in a Worksheet
Home Work

Analyzing Data in the Table

Introducing and Converting a Range to a Table
Sorting a Table using Different Methods
Filtering a Table using Different Methods
Analyzing Basic Table Operations
Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions

Analyzing Data with PivotTables

Introducing PivotTables
Creating PivotTable
Inserting Subtotals In the PivotTable
Summarizes Value Field by Changing Functions
Adding PivotChart and Slicer in the PivotTable

Analyzing Data with Business Intelligence (Power Queries and Trendlines)

Introducing Power Query and Upload CSV File
Retrieving Power Query Data into an Excel Table and Editing a Query Data
Adding a New Column and Grouping Values in a Power Query Data
Analyzing Revenue Data by Adding Trendlines in the Chart

Analyzing Data with Business Intelligence (Forecast Sheet)

Analyzing Revenue Data by Creating a Forecast Sheet

Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)

Introducing Database and Upload Access Database File
Creating the Data Model
Transferring Data in the Power Pivot
Exploring the Data Model in the Diagram View
Managing Table Relationships in the Power Pivot
Creating a PivotTable from the Data Model
Adding a Timeline Slicer in the PivotTable
Drilling down into the Data in the PivotTable
Visualizing Stores Sale Data with Power Map

Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)

Importing Population and Area Data from the Website and Creating Queries
Extracting Population and Area Data into PivotTable
Merging Two Queries into One query

Loading Website Data into Power Map(Power Query,Power Map)

Loading Website Data into Power Map

Extracting Data from the Website(Power Query,Pivot Table)

Extracting and Transforming User Rating Data from the Website
Combining Queries

Extracting Football Team Data from the Website(Power Query,Pivot Table)

Extracting and Transforming Data from the Website

Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)

Cost-Volume-Profit(CVP) Chart Analysis
Find the Break-Even Point by Using Goal Seek
Generate $30000 Net Income of Company by using Goal Seek Tool
Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume
Completing the One-Variable Data Table
Creating the CVP Chart of the Data Table
Viewing the Impact of Changing the Sales Price in the Data Table
Creating the Two-Variable Data Table
Create a Chart of the Two Variable Data Table

Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)

Define Names for the Income Statement Values
Adding the Scenarios in the Scenario Manager
View the Impact of the Reduced Operations Scenario
Creating the Scenario Summary Report
Creating the Scenario PivotTable Report

Analyzing Business Data with Solver

Understand Solver with Simple Example
Introducing Product Mix and Find an Optimal Solution with Solver Part 1
Introducing Product Mix and Find an Optimal Solution with Solver Part 2
Creating a Solver Answer Report
Saving and Loading Solver Model

Introduction to Excel

Starting With Excel
Excel Tabs,Groups and Commands
Excel Rows and Columns
Changing the Size of Columns and Rows
Entering Text and Numbers in Worksheet
Wrap Text Inside the Cell
Edit Text Within a Cell
Merging and Formatting Cells in a Worksheet
Formatting Header in a Worksheet
Adding Image in a Worksheet
Formatting Date in Excel Worksheet
Working of Undo & Redo Commands in an Excel Worksheet
Home Work
Introduction to Excel Quiz

Calculations With Basic Formulas

Introduction to Arithmetic Operators
Calculations with Arithmetic Operators
Copy and Paste the Formula
Auto Complete Formula
Inserting and Deleting Columns and Rows
Hide and Unhide Columns and Rows
Moving a Cell or Range by Drag and Drop Method
Moving a Cell or Range by Cut and Paste Method
Relative and Absolute Cell References
Home Work
Calculations With Basic Formulas Quiz

Calculations with Simple Excel Functions

Introduction to Function Syntax
Calculating Total Sales by Using SUM Function
Calculating Total Sales Quantities by Using SUM Function
Count Price Items by Using COUNT Function
Count Food Items by Using COUNTA Function
Calculating Average Sales by Using AVERAGE Function
Calculating Maximum Sales Value of Customer by Using MAX Function
Calculating Minimum Sales Value of Customer by Using MIN Function
Calculating Total Price of Products by Using PRODUCT Function
Calculating Sales Data by Using Auto FUNCTION Button
Calculating a Tax Rate on Total Sales
Home Work
Calculations with Simple Excel Functions Quiz

Formatting a Worksheet

Merging Two or More Cells into One Cell
Alignment of Cell Text
Splitting Text into Multiple Lines
Rotating a Cell Text or Numbers
Formatting Background Color of Text and Numbers
Formatting Font Size and Font Color
Adding Border into Cells
Formatting Cell Styles
Find and Replace Text in a Worksheet
Calculating Students Enrollment and Difference Between two Columns Values
Calculating Percentage Difference Between two Columns Values
Conditionally Formatting Cells in a Worksheet
Conditionally Formatting Cells with a Top and Bottom Rules
Home Work
Formatting a Worksheet Quiz

Saving and Printing a Workbook

Saving a Workbook
Worksheet Views,Page Orientation and Scaling
Setting Margins in a Print Page
Adding Header and Footer in a Print Page
Print Preview and Selecting Print Area
Setting Scaling and Margins in a Print Page(Document 1)
Saving and Printing a Workbook Quiz

Project Calculations with Operators and Functions

Calculating the Area of Field and Plots
Calculating the Grown and Empty Area of Vegetables Field
Calculating the Percentage of Grown and Empty area in Vegetables Field
Calculating Cost of Sales and Weightages of Vegetables
Calculating Profit and Percentage of Profit from Vegetables
Calculating Revenue by Using Sum,Max,Min,Average and Median Functions
Introduction to NESTED Function
Nesting the SUM and MEDIAN Functions within ROUND Function
Home Work
Project Calculations with Operators and Functions Quiz

IF and VLOOKUP Functions

Introduction to IF Function and Apply Weather Condition on IF Function
Apply Different Conditions on IF Function
Introduction to VLOOKUP Function
Apply VLOOKUP Function on Data Table
Retrieving Values from Data Table by Using VLOOKUP Function
Errors in VLOOKUP Function
Home Work

Adding Column and Pie Charts in an Excel worksheet

Embed Column Chart in a Worksheet
Analyzing Data with a Column Chart
Analyzing Data with a Pie Chart
Recommended Charts
Home Work

Date and Time Functions in an Excel

NOW and TIME Functions
HOUR,MINUTE and SECOND Functions
TODAY,DATE and DAYS Functions
YEAR,MONTH and DAY Functions
WEEKDAY Function
WEEKNUM Function
EDATE Function
EOMONTH Function
Determining Person's Birthday
Calculating Age of Person
Formatting Date in a Cell
DATEVALUE Function
DAYS360 Function
ISOWEEKNUM Function
NETWORKDAYS Function
TIMEVALUE Function
YEARFRAC Function

Logical Functions in an Excel

Calculating the Age of Employees and Length of Service
Analyzing Data by Using IF Function
Determining Birthday of Employees
Specifying Day of Birthdate by Nesting DAY Function Within IF Function
Determining Employee Eligibility for Promotion by Using AND Function
Nesting the AND Function Within IF Function
Determining Employee Eligibility for Promotion by Using OR Function
Nesting the OR Function Within IF Function
IFERROR Function
IFNA Function
FALSE Function
IFS Function
NOT Function
SWITCH Function
TRUE Function
XOR Function
Home Work

Lookup and Reference Functions in an Excel

Extracting Value from Data Table by Using VLOOKUP Function
Extracting Value from Data Table by Using HLOOKUP Function
Calculating Discount and Total Price
Calculating Tax Rate on Total Price Value
Extracting Value by Using CHOOSE Function
Nesting the CHOOSE Function Within Sum Function
MATCH Function
Extracting Value by Using INDEX Function
Nesting the MATCH Function Within an INDEX Function
Nesting the VLOOKUP Function Within an IFERROR Function
COLUMN Function
LOOKUP Function
TRANSPOSE Function
Home Work

Adding Line and Combination Charts in an Excel

Adding and Formatting Line Chart
Adding and Formatting Combination Chart

Text Functions in an Excel

BHATTEXT Function
CHAR Function
CLEAN Function
CODE Function
CONCAT Function
DOLLAR Function
EXACT Function
FIND Function
FIXED Function
LEFT Function
LEN Function
LOWER Function
MID Function
NUMBERVALUE Function
PROPER Function
REPLACE Function
REPT Function
RIGHT Function
SEARCH Function
SUBSTITUTE Function
T Function
TEXT Function
TEXTJOIN Function
TRIM Function
UNICHAR Function
UNICODE Function
UPPER Function
VALUE Function

Math and Trigonometry Functions in an Excel

SUM Function
MOD Function
POWER Function
SUBTOTAL Function
SUMIF Function
SUMIFS Function
SUMPRODUCT Function
ROUND Function
ROUNDDOWN Function
ROUNDUP Function
CEILING.MATH Function
FLOOR.MATH Function
EVEN Function
ODD Function
INT Function
TRUNC Function

Statistical Functions in an Excel

AVERAGE Function
AVERAGEIF Function
AVERAGEIFS Function
COUNT and COUNTA Function
COUNTBLANK Function
COUNTIF Function
COUNTIFS Function
LARGE Function
SMALL Function
MAX and MIN Function
MEDIAN Function
MODE.MULT Function
MODE.SNGL Function

Engineering Functions in an Excel

BIN2DEC Function
BIN2HEX Function
BIN2OCT Function
COMPLEX Function
CONVERT Function
DEC2BIN Function
DEC2HEX Function
DEC2OCT Function

Information Functions in an Excel

CELL Function
ERROR.TYPE Function
INFO Function
ISBLANK Function
ISERR Function
ISERROR Function
ISEVEN Function
ISFORMULA Function
ISLOGICAL Function
ISNA Function
ISNONTEXT Function
ISNUMBER Function
ISODD Function
ISREF Function
ISTEXT Function
N Function
NA Function
SHEET Function
SHEETS Function
TYPE Function

Database Functions in an Excel

DAVERAGE Function
DSUM Function
DMAX and DMIN Functions
DCOUNTA Function

Financial Functions:Borrow Money to Bank

Calculating a Quarterly Payment of Loan by using the PMT Function
Calculating a Future Value of Loan by using the FV Function
Calculating a Payment Period of Loan by using the NPER Function
Calculating a Present Value of Loan by using the PV Function
Calculating an Interest Rate of Loan by using the RATE Function
Positive Cash Flow and Negative Cash Flow
Calculating the Value of Inflation by Using FV Function
Calculating a Monthly Car Payment
Calculating the Interest Payment by using IPMT Function
Calculating the Principal Payment by using PPMT Function
Calculating Remaining Principal Amount and Total Payment
Completing the Amortization Schedule of Loan
Plotting Interest and Principal Payments
Calculating Cumulative Interest Payments by Using CUMIPMT Function
Calculating Cumulative Principal Payments by Using CUMPRINC Function
Calculating Remaining Principal,Total Interest and Total Principal Payments
Calculating Total Loan Amount

Financial Functions:Invest Money in the Bank Saving Account

Calculating the Compound Interest
Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions
Calculating the Future Value of an Investment by Monthly and Initial Deposits
Calculating the Interest Rate of an Investment
Calculating the Total Number of Deposits of an Investment
Calculating the Initial Deposit or Present Value of an investment
Calculating the Value of Deposit Per Month
Calculating the Variable Interest Rates by using FVSCHEDULE Function
Amortization Schedule of an Investment 1
Amortization Schedule of an Investment 2

Financial Functions: Build Future Income Statement of Company

Introduction to Income Statement Worksheet
Linear and Growth Trend Values
Projecting Future Value of Sales or Revenue by using Linear Trend Option
Projecting Future Value of Sales or Revenue by Inserting a Growth Trend
Calculating the Cost of Research and Development
Calculating the Cost of Sales and Marketing
Calculating the Gross Profit
Calculating the Expenses of Company Part 1
Calculating the Expenses of Company Part 2
Calculating the Expenses of Company Part 3
Calculating the Total General Expenses and Initial Earnings
Adding Depreciation of an Asset in the Income Statement
Calculating Operating Profit in the Income Statement
Adding Interest Expenses in the Income Statement
Calculating Profit Without Adding Tax
Adding Taxes in the Income Statement
Calculating Final Profit of the Company in the Income Statement

Financial Functions:Calculate Depreciation of an Asset of Company

Straight Line Depreciation of an Asset Part 1
Straight Line Depreciation of an Asset Part 2
Straight Line Depreciation of an Asset Part 3
Declining Balance Depreciation of an Asset Part 1
Declining Balance Depreciation of an Asset Part 2
Calculating Depreciation of an asset by Using SYD Function
Calculating Depreciation of an asset by Using DDB Function
Calculating Depreciation of an asset by Using VDB Function
Calculating Depreciation Value of a Car
Selecting Method of Depreciation to Calculate Depreciation of an Asset

Financial Functions:Invest Money in Company

Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1
Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2
Calculating Payback Period of an Investment Part 1
Calculating Payback Period of an Investment Part 2
Calculating Payback Period of an Investment Part 3
Calculate Present Value of an Invetment by Using NPV Function Part 1
Calculate Present Value of an Invetment by Using NPV Function Part 2
Calculate Net Present Value of an Invetment
Calculate Internal Rate of Return of an Invetment by Using IRR Function
Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons
Calculate Equivalent Value of Interest Rate by Using RRI Function

Basic Financial Examples(Learn Use of Operators +,-,/,*)

Calculating the Remaining Amount with 30% Rate
Calculating the Remaining Amount with 15% and 40% Rate
Calculating the Percentage of Remaining Amount
Calculating the Percentage of Savings
Finding the Value of Actual Amount
Calculating the Value of Expense,Save and Total Amount
Calculating the Remaining Profit
Calculating the Values of Profit and Percentage of Profit
Calculating the Values of Loss and Percentage of Loss

Microsoft Power BI

Introduction to Microsoft Power BI

Microsoft Power BI:Create Global Store Sales Dashboard

Introduction
Adding Background Image in the Page and Access Database File
Adding Image,Text Box and Card Part 1
Adding Image,Text Box and Card Part 2
Adding Buttons and Map
Adding Slicers
Adding Table and Selecting Top 5 Countries by Sales in Funnel Chart
Locking Visual for Filtering Data
Adding Table and Conditionally Formatting Table Values
Adding Column Chart and Customer Slicer
Adding Line Chart
Bookmarks the Pages
Use Buttons to Navigate Pages and Slicer for to Get Specific Data

Microsoft Power BI:Create Malaria Analytics Dashboard

Introduction
Adding Horizontal Bar,Image and Text Box
Adding Slicers and Clear Filters Button
Adding Data Set,Text Box,Button,Horizontal Line and Map Chart
Adding Stacked Bar Chart and Table
Adding Card and Text Box
Copy and Paste Slicers and Clear Filters Button
Adding Card and Text Box Part 1
Adding Card,Text Box and Stacked Area Chart Part 2
Adding Data Tables
Use Copy and Paste Technique
Adding Line Chart and Table
Filter Specific Data by Using Filter Pane
Copy and Paste Layers of Previous Page Part 1
Copy and Paste Layers of Previous Page Part 2
Adding Previous Buttons and Creating Bookmarks Part 1
Adding Previous Buttons and Creating Bookmarks Part 2
Inserting Bookmarks Links in the Buttons
Clear All Filters

Microsoft Power BI:Create Climate Change Report

Introduction
Creating Page 1 (Home Page)
Creating Page 2 (Carbon Dioxide) Part 1
Creating Page 2 (Carbon Dioxide) Part 2
Creating Page 2 (Carbon Dioxide) Part 3
Creating Page 2 (Carbon Dioxide) Part 4
Creating Page 2 (Carbon Dioxide) Part 5
Creating Page 2 (Carbon Dioxide) Part 6
Creating Page 2 (Carbon Dioxide) Part 7
Creating Page 3 (Global Temperature) Part 1
Creating Page 3 (Global Temperature) Part 2
Creating Page 3 (Global Temperature) Part 3
Creating Page 3 (Global Temperature) Part 4
Creating Page 3 (Global Temperature) Part 5
Creating Page 3 (Global Temperature) Part 6
Creating Page 4 (Ice Area) Part 1
Creating Page 4 (Ice Area) Part 2
Creating Page 4 (Ice Area) Part 3
Creating Page 4 (Ice Area) Part 4
Creating Page 4 (Ice Area) Part 5
Creating Page 4 (Ice Area) Part 6
Creating Page 5 (Disasters) Part 1
Creating Page 5 (Disasters) Part 2
Creating Page 5 (Disasters) Part 3
Creating Page 5 (Disasters) Part 4
Creating Page 5 (Disasters) Part 5
Creating Page 6 (Plastic Pollution) Part 1
Creating Page 6 (Plastic Pollution) Part 2
Creating Page 7 (Ozone Hole Area and Air Pollution) Part 1
Creating Page 7 (Ozone Hole Area and Air Pollution) Part 2
Creating Page 7 (Ozone Hole Area and Air Pollution) Part 3
Creating Page 8 (Causes , Effects and Prevention) Part 1
Creating Page 8 (Causes , Effects and Prevention) Part 2
Creating Page 8 (Causes , Effects and Prevention) Part 3
Creating Page 8 (Causes , Effects and Prevention) Part 4
Creating Page 8 (Causes , Effects and Prevention) Part 5
Creating Page 8 (Causes , Effects and Prevention) Part 6
Bookmarks Report Pages
Insert Bookmarks Links in the Buttons

Bookmarks Pane and Selection Pane

Analyzing Data by Creating Column,Bar and line Charts Buttons
Analyzing Data by Creating Pie,Donut and Map Charts Buttons
Analyzing Data by Creating Sales Report and Units Sold Report Buttons
Creating Color Buttons for Chart
Creating Font Sizes Buttons for Chart
Creating Axis Buttons for Chart
Creating Clear All Slicers Button
Creating Slicers Panel With Two Buttons
Creating Another Slicers Panel with Two Buttons
Creating Toggles Button
Creating Another Toggles Button

Editing and Visualizing Data

Introduction to Power BI and Loading Data in Power BI Part 1
Introduction to Power BI and Loading Data in Power BI Part 2
Manage Relationships Between Data Tables in the Power BI
Creating First Sales Report in the Report Tab
Visualizing First Sales Report Data
Filtering Data by Selecting Top and Bottom options
Creating and Visualizing Second Sales Report in the Report Tab
Fltering Data by Using Treemap Chart
Creating and Visualizing Third Sales Report in the Report Tab
Formating Column Chart
Analyzing Data by Using Pie Chart
Analyzing Data by Using Scatter Chart
Analyzing Data by Using Waterfall Chart
Analyzing Data by Using Guage Card
Adding Text Box,Image and Shapes
Locate Places with Latitudes and Longitudes
Globe Map
Creating and Visualizing Fourth Sales Report in the Report Tab
Analyzing Data in the Combination Charts
Formatting Slicers
Formatting and Changing Layout of Page
Creating a Duplicate Report Page
Summarizing Sales Data
Create Hierarchies and Drill Down Data
Selecting Filter Options
Changing the Background Color of Page
Adding Background Image in the Report Page
Analyzing Data by Using Analytics

Extracting Data from the Website

Extracting Data from the Website
Creating Report
Visualizing Report

Extracting Sales Data from the Website

Extracting Sales Data from the Website
Combining all Queries into one Query
Extracting User Data from the Website and Merging Two Queries Data in One Query
Analyzing Top Sold Movies Data in Power BI

Publish and Create Dashboard

Upload Report into Power BI Web
Create Dashboard
Quick Insights in Data
Open in Focus Mode and Edit Details
Adding Textbox in the Dashboard
View Dashboard in Full Screen Mode
Adding Image in the Dashboard
Asking Questions to Data
Manage Data Gateway(Automatically Refresh Dashboard Data)
Printing Dashboard
Republish Power BI Desktop Report
Create Workspace to Share Data into Organization
Creating Apps
Editing Apps
Installing Third Parties Apps
Publishing Power BI Report to Web

New Quick Measure(Calculations Without Dax)

Calculating Sales Year to Date
Calculating Running Total

Custom Visuals

Synoptic Panel Part 1
Synoptic Panel Part 2
Chiclet Slicer
KPI(Key Performance Indicator) Part 1
KPI(Key Performance Indicator) Part 2
Bullet Chart
Dial Gauge
Linear Gauge
Infographic Designer
Infographic Designer(Show Motorcycles Shapes in Bar Chart)
Infographic Designer(Show Apartment Shapes in Column Chart)
Infographic Designer(Adding Images in Column Chart)
Infographic Designer(Changing Multiple Layout Part 1)
Infographic Designer(Changing Multiple Layout Part 2)
Infographic Designer(Show Sales in Shapes)
Infographic Designer(Show Sales in Multiple Shapes)
TreeViz and Funnel Visuals
Agility Planning Matrix
Sunburst and KPI Card Visuals
Network Visuals

Popular Searches

Learn Microsoft Excel and Create Interactive Dashboards

Online

₹ 449 2699

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

Who it is for

What you will learn

The syllabus

Introduction to Course

Dashboard Layout Design 1:Create Sales Dashboard

Dashboard Layout Design 2:Create Sales Dashboard

Dashboard Layout Design 3:Create Sales Performance Dashboard

Dashboard Layout Design 4:Create Sales Dashboard

Dashboard Layout Design 5:Create Financial Dashboard

Dashboard Layout Design 6:Create KPIs Financial Dashboard

Dashboard Layout Design 7:Create KPIs Financial Dashboard (Navigation Pane)

Dashboard Layout Design 8:Create Sales Dashboard

Data Analysis in PivotTables (Creating Revenue Dashboard)

Sparklines (Line,Column,Win or Loss) and Data Bars

Waterfall Chart,Funnel Chart and Map Chart

People Graph,Sunburst Chart,Treemap and Bubble Charts

Stocks and Geography,Progress Chart

Analyzing Sales Data in Pivot Tables and Pivot Charts

Creating Excel Tables,PivotTables and PivotCharts

Data Validation and Inserting Comments

Analyzing Data in the Table

Analyzing Data with PivotTables

Analyzing Data with Business Intelligence (Power Queries and Trendlines)

Analyzing Data with Business Intelligence (Forecast Sheet)

Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)

Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)

Loading Website Data into Power Map(Power Query,Power Map)

Extracting Data from the Website(Power Query,Pivot Table)

Extracting Football Team Data from the Website(Power Query,Pivot Table)

Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)

Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)

Analyzing Business Data with Solver

Introduction to Excel

Calculations With Basic Formulas

Calculations with Simple Excel Functions

Formatting a Worksheet

Saving and Printing a Workbook

Project Calculations with Operators and Functions

IF and VLOOKUP Functions

Adding Column and Pie Charts in an Excel worksheet

Date and Time Functions in an Excel

Logical Functions in an Excel

Lookup and Reference Functions in an Excel

Adding Line and Combination Charts in an Excel

Text Functions in an Excel

Math and Trigonometry Functions in an Excel

Statistical Functions in an Excel

Engineering Functions in an Excel

Information Functions in an Excel

Database Functions in an Excel

Financial Functions:Borrow Money to Bank

Financial Functions:Invest Money in the Bank Saving Account

Financial Functions: Build Future Income Statement of Company

Financial Functions:Calculate Depreciation of an Asset of Company

Financial Functions:Invest Money in Company

Basic Financial Examples(Learn Use of Operators +,-,/,*)

Microsoft Power BI

Microsoft Power BI:Create Global Store Sales Dashboard

Microsoft Power BI:Create Malaria Analytics Dashboard

Microsoft Power BI:Create Climate Change Report

Bookmarks Pane and Selection Pane

Editing and Visualizing Data

Extracting Data from the Website

Extracting Sales Data from the Website

Publish and Create Dashboard

New Quick Measure(Calculations Without Dax)

Custom Visuals

Instructors