Excel 2007 Training

Excel 2007 Training

CustomGuide Excel 2007 Demo

Course Description

Turn unorganized data into useful information and quickly make spreadsheets your friends. CustomGuide’s Microsoft Excel 2007 course lets people of any technical level learn exactly what they need to know at their own pace. It starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.

Lessons: 167
Duration: 6h 57m
Start a Demo Today.

  • Course Outline:
  • The Fundamentals
  • Starting Excel 2007
  • What’s New in Excel 2007
  • Understanding the Excel Program Screen
  • Understanding the Ribbon
  • Using the Office Button and Quick Access Toolbar
  • Using Keyboard Commands
  • Using Contextual Menus and the Mini Toolbar
  • Using Help
  • Exiting Excel 2007
  • Worksheet Basics
  • Creating a New Workbook
  • Opening a Workbook
  • Navigating a Worksheet
  • Entering Labels
  • Entering Values
  • Selecting a Cell Range
  • Overview of Formulas and Using AutoSum
  • Entering Formulas
  • Using AutoFill
  • Understanding Absolute and Relative Cell References
  • Using Undo, Redo and Repeat
  • Saving a Workbook
  • Previewing and Printing a Worksheet
  • Closing a Workbook
  • Editing a Worksheet
  • Editing Cell Contents
  • Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells Using the Mouse
  • Using the Office Clipboard
  • Using the Paste Special Command
  • Checking Your Spelling
  • Inserting Cells, Rows, and Columns
  • Deleting Cells, Rows, and Columns
  • Using Find and Replace
  • Using Cell Comments
  • Tracking Changes
  • Formatting a Worksheet
  • Formatting Labels
  • Formatting Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders, Background Colors and Patterns
  • Using the Format Painter
  • Using Cell Styles
  • Using Document Themes
  • Applying Conditional Formatting
  • Creating and Managing Conditional Formatting Rules
  • Finding and Replacing Formatting
  • Creating and Working with Charts
  • Creating a Chart
  • Resizing and Moving a Chart
  • Changing Chart Type
  • Applying Built-in Chart Layouts and Styles
  • Working with Chart Labels
  • Working with Chart Axes
  • Working with Chart Backgrounds
  • Working with Chart Analysis Commands
  • Formatting Chart Elements
  • Changing a Chart’s Source Data
  • Using Chart Templates
  • Managing Workbooks
  • Viewing a Workbook
  • Working with the Workbook Window
  • Splitting and Freezing a Workbook Window
  • Selecting Worksheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming, Moving and Copying Worksheets
  • Working with Multiple Workbooks
  • Hiding Rows, Columns, Worksheets and Windows
  • Protecting a Workbook
  • Protecting Worksheets and Worksheet Elements
  • Sharing a Workbook
  • Creating a Template
  • Working with Page Layout and Printing
  • Creating Headers and Footers
  • Using Page Breaks
  • Adjusting Margins and Orientation
  • Adjusting Size and Scale
  • Adding Print Titles, Gridlines and Headings
  • Advanced Printing Options
  • More Functions and Formulas
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • AutoCalculate and Manual Calculation
  • Defining Names
  • Using and Managing Defined Names
  • Displaying and Tracing Formulas
  • Understanding Formula Errors
  • Working with Data Ranges
  • Sorting by One Column
  • Sorting by Colors or Icons
  • Sorting by Multiple Columns
  • Sorting by a Custom List
  • Filtering Data
  • Creating a Custom AutoFilter
  • Using an Advanced Filter
  • Working with Tables
  • Creating a Table
  • Working with Table Size
  • Working with the Total Row
  • Working with Table Data
  • Summarizing a Table with a PivotTable
  • Using the Data Form
  • Using Table Styles
  • Using Table Style Options
  • Creating and Deleting Custom Table Styles
  • Convert or Delete a Table
  • Working with PivotTables
  • Creating a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering and Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart
  • Working with the Web and External Data
  • Inserting a Hyperlink
  • Creating a Web Page from a Workbook
  • Importing Data from Access or Text Files
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections
  • Working with Macros
  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar
  • Editing a Macro’s Visual Basic Code
  • Inserting Copied Code in a Macro
  • Declaring Variables and Adding Remarks to VBA Code
  • Prompting for User Input
  • Using the If…Then…Else Statement
  • Working with Objects
  • Inserting Clip Art
  • Inserting Pictures and Graphics Files
  • Formatting Pictures and Graphics
  • Inserting Shapes
  • Formatting Shapes
  • Resize, Move, Copy and Delete Objects
  • Applying Special Effects to Objects
  • Grouping Objects
  • Aligning Objects
  • Flipping and Rotating Objects
  • Layering Objects
  • Inserting SmartArt
  • Working with SmartArt Elements
  • Formatting SmartArt
  • Using WordArt
  • Inserting an Embedded Object
  • Inserting Symbols
  • Advanced Topics
  • Customizing the Quick Access Toolbar
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Recovering Your Documents
  • Using Microsoft Office Diagnostics
  • Viewing Document Properties and Finding a File
  • Saving a Document as PDF or XPS
  • Adding a Digital Signature to a Workbook
  • Preparing Documents for Publishing and Distribution
  • Publishing a Workbook to a Document Workspace
  • Creating a Custom AutoFill List
  • Creating a Custom Number Format
  • Appendix of Common Functions
  • Using Logical Functions (IF)
  • Using Financial Functions (PMT)
  • Using Database Functions (DSUM)
  • Using Lookup Functions (VLOOKUP)

What’s Included:

CustomGuide Tutorials
Interactive Tutorials
CustomGuide Quizzes
Interactive Quizzes
CustomGuide Courseware
Training Manuals
CustomGuide Cheat Sheets
Cheat Sheets
SocialU Learning Platform
Learning Platform

Related Courses: