Excel 2010 Essentials

Learn the skills every Excel user needs to know no matter how new or how experienced you may be!
3.8 (4 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.
136 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 53
  • Length 7 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 6/2013 English

Course Description

 This series is for anyone who wants to learn Microsoft Excel 2010 in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be! 

This training includes the program-specific features that are mapped to the Microsoft Office Specialist (MOS) certification exam for the corresponding product.


MOS certification validates proficiency for individuals who PASS the certification exam, and demonstrates that they possess entry-level communications skills using the corresponding Adobe software.

Running Time
7.2 Hours

Presenter
Erin Olsen

Course Outline

Chapter 1: GETTING COMFORTABLE WITH EXCEL (51 min)

  1. Introducing Excel
  2. Recognizing Interface Features Unique to Excel
  3. Understanding Workbook Structure
  4. Navigating through Workbooks
  5. Making Workbook Selections

Chapter 2: THE BASICS OF DATA (41 min)

  1. Entering Text
  2. Entering Dates & Numbers
  3. Editing Cell Entries
  4. Copying & Moving Data
  5. Filling a Series

Chapter 3: MANAGING WORKBOOK STRUCTURE (28 min)

  1. Modifying Workbook & Worksheet Structure
  2. Resizing Worksheet Elements
  3. Hiding Workbook Components

Chapter 4: CREATING FORMULAS (33 min)

  1. Excel Calculations 101
  2. Entering Formulas
  3. Enforcing Absolute Referencing
  4. Controlling Calculation Options

Chapter 5: THE BASICS OF FUNCTIONS (26 min)

  1. The Foundation of Functions
  2. Using AutoSum & the Formulas Tab
  3. Using Function AutoComplete

Chapter 6: WHAT'S IN A NAME? (43 min)

  1. Creating Named Cells
  2. Dening Names
  3. Creating Names from Selections
  4. Creating Named Formulas
  5. Using Names as References
  6. Managing & Displaying Names

Chapter 7: MAKING DATA LOOK GOOD (74 min)

  1. Applying Basic Formatting
  2. Formatting Numbers
  3. Exploring the Format Cells Dialog Box
  4. Dening Custom Formats
  5. Creating & Applying Cell Styles
  6. Conditional Formatting
  7. Applying & Editing Conditional Formatting Rules

Chapter 8 A PICTURE IS WORTH A THOUSAND WORDS (38 min)

  1. Getting In-Cell Summaries with Sparklines
  2. Creating Charts
  3. Modifying Chart Design
  4. Working with Chart Layout & Format
  5. Saving & Using a Chart Template

Chapter 9 THE SIMPLICITY OF TABLES (54 min)

  1. Converting Data Ranges to Tables
  2. Modifying Table Formatting
  3. Working with Table Records
  4. Using Table Calculations
  5. Sorting Data
  6. Creating Custom Lists
  7. Filtering Data

Chapter 10 MANAGING THE EXCEL ENVIRONMENT (20 min)

  1. Conguring Excel Options
  2. Adjusting the View
  3. Controlling Excel Windows
Chapter 11 PREPARING FILES FOR DISTRIBUTION (23 min)
  1. Print Area, Print Titles & Sheet Options
  2. Renaming Sheets & Adding Headers/Footers
  3. Printing Worksheets

What are the requirements?

  • A working copy of the software is suggested so you can work along with the presenter.

What am I going to get from this course?

  • By the time you have finished this course you will be confident and knowledgable using Microsoft Excel 2010.
  • This training includes the program-specific features that are mapped to the Microsoft Office Specialist (MOS) certification exam for the corresponding product.

What is the target audience?

  • This course is for anyone who wants to learn Excel from scratch, upgrade from a previous version of Excel, take their Excel skills to a new level or is preparing to take their MOS exam.

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 Comfortable with Excel
Introducing Excel
Preview
12:26
Recognizing Interface Features Unique to Excel
Preview
05:17
Understanding Workbook Structure
10:29
Navigating through Workbooks
10:22
Making Workbook Selections
12:18
5 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 2: The Basics of Data
Entering Text
Preview
09:46
Entering Dates & Numbers
08:12
Editing Cell Entries
07:01
Copying & Moving Data
07:29
Filling a Series
08:51
7 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 3: Managing Workbook Structure
Modifying Workbook & Worksheet Structure
Preview
14:10
Resizing Worksheet Elements
05:58
Hiding Workbook Components
07:25
5 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 4: Creating Formulas
Excel Calculations 101
Preview
07:27
Entering Formulas
07:25
Enforcing Absolute Referencing
11:33
Controlling Calculation Options
07:02
7 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 5: The Basics of Functions
The Foundation of Functions
Preview
06:10
Using AutoSum & the Formulas Tab
09:32
Using Function AutoComplete
10:02
3 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 6: What's in a Name?
Creating Named Cells
Preview
07:47
Defining Names
05:55
Creating Names from Selections
05:06
Creating Named Formulas
05:21
Using Names as References
08:37
Managing & Displaying Names
10:06
6 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 7: Making Data Look Good
Applying Basic Formatting
Preview
14:20
Formatting Numbers
08:40
Exploring the Format Cells Dialog Box
13:44
Defining Custom Formats
12:22
Creating & Applying Cell Styles
07:16
Conditional Formatting
06:40
Applying & Editing Conditional Formatting Rules
10:55
7 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 8: A Picture is Worth a Thousand Words
Getting In-Cell Summaries with Sparklines
Preview
11:03
Creating Charts
03:06
Modifying Chart Design
10:46
Working with Chart Layout & Format
07:57
Saving & Using a Chart Template
05:27
5 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 9: The Simplicity of Tables
Converting Data Ranges to Tables
Preview
06:16
Modifying Table Formatting
Preview
05:30
Working with Table Records
06:05
Using Table Calculations
06:39
Sorting Data
11:44
Creating Custom Lists
07:11
Filtering Data
10:10
7 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 10: Managing the Excel Environment
Configuring Excel Options
Preview
04:48
Adjusting the View
07:18
Controlling Excel Windows
07:47
3 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 11: Preparing Files for Distribution
Print Area, Print Titles & Sheet Options
Preview
08:04
Renaming Sheets & Adding Headers/Footers
08:28
Printing Worksheets
05:52
Credits
00:12
7 questions

Assessment questions provide an opportunity to review material covered in a lesson in order to ensure it is clearly understood. Sometimes in learning, when a person reads, sees or hears content, they believe they understand it and if asked about the information or skill they can repeat it. The human brain is tricky though and being able to repeat something does not necessarily mean it is understood much less that the information will be able to be integrated into the virtually limitless number of ways we may encounter a need for it in the real world. The result of effective learning is the ability to truly comprehend concepts and skills and then be able to apply that knowledge to any variety of situations when appropriate.

To assist in optimizing your learning experience, the assessment questions attempt to review the main objectives of a lesson by offering choices to get you to justify your responses through reasoned choices. They may be presented in a variety of ways including multiple choice, short answer, fill in the blank, true/false, ordering, labeling and matching questions. By completing the assessment questions, you will improve comprehension and retention so you have additional tools to assist you in addressing tasks in your work or personal life. 

Section 12: Supplementary Materials
Supplementary Materials
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Total Training, Video Training for creative & office productivity software

Total Training, founded in 1997, is a pioneer in innovative video training for leading creative print, web design, web development, digital video, audio music technology and office productivity software programs. Our award-winning training courses feature some of the best professionals in the industry. Learn by doing with our self-paced, in-depth video training.

Ready to start learning?
Take This Course