Learn Excel in 3 Hours Flat
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.
127 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Excel in 3 Hours Flat to your Wishlist.

Add to Wishlist

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.
127 students enrolled
Last updated 9/2014
English
Price: $60
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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.
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
Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 02:20:33
+
Introduction
1 Lecture 00:00

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!

How can I Learn Excel in 3 Hours Flat?
1 page
+
Entering Data
2 Lectures 11:37

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.

Preview 04:16

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!

Preview 07:21
+
Performing Calculations
2 Lectures 32:08

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!

Formulas and Functions
19:14

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.

Absolute Cell References
12:54
+
Formatting: Making It Look Good!
2 Lectures 28:55

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!

Cell and Text Formatting
20:25

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!

Conditional Formatting
08:30
+
Charts
2 Lectures 27:36

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.

Sparklines
07: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.

Charts
20:18
+
Data Analysis
3 Lectures 26:15

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!

Data Tables
10:34

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!

Pivot Tables
11:12

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.

Tracing Dependencies
04:29
+
Printing
1 Lecture 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.

Printing Your Handiwork
13:02
About the Instructor
Alicia Katz Pollock
4.4 Average rating
80 Reviews
365 Students
9 Courses
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