Learn Microsoft Excel and Create Interactive Dashboards

Learn Microsoft Excel and Create Interactive Dashboards

What you’ll learn

Learn all basic concepts of excel
Learn most commonly used formulas in the office
Learn PivotTables and PivotCharts
Learn Power Query
Learn Power Pivot
Learn Power Map
Learn What-if-analysis Tools
Learn Forecasting Sheet
Learn Excel Formulas and Functions
Create Excel Dashboards
And Much More!
Create reports in power bi
Create dashboards in power bi
Visualize data in power bi
Edit data in power bi and power query editor
Add buttons in report page
Visualize data in power bi by adding custom visuals

Requirements

This course is recorded on office 365 but this will work on excel 2019.

Description

Note: Select “auto” to watch 1080p HD quality videos.This course covers training for two Microsoft apps.Microsoft Excel and Microsoft Power BI.These two apps are very useful in the  office and business world.                                                                                                       Microsoft Excel/Office 365Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel.Learn how to create dashboards in Excel.To see more topics of this course,view course contents in the course landing page.Note:-Extra downloadable Dashboard Templates are included with this course in the resource.21.Covid 19 (1).xlsx20.Covid 19.xlsx19.Monthly Budget Dashboard Template.xlsx18.University Monthly Budget Dashboard Template.xlsx17.Monthly Personal Budget Dashboard Template.xlsx16.Multiple Dependent drop down list Sales Dashboard.xlsx15.Dependent drop down list Sales Dashboard.xlsx14.Sales KPI Dashboard Template 2.xlsx13.Download Searchable Drop Down List COVID – 19 Microsoft Excel Dashboard Live Update 26/05/2020.xlsx12.Searchable drop down list Excel Dashboard Template with lookup picture.xlsx11.Extra Project 2 – Sales Commission Calculator Template.xlsx10.Extra Project 0 – Searchable Drop Down List Sales Dashboard Template.xlsx9.KPI Sales Dashboard Template.xlsx8.Business Finance Management Dashboard Template.xlsx7.Extra Project 0 – COVID – 19 Data Analytics in Excel Dashboard Template 1 – Live Update.xlsx6.Download Sales KPI Dashboard Template1.xlsx5.Download Customer Analytics Dashboard Template.xlsx4.Extra Project 5 – Real Estate Management Dashboard Template.xlsx3.Download Sales Team Dashboard Template.xlsx2.Extra Project 6 – Fully Automated Inventory Management Dashboard Template.xlsx1.Extra Project 0 – COVID – 19 Data Analytics in Excel Dashboard Template 2 – Live Update.xlsx                                       ______________________________________________________________________________________________________                                                                                                      Microsoft Power BI/Office 365Learn How to Analyze Data in Microsoft Business Intelligence Power BI.How to Reports and Dashboards are Created in Power BI.In this course,you will learn,how to analyze business data in Microsoft business intelligence power bi.You will learn how to extract data from the website and an other sources and how that data is transformed in power query editor and power bi.You will learn how to that data is visualized in power bi.You will learn how to create reports and dashboards in power bi and how to add buttons in report page.You will learn how to custom visuals are added and data is visualized from that visuals.And much more!

Overview

Section 1: Introduction to Course

Lecture 1 Introduction to Course

Section 2: Dashboard Layout Design 1:Create Sales Dashboard

Lecture 2 Introduction to Sales Dashboard

Lecture 3 Creating Dashboard Layout

Lecture 4 Adding Shapes and Text Boxes in Each Widgets of Dashboard

Lecture 5 Adding Icons in Each Widgets of Dashboard

Lecture 6 Adding and Formatting Line Chart in the Dashboard

Lecture 7 Overlap Two Line Charts in the Dashboard

Lecture 8 Adding and Formatting Map Chart in the Dashboard

Lecture 9 Adding and Formatting Waterfall Chart in the Dashboard

Lecture 10 Adding and Formatting Donut Charts in the Dashboard

Lecture 11 Adding Text Boxes Inside the Donut Charts and Extracting Numerical Values Inside

Lecture 12 Adding and Formatting Bar Chart in the Dashboard

Lecture 13 Creating Custom Slicers Style in the Dashboard

Lecture 14 Creating Collapse and Toggle Buttons in the Dashboard Part 1

Lecture 15 Creating Collapse and Toggle Buttons in the Dashboard Part 2

Lecture 16 Creating Collapse and Toggle Buttons in the Dashboard Part 3

Lecture 17 Creating Collapse and Toggle Buttons in the Dashboard Part 4

Lecture 18 Creating Collapse and Toggle Buttons in the Dashboard Part 5

Lecture 19 Removing Reference Errors from the Formulas

Section 3: Dashboard Layout Design 2:Create Sales Dashboard

Lecture 20 Introduction to Sales Dashboard

Lecture 21 Creating Dashboard Layout

Lecture 22 Creating Drop Down List and Linking Index and Match Functions with it

Lecture 23 Adding and Formatting Donut Charts in the Dashboard

Lecture 24 Adding and Formatting Text Boxes Inside the Donut Charts and Extracting % Value

Lecture 25 Adding and Formatting Text Boxes & Extracting Revenue & Quantity Ordered Values

Lecture 26 Creating and Formatting Column and Line Charts in the Dashboard

Lecture 27 Creating Drop Down List in the Dashboard and Linking to the Data Source

Section 4: Dashboard Layout Design 3:Create Sales Performance Dashboard

