Microsoft Excel 2007 Instructor-led Video Tutorial Instructor-led Excel 2007 tutorial videos give you a thorough tour of the Excel environment where you will see the features demonstrated and hear step-by-step explanations. Even if you haven't yet upgraded to the 2007 version of Microsoft Office, you'll get to explore the simulated environment and participate in hands-on exercises. By seeing Excel in action, learning what each function is for and how to use it, and practicing in a simulated environment, you will be well on your way toward mastering spreadsheet usage. Best of all, all training takes place on either your computer or laptop for the ultimate in portable, anytime, anywhere study sessions. The new version of Excel has undergone an extensive redesign which makes it tough for even seasoned users to get around. Using an Excel 2007 training CD is an ideal way for existing users to get their bearings and is even better for new users who want to learn Excel from the ground up. Benefits of Microsoft Excel 2007 Training If you work with numbers, chances are you also must use a spreadsheet from time to time. Do you know how to use your spreadsheets to their full potential? Excel has been the leading spreadsheet application for many years with many users knowing just enough to get by. Now that Excel 2007 has been redesigned, consider enrolling in a Microsoft Excel 2007 training course and moving beyond the status quo. Not only does Excel sport a new look, it also has numerous enhancements. By learning and mastering Excel 2007, you will set yourself apart from everyone else. Rather than simply storing data in Excel, learn how to use the data. The powerful tools are waiting for you to use them. Enroll in a self-study Microsoft Excel 2007 tutorial training course and learn what those tools are, how they can benefit you, and how to use them. You'll be able to analyze your numbers, not just enter them. As you become more proficient with using this application, you'll become more valued within your organization. Your new skills will allow you to work more productively. Your in-depth understanding of relevant data will affect your job performance for the better. By better understanding the data you work with, you'll be able to make better decisions, projections, and recommendations. Microsoft Excel is a leading spreadsheet for good reason: it's a powerful tool. And, it's getting better and better. Many of the old limitations are gone making Excel more versatile than ever. Find out how each of the function of Excel works so that you can take advantage of these powerful features by taking a Microsoft Excel 2007 training course. Excel training isn't just for newcomers to the Office suite. Anyone who uses Excel, even seasoned users can increase their knowledge on their own through self-study Microsoft Excel 2007 training. Microsoft Excel 2007 Basic 1.0 Creating a Basic Worksheet
1.1 Explore the User Interface and the Ribbon
1.2 Customize the Quick Access Toolbar
1.3 Navigate and Select in Excel
1.4 Enter Data and Save a Workbook 2.0 Performing Calculations
2.1 Create Basic Formulas
2.2 Calculate with Functions
2.3 Copy Formulas and Functions 3.0 Modifying a Worksheet
3.1 Manipulate Data
3.2 Working with Cells, Columns, and Rows
3.3 Search for Data in a Worksheet
3.4 Spell Check a Worksheet 4.0 Formatting a Worksheet
4.1 Modify Fonts
4.2 Add Borders and Color to Cells
4.3 Change Column Width and Row Height
4.4 Apply Number Formats
4.5 Using Styles 5.0 Printing Workbook Contents
5.1 Print Workbook Contents Using Default Print Options
5.2 Setting Page Breaks 6.0 Managing Large Workbooks
6.1 Format Worksheet Tabs
6.2 Manage Worksheets in a Workbook
6.3 Manage the View of Large Worksheets
Microsoft Excel 2007 Intermediate
1.0 Calculating Data with Advanced Formulas
1.1 Manage Cell and Range Names
1.2 Calculating Data Across Worksheets
1.3 Analyzing Data with Logical and Lookup Functions 2.0 Organizing Worksheet and Table Data
2.1 Creating and Modifying Tables
2.2 Formatting Tables
2.3 Sorting or Filtering Worksheet or Table Data
2.4 Calculating Data in a Table or Worksheet 3.0 Presenting Data Using Charts
3.1 How to Create a Chart
3.2 Modifying Charts
3.3 Formatting Charts 4.0 Analyzing Data Using PivotTables and PivotCharts
4.1 Creating a PivotTable Report
4.2 Analyzing and Modifying a PivotTable 5.0 Inserting Graphic Objects
5.1 Inserting and Modifying Pictures and ClipArt
5.2 Drawing and Modifying Shapes 6.0 Customizing and Enhancing Workbooks and the Excel Environment
6.1 How to Customize the Excel Environment
6.2 Customizing Workbooks
6.3 Managing Themes
6.4 How to Create and Use Templates
Microsoft Excel 2007 Advanced
1.0 Streamlining Workflow
1.1 Creating Macros
1.2 Adding Macros to the Quick Access Toolbar
1.3 Editing a Macro
1.4 Using Conditional Formatting
1.5 Applying Data Validation to a Worksheet
1.6 Updating Workbook Properties
1.7 Modifying Excel Options 2.0 Collaborating with Others
2.1 Protecting Files and Sharing Workbooks
2.2 Merging Multiple Workbooks
2.3 Adjusting Macro Settings
2.4 Restricting Document Access 3.0 Auditing Worksheets
3.1 Tracing Cell Precedents and Dependents
3.2 Troubleshooting Errors in Formulas
3.3 Watching and Evaluating Formulas
3.4 Creating a Data List Outline 4.0 Analyzing Data
4.1 Adding a Trend Line to Charts
4.2 Create Scenarios and Performing What-If Analysis 5.0 Working with Multiple Workbooks
5.1 Create a Workspace
5.2 Consolidate Data
5.3 Managing Linked Cells in Different Workbooks 6.0 Importing and Exporting Data
6.1 Exporting Excel Data
6.2 Importing a Table from Word | 
