Introduction to Excel
Even in data science, smaller datasets are processed quicker in Excel rather than Python, R, or SQL. This course gives you the skills you need to crunch numbers in the number one spreadsheet program.
with Ned Krastev
Start courseCourse Overview
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, look up functions, and more!
Skills you will gain
What You'll Learn
Every data analyst needs Excel in their arsenal. This course will teach you how to apply various Excel techniques for performing calculations, data manipulations, analyses, and more!
Curriculum
- Welcome! Course Introduction Free10 Lessons 31 Min
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.
Welcome to the Course Free Excel Made Easy: A Beginner's Guide to Excel Spreadsheets Free Data Entry Techniques in Excel Free How to Make Your Spreadsheets Look Professional Free Inserting, Deleting, and Modifying Rows & Columns Free Excel Formulas for Beginners Free Excel Functions Free Work Efficiently by Using Cut, Copy, and Paste Free Formatting Free Pasting Values, Formulas and Formats with Paste Special Free - Useful Tools & Tips Free29 Lessons 62 Min
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.
Inserting a Line Break with Alt + Enter Free Do More with Your Sales Data with Excel's Text to Columns Feature Free Create Easily Printable Excel Documents Free How to Wrap Text in Excel and Adjust a Cell's Size Free Insert Hyperlinks into Excel Spreadsheets Free Using Excel's Freeze Panes to Handle Large Datasets Free Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do Free A Quick Introduction to Excel's Pivot Tables Free Initial Formatting Is Key for Creating Professional-looking Spreadsheets Free Macros Are a Great Timesaver! Here's Why Free How to Use the Same Macro On Multiple Workbooks Free The Secret to Faster Scrolling in Excel Free Be even quicker: F5 + Enter Free Using Absolute and Relative Cell References Free Find and Select Cells That Meet Specific Conditions Free How to Create Dynamic Names in Excel Spreadsheets Free Using Named Ranges to Make Formulas More Readable Free How to Add a Drop-down List in Excel Free Using Custom-sort to Sort Multiple Columns Within a Table Free Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts Free Multiply by 1 Free Find and Replace - References Free Find and Replace - Formatting Free Green References Free Beauty Saving - The Professional Way of Saving Files Free The Power of F2 Free Conditional Formatting Free Introduction to Custom Cell Formatting Free Custom Formatting - An example Free - Beginner, Intermediate & Advanced Functions17 Lessons 52 Min
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 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 - Practical Exercise "Build a P&L From Scratch"16 Lessons 41 Min
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.
Introduction to the Case Study What You Will See Next Understand Your Data Source Before You Start Working on It Ordering the Source Worksheet Create a Code: The Best Way to Organize Your Data and Work Efficiently with It Learn How to Create a Database Using Lookup Functions (Vlookup) to Fill the Database Sheet Use Sumif to Complete the Database Sheet Using Index & Match as a Substitute for Vlookup The Mapping Exercise Mapping the Rows in the Database Sheet Building the Structure of the P&L Sheet A Practical Example of Professional Formatting in Excel Populate the P&L Sheet with Sumif Learn How to Find Mistakes with Countif Calculating Growth Rates in Excel - Introduction to Excel Charts7 Lessons 15 Min
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 - Building Professional Charts in Excel4 Lessons 22 Min
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 you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.
Stacked Column Chart with a Secondary Axis Doughnut Chart Area Chart Bridge Chart
“The ability to work effectively and efficiently with a spreadsheet software is one of the most valuable skills you can acquire at the beginning of your career. Excel is a must for anyone who wants to work with data and share their work with colleagues.”
Ned Krastev
CEO at 365 Data Science
Introduction to Excel
with Ned Krastev