Invest in Yourself!
Chamber Sign-up
Associations! Add value for your membership today through our exclusive benefit program.
Featured Courses
CLN Guided Tour
Watch now!Sign up for our Newsletter!
Beyond the Basics in Excel
Category:
Technical Training Excel 2007: Getting Started
Length: 2 hours
Description: This course provides information about using Microsoft Excel 2007. It provides basic information for beginners, or for those individuals wanting to brush up on working in Excel.
Excel 2007: Creating a Worksheet
Length: 3 hours
Description: This course provides information about entering text, values and formulas into worksheet cells in Microsoft Excel 2007. It also provides information about calculating formulas and using built-in functions, like AutoComplete, AutoFill, Insert Function, and AutoSum.
Excel 2007: Formatting Data
Length: 1 hour
Description: This course shows you how to select, adjust and apply different formats to cells in Excel 2007.
Excel 2007: Editing and Printing Worksheets
Length: 1 hour
Description: This course provides information about using different viewing modes to preview workbooks, distinguishing between relative and absolute cell references, copying formulas from one cell to another, and viewing copied items on the clipboard. It also provides information about deleting, inserting and hiding cells; and using the Page Setup dialog box to insert headers, footers and page breaks.
Excel 2007: Managing Worksheets
Length: 2 hours
Description: This course provides information about managing multiple worksheets, naming cells and ranges, and searching for data within your worksheet. It also covers sharing and protecting your workbooks and adding cell-specific information such as Web links and comments.
Excel 2007: Using Charts and Objects
Length: 2 hours
Description: This course provides a detailed look at how you can insert and modify charts, shapes, text boxes, pictures, SmartArt, and clip art to visually enhance your worksheets.
Excel 2007 Advanced: Filtering and Sorting Data
Length: 2 hours
Description: This course provides information on how to filter and sort your worksheets in Excel 2007.
Excel 2007 Advanced: Using Pivot Tables
Length: 2 hours
Description: This course explains how to create and use pivot tables in Excel 2007.
Excel 2007 Advanced: Working with Functions
Length: 3 hours
Description: This course introduces the use of Excel 2007 functions.
Excel 2007 Advanced: Using Data Analysis Tools
Length: 1 hour
Description: This course provides an introduction to the commands used to analyze data in Excel 2007.
Excel 2007 Advanced: Automating with VBA Macros
Length: 2 hours
Description: This course introduces the use of macros in Excel 2007.
Excel 2007 Advanced: Adding Connections and Importing Data
Length: 2 hours
Description: This course provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources.
“I really enjoyed the course and would absolutely take more this way. Liked the fact that it repeated things because it helped the topics stick in my head and I loved the fact that if I got a question wrong that it would explain the right answer. The program really works for my lifestyle.”