Lecture 28 Introduction to Sales Performance Dashboard

Lecture 29 Creating Pivot Tables and Progress Chart Part 1

Lecture 30 Creating Pivot Tables and Progress Chart Part 2

Lecture 31 Creating Layout of Dashboard

Lecture 32 Inserting Text and Formulas Inside the Text Boxes

Lecture 33 Inserting Icons inside the Dashboard Layout

Lecture 34 Adding Progress Chart and Slicers in the Dashboard

Lecture 35 Adding Column,Line and Pie Charts Inside the Dashboard

Lecture 36 Removing Formula Errors from the Text Boxes

Section 5: Dashboard Layout Design 4:Create Sales Dashboard

Lecture 37 Introduction to Sales Dashboard

Lecture 38 Creating Dashboard Layout

Lecture 39 Adding Icons in the Dashboard Layout and Creating Line Chart

Lecture 40 Creating Column and Bar Charts

Lecture 41 Creating Map Chart

Lecture 42 Inserting Formulas Inside the Text Boxes Part 1

Lecture 43 Inserting Formulas Inside the Text Boxes Part 2

Lecture 44 Adding Slicers in the Dashboard

Lecture 45 Grouping the Layers and Removing Errors From Formulas

Section 6: Dashboard Layout Design 5:Create Financial Dashboard

Lecture 46 Introduction to Financial Dashboard

Lecture 47 Creating Layout of Dashboard Part 1

Lecture 48 Creating Layout of Dashboard Part 2

Lecture 49 Calculating Financial Data

Lecture 50 Connecting Drop Down List to the IF Function

Lecture 51 Calculating Variation Values Between Months by Using IF Function

Lecture 52 Adding Text Box and Inserting Formulas Inside

Lecture 53 Applying Conditionally Formatting Rules on Variation Values

Lecture 54 Using Camera Commands in Dashboard

Lecture 55 Creating Donut Charts

Lecture 56 Adding Donut Charts and Inserting Text Boxes Inside

Lecture 57 Inserting Text Boxes Inside the Donut Charts

Lecture 58 Adding Column and Line Charts in the Dashboard

Lecture 59 Creating Drop Down List in the Dashboard

Lecture 60 Removing Errors From Formulas

Section 7: Dashboard Layout Design 6:Create KPIs Financial Dashboard

Lecture 61 Introduction to KPIs Financial Dashboard

Lecture 62 Creating Dashboard Layout

Lecture 63 Calculating Financial Data

Lecture 64 Creating and Linking Drop Down List to the Data Source

Lecture 65 Calculating Variation Values

Lecture 66 Applying Conditionally Formatting Rules

Lecture 67 Creating Key Performance Indicators

Lecture 68 Extracting Numerical Values in the Text Boxes

Lecture 69 Adding Conditionally Formatted Values and KPIs in the Dashboard

Lecture 70 Adding Line Charts in the Text Boxes

Lecture 71 Adding Donut Charts in the Dashboard

Lecture 72 Adding Text Boxes Inside Donut Charts

Lecture 73 Adding Conditionally Formatted Values and Symbols Inside Donut Charts

Lecture 74 Creating Income Statement in the Dashboard

Lecture 75 Adding Column Charts in the Dashboard

Lecture 76 Adding Line Chart in the Dashboard

Lecture 77 Creating Drop Down List in the Dashboard and Linking to the Data Source

Lecture 78 Removing Errors from Formulas

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

Lecture 79 Introduction to KPIs Financial Dashboard

Lecture 80 Creating Navigation Pane

Lecture 81 Creating Dashboard Layout

Lecture 82 Adding All Data in the Dashboard

Section 9: Dashboard Layout Design 8:Create Sales Dashboard

Lecture 83 Introduction to Sales Dashboard

Lecture 84 Loading Data in the Pivot Table and Creating Validation List

Lecture 85 Inserting Index and Match Functions in the Data Validation List (Drop Down List)

Lecture 86 Calculating Percentage Sales Values

Lecture 87 Creating Layout of Dashboard

Lecture 88 Adding and Formatting Donuts Charts in the Dashboard

Lecture 89 Adding Text Box and Inserting Formulas inside

Lecture 90 Linking Another Pivot Table to the Drop Down List

Lecture 91 Adding and Formatting Line and Column Charts

Lecture 92 Linking Drop Down List from Dashboard to the Data Source

Section 10: Data Analysis in PivotTables (Creating Revenue Dashboard)

Lecture 93 Introduction

Lecture 94 Importing Access Database Data File

Lecture 95 Adding and Formatting Column Chart

Lecture 96 Adding and Formatting Donut Chart

Lecture 97 Adding and Formatting Bar Chart and Creating Customer Revenue PivotTable

Lecture 98 Creating Dashboard Part 1

Lecture 99 Creating Dashboard (Adding Text Box) Part 2

Lecture 100 Creating Dashboard (Adding Text Box) Part 3

Lecture 101 Creating Dashboard (Adding Text Box) Part 4

Lecture 102 Creating Connections between PivotTables and Slicers

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

Lecture 103 Sparklines (Line,Column,Win or Loss)

Lecture 104 Data Bars

Section 12: Waterfall Chart,Funnel Chart and Map Chart

Lecture 105 Waterfall Chart,Funnel Chart and Map Chart

Section 13: People Graph,Sunburst Chart,Treemap and Bubble Charts

Lecture 106 People Graph,Sunburst Chart,Treemap and Bubble Charts

