excel-logoUpon completion of this course the participating real estate professional should be able to create professional spreadsheets, create formulas and functions, format cells and create graphs and charts to manage, analyze important data and present it in a professional manner.You will learn to use Basic workbook skills, working with ranges and creating simple formulas, coping and formatting data , printing and formatting cells ,working with column and rows,using automatic formatting styles and drawing graphs ad charts with the provided and interpreted data

Course Outline :

Introduction

  • Starting Microsoft Excel
  •  Microsoft Excel 2010 Screen Elements
  •  Adding and Renaming Worksheets
  •  The Standard Toolbar

Using Basic workbook Skills

  •  Selecting a Cell using the Keyboard
  •  Scrolling using the Mouse
  •  Entering Text into Cells
  •  Entering Numbers into Cells
  •  Saving a New Workbook
  •  Closing a Workbook
  •  Creating a New Workbook
  •  Opening an Existing Workbook
  •  Using Data Entry Shortcuts
  •  Editing Cell Entries
  •  Renaming an Existing Workbook

Working with Ranges

  •  Working with Ranges
  •  Selecting Ranges with the Keyboard
  •  Selecting Ranges with the Mouse
  •  Selecting Non-adjacent Ranges
  •  Entering Values into a Range
  •  Using the AutoFill Feature

Creating Simple Formulas

  •  Using Formulas
  •  Entering Formulas
  •  Using the AutoSum Button
  •  Using Basic Functions
  •  Using the AutoCorrect Feature
  •  Using the Formula Palette
  •  Using the Paste Function Button
  •  Using the AutoCalculate Feature
  •  Using the Range Finder Feature

Copying and Moving Data

  •  Copying/Cutting and Pasting Data
  •  Pasting from the Clipboard Toolbar
  •  Creating an Absolute Reference
  •  Filling Cells
  •  Using Drag-and-Drop Editing
  •  Using Undo and Redo

Printing

  •  Previewing a Worksheet
  •  Printing the Current Worksheet
  •  Printing the Selected Range
  •  Setting Margin and Centering Options
  •  Changing the Page Orientation
  •  Editing Headers and Footers
  •  Customizing Headers and Footers
  •  Changing Print Guidelines
  •  Repeating Row and Column Labels
  •  Scaling a Worksheet
  •  Using Page Break Preview
  •  Setting/Removing a Print Area

Formatting Numbers

  •  Using Number Formats
  •  Using the Currency Style
  •  Using the Percent Style
  •  Using the Comma Style
  •  Changing Decimal Places

Formatting Text

  •  Changing Text Appearance
  •  Using the Font List
  •  Using the Font Size List
  •  Using the Bold/Italic Buttons
  •  Using the Underline Button
  •  Using the Font Color Button
  •  Rotating Text in a Cell
  •  Wrapping Text in a Cell
  •  Shrinking Text in a Cell
  •  Merging Cells into One Cell
  •  Changing Text Indent

Working with Column and Rows

  •  Selecting Columns and Rows
  •  Changing the Width of Columns
  •  Changing the Height of Rows
  •  Adjusting Columns Automatically
  •  Hiding Columns and Rows
  •  Unhiding Columns and Rows
  •  Inserting a Column
  •  Inserting a Row
  •  Deleting a Column
  •  Deleting a Row

Formatting Cells

  •  Changing Cell Alignment
  •  Using the Merge and Center Button
  •  Using the Borders Button
  •  Using the Fill Color Button
  •  Using the Format Painter Button
  •  Copying to Non-adjacent Cells
  •  Clearing Formats
  •  Inserting Selected Cells
  •  Deleting Selected Cells

Using Automatic Formatting and Styles

  •  Using Automatic Formatting Features
  •  Applying an Auto Format
  •  Changing AutoFormat Options
  •  Extending List Formats and Formulas
  •  Creating a Style by Example
  •  Applying a Style
  •  Creating a New Style
  •  Modifying a Style
  •  Merging Styles

Drawing Graphs and Charts

  •  Charts
  •  Creating a Chart

Course Content

Lessons Status
1

Ms Excel 2010 Chapter 1

2

Ms Excel 2010 Chapter 2

3

Ms Excel 2010 Chapter 3

4

Ms Excel 2010 Chapter 4

5

Ms Excel 2010 Chapter 5

6

Ms Excel 2010 Chapter 6

7

Ms Excel 2010 Chapter 7

8

Ms Excel 2010 Chapter 8

9

Ms Excel 2010 Chapter 9

10

Ms Excel 2010 Chapter 10

11

Ms Excel 2010 Chapter 11

12

Ms Excel 2010 Chapter 12