Microsoft Excel Beginner & Intermediate Training w/ Projects

A Beginners and Intermediate Guide to Using Microsoft Excel in the Real World
4.5 (80 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5,563 students enrolled
$19
$145
87% off
Take This Course
  • Lectures 96
  • Length 8.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

Course Highlights:

  • 80+ Individual, Bite-Sized Lessons
  • 9 Real-World Mini-Projects
  • Course PDF & Road Map
  • Verifiable Certificate of Completion
  • Downloadable Excel Files & Corresponding Project Files
  • Instant Access to Instructor and the ProductivityMe Community
  • Regular Course Updates and Bonus Materials Provided

A Bit More Information:

Hi there,

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:

  1. Getting Started with Excel 2013
  2. Entering Data
  3. Formulas and Functions
  4. Formatting & Presenting Data
  5. Database Features
  6. Using Tables
  7. Charts & Graphs
  8. Modifying & Adjusting Data
  9. Using Special View Features within Workbooks
  10. Managing Worksheets within a Workbook

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.

So...

If you have questions, comments, ideas, we’d love to hear from you.

Email or message us any time.

ONE LAST THING:

We want EVERYONE who is interested in taking this course be able to enroll, regardless of his or her finances. If you have limited means and feel as though you can’t afford $25 for this course, please send us a message explaining your situation. We will give you a coupon, and allow you to enroll in the course at no cost. We’ve allowed several students the ability to take our course at no cost, and of course, this is a trust based thing, so you know, don’t abuse it. We ask you to keep it honest so that we can continue creating awesome courses, and the whole community can continue to benefit.

Ready to enroll? ALRIGHT, what are you waiting for? See you in class!

Cheers,


Tolan & Ryan
ProductivityMe Co-Founders Udemy Instructors & All-Around Good Guys

What are the requirements?

  • No previous knowledge of Excel or spreadsheets is required

What am I going to get from this course?

  • Create, modify, and delete worksheets
  • Create, manage, and format complex Excel workbooks
  • Understand and employ special views and features within Microsoft Excel worksheets
  • Enter, edit, organize, and manipulate data
  • Use common formulas and functions
  • Create charts, tables, filters, and other useful tools in Excel
  • Sort, dissect, remove, re-aggregate sets and subsets of data
  • Create compelling visual presentations of your data
  • Create own unique problem sets to practice with
  • Use Microsoft Excel to solve real-world problems
  • Understand possible next steps to continue building own skills in Microsoft Excel

What is the target audience?

  • Excel 2010, 2013, or 2016 (Windows)
  • Beginner and intermediate users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started with Excel 2013
Introduction
Preview
02:16
DOWNLOAD: Course PDF
7 pages
DOWNLOAD: Course Excel Files & Individual Project Files
Preview
07:25
01.01 - What is Excel?
Preview
02:19
01.02 - Using Excels Menu System
08:57
01.03 - Using the Quick Access Toolbar
06:49
01.04 - The Structure of a Worksheet or Workbook
04:19
01.05 - Using the Formula Bar
02:30
01.06 - Using the Status Bar
06:00
01.07 - Navigating Worksheets & Workbooks
06:18
01.08 - Shortcut Menus and the Mini Toolbar
03:41
01.09 - Using Excel's Built-in Help Function
04:31
01.10 - Creating New File; Saving That File
05:14
01.11 - Opening Existing File; Using Save As
06:24
Section 2: Entering Data
02.01 - Entering Data
05:33
02.02 - Editing Data
03:33
02.03 - Undo & Redo
04:19
02.04 - Navigating within a Worksheet
05:55
02.05 - Making Desired Selection
06:34
02.06 - Using the Fill Handle
06:23
02.07 - Autocomplete & AutoFill
07:26
PROJECT TWO: Creating a Simple Income Statement and Attendance Sheet
14:47
Section 3: Formulas and Functions
03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel.
07:55
03.02 - Replicating Formula from a Near-by Cell
04:45
03.03 - Applying Varying Formulas Based on Cell's Context
02:55
03.04 - Quickly Remembering Order of Operations in with a Function
05:26
03.05 - Using Relative, Absolute, and Mixed References
09:56
03.06 - Exploring Basic Excel Functions - SUM
04:18
03.07 - Exploring Basic Excel Functions - PRODUCT
04:49
03.08 - Exploring Basic Excel Functions - AVERAGE
02:38
03.09 - Exploring Basic Excel Functions - MIN & MAX
04:01
03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK
05:04
PROJECT THREE: Creating a Gradebook
16:33
Section 4: Formatting & Presenting Data
04.01 - Inserting and Deleting Columns & Rows
03:01
04.02 - Hiding and Unhiding Columns & Rows
05:09
04.03 - Adding, Modifying, and Removing Cell Borders
05:13
04.04 - Applying Different Number Formats
05:23
04.05 - Adjusting the Number of Decimals Displayed
04:36
04.06 - Changing the Widths and Heights of Columns & Rows
04:32
04.07 - Wrapping Text
03:18
04.08 - Merging Contents from Multiple Cells
04:07
04.09 - Modifying Cell Font
03:59
04.10 - Using Cell Alignment
04:06
04.11 - Using Cell Alignment
02:59
04.12 - Using Cell Orientation
03:28
04.13 - Using the Format Painter
05:34
04.14 - Using Paste Special for Formatting
03:35
04.15 - Clearing Cell Formatting
03:23
04.16 - Clearing Cell Contents AND Formatting
03:41
04.17 - Inserting & Using Shapes
04:32
04.18 - Inserting Pictures & Other Visual Elements
04:12
PROJECT FOUR: Formatting Facebook Inc.’s Actual Income Statement
19:59
Section 5: Database Features
05.01 - Sorting Data
06:03
05.02 - Inserting Subtotals within Active Worksheet
06:28
05.03 - Filtering Data
07:47
05.04 - Data Tool: Text to Columns (Delimited)
05:40
05.05 - Data Tool: Text to Columns (Fixed Width)
04:33
05.06 - New to Excel 2013: Using Flash Fill
04:28
05.07 - Removing Duplicates from Selected Range
03:43
PROJECT FIVE: Sorting Data with an Employee Reference Sheet
12:35
Section 6: Using Tables
06.01 - Getting Started with Tables
02:43
06.02 - Inserting Tables & Understanding Contextual Tabs
03:01
06.03 - Modifying Table Formatting & Design
03:09
06.04 - Filtering a Table & Using the Search Functionality
03:55
06.05 - Adding Rows & Columns to a Table
04:07
06.06 - Converting a Table to a Range
03:30
PROJECT SIX: Using Tables to Store a Class Gradebook
11:05
Section 7: Charts & Graphs
07.01 - Getting Started with Charts
01:40
07.02 - Inserting Charts in Excel
04:07
07.03 - New to Excel 2013: Recommended Charts
04:56
07.04 - Understanding Chart Data & Chart Elements
04:47
07.05 - Modifying Chart Type
03:15
07.06 - Formatting the Data, Type, Location, and Elements of a Chart
05:55
07.07 - Modifying Chart Axis, Labels, Gridlines, Etc.
03:44
07.08 - Copying & Pasting Charts in Excel
03:23
07.09 - New to Excel 2013: Sparklines (In-Cell "Mini"Graphs)
05:39
PROJECT SEVEN: Graphing Sales Data from Apple Inc. Annual Report
11:22
Section 8: Modifying & Adjusting Data
08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Wor
02:39
08.02 - Cutting, Copying, and Pasting (in Same Worksheet)
02:43
08.03 - Dragging & Dropping Contents (between Multiple Worksheets)
03:10
08.04 - Cutting, Copying, and Pasting (between Multiple Worksheets)
02:36
08.05 - Using Paste Special for More than Formatting
05:41
08.06 - Finding & Replacing Cell Contents
05:34
08.07 - Using Spellcheck in Excel
04:20
PROJECT EIGHT: Using Data from Apple Inc. Net Sales by Operating Segment
10:27
Section 9: Using Special View Features within Workbooks
09.01 - Adding Comments to a Worksheet
03:29
09.02 - Freezing & Unfreezing Panes in Active Sheet
03:53
09.03 - Splitting Screens in Excel (Horizontally & Vertically)
03:59
09.04 - Displaying Multiple Worksheets or Workbooks
05:37
PROJECT NINE: Looking at Hiring Interns as a Manager at Facebook
07:12
Section 10: Section 10: Managing Worksheets within a Workbook

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

The ProductivityMe Company, Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

ProductivityMe

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

Tolan Thornton
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.

Ryan FitzPatrick
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!

Ready to start learning?
Take This Course