Section 14: Stocks and Geography,Progress Chart

Lecture 107 Stocks and Geography,Progress Chart Part 1

Lecture 108 Stocks and Geography,Progress Chart Part 2

Section 15: Analyzing Sales Data in Pivot Tables and Pivot Charts

Lecture 109 Adding Data in Excel Table

Lecture 110 Adding and Formatting First Chart in Pivot Table

Lecture 111 Adding and Formatting Second Chart in Pivot Table

Lecture 112 Adding and Formatting Third Chart in Pivot Table

Lecture 113 Adding and Formatting Fourth Chart in Pivot Table

Lecture 114 Adding and Formatting Fifth Chart in Pivot Table

Lecture 115 Adding and Formatting Sixth Chart in Pivot Table

Lecture 116 Adding Chart in Excel Dashboard

Lecture 117 Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box

Lecture 118 Inserting Slicers in the Dashboard for Analyzing Sales Data

Section 16: Creating Excel Tables,PivotTables and PivotCharts

Lecture 119 Freezing Header or Row

Lecture 120 Converting Data in an Excel Table

Lecture 121 Adding Records in an Excel Table

Lecture 122 Renaming and Finding Records in an Excel Table

Lecture 123 Editing and Deleting Records in an Excel Table

Lecture 124 Remove Duplicates

Lecture 125 Sorting Date Column in an Excel Table

Lecture 126 Sorting Multiple Columns

Lecture 127 Filtering Data in an Excel Worksheet and Deleting an Excel Table

Lecture 128 Filtering Data by Creating Criteria

Lecture 129 Filtering Data in an Excel Table by Using Slicer

Lecture 130 Splitting the Worksheet into Panes

Lecture 131 Calculating Records in an Excel Table

Lecture 132 Inserting Subtotals

Lecture 133 Creating and Adding Data in a Pivot Table

Lecture 134 Filtering Data in a Pivot Table

Lecture 135 Adding Pivot Chart in a Pivot Table

Lecture 136 Home Work

Section 17: Data Validation and Inserting Comments

Lecture 137 Specifying a Validation Rule by Using List

Lecture 138 Show an Input Message on an Active Cell

Lecture 139 Displaying Error Alert Message

Lecture 140 Circle Invalid Data

Lecture 141 Inserting Comments in a Worksheet

Lecture 142 Home Work

Section 18: Analyzing Data in the Table

Lecture 143 Introducing and Converting a Range to a Table

Lecture 144 Sorting a Table using Different Methods

Lecture 145 Filtering a Table using Different Methods

Lecture 146 Analyzing Basic Table Operations

Lecture 147 Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions

Section 19: Analyzing Data with PivotTables

Lecture 148 Introducing PivotTables

Lecture 149 Creating PivotTable

Lecture 150 Inserting Subtotals In the PivotTable

Lecture 151 Summarizes Value Field by Changing Functions

Lecture 152 Adding PivotChart and Slicer in the PivotTable

Section 20: Analyzing Data with Business Intelligence (Power Queries and Trendlines)

Lecture 153 Introducing Power Query and Upload CSV File

Lecture 154 Retrieving Power Query Data into an Excel Table and Editing a Query Data

Lecture 155 Adding a New Column and Grouping Values in a Power Query Data

Lecture 156 Analyzing Revenue Data by Adding Trendlines in the Chart

Section 21: Analyzing Data with Business Intelligence (Forecast Sheet)

Lecture 157 Analyzing Revenue Data by Creating a Forecast Sheet

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

Lecture 158 Introducing Database and Upload Access Database File

Lecture 159 Creating the Data Model

Lecture 160 Transferring Data in the Power Pivot

Lecture 161 Exploring the Data Model in the Diagram View

Lecture 162 Managing Table Relationships in the Power Pivot

Lecture 163 Creating a PivotTable from the Data Model

Lecture 164 Adding a Timeline Slicer in the PivotTable

Lecture 165 Drilling down into the Data in the PivotTable

Lecture 166 Visualizing Stores Sale Data with Power Map

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

Lecture 167 Importing Population and Area Data from the Website and Creating Queries

Lecture 168 Extracting Population and Area Data into PivotTable

Lecture 169 Merging Two Queries into One query

Section 24: Loading Website Data into Power Map(Power Query,Power Map)

Lecture 170 Loading Website Data into Power Map

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

Lecture 171 Extracting and Transforming User Rating Data from the Website

Lecture 172 Combining Queries

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

Lecture 173 Extracting and Transforming Data from the Website

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

Lecture 174 Cost-Volume-Profit(CVP) Chart Analysis

Lecture 175 Find the Break-Even Point by Using Goal Seek

Lecture 176 Generate $30000 Net Income of Company by using Goal Seek Tool

Lecture 177 Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume

Lecture 178 Completing the One-Variable Data Table

Lecture 179 Creating the CVP Chart of the Data Table

Lecture 180 Viewing the Impact of Changing the Sales Price in the Data Table

Lecture 181 Creating the Two-Variable Data Table

Lecture 182 Create a Chart of the Two Variable Data Table

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

Lecture 183 Define Names for the Income Statement Values

Lecture 184 Adding the Scenarios in the Scenario Manager

Lecture 185 View the Impact of the Reduced Operations Scenario

Lecture 186 Creating the Scenario Summary Report

Lecture 187 Creating the Scenario PivotTable Report

Section 29: Analyzing Business Data with Solver

Lecture 188 Understand Solver with Simple Example

