Introduction to Microsoft Excel 2010

Learn the basics of Microsoft Excel 2010 in this interactive course!
0.0 (0 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.
8 students enrolled
$50
Take This Course
  • Lectures 98
  • Length 4.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 5/2012 English

Course Description

Want to learn the basics of Microsoft Excel 2010? We have the course for you. Designed by Webucator, a global training partner, this course covers all of the best activities to get you started. And its packed with readings, trainer presentations, and exercises!

In this Introduction to Microsoft Excel 2010 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2010 worksheets.

Class Goals
  • Create basic worksheets using Microsoft Excel 2010.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.

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

Class Files
193.3 kB
Section 1: Creating a Microsoft Excel Workbook
Article
Starting Microsoft Excel To start Microsoft Excel (see screenshot below): Click the Start menu. Select All Programs. Select Microsoft Office. Select Microsoft Excel 2010. Creating a Workbook When you open Microsoft Excel, a workbook is automatically opened as well. As you can see in the screenshot b…
Article
The Status Bar The Status Bar, located at the bottom of Excel, shows basic information about your workbook and enables you to change your viewing settings. Specific items on the Status Bar include: Ready status .  Ready  indicates that you are ready to begin entering data.  Enter  indicates that you…
Article
Adding and Deleting Worksheets Depending on your settings, Excel workbooks typically open with one to three worksheets, named Sheet1, Sheet2, etc: To add additional worksheets, simply click on the Insert worksheet icon ( ). To delete a worksheet, simply right-click on the worksheet name and select D…
Article
Closing a Workbook The two most common ways to close a Microsoft Excel workbook are: 1.  Click one of the "X's" in the upper-right-hand corner: 2.  Select  Close  from the  File  menu: When you close your workbook, you will be prompted to save if you have made any changes since the last time you sav…
Starting Microsoft Excel
05:07
Article
Creating a Microsoft Excel Workbook Duration: 5 to 15 minutes. In this exercise, you will create, save and close a Microsoft Excel workbook. You will also name a worksheet. If you currently have Microsoft Excel open, please close it before starting the exercise. Create and save the following workboo…
Exercise Solution
02:13
Section 2: The Ribbon
Article
The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups and Commands. Tabs Microsoft Excel is a powerful program wh…
Article
Groups To further organize the many commands available in Microsoft Excel, commands are organized in  groups  on each tab. Each group contains three or more related commands. The following table lists the groups found on each tab: Tab Group Home Clipboard Font Alignment Number Styles Cells Editing I…
The Ribbon Review
04:32
Article
Exploring the Ribbon Duration: 10 to 20 minutes. In this exercise, you will explore the Ribbon to answer the following questions: How many tabs are there? How many groups are there on the View tab? Which tab contains the most commonly used groups and commands? What is another name for the File menu?…
Section 3: The Backstage View (The File Menu)
Article
Introduction to the Backstage View The Ribbon, covered in the prior lesson, is where you find all the commands necessary to make changes to your worksheets. Clicking on the tabs in the Ribbon changes the set of commands available to you while you work in your worksheet. After clicking on the File me…
Article
Opening a Workbook There are two ways to open a Microsoft Excel workbook from the Backstage view: 1.  Select  Open  from the  File  menu. In the dialog box that opens up, navigate to the file you want to open and double-click it or select it and click  Open . 2.  For files you have recently used, se…
Backstage View Review
02:46
Article
Open a Workbook Duration: 5 to 10 minutes. In this exercise, you will practice opening Microsoft Excel workbooks from the File menu. Using the File menu, open  My First Workbook.xlsx  from the  Excel2010A/Exercises  folder. Close  My First Workbook.xlsx . Open  My First Workbook.xlsx  from the File …
Exercise Solution
01:39
Article
New Workbooks and Excel Templates When creating a new Microsoft Excel workbook, you can choose between creating a  blank  workbook or creating your workbook from an existing template. Creating a New Blank Workbook To create a new blank workbook: 1.  From the  File  menu, select  New : 2.  Double-cli…
Excel Templates Review
03:05
Article
Select, Open and Save a Template Agenda Duration: 5 to 10 minutes. In this exercise, you will create a new workbook using a Microsoft template. Locate an Office.com template to use to create an agenda for a meeting. Download the template. Save the workbook as  My Agenda.xlsx  in your  Webucator/Exce…
Exercise Solution
02:14
Article
Printing Worksheets The Print window gives you access to several printing and page layout options. You will also see a preview of how your worksheet will print. To print a Microsoft Excel worksheet: 1.  From the  File  menu, select  Print . 2.  Choose your print options (number of copies, printer, e…
Article
Print a Worksheet Duration: 5 to 10 minutes. In this exercise, you will print the agenda you created in the last exercise. You will need to have a printer connected to successfully complete this exercise. Using the File menu, print the agenda you created in the last exercise. Solution: File > Print…
Exercise Solution
01:24
Article
Getting Help Searching for help in Microsoft Excel is very similar to searching for information in a browser. To access  Help  in Microsoft Excel: 1.  From the  File  menu, select  Help . 2.  Click  Microsoft Office Help . 3.  Search for help by entering keywords into the search box.
Getting Help Review
01:45
Article
Using Help Duration: 5 to 15 minutes. In this exercise, you will use features of Help to learn how to insert a row into a worksheet. Use Help to figure out how to insert a row into a worksheet. Solution: To get help on inserting rows into a worksheet: File > Help > Microsoft Office Help Search on "I…
Exercise Solution
00:57
Article
Adding Your Name to Microsoft Excel You can personalize your copy of Microsoft Excel by adding your name. When you do so, the information is used throughout the Microsoft Office products. Excel uses this information for tracking changes and assigning comments and for prefilling data used by some of…
Adding Your Name Review
01:24
Section 4: The Quick Access Toolbar
Article
The  Quick Access Toolbar  is a small toolbar which includes commonly used commands and is always accessible. By default, the  Quick Access Toolbar  is located in the top left corner of Microsoft Excel. By default, the  Quick Access Toolbar  includes three commands: Save. Click Save to save your wor…
Article
Adding Common Commands To add commonly used commands to the Quick Access Toolbar:1.  Click the dropdown arrow on the far right of the  Quick Access Toolbar . 2.  Select a command from the list that appears:
Article
Adding Additional Commands with the Customize Dialog Box To add additional commands to the Quick Access Toolbar:1.  Click the dropdown arrow on the far right of the  Quick Access Toolbar . 2.  Select  More Commands...  towards the bottom of the list that appears: 3.  Select a command from the list c…
Article
Adding Ribbon Commands or Groups If you find yourself using the same commands or group of commands frequently, you can quickly add them to the Quick Access Toolbar: Right click on the command or on the group name. Select Add to Quick Access Toolbar:
Article
Placement You can choose to keep the Quick Access Toolbar in the top left corner of Microsoft Excel or move it below the Ribbon. To move the Quick Access Toolbar below the Ribbon: 1.  Click the dropdown arrow on the far right of the  Quick Access Toolbar . 2.  Select  Show Below the Ribbon . 3.  To…
Quick Access Toolbar Review
03:28
Article
Customize the Quick Access Toolbar Duration: 10 to 20 minutes. In this exercise, you will customize the Quick Access Toolbar. Add the following commands to the Quick Access Toolbar: New Open Quick Print Paste Find Remove Find from the Quick Access Toolbar. Move the Quick Access Toolbar below the Rib…
Exercise Solution
02:58
Section 5: Entering Data in Microsoft Excel Worksheets
Article
Microsoft Excel worksheets are made up of rows and columns. Rows are defined by numbers and columns are defined by letters. When you open Excel, cell  A1  is automatically highlighted. Anything you type will show up in this cell. To enter text into a different cell, simply select the cell by clickin…
Article
Entering Text To enter text in Microsoft Excel: Select the cell into which you wish to enter text by clicking on it. Begin typing. Note that in addition to showing up in the cell, the text you are typing also shows up in the Formula Bar: If you are entering a lot of text, it is sometimes easier to t…
Article
Using AutoComplete When you are typing data into a list, Microsoft Excel will attempt to guess what you intend to type based on the data in the cells above the one in which you are typing. The example below illustrates this. Only the letter "B" has been typed into cell  A4 . Excel is guessing that t…
Entering Data Review
04:13
Article
Entering Text and Using AutoComplete Duration: 5 to 10 minutes. Before the end of this course we will build a spreadsheet showing the quarterly profit & loss statement for a fictitious company called Dave's Lemonade Stand. This is the first of these exercises. The spreadsheet will ultimately look li…
Exercise Solution
03:07
Article
Entering Numbers and Dates In the next lesson we will cover formatting numbers to include commas, decimals, currency symbols and more, and formatting dates in various ways. In this lesson, however, we will simply enter dates and numbers in the most basic format, and use autofill to quickly add numbe…
Article
Using the Fill Handle If your data follows a pattern, you can use the Fill Handle to quickly and easily add data to multiple rows and columns. To use the Fill Handle: 1.  Enter enough data to establish a pattern and then select the cells containing the pattern: 2.  Click on the  Fill Handle , which…
Entering Numbers and Dates Review
04:12
Article
Entering Numbers and Dates Duration: 5 to 10 minutes. In this exercise, you will enter the four quarters of the year at the top of your worksheet and will enter projected quarterly numbers for the two income categories. Open or go to  Dave's Lemonade Stand.xlsx . Follow the instructions below to add…
Exercise Solution
02:45
Section 6: Formatting Microsoft Excel Worksheets
Article
There are many types of formatting that can be applied to Microsoft Excel worksheets. The most commonly used formatting commands show up on the Home tab in three groups: The Font Group . The font group commands change the appearance of text within a cell or of the cell itself. The Alignment Group .…
Article
Selecting Ranges of Cells To select a range of cells in Microsoft Excel: 1.  Click on a cell in one of the corners of the range of cells you wish to select: 2.  Hold the left mouse button down and drag horizontally and vertically until the range you wish to select is highlighted: 3.  Release the cli…
Article
The Font Group Bold, Italicize and Underline Text To bold text in Microsoft Excel: Select the cell or cells in which you wish to bold the text. On the Home tab, in the Font group, click the Bold command. To italicize text in Microsoft Excel: Select the cell or cells in which you wish to italicize th…
Formatting Review
06:46
Article
Working with Font Group Commands Duration: 10 to 15 minutes. In this exercise, you will use commands found on the Font group to begin formatting the profit & loss statement for Dave's Lemonade Stand. Continue working in the workbook from the last exercise or open  Dave's Lemonade Stand - Working wit…
Exercise Solution
03:42
Article
The Alignment Group Align Text Text within cells in Microsoft Excel can be aligned both vertically (top, center and bottom) and horizontally (left, center and right). To align text vertically within a cell or cells in Microsoft Excel: Select the cell or cells in which you wish to align the text. On…
Alignment Group Review
04:23
Article
Working with Alignment Group Commands Duration: 10 to 15 minutes. In this exercise, you will use commands found on the Alignment group to continue formatting the profit & loss statement for Dave's Lemonade Stand. Continue working in the workbook from the last exercise or open  Dave's Lemonade Stand…
Exercise Solution
02:13
Article
The Number Group By default, numbers in Microsoft Excel do not show commas and do show the first two decimals (unless they are 0). However, numbers can be formatted to appear in many different ways. Number Formats Numbers in Excel can be formatted to show commas, show currency symbols, appear as per…
Number Group Review
04:07
Article
Working with Number Group Commands Duration: 10 to 15 minutes. In this exercise, you will use commands found on the Number group to continue formatting the profit & loss statement for Dave's Lemonade Stand. Continue working in the workbook from the last exercise or open  Dave's Lemonade Stand - Work…
Exercise Solution
02:18
Section 7: Using Formulas in Microsoft Excel
Article
In this lesson, we'll go through a few readings up front, and then a guest presenter, Nance Pilowa - an Excel Instructor, will join us for a fun presentation reviewing all concepts, and then again after the exercise to go through the solution with you. Math Operators and the Order of Operations Math…
Article
Entering Formulas The simplest (not always the easiest) way to enter a formula in Excel is to: Select the cell in which you wish to enter a formula. Press "=" on your keyboard. Select the first cell which contains data you will use in your formula. Type the operator (+, -, *, or /). Select the secon…
Article
AutoSum (and Other Common Auto-Formulas) Some formulas can be entered simply by clicking a button in Excel. Excel will even guess which data the formula applies to, meaning that if your spreadsheet is properly laid out, you don't have to select the cells. AutoSum To quickly sum a row or column of da…
Article
Copying Formulas and Functions Formulas can be copied from one cell to other cells in Excel. To copy formulas in Excel: 1.  Select the cell which contains the formula you wish to copy. 2.  On the  Home  tab, in the  Clipboard  group, click the  Copy  command. 3.  Select the cell into which you wish…
Article
Relative and Absolute Cell References Relative Cell References Note that in the example above, when we copied the formula from one cell to others, the formula automatically changed to add the cells in the corresponding rows: The formula in cell  E2  added  B2 ,  C2  and  D2 . The formula in  E3  add…
Formulas Review
10:43
Article
Working with Formulas Duration: 15 to 25 minutes. In this exercise, you will use formulas to enter additional data into the quarterly profit and loss statement we are creating for Dave's Lemonade Stand. In the following presentation, Nance will walk you through the solution to this exercise as well.…
Exercise Solution
10:57
Section 8: Working with Rows and Columns
Article
Inserting Rows and Columns To insert a row or a column into a Microsoft Excel worksheet: 1.  Select a cell in your worksheet where you would like the new row or column to be inserted. To insert multiple rows or columns, simply select multiple cells. A.  New rows are inserted above the selected cell(…
Article
Deleting Rows and Columns To delete a row or a column in a Microsoft Excel worksheet: 1. Select a cell in your worksheet in the row or column you wish to delete. To delete multiple rows or columns, simply select multiple cells. 2.  On the  Home  tab, in the  Cells  group, click the  Delete  command.…
Inserting/Deleting Rows and Columns
03:06
Article
Setting Row Height and Column Width Set a Specific Height or Width To change the row height or column width of rows and columns in a Microsoft Excel worksheet: 1.  Select a cell in your worksheet in the row or column of which you wish to change the height or width. To change the height or width of m…
Article
Hiding and Unhiding Rows and Columns Hiding Rows and Columns To hide rows or columns in a Microsoft Excel worksheet: 1.  Select a cell in your worksheet in the row or column you wish to hide. To hide multiple rows or columns, simply select multiple cells. 2.  On the  Home  tab, in the  Cells  group,…
Article
Freezing Panes Freezing panes is a way of making one or more rows or columns stay at the top or left of your worksheet as you scroll through the worksheet. A common use of freezing panes is to keep a header row in view as you scroll through a large worksheet. In the following example, notice that th…
Rows and Columns Review
06:31
Article
Working with Rows and Columns Duration: 5 to 10 minutes. In this exercise, you will insert rows into a Microsoft Excel worksheet, hide rows, and adjust column widths and row heights. Continue working in the workbook from the last exercise or open  Dave's Lemonade Stand - Working with Rows and Column…
Exercise Solution
03:44
Section 9: Editing Worksheets
Article
Find Use the Find command to find instances of words or numbers within a worksheet. To use the Find command: 1.  On the  Home  tab, in the  Editing  group, click the  Find & Select  command and then select  Find : 2.  Type the word or number you wish to find in the  Find and Replace  dialog box and…
Article
Find and Replace Use the Replace command to find instances of words or numbers within a worksheet and replace them with other words or numbers. To use the Replace command: On the Home tab, in the Editing group, click the Find & Select command and then select Replace: In the Find and Replace dialog b…
Find and Replace Review
04:11
Article
Using Find and Replace Duration: 5 to 10 minutes. In this exercise you will find and replace text in a worksheet. Continue working in the workbook from the last exercise or open  Dave's Lemonade Stand - Using Find and Replace.xlsx  from your Webucator/Excel2010A/Exercises  folder. Use Find and Repla…
Exercise Solution
01:33
Article
Using the Clipboard The Clipboard group, located on the Home tab, contains four commands: Cut. Use the Cut command to  cut  a selection from your document. The cut selection is saved on the Clipboard for use elsewhere - either in the current workbook or another one (or even in a separate application…
Clipboard Review
03:21
Article
Using the Clipboard Duration: 5 to 10 minutes. In this exercise, you will use the clipboard to cut, copy, paste and format cells. Open  Clipboard exercise.xlsx  from your  Webucator/Excel2010A/Exercises  folder. Use the clipboard to: Copy cell  A1  to cell  C1 . Cut cell  A2  and paste it in cell  C…
Exercise Solution
02:24
Article
Setting Margins You can increase and decrease margins in Microsoft Excel worksheets to change the amount of white space that shows up between your data and the edge of the page when you print. By default, top and bottom margins are .75 inches, side margins are .7 inches, and header and footer margin…
Margins and Page Orientation Review
03:22

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Webucator Training, Global training company. Trained over 26,000 students. Thousands of student testimonials.

  • Founded in 2003.
  • Webucator provides technical and business training.
  • Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS)
  • Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for its training courses.
  • Webucator has a GSA Contract (GS-35F-0556S).
  • We have provided training to over 70% of the Fortune 100 companies (See Partial Client List).
Why should you choose us?

Ready to start learning?
Take This Course