#
 

Excel 2007 Overview

Free Excel 2007 training notes are now available! These notes are free and available for all levels of users from the beginner to the advanced user who want know more about the most common features used in Microsoft's Excel 2007. Some helpful notes we think you'll find are about the new formatting options in Excel 2007, which requires a conversion if you want to share this with others who have older versions of Excel. Some of the new formatting options will enhance your presentation when it comes to creating charts. We do hope as you learn more about Excel 2007 you'd be interested in seeing it in action and purchase our Excel 2007 online training videos, and or our online Excel 2007 training manual.

Microsoft Certified Application Specialists (MCAS) is a new certification specifically to Office 2007. Part of becoming a certified 2007 MCAS requires passing the Excel 2007 exam. Our training videos and manuals have all been created by Kirt Kershaw who holds certifications as Microsoft Office Master Instructor from Office 2000 to 2007. Learn more about your trainer including his: experience, testimonials, certifications and benefits.
#

Free Excel 2007 Training Tutorials

Microsoft Excel 2007 training videos from Dream Force — online training solutions. Free Excel 2007 tips for Microsoft Excel 2007 users.

Excel 2007
Microsoft 2007 Training Tour:
Web Medical Billing TrainingWeb-based Training
#
Excel 2007 Overview

Beginner

  1. Excel Basics
  2. Quick Access Toolbar
  3. Data Entry
  4. Converting to 2007
  5. Converting to Previous
  6. Move Copy Cut Data
  7. AutoFill Feature
  8. Editing Data
  9. Find and Replace
  10. GoTo Feature
  11. Spell Check
  12. Basic Formulas
  13. SUM and AVERAGE
  14. MAX and MIN
  15. COUNT and COUNTA
  16. Absolute Reference
  17. Mixed References
  18. Text To Columns
  19. Combine Columns
  20. Modifying Fonts
  21. Borders and Shading
  22. Adding Backgrounds
  23. Adjusting Columns Rows
  24. Text Wrapping
  25. Hide Columns Rows
  26. Merge Cells
  27. Formatting Numbers
  28. Create Modify Styles
  29. AutoFormat
  30. Applying Themes
  31. Modifying Worksheets
  32. Print Titles
  33. Headers and Footers
  34. Margins
  35. Page Orientation
  36. Page Breaks
  37. Print Scaling
  38. Set Print Area
  39. Split Window
  40. Freeze Panes
  41. Arranging Worksheets
  42. Hide Worksheet Books
  43. Speak Cells
  44. Customize Workbook
  45. Watermarks and Gridlines
  46. Customize Themes
  47. Cell Comments
  48. Create Hyperlinks
  49. Web Research
  50. Custom Templates
  51. Create Tables
  52. Modifying Tables
  53. Custom Table Styles
  54. Create Charts
  55. Modify Charts
  56. Chart Templates
  57. Chart Sharing
  58. Create PivotTables

Intermediate

  1. Create PivotCharts
  2. Insert Pictures
  3. Draw Modify Shapes
  4. SmartArt Processes
  5. Clip Art
  6. Layering and Groups
  7. Create Name Ranges
  8. Linking Data
  9. Time Functions
  10. LEFT and SEARCH
  11. RIGHT SEARCH and LEN
  12. PROPER UPPER and LOWER
  13. SUM COUNT AVG IFs
  14. HLOOKUP
  15. VLOOKUP
  16. IF AND and OR
  17. Nested IF
  18. IFERROR
  19. Display & Print Formulas
  20. PMT Payment
  21. Consecutive Sorts & Design Flaws
  22. AutoFilter
  23. DSUM DAVG DCOUNT
  24. Subtotals
  25. Macro Basics
  26. Editing Macros
  27. Advanced Filter and Macros
  28. Conditional Formatting
  29. Validation Rule
  30. Workbook Properties
  31. Excel Default Settings
  32. Protect Worksheet
  33. Protect Structure and Windows
  34. Protect Workbook and Backup
  35. Share Workbook
  36. Protect Shared Workbook
  37. Merge Workbooks
  38. Macro Settings
  39. Digital Signatures
  40. Restrict Access by User
  41. Formula Auditing
  42. Circle Invalid Data
  43. Watch & Evaluate Formulas
  44. Automatic Outline and Group
  45. Chart Trend Lines
  46. Scenario Manager
  47. Goal Seek
  48. Solver
  49. Random Sampling
  50. Workspace
  51. Consolidate Data
  52. Link Workbooks
  53. Export To Word
  54. Import Text Files
  55. Publish Worksheets To Web
  56. Import Data From Web
  57. XML Structuring
  58. Advanced Number Formats
#
 
 
Access 2007 Training Videos | Excel 2007 Training Videos | Office 2007 Training Videos | Outlook 2007 Training Videos
PowerPoint 2007 Training Videos | Project 2007 Training Videos | Word 2007 Training Videos | Windows Vista Training Videos
Windows 7 Training Videos | Free Medical Billing Training Videos | Free Access 2007 Tips | Free Excel 2007 Tips | Free Office 2007 Tips
Free Outlook 2007 Tips | Free PowerPoint 2007 Tips | Free Project 2007 Tips | Free Word 2007 Tips | Free Windows Vista Tips | Free Medical Billing Training Tips
Office 2007 Video Training Home | About | Products | Contact | Testimonials | Privacy | FAQs

© 2009 Dream Force, LLC. All Rights Reserved. Terms of Use