Lecture 189 Introducing Product Mix and Find an Optimal Solution with Solver Part 1

Lecture 190 Introducing Product Mix and Find an Optimal Solution with Solver Part 2

Lecture 191 Creating a Solver Answer Report

Lecture 192 Saving and Loading Solver Model

Section 30: Introduction to Excel

Lecture 193 Starting With Excel

Lecture 194 Excel Tabs,Groups and Commands

Lecture 195 Excel Rows and Columns

Lecture 196 Changing the Size of Columns and Rows

Lecture 197 Entering Text and Numbers in Worksheet

Lecture 198 Wrap Text Inside the Cell

Lecture 199 Edit Text Within a Cell

Lecture 200 Merging and Formatting Cells in a Worksheet

Lecture 201 Formatting Header in a Worksheet

Lecture 202 Adding Image in a Worksheet

Lecture 203 Formatting Date in Excel Worksheet

Lecture 204 Working of Undo & Redo Commands in an Excel Worksheet

Lecture 205 Home Work

Section 31: Calculations With Basic Formulas

Lecture 206 Introduction to Arithmetic Operators

Lecture 207 Calculations with Arithmetic Operators

Lecture 208 Copy and Paste the Formula

Lecture 209 Auto Complete Formula

Lecture 210 Inserting and Deleting Columns and Rows

Lecture 211 Hide and Unhide Columns and Rows

Lecture 212 Moving a Cell or Range by Drag and Drop Method

Lecture 213 Moving a Cell or Range by Cut and Paste Method

Lecture 214 Relative and Absolute Cell References

Lecture 215 Home Work

Section 32: Calculations with Simple Excel Functions

Lecture 216 Introduction to Function Syntax

Lecture 217 Calculating Total Sales by Using SUM Function

Lecture 218 Calculating Total Sales Quantities by Using SUM Function

Lecture 219 Count Price Items by Using COUNT Function

Lecture 220 Count Food Items by Using COUNTA Function

Lecture 221 Calculating Average Sales by Using AVERAGE Function

Lecture 222 Calculating Maximum Sales Value of Customer by Using MAX Function

Lecture 223 Calculating Minimum Sales Value of Customer by Using MIN Function

Lecture 224 Calculating Total Price of Products by Using PRODUCT Function

Lecture 225 Calculating Sales Data by Using Auto FUNCTION Button

Lecture 226 Calculating a Tax Rate on Total Sales

Lecture 227 Home Work

Section 33: Formatting a Worksheet

Lecture 228 Merging Two or More Cells into One Cell

Lecture 229 Alignment of Cell Text

Lecture 230 Splitting Text into Multiple Lines

Lecture 231 Rotating a Cell Text or Numbers

Lecture 232 Formatting Background Color of Text and Numbers

Lecture 233 Formatting Font Size and Font Color

Lecture 234 Adding Border into Cells

Lecture 235 Formatting Cell Styles

Lecture 236 Find and Replace Text in a Worksheet

Lecture 237 Calculating Students Enrollment and Difference Between two Columns Values

Lecture 238 Calculating Percentage Difference Between two Columns Values

Lecture 239 Conditionally Formatting Cells in a Worksheet

Lecture 240 Conditionally Formatting Cells with a Top and Bottom Rules

Lecture 241 Home Work

Section 34: Saving and Printing a Workbook

Lecture 242 Saving a Workbook

Lecture 243 Worksheet Views,Page Orientation and Scaling

Lecture 244 Setting Margins in a Print Page

Lecture 245 Adding Header and Footer in a Print Page

Lecture 246 Print Preview and Selecting Print Area

Lecture 247 Setting Scaling and Margins in a Print Page(Document 1)

Section 35: Project Calculations with Operators and Functions

Lecture 248 Calculating the Area of Field and Plots

Lecture 249 Calculating the Grown and Empty Area of Vegetables Field

Lecture 250 Calculating the Percentage of Grown and Empty area in Vegetables Field

Lecture 251 Calculating Cost of Sales and Weightages of Vegetables

Lecture 252 Calculating Profit and Percentage of Profit from Vegetables

Lecture 253 Calculating Revenue by Using Sum,Max,Min,Average and Median Functions

Lecture 254 Introduction to NESTED Function

Lecture 255 Nesting the SUM and MEDIAN Functions within ROUND Function

Lecture 256 Home Work

Section 36: IF and VLOOKUP Functions

Lecture 257 Introduction to IF Function and Apply Weather Condition on IF Function

Lecture 258 Apply Different Conditions on IF Function

Lecture 259 Introduction to VLOOKUP Function

Lecture 260 Apply VLOOKUP Function on Data Table

Lecture 261 Retrieving Values from Data Table by Using VLOOKUP Function

Lecture 262 Errors in VLOOKUP Function

Lecture 263 Home Work

Section 37: Adding Column and Pie Charts in an Excel worksheet

Lecture 264 Embed Column Chart in a Worksheet

Lecture 265 Analyzing Data with a Column Chart

Lecture 266 Analyzing Data with a Pie Chart

Lecture 267 Recommended Charts

Lecture 268 Home Work

Section 38: Date and Time Functions in an Excel

Lecture 269 NOW and TIME Functions

Lecture 270 HOUR,MINUTE and SECOND Functions

Lecture 271 TODAY,DATE and DAYS Functions

Lecture 272 YEAR,MONTH and DAY Functions

Lecture 273 WEEKDAY Function

Lecture 274 WEEKNUM Function

