**** Important Notice *********************************
Still building the Power BI section. Expect lots of new content as the business data analysis world is now a fast changing one. Microsoft is constantly updating and expanding the features of Microsoft Excel and Power BI.
Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you.
Power BI is Microsoft's business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it you can create reports with drill down features, access-level restrictions, auto-refresh, alerts/triggers and interactivity.
This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.
Excel recognizes only four data types. Anything you type into Excel will fall under one of these data types. In this lecture we will set some of the foundation knowledge you will need to work productively in Excel.
This builds up on the knowledge established in Lecture 2. Excel is different from the other software in the Microsoft Office suite and has its own special set of guidelines to make the most of it. We will be going into those general rules you need to master to be very proficient in the use of Excel for business purposes.
Almost everything you enter in Excel -- reports, raw data -- are in table format. However there are some special types that I refer to as datatable. In this lecture I will explain what they are and why they need to be handled differently.
I will introduce you to sorting in Excel. Talk about the recommended way to sort. Do examples that cover the usual top to bottom sorting, then the left to right sorting, and cascaded sorting.
I will cover removing duplicates, text-to-column, subtotal and data validation.
I'll show you how to use the "Format as Table" tool. Also how to set up your Excel sheet for printing. And finally how to put some of your analysis/report directly in the body of an email.
I'll show you the most commonly used charts. Explaining when to use each and how to create them. The main charts covered are Column chart, Bar chart, Pie Chart, Combo chart and Sparkline.
I'll show you some creative uses of Excel.
I'll show you more creative uses of Excel
I'll show you more creative uses of Excel
I'll show you my favourite Excel keyboard shortcuts.
I'll demystify the PivotTable for you with an interesting easy to follow example. I will also teach you how to insert a PivotChart and work with PowerPivot.
I'll show you how to use mail merge feature of Microsoft Word in conjuction with Excel and Outlook.
This is one of the core lectures in the training course. It covers linking sheets, duplicating sheets, freezing panes, splitting windows and conditional formatting.
This covers VLOOKUP, HLOOKUP, INDEX and MATCH. It is another core lecture in this training.
I'll be showing you how to make sales (or any other metric) forecast using the new forecast tool in Excel 2016. Don't forget to download the practice along file.
This is a lecture to show you a creative use of PivotTable for a dynamic analysis.
I'll explain to you some important tips to remember in making business reports and presentation data from Excel.
I teach you the benefits and how to create a named range. I'll also cover Goal Seek and Scenario Manager.
I'll show you how to protect a worksheet, a workbook structure and the Excel file.
I'll show you a creative use of the Excel web query.
This is another core lecture. I'll cover the power Excel functions: IF, SUM, SUMIFS, COUNTIFS, LEFT, RIGHT, MID and many others.
Update to the Power Excel Function List. I've included SUMPRODUCT as it is a very powerful function and can be creatively used to set up a neat template.
I explained in-depth its use for simple calculations and complex calculations.
I'll introduce you to creating Excel macros just by pressing a button twice. Excel macros are that easy!
We will dive in deeper into Excel Macros by creating an interactive form for a user to enter in data into a table in Excel. It's a very interesting example you will definitely find more use for.
Michael is a Microsoft Excel MVP (Most Valuable Professional), Microsoft Certified Trainer and founder of UrBizEdge, a Microsoft Excel and business data analysis consulting firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.
He is addicted to Microsoft Excel, Power BI, VBA programming and web app development. He loves blogging daily and loves helping people with their Microsoft Excel issues.