Excel 2010: Intermediate

Course Description

In Microsoft Office Excel 2010: Foundation, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks. In this course, you will use Microsoft Office Excel 2010 to streamline and enhance your spreadsheets with templates, functions, formulae, arrays, tables, WordArt and also using Excel with Word, Access and other packages.
1 day
Contact us for pricing

Prerequisites

To ensure the successful completion of the Intermediate course, the completion of the Foundation course or equivalent knowledge is recommended.

Advanced File Tasks

1.1: Using My Computer within Excel
• Using the My Places Toolbar
• Navigating with My Computer
• Performing Basic Tasks with My Computer
• Changing Views
1.2: Saving your Files
• File Formats
• File Properties
• AutoRecover
• Upgrading a Workbook
1.3: Using Templates
• Opening a Template
• Downloading a Template
• Using a Template
• Creating a Template

Working with Functions and Formulas

2.1: Using Formulas in Excel
• Understanding Relative and Absolute Cell References
• Basic Mathematical Operators
• Using Formulas with Multiple Cell References
• The Formula Auditing Buttons
• Fixing Formula Errors
• Displaying and Printing Formulas
2.2: Exploring Excel Functions
• What are Functions?
• Finding the Right Function
• Some Useful and Simple Functions
2.3: Using Functions in Excel
• Inserting Functions
• Using Functions and AutoFill to Perform Difficult Calculations
• Using the IF Function
• Working with Nested Functions
2.4: Working with Names and Ranges
• What Are Range Names?
• Defining and Using Range Names
• Selecting Nonadjacent Ranges
• Using AutoCalculate
2.5: Working with Array Formulas
• What are Array Formulas?
• Using Basic Array Formulas
• Using Functions with Array Formulas
• Using the IF function in Array Formulas

Managing Tables

3.1: Working with Tables
• What is a Table?
• Creating Tables
• Modifying Tables
• What is the Total Row?
3.2: Working with Records and Fields
• What are Records and Fields?
• Adding Fields by Inserting Columns
• Adding Records by Inserting Rows
• Quickly Adding Records to a Data table
• Deleting Records or Fields
3.3: Working with Tables and Filters
• Sorting Data in a Table
• What is an AutoFilter?
• Custom AutoFilters
• Using an Advanced Filter
• Copying Filtered Records
3.4: Using Excel as a Database
• Filtering with Wildcard Characters
• Validating Your Data
• What are Database Functions?

Enhancing your Workbook

4.1: Customizing your Workbook
• Inserting a Symbol or Special Character
• Adding and Editing Shapes
• Creating and Altering Diagrams
• Changing the Diagram Type
• Incorporating Text
• Adding a Signature Line
4.2: Working with Text Boxes
• Adding a Text Box
• Selecting a Text Box
• Manipulating a Text Box
• Formatting a Text Box
4.3: WordArt
• Adding WordArt to your Spreadsheet
• Changing the Font Color
• Changing the Outline Color
• Adding Effects
4.4: ClipArt
• Finding ClipArt
• Inserting ClipArt
• Manipulating ClipArt
• Inserting a Photographic Image
• Adding a Screen Capture
4.5: Using Objects
• Creating New Embedded Objects
• Embedding Existing Files
• Editing Embedded Objects
• Embedding Parts of Files

Finalizing Your Workbook

5.1: Protecting your Workbook
• Protecting your Workbook
• Protecting your Worksheets
• Unlocking Cells
• Protecting your Excel Files
5.2: Finishing Your Workbook
• Using the Document Inspector
• Using the Compatibility Checker
• Marking a Workbook as Final
• Adding Sparklines to Your Workbook (this probably should be moved)
5.3: Using Excel in Word
• Inserting Excel Data in Word
• Linking Excel Data in a Word Document
• Modifying Excel Data after Insertion
• Insert an Excel Chart into a Word Document
5.4: Using Excel and Access
• Linking an Excel Workbook to an Access Database
• Importing Table, PivotTable, and PivotChart Data from Access
• Transforming an Excel Workbook into an Access Database
5.5: Using Excel With other Programs and Files
• Using Outlook to Send Excel Data
• Opening an Excel File in a Different Format
• Importing Data from a Text File
• Importing Data from External Data Sources
• Publishing a Workbook as a PDF File
• Faxing a Workbook

Excel 2010Microsoft Excel 2010