Lecture 275 EDATE Function

Lecture 276 EOMONTH Function

Lecture 277 Determining Person’s Birthday

Lecture 278 Calculating Age of Person

Lecture 279 Formatting Date in a Cell

Lecture 280 DATEVALUE Function

Lecture 281 DAYS360 Function

Lecture 282 ISOWEEKNUM Function

Lecture 283 NETWORKDAYS Function

Lecture 284 TIMEVALUE Function

Lecture 285 YEARFRAC Function

Section 39: Logical Functions in an Excel

Lecture 286 Calculating the Age of Employees and Length of Service

Lecture 287 Analyzing Data by Using IF Function

Lecture 288 Determining Birthday of Employees

Lecture 289 Specifying Day of Birthdate by Nesting DAY Function Within IF Function

Lecture 290 Determining Employee Eligibility for Promotion by Using AND Function

Lecture 291 Nesting the AND Function Within IF Function

Lecture 292 Determining Employee Eligibility for Promotion by Using OR Function

Lecture 293 Nesting the OR Function Within IF Function

Lecture 294 IFERROR Function

Lecture 295 IFNA Function

Lecture 296 FALSE Function

Lecture 297 IFS Function

Lecture 298 NOT Function

Lecture 299 SWITCH Function

Lecture 300 TRUE Function

Lecture 301 XOR Function

Lecture 302 Home Work

Section 40: Lookup and Reference Functions in an Excel

Lecture 303 Extracting Value from Data Table by Using VLOOKUP Function

Lecture 304 Extracting Value from Data Table by Using HLOOKUP Function

Lecture 305 Calculating Discount and Total Price

Lecture 306 Calculating Tax Rate on Total Price Value

Lecture 307 Extracting Value by Using CHOOSE Function

Lecture 308 Nesting the CHOOSE Function Within Sum Function

Lecture 309 MATCH Function

Lecture 310 Extracting Value by Using INDEX Function

Lecture 311 Nesting the MATCH Function Within an INDEX Function

Lecture 312 Nesting the VLOOKUP Function Within an IFERROR Function

Lecture 313 COLUMN Function

Lecture 314 LOOKUP Function

Lecture 315 TRANSPOSE Function

Lecture 316 Home Work

Section 41: Adding Line and Combination Charts in an Excel

Lecture 317 Adding and Formatting Line Chart

Lecture 318 Adding and Formatting Combination Chart

Section 42: Text Functions in an Excel

Lecture 319 BHATTEXT Function

Lecture 320 CHAR Function

Lecture 321 CLEAN Function

Lecture 322 CODE Function

Lecture 323 CONCAT Function

Lecture 324 DOLLAR Function

Lecture 325 EXACT Function

Lecture 326 FIND Function

Lecture 327 FIXED Function

Lecture 328 LEFT Function

Lecture 329 LEN Function

Lecture 330 LOWER Function

Lecture 331 MID Function

Lecture 332 NUMBERVALUE Function

Lecture 333 PROPER Function

Lecture 334 REPLACE Function

Lecture 335 REPT Function

Lecture 336 RIGHT Function

Lecture 337 SEARCH Function

Lecture 338 SUBSTITUTE Function

Lecture 339 T Function

Lecture 340 TEXT Function

Lecture 341 TEXTJOIN Function

Lecture 342 TRIM Function

Lecture 343 UNICHAR Function

Lecture 344 UNICODE Function

Lecture 345 UPPER Function

Lecture 346 VALUE Function

Section 43: Math and Trigonometry Functions in an Excel

Lecture 347 SUM Function

Lecture 348 MOD Function

Lecture 349 POWER Function

Lecture 350 SUBTOTAL Function

Lecture 351 SUMIF Function

Lecture 352 SUMIFS Function

Lecture 353 SUMPRODUCT Function

Lecture 354 ROUND Function

Lecture 355 ROUNDDOWN Function

Lecture 356 ROUNDUP Function

Lecture 357 CEILING.MATH Function

Lecture 358 FLOOR.MATH Function

Lecture 359 EVEN Function

Lecture 360 ODD Function

Lecture 361 INT Function

Lecture 362 TRUNC Function

Section 44: Statistical Functions in an Excel

Lecture 363 AVERAGE Function

Lecture 364 AVERAGEIF Function

Lecture 365 AVERAGEIFS Function

Lecture 366 COUNT and COUNTA Function

Lecture 367 COUNTBLANK Function

Lecture 368 COUNTIF Function

Lecture 369 COUNTIFS Function

Lecture 370 LARGE Function

Lecture 371 SMALL Function

Lecture 372 MAX and MIN Function

Lecture 373 MEDIAN Function

Lecture 374 MODE.MULT Function

Lecture 375 MODE.SNGL Function

Section 45: Engineering Functions in an Excel

Lecture 376 BIN2DEC Function

Lecture 377 BIN2HEX Function

Lecture 378 BIN2OCT Function

Lecture 379 COMPLEX Function

Lecture 380 CONVERT Function

Lecture 381 DEC2BIN Function

Lecture 382 DEC2HEX Function

Lecture 383 DEC2OCT Function

Section 46: Information Functions in an Excel

Lecture 384 CELL Function

Lecture 385 ERROR.TYPE Function

Lecture 386 INFO Function

Lecture 387 ISBLANK Function

Lecture 388 ISERR Function

Lecture 389 ISERROR Function

Lecture 390 ISEVEN Function

Lecture 391 ISFORMULA Function

