Learn Excel in 3 Hours Flat

The essential spreadsheet skills needed to succeed at work, from basics to charts to pivot tables.
4.8 (9 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.
126 students enrolled
$60
Take This Course
  • Lectures 13
  • Length 2.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 9/2014 English

Course Description

Crunching numbers in a spreadsheet is only daunting until you know what you’re doing. Our 3-hour class teaches you the essentials of not just beginning-level Excel, but some of the more advanced features that are essential to working with your numbers.

This class is perfect on-the-job training.

We will cover:

  1. Moving around in a spreadsheet
  2. Entering Data
  3. AutoFill Handle
  4. Formulas
  5. Functions
  6. Relative & Absolute Cell References
  7. Formatting
  8. Conditional Formatting
  9. Sparklines
  10. Charts
  11. Data Tables for filtering
  12. Pivot Tables
  13. Tracing Dependencies
  14. Printing tips

What are the requirements?

  • No prerequisite knowledge needed.
  • This course is recorded in Excel 2013 on a PC
  • The techniques work similarly in Excel 2007 and 2010 for PC. The screen appearance may look a little different, but the tools function the same way.
  • Excel for Mac users will find that all the same tools are there, but they may be located in slightly different places on the toolbar
  • It doesn't matter what version of the PC or Mac operating system you're using.
  • Practice files are included with the course so that you can follow along.

What am I going to get from this course?

  • By the end of this course, you will be able to create a spreadsheet from scratch, format it for at-a-glance understanding, and use advanced tools for data analysis.
  • Enter data
  • Create formulas and functions
  • Use Absolute Cell Formatting to copy formulas anywhere
  • Use AutoFill to replicate values and formulas
  • Format appearance for quick understanding
  • Create Charts of several types
  • Use Data Tables to manage lists
  • Use Pivot Tables to analyze data
  • Take control of your Printing

What is the target audience?

  • No previous knowledge or experience is necessary!
  • Effective, efficient on-the-job training for employees
  • Solid foundation for students in classes that use Excel
  • Perfect for beginners who want to start from scratch
  • Great for seasoned users looking to fill in gaps in their knowledge
  • Full of tips and tricks to shave time off your daily tasks
  • We specialize in what you "don't know that you don't know", so you're guaranteed to glean essential nuggets of information to make using Excel easier than before

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: Introduction
1 page

I'm Alicia Katz Pollock, and we're going to learn Excel in 3 Hours Flat. You didn't think that's possible? Well, it is, and here's how:

We're going to focus on the most essential topics that you'll use on the job every day.

Are you ready? Let's Learn Excel!

Section 2: Entering Data
04:16

A tour of the Excel program: from getting started, to understanding the tools you see in front of you.

We'll open new templates and recently-used documents, then introduce our terminology. Meet the Quick Access Toolbar, plus tabs and ribbons that contain all the commands. We'll explain cells, rows, columns, and worksheets.

07:21

We'll start from scratch to build a sample budget. We'll enter labels and values. And you'll learn your first wow-factor tool that you can't live without: the Autofill Handle!

Section 3: Performing Calculations
19:14

The best part of Excel is that you don't perform any math yourself, by hand. Excel does all the calculating for you, even if your numbers change. We'll start with the basics of entering formulas, then move into faster ways of creating them.

Functions use words and "arguments" to instruct Excel on what kinds of math to do. We'll explain what that means, and how to make functions work for you. You'll even see a few traps to avoid!

12:54

When you're creating formulas and functions, Excel lets you copy them so that you don't need to create each one by hand (that's called "Relative Cell References"). But that can cause problems when you need the formula to always point to one particular variable.

Absolute Cell References ensure that your formula always looks to the correct cell, even if you copy it somewhere else.

Section 4: Formatting: Making It Look Good!
20:25

If you hand someone a spreadsheet, they'll have to spend some time figuring out what they're looking at. When a spreadsheet is formatting well, it helps the reader understand at a glance.

It can also be time-consuming to type in all your dollar signs, commas, and decimals. There's no need!

Use text and cell formatting to make your text stand out. Format your numbers as decimals, currency, percentages, and more. Call attention to key information by changing its size and color. Resize your columns to best fit the contents. Draw borders around cells.

A well-formatted spreadsheet communicates your message!

08:30

When you're looking at a spreadsheet, it's helpful to analyze your numbers at a glance, instead of having to look at every single total and compare it in your mind. Conditional Formatting allows you to colorize your values to call out high, low, and average values...or cells that meet a specific criteria.

The best part is that as your numbers change, the formatting does, too!

Section 5: Charts
07:18

Sparklines are tiny little one-cell charts that allow you to visualize trends right next to your data. They're a great way to add pizazz and usable information in a small space.

20:18

Charts allow you to visualize your data so you can analyze at a glance. They're pretty, and powerful. Using Column and Pie charts as the examples, we'll learn to change the color scheme, style, and content on the fly.

Section 6: Data Analysis
10:34

Data Tables are Excel's best-kept secret. By nature, people tend to store lists of data in Excel because it's organized into rows and columns. But if you've ever tried to sort your list and accidentally broken the data, you know this is kind of like using a hammer when you need a screwdriver!

The secret is to turn your list into a Data Table that allows you to sort your data to your heart's content. It also allows you to filter your data to just look at specific records. We'll even show you how to format the entire table in just one click!

11:12

For some reason, people seem to be scared of Pivot Tables, but there's no reason to be. They're actually fun!

Pivot Tables allow you to group your data lists so that you can pull out meaningful information and statistics. Break down and summarize your numbers into totals, averages, and counts.

Then, we'll just give them a little twist and look at your data in a whole new way!

04:29

Have you ever looked at a total in your spreadsheet and wondered where the heck it came from? Excel allows you to view your spreadsheet behind-the-scenes, to see the formulas and functions behind the figures. We'll show you how to trace the calculations back to the source to uncover errors.

Section 7: Printing
13:02

A lot of the time, your spreadsheets print with just a couple rows or columns bleeding over onto the next page. We'll show you how to fit everything on one page!

We'll also explore headers and footers, complete with page numbers, automatic dates, and file paths so you know where to find the file on your computer in the future.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Alicia Katz Pollock, QuickBooks ProAdvisor with a Masters Degree in Teaching

Over 30 years ago, when she was 13, Alicia Katz Pollock received her first computer, an Apple IIc. She immediately designed a database for her father’s dental practice to automatically send postcards to his patients every 6 months to come in for a checkup and cleaning. Her passion for computers grew as she did.

A natural teacher, Alicia earned her Master of Arts in Teaching, but instead of turning to the public schools, she developed computer curricula.

She blends the skills of technology, the art of communication, the patience of a trainer, the wisdom of a business consultant, and the detailed eye of an obsessive-compulsive to bring you the finest in business solutions.

Alicia’s certifications include:

  • QuickBooks Certified User
  • Intuit ProAdvisor
  • Microsoft Certified Trainer
  • Apple Consultants Network
  • Apple Certified Support Professional, 10.5
  • Apple Certified Support Professional, 10.7
  • Apple Certified Support Professional, 10.10
  • Microsoft Certified Application Specialist in Word, Excel, Access, PowerPoint, and Outlook
  • Microsoft Office Specialist, Master Level


    Ready to start learning?
    Take This Course