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.
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.
Learn Microsoft Excel for Data Analysis with this course from Zero to Hero. Master Microsoft Excel to Excel in the industry..
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or comp..
Learn Continuous Integration, Continuous Delivery & 15 DevOps tools like Docker, Ansible, Terraform, Jenkins, AWS, Chef
The Complete Beginner Course in JavaScript. Learn the fundamentals of JavaScript (Execution Context, Memory, Call Stack, e..
This PHP course teaches PHP to beginners most quickly and straightforwardly possible using real-world projects.