Excel 2010 Productivity
4.9 (14 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.
145 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 Productivity to your Wishlist.

Add to Wishlist

Excel 2010 Productivity

Learn the foundations of productivity in this engaging Excel 2010 video course from a 20-year Excel power user.
4.9 (14 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.
145 students enrolled
Created by Andy Lanning
Last updated 5/2013
English
English
Current price: $10 Original price: $95 Discount: 89% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
The goal of this course is to make the student a confident and proficient user of Excel 2010. You will learn the basic foundations and how to take control of spreadsheets rather than feel "at the mercy" of them.
View Curriculum
Requirements
  • Students will need access to a computer to watch the videos, and a printer to print the handouts. Excel 2010 (preferred) or 2007 will work for the lessons. This course does not apply to Excel 2003.
Description

 Here is the current situation I see in the 2013 job market:

  1. You must know how to operate basic office software in order to find and hold a job.
  2. Finding a class is difficult, expensive, and usually doesn't fit your schedule.
  3. Employers want at least a proficient understanding of Excel and Outlook.

This course will give you the proficiency training needed for job qualifications and confidence. The videos and matching handouts will guide you along the way as you learn Excel 2010 in a build-upon-foundations format.

There are 10 videos per session, currently 4 sessions. Total session time is approximately 1 1/2 hours of training.  The course is structured so that you can choose which section is most important for your situation.  I recommend you start at 1 and continue through sequentially. But, depending on your current job, you may need to jump right into Charting - Course 2. (Come back to 1, though, get your solid foundation in place.)

Who is the target audience?
  • This course assumes no previous knowlege of Excel 2010, and is also helpful for anyone who is "self-taught" but still struggling with spreadsheets.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 46 Lectures Collapse All 46 Lectures 05:45:13
+
First 3 Videos Free
3 Lectures 22:11
Become familiar with the Excel screen layout as a vital first step to understanding Excel. There are alot of tools at your fingertips.
Preview 06:38

The Name Box is a true "Productivity" tool. Learn this feature early and you will have faster success with spreadsheets.
Preview 08:03

Screen Layout was a lesson in the constant on-screen tools. This lesson is about the tools that appear "only when needed" and you need to know about them.
Preview 07:30
+
Excel 2010 Must-Know Features
10 Lectures 01:10:50
The basis of all software programs are these 4 Computer Super Secrets. Learn them, use them, become a better computer user.
Computer Super Secrets
07:05

Cut, Copy, Paste is the essence of using any software program. This lesson teaches the long and short way of getting the job done.
Cut Copy Paste... productively
07:34

The Ctrl Key, with other keyboard strokes, gives the zip-zam-zoom effect to moving through a spreadsheet.
Power of the Ctrl Key
05:01

The Quick Access Bar is a re-make of the old and beloved "Standard Toolbar". Learn how to rebuild it to bring your favorite tools back.
Quick Access Bar, Customize
10:15

Getting "to" your files quickly is just as productive as using them afterwards. Learn great tips about "File" in this lesson.
File Ribbon - Recent
05:23

Learn the features on the File Ribbon to effectively Find, Recover, Save, and Print your files.
File Ribbon - Info, New, Print, Save
09:15

Super Secret #4 to computers is "File, Options". In this lesson you will learn how to customize some Excel features.
File - Options
07:52

The Status Bar sits at the bottom of the screen usually unnoticed. But not so fast... this is another useful tool on the screen.
Status Bar, Customize
05:07

Moving a Column or Row is explained and is surprisingly easy to do.
Manage Columns and Rows
08:18

Believe it or not, there is a technique for finding help in Excel. Learn it in this lesson.
How to Find HELP
05:00
+
Excel 2010 Charts
10 Lectures 01:29:50
Yes, a chart in 2 Steps. Amazing trick that makes you feel like a pro.
The Two-Step Chart
07:12

Create a chart using the "Insert" Ribbon.
Charts via Insert Ribbon
11:13

With charting come many new tools to learn. This lesson covers the Chart Design Ribbon.
The Chart Design Ribbon
10:13

This lesson covers the Chart Layout Ribbon and you also learn the "Super Secret" to Charts.
Layout Ribbon and Super Secret of Charts
08:43

Adding picture elements to your chart keeps your audience's attention.
Pictures, Shapes, Text Boxes
09:40

Add depth and interest to your chart with Background Pictures and Colors.
Background Colors and Pictures
08:32

Label your chart properly to help your audience figure out what you're showing them.
Data Labels and Gridlines
08:31

Axes are the side and bottom scales on a chart. Learn how to control them in this lesson.
Axes and Trendlines
06:42

This amazing tool is new to Excel 2010. Put a mini-chart in a cell next to your data. I Love it!
Format and Sparklines
09:29

Pie charts show portions of a whole. You will learn how to make those portions most effective in this lesson.
Pie Charts
09:35
+
Excel 2010 Formatting
10 Lectures 01:12:58
Effectively Formatting Borders will guide the end user's eyes easily to your results.
Borders
07:17

Formatting is at your fingertips with the new MiniBar feature. Also learn about Ribbon Groups and Currency format.
Mini Bar, Ribbon Groups, Currency
04:34

Banded rows ROCK and are basically alternating colored rows or columns. A little tricky, but worth the effort.
Banded Rows, Format Painter
07:00

This lesson is beyond just picking a font; it's about adjusting their formats.
Fonts
11:20

Centering titles, aligning data in a cell, and getting your numbers to look straight. All of this is a very necessary lesson.
Allignment Group
07:22

Sometimes just adding a color automatically makes the whole spreadsheet worthwhile. Learn to format based on a condition in this lesson.
Conditional Formatting
07:35

Adjusting Margins and working with multiple pages can be overwhelming. This lesson covers the tools to do this efficiently.
Page Layout
07:23

Headers and Footers allow you to place info or pictures into the Margin area of the paper.
Headers and Footers
07:17

Ever have just one column print on a second page? Learn how to solve that issue with Scale to Fit.
Scale to Fit
04:30

Get a grip on your passwords! (And design a form to keep track of them.)
Design a Password Form
08:40
+
Excel 2010 Formulas
12 Lectures 01:27:43
It's time to customize the Quick Access Bar to work with Formulas. This lesson guides you to which buttons you need to add.
Quick Access buttons for Formulas
05:40

This lesson shows you how to use the buttons you just added in the last lesson. Cool info.
How to Use the Quick Access buttons for Formulas
10:35

Just watch this video. Skip everything else and watch this video. Amazing formula super secret that I learned far too late. (Better late than never!)

AutoSum & Formulas Super Secret
10:03

This lesson is why we use Excel... to do math functions! Learn the codes you need to accomplish basic math.
Basic Math Formulas
07:36

Download Working Files here (applies to lectures 39-45)
00:11

There are formulas to change Text. (Believe it.) Don't re-type text ever again. Just learn these formulas.
Text Formulas
08:07

One of the most common problems with data is duplicate records.  This feature removes duplicates in less than 10 seconds.
Remove Duplicates
05:05

Another common problem with data is how to get certain text out of a cell and into another without re-typing it. This video teaches you how.
Split Text
07:30

The previous video showed how to separate text. This video shows how to put it back together. It's a formula worth tucking in your cap.
Combine Text
08:50

These extra formulas have become my "old standby's". They are basic and very useful.
More Formulas and Tips
07:05

The SumIF formula may be a little beyond basic, but it is a vital tool for ensuring correct calculations no matter how your data sorts above it.

SumIf Formulas
11:35

I once showed the SubTotal feature to a receptionist, who had just spent 3 hours on a project, how to accomplish the same thing in less than 10 seconds. She promptly took a walk outside to get some air. (Smile)
SubTotals
05:26
+
Conclusion
1 Lecture 01:35
A final thought about your Excel progress and what to do next...
Thanks and What to do Next...
01:35
About the Instructor
Andy Lanning
4.5 Average rating
541 Reviews
9,147 Students
5 Courses
Instructor

Andy Lanning, Owner/Trainer
Computer Software Training, LLC

Andy is a self-taught computer “nerd” and has been training individuals and groups since 1996.  She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ years experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.

Be prepared to learn more than you bargained for in her class. Andy always teaches the 4 Super Secrets to computers and believes firmly in efficiency training.

“My goal is to lower frustration and raise productivity.
And maybe have some laughs along the way!”

Software specialty areas include:
· Microsoft Office: Word, Excel, Outlook, PowerPoint, Publisher
· Office Processes: mail merges, forms, databases, data analysis
· Internet and E-mail
· Computer Basics