Lecture 392 ISLOGICAL Function

Lecture 393 ISNA Function

Lecture 394 ISNONTEXT Function

Lecture 395 ISNUMBER Function

Lecture 396 ISODD Function

Lecture 397 ISREF Function

Lecture 398 ISTEXT Function

Lecture 399 N Function

Lecture 400 NA Function

Lecture 401 SHEET Function

Lecture 402 SHEETS Function

Lecture 403 TYPE Function

Section 47: Database Functions in an Excel

Lecture 404 DAVERAGE Function

Lecture 405 DSUM Function

Lecture 406 DMAX and DMIN Functions

Lecture 407 DCOUNTA Function

Section 48: Financial Functions:Borrow Money to Bank

Lecture 408 Calculating a Quarterly Payment of Loan by using the PMT Function

Lecture 409 Calculating a Future Value of Loan by using the FV Function

Lecture 410 Calculating a Payment Period of Loan by using the NPER Function

Lecture 411 Calculating a Present Value of Loan by using the PV Function

Lecture 412 Calculating an Interest Rate of Loan by using the RATE Function

Lecture 413 Positive Cash Flow and Negative Cash Flow

Lecture 414 Calculating the Value of Inflation by Using FV Function

Lecture 415 Calculating a Monthly Car Payment

Lecture 416 Calculating the Interest Payment by using IPMT Function

Lecture 417 Calculating the Principal Payment by using PPMT Function

Lecture 418 Calculating Remaining Principal Amount and Total Payment

Lecture 419 Completing the Amortization Schedule of Loan

Lecture 420 Plotting Interest and Principal Payments

Lecture 421 Calculating Cumulative Interest Payments by Using CUMIPMT Function

Lecture 422 Calculating Cumulative Principal Payments by Using CUMPRINC Function

Lecture 423 Calculating Remaining Principal,Total Interest and Total Principal Payments

Lecture 424 Calculating Total Loan Amount

Section 49: Financial Functions:Invest Money in the Bank Saving Account

Lecture 425 Calculating the Compound Interest

Lecture 426 Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions

Lecture 427 Calculating the Future Value of an Investment by Monthly and Initial Deposits

Lecture 428 Calculating the Interest Rate of an Investment

Lecture 429 Calculating the Total Number of Deposits of an Investment

Lecture 430 Calculating the Initial Deposit or Present Value of an investment

Lecture 431 Calculating the Value of Deposit Per Month

Lecture 432 Calculating the Variable Interest Rates by using FVSCHEDULE Function

Lecture 433 Amortization Schedule of an Investment 1

Lecture 434 Amortization Schedule of an Investment 2

Section 50: Financial Functioms:Build Future Income Statement of Company

Lecture 435 Introduction to Income Statement Worksheet

Lecture 436 Linear and Growth Trend Values

Lecture 437 Projecting Future Value of Sales or Revenue by using Linear Trend Option

Lecture 438 Projecting Future Value of Sales or Revenue by Inserting a Growth Trend

Lecture 439 Calculating the Cost of Research and Development

Lecture 440 Calculating the Cost of Sales and Marketing

Lecture 441 Calculating the Gross Profit

Lecture 442 Calculating the Expenses of Company Part 1

Lecture 443 Calculating the Expenses of Company Part 2

Lecture 444 Calculating the Expenses of Company Part 3

Lecture 445 Calculating the Total General Expenses and Initial Earnings

Lecture 446 Adding Depreciation of an Asset in the Income Statement

Lecture 447 Calculating Operating Profit in the Income Statement

Lecture 448 Adding Interest Expenses in the Income Statement

Lecture 449 Calculating Profit Without Adding Tax

Lecture 450 Adding Taxes in the Income Statement

Lecture 451 Calculating Final Profit of the Company in the Income Statement

Section 51: Financial Functions:Calculate Depreciation of an Asset of Company

Lecture 452 Straight Line Depreciation of an Asset Part 1

Lecture 453 Straight Line Depreciation of an Asset Part 2

Lecture 454 Straight Line Depreciation of an Asset Part 3

Lecture 455 Declining Balance Depreciation of an Asset Part 1

Lecture 456 Declining Balance Depreciation of an Asset Part 2

Lecture 457 Calculating Depreciation of an asset by Using SYD Function

Lecture 458 Calculating Depreciation of an asset by Using DDB Function

Lecture 459 Calculating Depreciation of an asset by Using VDB Function

Lecture 460 Calculating Depreciation Value of a Car

Lecture 461 Selecting Method of Depreciation to Calculate Depreciation of an Asset

Section 52: Financial Functions:Invest Money in Company

Lecture 462 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1

Lecture 463 Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2

Lecture 464 Calculating Payback Period of an Investment Part 1

Lecture 465 Calculating Payback Period of an Investment Part 2

Lecture 466 Calculating Payback Period of an Investment Part 3

Lecture 467 Calculate Present Value of an Invetment by Using NPV Function Part 1

Lecture 468 Calculate Present Value of an Invetment by Using NPV Function Part 2

Lecture 469 Calculate Net Present Value of an Invetment

Lecture 470 Calculate Internal Rate of Return of an Invetment by Using IRR Function

Lecture 471 Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons

Lecture 472 Calculate Equivalent Value of Interest Rate by Using RRI Function

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

Lecture 473 Calculating the Remaining Amount with 30% Rate

Lecture 474 Calculating the Remaining Amount with 15% and 40% Rate

Lecture 475 Calculating the Percentage of Remaining Amount

