Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
A Bit More Information:
And welcome to our course page!
You must be interested in Microsoft Excel, or learning it. YAY! Ryan and I are super excited to have you here, we’re honored that you’ve taken a minute out of your day to read this far.
Microsoft Excel is an amazing application. You can do fun and important things with Excel. Whether you’re working in finance, consulting, non-profits, or even still in school, Microsoft Excel is the industry standard for organizing, analyzing, manipulating, and storing data in tabular form.
Why Learn Excel?
Microsoft Excel is the world’s most popular spreadsheet program. Learning it can be frustrating (or at least it was for me).
Maybe you have a small business, and you need to learn Excel for tracking your sales. Maybe you want to work at a startup, boutique marketing firm, or investment bank... Maybe you're a recent graduate apply for an analyst job at a Fortune 500,,,, Or maybe you're like me and you want to be able to do more in less time, perhaps get a raise or job promotion.
Knowing how to use Excel to solve real-world problems can be an awesome tool to help differentiate you from the competition!
In this Course:
Learning Excel takes time, particularly if you try to do it without any structure!
In this course, we'll talk you through the basics from how to create a spreadsheet, to how to sort and filter your data in tables, even create charts and use awesome tools like Sparklines and Flash Fill!
In this training course, we’ve broken down Microsoft Excel into ten main sections:
About our approach:
We want you to succeed! Ryan and I have worked hard to create awesome and amazing content, but, perhaps more importantly, to create and cultivate a vibrant community around sharing and improving that content (i.e., content on how to best learn Microsoft Excel).
Maybe you like doing things on your own. Watch a video, and then go off and tinker with your own workbooks. Maybe you like following along. Open up your spreadsheet, and move through each lesson step-by-step with us. Maybe you just want to learn about the sorting feature within Tables, well then jump right to lecture 64! There’s no right way to learn Excel, well, except for well, actually starting…
In each section, we walk you through the core components of the skills and techniques that you need to use Microsoft Excel in the real-world.
Each lesson will cover one single topic, delivered in a short bite-sized video.
At the end of each section we’ll do a small project, in which you can apply the core skills that you’ve learned in the section.
We've made it easy to follow along with the course, by providing a course PDF, and for those of you interested- feel free to download the course Exercise and Project files.
If you have questions, comments, ideas, we’d love to hear from you.
Email or message us any time.
Tolan & Ryan
ProductivityMe Co-Founders Udemy Instructors & All-Around Good Guys
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started with Excel 2013|
DOWNLOAD: Course PDF
DOWNLOAD: Course Excel Files & Individual Project FilesPreview
01.01 - What is Excel?Preview
01.02 - Using Excels Menu System
01.03 - Using the Quick Access Toolbar
01.04 - The Structure of a Worksheet or Workbook
01.05 - Using the Formula Bar
01.06 - Using the Status Bar
01.07 - Navigating Worksheets & Workbooks
01.08 - Shortcut Menus and the Mini Toolbar
01.09 - Using Excel's Built-in Help Function
01.10 - Creating New File; Saving That File
01.11 - Opening Existing File; Using Save As
|Section 2: Entering Data|
02.01 - Entering Data
02.02 - Editing Data
02.03 - Undo & Redo
02.04 - Navigating within a Worksheet
02.05 - Making Desired Selection
02.06 - Using the Fill Handle
02.07 - Autocomplete & AutoFill
PROJECT TWO: Creating a Simple Income Statement and Attendance Sheet
|Section 3: Formulas and Functions|
03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel.
03.02 - Replicating Formula from a Near-by Cell
03.03 - Applying Varying Formulas Based on Cell's Context
03.04 - Quickly Remembering Order of Operations in with a Function
03.05 - Using Relative, Absolute, and Mixed References
03.06 - Exploring Basic Excel Functions - SUM
03.07 - Exploring Basic Excel Functions - PRODUCT
03.08 - Exploring Basic Excel Functions - AVERAGE
03.09 - Exploring Basic Excel Functions - MIN & MAX
03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK
PROJECT THREE: Creating a Gradebook
|Section 4: Formatting & Presenting Data|
04.01 - Inserting and Deleting Columns & Rows
04.02 - Hiding and Unhiding Columns & Rows
04.03 - Adding, Modifying, and Removing Cell Borders
04.04 - Applying Different Number Formats
04.05 - Adjusting the Number of Decimals Displayed
04.06 - Changing the Widths and Heights of Columns & Rows
04.07 - Wrapping Text
04.08 - Merging Contents from Multiple Cells
04.09 - Modifying Cell Font
04.10 - Using Cell Alignment
04.11 - Using Cell Alignment
04.12 - Using Cell Orientation
04.13 - Using the Format Painter
04.14 - Using Paste Special for Formatting
04.15 - Clearing Cell Formatting
04.16 - Clearing Cell Contents AND Formatting
04.17 - Inserting & Using Shapes
04.18 - Inserting Pictures & Other Visual Elements
PROJECT FOUR: Formatting Facebook Inc.’s Actual Income Statement
|Section 5: Database Features|
05.01 - Sorting Data
05.02 - Inserting Subtotals within Active Worksheet
05.03 - Filtering Data
05.04 - Data Tool: Text to Columns (Delimited)
05.05 - Data Tool: Text to Columns (Fixed Width)
05.06 - New to Excel 2013: Using Flash Fill
05.07 - Removing Duplicates from Selected Range
PROJECT FIVE: Sorting Data with an Employee Reference Sheet
|Section 6: Using Tables|
06.01 - Getting Started with Tables
06.02 - Inserting Tables & Understanding Contextual Tabs
06.03 - Modifying Table Formatting & Design
06.04 - Filtering a Table & Using the Search Functionality
06.05 - Adding Rows & Columns to a Table
06.06 - Converting a Table to a Range
PROJECT SIX: Using Tables to Store a Class Gradebook
|Section 7: Charts & Graphs|
07.01 - Getting Started with Charts
07.02 - Inserting Charts in Excel
07.03 - New to Excel 2013: Recommended Charts
07.04 - Understanding Chart Data & Chart Elements
07.05 - Modifying Chart Type
07.06 - Formatting the Data, Type, Location, and Elements of a Chart
07.07 - Modifying Chart Axis, Labels, Gridlines, Etc.
07.08 - Copying & Pasting Charts in Excel
07.09 - New to Excel 2013: Sparklines (In-Cell "Mini"Graphs)
PROJECT SEVEN: Graphing Sales Data from Apple Inc. Annual Report
|Section 8: Modifying & Adjusting Data|
08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Wor
08.02 - Cutting, Copying, and Pasting (in Same Worksheet)
08.03 - Dragging & Dropping Contents (between Multiple Worksheets)
08.04 - Cutting, Copying, and Pasting (between Multiple Worksheets)
08.05 - Using Paste Special for More than Formatting
08.06 - Finding & Replacing Cell Contents
08.07 - Using Spellcheck in Excel
PROJECT EIGHT: Using Data from Apple Inc. Net Sales by Operating Segment
|Section 9: Using Special View Features within Workbooks|
09.01 - Adding Comments to a Worksheet
09.02 - Freezing & Unfreezing Panes in Active Sheet
09.03 - Splitting Screens in Excel (Horizontally & Vertically)
09.04 - Displaying Multiple Worksheets or Workbooks
PROJECT NINE: Looking at Hiring Interns as a Manager at Facebook
|Section 10: Section 10: Managing Worksheets within a Workbook|
Try. Learn. Conquer. Excel.
We create short, engaging videos that help people Master Excel.
We offer simple and easy-to-follow courses, and like our thousands of students, we’re always excited to learn cool new things.
This is ProductivityMe.
Udemy Course Instructors
ProductivityMe Co-founder & Lead Udemy Instructor
Tolan went to the University of Arizona. He graduated summa cuma laude in the top 1% of his class with a Bachelor’s of Science Administration in Finance & Entrepreneurship and a Bachelor’s of Arts in French & East Asian Studies.
Tolan has worked at a top-tier economic consulting firm, specializing in Energy Deals and Financial Litigation.
Fun Facts about Tolan:
Tolan is the oldest of 3 children. He loves to travel.
Tolan has lived in Paris, New York, London, Beijing, Hangzhou, and Casablanca.
Odd fact? Tolan’s left leg is 5mm shorter than his right.
If Tolan had a year off, he’d learn a fourth language- maybe Portuguese, Spanish, or Hindi.
ProductivityMe Co-founder & Udemy Instructor
Ryan graduated summa cuma laude in the top 3% of his class with a Bachelor’s of Science Administration in Management Information Systems & Entrepreneurship.
Ryan has worked in non-profits as well as in Enterprise Management Software. He has worked as a consultant, as a tutor, even a bit in retail!
Fun Facts about Ryan:
Ryan is the younger of 2 children. Though he travels a lot for work, Ryan thinks of Tucson as home.
Ryan loves to write. Short-stories and essays are mostly his passion, but Ryan has even started screenplays, just for kicks!
If Ryan had a year off, he’d probably learn to code. That or start (another) company. Who knows, maybe he’d even do both!