All Courses

Excel and PowerBi for Data Visualization

Excel and PowerBi for Data Visualization

Data Visualization with Microsoft Excel and PowerBi

What you’ll learn

Excel and PowerBi for Data Visualization

  • Excel and PowerBi for Data Visualization

  • Data analysis with Excel

  • Data visualization with PowerBi

  • Hands-on experience with Excel and PowerBi


  • No prior experience is required, we start from the basics


Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software. Power BI is an interactive data visualization software developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. We cover Excel fundamentals, Quick Access Toolbar, and Basic excel functions such as SUM, MIN & MAX, and Average & AutoSum.

Excel sheet modifications using Moving & Copying data, Inserting & deleting rows, Hiding, unhiding, and re-naming. Formatting data, Font formatting, Creating styles, Conditional formatting, Creating Charts, Excel column charts, Adding and modifying data, Excel Pie charts. Pivot Table, Creating a Pivot table, Modifying pivot table, Grouping pivot table, Creating pivot charts, Filtering pivot charts, Excel conditional functions, IF function, Nesting function. Lookup functions VLookup, HLookup, INDEX & MATCH. For PowerBi we go through Power BI, Introduction to PowerBI desktop, Connecting to Data, Table relationships, Data model, Filter Flow, Data Analysis Expressions (DAX) – Calculated Columns, Data Analysis Expressions (DAX) – Measures, IF, AND, OR, CALCULATE, CALCULATE ALL, SUMX, Report View in PowerBI, Inserting Charts, Formatting, Filtering options, Matrix Visuals, Treemaps, Trend lines and forecast, Managing roles in Power BI

I am publishing to PowerBI service.

Who this course is for:

  • Anyone interested in data visualization

If the links does not work, contact us we will fix them