Lecture 476 Calculating the Percentage of Savings

Lecture 477 Finding the Value of Actual Amount

Lecture 478 Calculating the Value of Expense,Save and Total Amount

Lecture 479 Calculating the Remaining Profit

Lecture 480 Calculating the Values of Profit and Percentage of Profit

Lecture 481 Calculating the Values of Loss and Percentage of Loss

Section 54: Microsoft Power BI

Lecture 482 Introduction to Microsoft Power BI

Section 55: Microsoft Power BI:Create Global Store Sales Dashboard

Lecture 483 Introduction

Lecture 484 Adding Background Image in the Page and Access Database File

Lecture 485 Adding Image,Text Box and Card Part 1

Lecture 486 Adding Image,Text Box and Card Part 2

Lecture 487 Adding Buttons and Map

Lecture 488 Adding Slicers

Lecture 489 Adding Table and Selecting Top 5 Countries by Sales in Funnel Chart

Lecture 490 Locking Visual for Filtering Data

Lecture 491 Adding Table and Conditionally Formatting Table Values

Lecture 492 Adding Column Chart and Customer Slicer

Lecture 493 Adding Line Chart

Lecture 494 Bookmarks the Pages

Lecture 495 Use Buttons to Navigate Pages and Slicer for to Get Specific Data

Section 56: Microsoft Power BI:Create Malaria Analytics Dashboard

Lecture 496 Introduction

Lecture 497 Adding Horizontal Bar,Image and Text Box

Lecture 498 Adding Slicers and Clear Filters Button

Lecture 499 Adding Data Set,Text Box,Button,Horizontal Line and Map Chart

Lecture 500 Adding Stacked Bar Chart and Table

Lecture 501 Adding Card and Text Box

Lecture 502 Copy and Paste Slicers and Clear Filters Button

Lecture 503 Adding Card and Text Box Part 1

Lecture 504 Adding Card,Text Box and Stacked Area Chart Part 2

Lecture 505 Adding Data Tables

Lecture 506 Use Copy and Paste Technique

Lecture 507 Adding Line Chart and Table

Lecture 508 Filter Specific Data by Using Filter Pane

Lecture 509 Copy and Paste Layers of Previous Page Part 1

Lecture 510 Copy and Paste Layers of Previous Page Part 2

Lecture 511 Adding Previous Buttons and Creating Bookmarks Part 1

Lecture 512 Adding Previous Buttons and Creating Bookmarks Part 2

Lecture 513 Inserting Bookmarks Links in the Buttons

Lecture 514 Clear All Filters

Section 57: Microsoft Power BI:Create Climate Change Report

Lecture 515 Introduction

Lecture 516 Creating Page 1 (Home Page)

Lecture 517 Creating Page 2 (Carbon Dioxide) Part 1

Lecture 518 Creating Page 2 (Carbon Dioxide) Part 2

Lecture 519 Creating Page 2 (Carbon Dioxide) Part 3

Lecture 520 Creating Page 2 (Carbon Dioxide) Part 4

Lecture 521 Creating Page 2 (Carbon Dioxide) Part 5

Lecture 522 Creating Page 2 (Carbon Dioxide) Part 6

Lecture 523 Creating Page 2 (Carbon Dioxide) Part 7

Lecture 524 Creating Page 3 (Global Temperature) Part 1

Lecture 525 Creating Page 3 (Global Temperature) Part 2

Lecture 526 Creating Page 3 (Global Temperature) Part 3

Lecture 527 Creating Page 3 (Global Temperature) Part 4

Lecture 528 Creating Page 3 (Global Temperature) Part 5

Lecture 529 Creating Page 3 (Global Temperature) Part 6

Lecture 530 Creating Page 4 (Ice Area) Part 1

Lecture 531 Creating Page 4 (Ice Area) Part 2

Lecture 532 Creating Page 4 (Ice Area) Part 3

Lecture 533 Creating Page 4 (Ice Area) Part 4

Lecture 534 Creating Page 4 (Ice Area) Part 5

Lecture 535 Creating Page 4 (Ice Area) Part 6

Lecture 536 Creating Page 5 (Disasters) Part 1

Lecture 537 Creating Page 5 (Disasters) Part 2

Lecture 538 Creating Page 5 (Disasters) Part 3

Lecture 539 Creating Page 5 (Disasters) Part 4 Preview

Lecture 540 Creating Page 5 (Disasters) Part 5

Lecture 541 Creating Page 6 (Plastic Pollution) Part 1

Lecture 542 Creating Page 6 (Plastic Pollution) Part 2

Lecture 543 Creating Page 7 (Ozone Hole Area and Air Pollution) Part 1

Lecture 544 Creating Page 7 (Ozone Hole Area and Air Pollution) Part 2

Lecture 545 Creating Page 7 (Ozone Hole Area and Air Pollution) Part 3

Lecture 546 Creating Page 8 (Causes , Effects and Prevention) Part 1

Lecture 547 Creating Page 8 (Causes , Effects and Prevention) Part 2

Lecture 548 Creating Page 8 (Causes , Effects and Prevention) Part 3

Lecture 549 Creating Page 8 (Causes , Effects and Prevention) Part 4

Lecture 550 Creating Page 8 (Causes , Effects and Prevention) Part 5

Lecture 551 Creating Page 8 (Causes , Effects and Prevention) Part 6

Lecture 552 Bookmarks Report Pages

Lecture 553 Insert Bookmarks Links in the Buttons

