English French German Italian Portuguese Russian Spanish

logo_old

  • Microsoft Training

    microsoftInterSource offers courses on all practically all Microsoft products and technologies:

    Operating Systems: XP, Vista, Server Server2003, Server 2008 IIS, SQL Server

    Development Tools & Environments: ASP, ASP.NET, C#, .NET, VBA, Visual Basic

    Applications: Dynamics, Expression, Access, Excel, Word PowerPoint, Exchange, InfoPath, Outlook, SharePoint , Project, Publisher, Business Intelligence

    Please refer to our detailed course outlines below.

  • About Microsoft

    Microsoft has had an impact on, and indeed defined the computing world like no other company. The development tools, operating systems and applications produced by Microsoft have achieved near-ubiquity in the desktop computer market. The original mission set by Microsoft's founder was to have "a computer on every desk and in every home, running Microsoft software". About 90% of computer users worldwide run Microsoft products, hence this objective has largely been met. For operating systems, Web client statistics suggest that Microsoft Windows has about a 92% share, Apple Mac OS 6% and Linux, 1%.

    Read More

  • Course Details Microsoft

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative date, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

Comprehensive Microsoft Excel 2007 Training

 PDF PrintEmail

Course duration

  • 3 Days

Course Outline

On the first day of this comprehensive Microsoft Excel 2007 training course, students will learn to use Excel to create, modify and format Excel worksheets, perform calculations, and print and Excel workbooks. On the second day, they will learn to will apply visual elements and advanced formulas to a worksheet to display data in various formats. And on the third day, they will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

  • Create basic worksheets using Microsoft Excel.
  • 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.
  • Learn to use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Learn to use conditional formatting and styles.
  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.
  1. Creating a Microsoft Excel Workbook
    1. Starting Microsoft Excel
    2. Creating a Workbook
    3. Saving a Workbook
    4. The Status Bar
    5. Adding and Deleting Worksheets
    6. Copying and Moving Worksheets
    7. Changing the Order of Worksheets
    8. Spliting the Worksheet Window
    9. Closing a Workbook
  2. The Ribbon
    1. Tabs
    2. Groups
    3. Commands
  3. The Backstage View (The File Menu)
    1. Introduction to the Backstage View
    2. Opening a Workbook
    3. New Workbooks and Excel Templates
    4. Printing Worksheets
    5. Adding Your Name to Microsoft Excel
  4. The Quick Access Toolbar
    1. Adding Common Commands
    2. Adding Additional Commands with the Customize Dialog Box
    3. Adding Ribbon Commands or Groups
    4. Placement
  5. Entering Data in Microsoft Excel Worksheets
    1. Entering Text
    2. Expand Data across Columns
    3. Adding and Deleting Cells
    4. Adding an Outline
    5. Adding a Hyperlink
    6. Add WordArt to a Worksheet
    7. Using AutoComplete
    8. Entering Numbers and Dates
    9. Using the Fill Handle
  6. Formatting Microsoft Excel Worksheets
    1. Selecting Ranges of Cells
    2. Hiding Worksheets
    3. Adding Color to Worksheet Tabs
    4. Adding Themes to Workbooks
    5. Adding a Watermark
    6. The Font Group
    7. The Alignment Group
    8. The Number Group
  7. Using Formulas in Microsoft Excel
    1. Math Operators and the Order of Operations
    2. Entering Formulas
    3. AutoSum (and Other Common Auto-Formulas)
    4. Copying Formulas and Functions
    5. Displaying Formulas
    6. Relative, Absolute, and Mixed Cell References
  8. Working with Rows and Columns
    1. Inserting Rows and Columns
    2. Deleting Rows and Columns
    3. Transposing Rows and Columns
    4. Setting Row Height and Column Width
    5. Hiding and Unhiding Rows and Columns
    6. Freezing Panes
  9. Editing Worksheets
    1. Find
    2. Find and Replace
    3. Using the Clipboard
  10. Finalizing Microsoft Excel Worksheets
    1. Setting Margins
    2. Setting Page Orientation
    3. Setting the Print Area
    4. Print Scaling (Fit Sheet on One Page)
    5. Printing Headings on Each Page/Repeating Headers and Footers
    6. Headers and Footers
  11. Advanced Formulas
    1. Using Named Ranges in Formulas
    2. Naming a Single Cell
    3. Naming a Range of Cells
    4. Naming Multiple Single Cells Quickly
    5. Using Formulas That Span Multiple Worksheets
    6. Using the IF Function
    7. Using the SUMIF, AVERAGEIF, and COUNTIF Functions
    8. Using the PMT Function
    9. Using the VLOOKUP Function
    10. Using the HLOOKUP Function
    11. Using the CONCATENATE Function
    12. Using the PROPER, UPPER, and LOWER Functions
    13. The UPPER Function
    14. The LOWER function
    15. The TRIM Function
    16. Using the LEFT, RIGHT, and MID Functions
    17. The MID Function
    18. Using Date Functions
  12. Working with Lists
    1. Converting a List to a Table
    2. Removing Duplicates from a List
    3. Sorting Data in a List
    4. Filtering Data in a List
    5. Adding Subtotals to a List
    6. Grouping and Ungrouping Data in a List
  13. Working with Illustrations
    1. Working with Clip Art
    2. Using Shapes
    3. Working with SmartArt
  14. Visualizing Your Data
    1. Inserting Charts
    2. Editing Charts
    3. Changing the Layout of a Chart
    4. Changing the Style of a Chart
    5. Adding a Shape to a Chart
    6. Adding Additional Data Series to a Chart
    7. Switch between Rows and Columns in a Chart
    8. Positioning a Chart
    9. Modifying Chart and Graph Parameters
    10. Showing, Hiding, or Changing the Location of the Legend in a Chart
    11. Show or Hiding the Title of a Chart
    12. Changing the Title of a Chart
    13. Show, Hiding, or Changing the Location of Data Labels in a Chart
    14. Changing the Style of Pieces of a Chart
    15. Add and Format Objects
    16. Insert a Text Box
  15. Working with Tables
    1. Format Data as a Table
    2. Move between Tables and Ranges
    3. Modify Tables
    4. Add and Remove Cells within a Table
    5. Define Titles
    6. Band Rows and Columns
    7. Remove Styles from Tables
  16. Advanced Formatting
    1. Applying Conditional Formatting
    2. Working with Styles
    3. Applying Styles to Tables
    4. Applying Styles to Cells
  17. Microsoft Excel New Features
    1. New Functions in Excel
    2. Using New Chart Tools
    3. Using the Quick Analysis Tool
    4. Using the Chart Recommendation Feature
  18. Using Pivot Tables
    1. Creating Pivot Tables
    2. Preparing Your Data
    3. Inserting a Pivot Table
    4. Inserting Slicers
    5. Inserting Pivot Charts
    6. More Pivot Table Functionality
  19. Auditing Worksheets
    1. Tracing Precedents
    2. Tracing Dependents
    3. Showing Formulas
  20. Data Tools
    1. Converting Text to Columns
    2. Data Validation
    3. Consolidating Data
    4. Goal Seek
  21. Working with Others
    1. Protecting Worksheets and Workbooks
    2. Password Protecting a Workbook
    3. Password Protecting a Worksheet
    4. Password Protecting Ranges in a Worksheet
    5. Tracking Changes
    6. Accepting or Rejecting Changes
  22. Recording and Using Macros
    1. Recording Macros
    2. Running Macros
    3. Editing Macros
    4. Adding Macros to the Quick Access Toolbar
  23. Random Useful Items
    1. Sparklines
    2. Inserting Sparklines
    3. Customizing Sparklines
    4. Importing and Exporting Files
    5. Importing Text Files
    6. Exporting Worksheet Data to Microsoft Word
    7. Exporting Excel Charts to Microsoft Word

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.