Introduction to Microsoft Excel
Microsoft Excel is the #1 productivity software in the world. A huge amount of data comes in a spreadsheet format, so an analyst needs Excel in their arsenal. This course will teach you all the Excel skills you need to perform multi-layered calculations, create charts, manipulate data, lookup functions, and more!
4 hours
27 exercises
1 assignments
0 quizzes
236 downloadables Sign up to
preview the course
for FREE!
Create a free account and start learning data science today.
create free account
Our graduates work at exciting places:
Section 1
Welcome! Course Introduction
This section is fundamental for those of you who have never used Excel. We will start from the very basics: introducing the Excel ribbon, learning how to insert (and delete) rows and columns, how to perform data entry tasks, and how to format worksheets professionally. In addition, you will create your first formulas and functions, and cut, copy, and paste values for the first time.
Section 2
Useful Tools & Tips
Once you are familiar with the basic operations in Excel, it will be time to learn Excel best practices and learn how to navigate spreadsheets professionally. In this section, you will learn how to apply fast scrolling, use keyboard shortcuts, format sheets professionally, fix cell references, use named ranges, apply custom cell formats, and much more.
Excel tips and tricks Conditional Formatting Section 3
Beginner, Intermediate & Advanced Functions
Excel is one of the most popular productivity tools the business world has ever seen. The main reason for this is Excel functions. Here you will learn how to use Excel functions like a true professional. We will start with some easier examples (SUM, COUNT, AVERAGE, IF, MAX, MIN, VLOOKUP, HLOOKUP), and gradually introduce more advanced (and more powerful) functions such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, INDEX, MATCH, INDEX & MATCH, etc.
Key Excel Functions: If Enlarge the formula bar Key Excel Functions: Sum, Sumif, Sumifs Key Excel Functions: Count, Counta, Countif, Countifs Key Excel Functions: Average & Averageif Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, & Working with text in Excel Find the Highest and Lowest Values in a Range: Max & Min =' and '+' are interchangeable when you start typing a formula Use Round in Your Financial Models Excel's Lookup Functions: Vlookup & Hlookup Made Easy Index, Match, and Their Combination - The Perfect Substitute for Vlookup Using Excel's Iferror Function to Trap Spreadsheet Errors A Useful Tool for Financial Analysis - The Rank Function Create Flexible Financial Models with Choose Goal Seek Will Help You Find the Result You Are Looking For Perform Sensitivity Analysis with Excel's Data Tables Functionality Section 4
Practical Exercise "Build a P&L From Scratch"
It is one thing to learn how to work with Excel’s most important tools, but it is even better to apply these techniques in a practical exercise. This is what we will do here. The “Build a P&L from scratch” exercise allows you to see how everything you have learned so far can be put into practice.
Build a P&L from scratch: data preparation Build a P&L from scratch: fill in the database Build a P&L from scratch: mapping Build a P&L from scratch: creating a P&L Build a P&L from scratch: adding % variations Section 5
Building Professional Charts in Excel
One of the strongest features of Microsoft Excel, besides multi-layered calculations, is that it allows you to visualize data. Here you will learn how to insert and format different types of charts that will help you make sense of numbers and figure out their trend.
Introduction to Excel Charts Beginner's Guide to Inserting Charts in Excel Modifying Excel Charts - The Easy Way Making Your Excel Charts Sexier - Proven Tips Creating a Bridge Chart in Excel 2016 - As Easy as It Gets New Ways to Visualize Your Data - Treemap Charts How to Represent Trends with Sparklines Stacked Column Chart with a Secondary Axis Doughnut Chart Area Chart Bridge Chart Section 6
Introduction to Pivot tables
Pivot Tables are capable of summarizing thousands of rows of data in just a few seconds. All you have to do is drag and drop and you will be able to create the report that you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.
Intro to Pivot tables Editing a Pivot table Formatting a Pivot table Adjusting a Pivot table GETPIVOTDATA Slicers Section 7
A practical case study with Pivot Tables
In this case study, you will: 1. Apply in practice what you have learned so far 2. Work on a real-world task 3. Enhance your spreadsheet formatting skills 4. Learn how to create advanced charts
Introduction to the case study Working with an SAP data extraction Preliminary mapping of the data extraction Creating an output structure of the FMCG model Improving the layout and appearance of the FMCG report Inserting formulas and automating calculations Creating a Master Pivot Table: The main data source for the FMCG report GetPivotData is great! Extracting data from the Master Pivot Table Combining Slicers and GetPivotData: The key to our success Getting fancy with Excel slicers This is how the report can be used in practice by high-level executives Data Science Fundamentals
This course is part of Module 1 of the 365 Data Science Program. The complete training consists of four modules, each building up on your knowledge from the previous one. Whereas the other three modules are designed to improve upon your technical skillset, Module 1 is designed to help you create a strong foundation for your data science career. You will understand the core principles of probability, statistics, and mathematics; you will also learn how to visualize your data.
See All Modules Why Choose the 365 Data Science Program?
Practice
Real-life project and data. Solve them on your own computer as you would in the office.
Q&A Hub
Our expert instructors are happy to help. Post a question and get a personal answer by one of our instructors.
Certificates
Earn a verifiable certificate after each completed course. Celebrate your successes and share your progress with your professional network!
Trust the other 276,000 students
The course is in-depth and is delivered at a steady pace with eye catching visuals. The instructors go through all the basics really well. They try not to over-simplify the material, you get a good sense аof how deep Data Science is in the course. Great job!!!
This course is amazing! After watching the video carefully and doing all the exercises, I am even capable of having discussions with Machine learning major Master’s students! High standard course with reasonable pricing.
Very clear and in-depth explanation of data science and how all the inter-related concepts apply in real life business environment. Absolutely great for beginners! Best data science course I have come across so far!
I would highly recommend the course to any beginner who wants to venture into the world of Data Science. The concepts are very well explained and there is an emphasis on practical application which really helps create a better understanding of the concepts.
Ready to start?
Sign up today for FREE!