Section 58: Bookmarks Pane and Selection Pane

Lecture 554 Analyzing Data by Creating Column,Bar and line Charts Buttons

Lecture 555 Analyzing Data by Creating Pie,Donut and Map Charts Buttons

Lecture 556 Analyzing Data by Creating Sales Report and Units Sold Report Buttons

Lecture 557 Creating Color Buttons for Chart

Lecture 558 Creating Font Sizes Buttons for Chart

Lecture 559 Creating Axis Buttons for Chart

Lecture 560 Creating Clear All Slicers Button

Lecture 561 Creating Slicers Panel With Two Buttons

Lecture 562 Creating Another Slicers Panel with Two Buttons

Lecture 563 Creating Toggles Button

Lecture 564 Creating Another Toggles Button

Section 59: Editing and Visualizing Data

Lecture 565 Introduction to Power BI and Loading Data in Power BI Part 1

Lecture 566 Introduction to Power BI and Loading Data in Power BI Part 2

Lecture 567 Manage Relationships Between Data Tables in the Power BI

Lecture 568 Creating First Sales Report in the Report Tab

Lecture 569 Visualizing First Sales Report Data

Lecture 570 Filtering Data by Selecting Top and Bottom options

Lecture 571 Creating and Visualizing Second Sales Report in the Report Tab

Lecture 572 Fltering Data by Using Treemap Chart

Lecture 573 Creating and Visualizing Third Sales Report in the Report Tab

Lecture 574 Formating Column Chart

Lecture 575 Analyzing Data by Using Pie Chart

Lecture 576 Analyzing Data by Using Scatter Chart

Lecture 577 Analyzing Data by Using Waterfall Chart

Lecture 578 Analyzing Data by Using Guage Card

Lecture 579 Adding Text Box,Image and Shapes

Lecture 580 Locate Places with Latitudes and Longitudes

Lecture 581 Globe Map

Lecture 582 Creating and Visualizing Fourth Sales Report in the Report Tab

Lecture 583 Analyzing Data in the Combination Charts

Lecture 584 Formatting Slicers

Lecture 585 Formatting and Changing Layout of Page

Lecture 586 Creating a Duplicate Report Page

Lecture 587 Summarizing Sales Data

Lecture 588 Create Hierarchies and Drill Down Data

Lecture 589 Selecting Filter Options

Lecture 590 Changing the Background Color of Page

Lecture 591 Adding Background Image in the Report Page

Lecture 592 Analyzing Data by Using Analytics

Section 60: Extracting Data from the Website

Lecture 593 Extracting Data from the Website

Lecture 594 Creating Report

Lecture 595 Visualizing Report

Section 61: Extracting Sales Data from the Website

Lecture 596 Extracting Sales Data from the Website

Lecture 597 Combining all Queries into one Query

Lecture 598 Extracting User Data from the Website and Merging Two Queries Data in One Query

Lecture 599 Analyzing Top Sold Movies Data in Power BI

Section 62: Publish and Create Dashboard

Lecture 600 Upload Report into Power BI Web

Lecture 601 Create Dashboard

Lecture 602 Quick Insights in Data

Lecture 603 Open in Focus Mode and Edit Details

Lecture 604 Adding Textbox in the Dashboard

Lecture 605 View Dashboard in Full Screen Mode

Lecture 606 Adding Image in the Dashboard

Lecture 607 Asking Questions to Data

Lecture 608 Manage Data Gateway(Automatically Refresh Dashboard Data)

Lecture 609 Printing Dashboard

Lecture 610 Republish Power BI Desktop Report

Lecture 611 Create Workspace to Share Data into Organization

Lecture 612 Creating Apps

Lecture 613 Editing Apps

Lecture 614 Installing Third Parties Apps

Lecture 615 Publishing Power BI Report to Web

Section 63: New Quick Measure(Calculations Without Dax)

Lecture 616 Calculating Sales Year to Date

Lecture 617 Calculating Running Total

Section 64: Custom Visuals

Lecture 618 Synoptic Panel Part 1

Lecture 619 Synoptic Panel Part 2

Lecture 620 Chiclet Slicer

Lecture 621 KPI(Key Performance Indicator) Part 1

Lecture 622 KPI(Key Performance Indicator) Part 2

Lecture 623 Bullet Chart

Lecture 624 Dial Gauge

Lecture 625 Linear Gauge

Lecture 626 Infographic Designer

Lecture 627 Infographic Designer(Show Motorcycles Shapes in Bar Chart)

Lecture 628 Infographic Designer(Show Apartment Shapes in Column Chart)

Lecture 629 Infographic Designer(Adding Images in Column Chart)

Lecture 630 Infographic Designer(Changing Multiple Layout Part 1)

Lecture 631 Infographic Designer(Changing Multiple Layout Part 2)

Lecture 632 Infographic Designer(Show Sales in Shapes)

Lecture 633 Infographic Designer(Show Sales in Multiple Shapes)

Lecture 634 TreeViz and Funnel Visuals

Lecture 635 Agility Planning Matrix

Lecture 636 Sunburst and KPI Card Visuals

Lecture 637 Network Visuals

If someone want to learn excel from basic to Advance,this course covers basic and advance levels topics.,If someone want to learn business intelligence for data analysis and for creating dashboards and reports,learn Microsoft power BI from basic to advance levels.

Course Information:

Udemy | English | 46h 9m | 22.36 GB
Created by: Mubeen Ali

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com