Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel 2007 Essential Training

via LinkedIn Learning

Overview

A detailed look at the features and uses of Excel 2007, including how and why to use spreadsheets.

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

Syllabus

Introduction
  • Welcome
1. Getting Started
  • Why use a spreadsheet?
  • What's changed in Excel 2007?
  • The Ribbon
  • The Microsoft Office Button
2. Setting Up Excel 2007
  • What's on the Ribbon?
  • Making your way around the Ribbon
  • Customizing the Ribbon
  • Customizing the Microsoft Office Button
3. Modifying Worksheets
  • Opening old worksheets
  • Adding and deleting worksheets
  • Inserting and deleting cells
  • Freezing areas of a worksheet
4. Basic Formatting
  • Width and height
  • Numeric formats
  • Alignment of data
  • Playing with fonts
  • AutoFilter
  • Formatting as a table
5. Advanced Formatting
  • Removing duplicates
  • What is Conditional Formatting?
  • Working with Conditional Formatting
  • Managing Conditional Formatting rule preferences
  • Converting text to columns
  • Data validation
6. Using Templates, Styles, and AutoFormat
  • Templates
  • Styles
  • AutoFormat
7. Managing Lists in Excel
  • Excel lists have now become tables
  • Converting text to columns
  • Sorting and Grouping
  • Creating a summary report
8. Reviewing Worksheets
  • Proofing your work
  • Providing comments on worksheets
9. Sharing Worksheets
  • Protecting and sharing a worksheet
  • Allowing others to edit ranges
  • Track Changes
10. Printing Workbooks
  • Preparing to print
  • Print Preview
  • The Page Layout Tab
  • Page Breaks
  • The Page Layout View
  • Headers and Footers
11. Enhancing Worksheets
  • Adding themes to your worksheet
  • Page setup options
  • Scale to Fit
  • Worksheet options
  • Inserting images
12. Using Templates
  • Using templates
13. Manipulating the Screen Display
  • Workbook Views
  • Hiding and Zooming
  • Window Panes
  • More screen options
14. Importing Data
  • Importing from Access
  • Using the Import Wizard for text files
15. Finding and Replacing Data
  • The Find and Select button
  • Find and Replace
  • Removing duplicates
16. Working with Formulas
  • What are formulas?
  • Order of Operations
  • Relative and absolute referencing
  • The new Formula Tab
17. Working with Basic Functions
  • What are Functions?
  • AutoSum
  • Minimum
  • Trim
  • Left
18. Working with Advanced Functions
  • Concatenation
  • SumIf
  • Lookup
  • What-If Analysis
19. Charts
  • Why create a chart?
  • Creating your chart
  • Modifying your chart
  • Laying out your chart
20. Pivot Tables
  • What are PivotTable reports and PivotChart reports?
  • Creating a PivotTable
  • Laying out your PivotTable
  • Designing your PivotTable
  • Creating a PivotChart
21. Working with Macros
  • Why use macros?
  • Creating a macro
  • Macro security
22. Workflow in Excel 2007
  • Reviewing a workflow in Excel
Conclusion
  • Conclusion

Taught by

Lorna Daly

Related Courses

Reviews

Start your review of Excel 2007 Essential Training

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free