Learn Excel 2007 Essential Skills with the Smart Method: Courseware Tutorial for Self-Instruction to Beginner and Intermediate Level

This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. Here are just five of the many ways in which this book is unique: * The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book. * This is the only book that is also available as a low-cost video (DVD). Each can be used as a stand-alone product, but together they provide an incredibly powerful learning experience. * Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses. * Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book). * Each lesson has a sample file that models a real-world business problem. You'll immediately appreciate the value and relevance of each skill as it is taught.Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. From the Back Cover Amongst other things you'll learn how to: * Master Excel 2007's new Fluent User Interface and Ribbon * Understand the new Excel 2007 file formats and when to use them * Create your own formulas with the new Formula AutoComplete feature * Create cross worksheet formulas * Understand absolute, relative and mixed cell references * Create stunning, professional, presentation-quality charts * Use the new Themes feature to create visually excellent worksheets * Use Excel 2007's new Trend Line feature * Bring your data alive with Excel 2007's stunning Visualizations * Create custom conditional formatting rules with the new Rules Manager * Add a professional sheen to your work with 3-D Elements * Understand and work with three-dimensional worksheet groups Companies who have taken Smart Method courses include: AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW...and many, many others.

Table of Contents:
Session One: Basic Skills Session Objectives Lesson 1 1: Start Excel and check your program version Vista Windows XP Lesson 1 2: Maximize, minimize, re-size, move and close the Excel window Lesson 1 3: Understand the Application and Workbook windows Lesson 1 4: Open and navigate a workbook Lesson 1 5: Save a workbook Excel Workbook (the Open XML format) Excel Macro Enabled Workbook Excel 97-2003 Workbook Excel Binary Workbook Lesson 1 6: Pin a document and understand file organization Lesson 1 7: View, add, rename, delete and navigate worksheet tabs Lesson 1 8: Use the Ribbon Lesson 1 9: Understand Ribbon components Normal button Menu or gallery button Split button Check box Command group Dialog launcher Drop down list Drop down gallery Rich menu Lesson 1 10: Customize the Quick Access Toolbar and preview the printout Lesson 1 11: Use the Mini Toolbar, Key Tips and keyboard shortcuts Lesson 1 12: Understand views Lesson 1 13: Use full screen view Lesson 1 14: Use the help system Session 1: Exercise Session 1: Exercise answers Session Two: Doing Useful Work with Excel Session Objectives Lesson 2 1: Enter text and numbers into a worksheet Lesson 2 2: Create a new workbook and view two workbooks at the same time Lesson 2 3: Use AutoSum to quickly calculate totals Lesson 2 4: Select a range of cells and understand Smart Tags Lesson 2 5: Enter data into a range and copy data across a range Lesson 2 6: Select adjacent and non-adjacent rows and columns Lesson 2 7: Select non-contiguous cell ranges and view summary information Lesson 2 8: AutoSelect a range of cells Lesson 2 9: Re-size rows and columns Lesson 2 10: Use AutoSum to sum a non-contiguous range Lesson 2 11: Use AutoSum to quickly calculate averages Lesson 2 12: Create your own formulas Lesson 2 13: Create functions using Formula AutoComplete Lesson 2 14: Use AutoFill for text and numeric series Lesson 2 15: Use AutoFill to adjust formulas Lesson 2 16: Use AutoFill options Lesson 2 17: Speed up your AutoFills and create a custom fill series Lesson 2 18: Use the zoom control Lesson 2 19: Print out a worksheet Session 2: Exercise Session 2: Exercise answers Session Three: Taking your skills to the next level Session Objectives Lesson 3 1: Insert and delete rows and columns Lesson 3 2: Use AutoComplete and fill data from adjacent cells Lesson 3 3: Cut, copy and paste Lesson 3 4: Cut, copy and paste using drag and drop Lesson 3 5: Use Paste Values and increase/decrease decimal places displayed Lesson 3 6: Transpose a range Lesson 3 7: Use the Multiple Item Clipboard Lesson 3 8: Use Undo and Redo Lesson 3 9: Insert cell comments Lesson 3 10: View cell comments Lesson 3 11: Print cell comments Lesson 3 12: Understand absolute and relative cell references Lesson 3 13: Understand mixed cell references Lesson 3 14: Create a template What is a template? Lesson 3 15: Use a template Lesson 3 16: Freeze columns and rows Lesson 3 17: Split the window into multiple panes Lesson 3 18: Check spelling Session 3: Exercise Session 3 Exercise answers Session Four: Making Your Worksheets Look Professional Session Objectives Lesson 4 1: Format dates Lesson 4 2: Understand date serial numbers How Excel stores dates The world began in 1900 In Excel every time is a date, and every date is a time Lesson 4 3: Format numbers using built-in number formats Formatting fundamentals Lesson 4 4: Create custom number formats Overview of custom formats Lesson 4 5: Horizontally align the contents of cells Lesson 4 6: Merge cells, wrap text and expand/collapse the formula bar Lesson 4 7: Vertically align the contents of cells Lesson 4 8: Understand themes Font sets Colour sets Effects Lesson 4 9: Use cell styles and change themes Lesson 4 10: Add color and gradient effects to cells Lesson 4 11: Add borders and lines Lesson 4 12: Create your own Custom theme Lesson 4 13: Create your own Custom cell styles Lesson 4 14: Use a master style book to merge styles Lesson 4 15: Use simple Conditional Formatting Lesson 4 16: Manage multiple conditional formats using the Rules Manager Lesson 4 17: Bring data alive with visualizations Lesson 4 18: Create a formula driven conditional format Lesson 4 19: Use the Format Painter Lesson 4 20: Rotate text Session 4: Exercise Session 4: Exercise answers Session Five: Charts and Graphics Session Objectives Lesson 5 1: Create a simple chart with two clicks Lesson 5 2: Move, re-size, copy and delete a chart Lesson 5 3: Change the chart layout and add a data table Lesson 5 4: Format chart element fills and borders Lesson 5 5: Format 3-D elements and align text Lesson 5 6: Move, re-size add and delete chart elements Lesson 5 7: Change a chart's source data Lesson 5 8: Assign non-contiguous source data by click and drag Lesson 5 9: Change source data using the Select Data Source dialog tools Lesson 5 10: Chart non-contiguous source data by hiding rows and columns Lesson 5 11: Create a chart with numerical axis Lesson 5 12: Deal with empty data points Lesson 5 13: Add data labels to a chart Lesson 5 14: Highlight specific data points with color and annotations Lesson 5 15: Add gridlines and scale axes Lesson 5 16: Emphasize data by manipulating pie charts Lesson 5 17: Create a chart with two vertical axis Lesson 5 18: Create a combination chart containing different chart types Lesson 5 19: Add a trend line Lesson 5 20: Switch chart rows/columns and add a gradient fill. Lesson 5 21: Create your own chart templates Session 5: Exercise Session 5: Exercise answers Session Six: Working With Multiple Worksheets and Workbooks Session Objectives Lesson 6 1: View the same workbook in different windows Lesson 6 2: View two windows side by side and perform synchronous scrolling Lesson 6 3: Duplicate worksheets within a workbook Lesson 6 4: Move and copy worksheets from one workbook to another Lesson 6 5: Hide and unhide a worksheet Lesson 6 6: Create cross worksheet formulas Lesson 6 7: Understand worksheet groups Lesson 6 8: Use find and replace Session 6: Exercise Session 6: Exercise answers Session Seven: Printing Your Work Session Objectives Lesson 7 1: Print Preview and change paper orientation Lesson 7 2: Use page layout view to adjust margins Lesson 7 3: Use Page Setup to set margins more precisely and center the worksheet Lesson 7 4: Set paper size and scale Lesson 7 5: Insert, delete and preview page breaks Lesson 7 6: Adjust page breaks using Page Break Preview Lesson 7 7: Add auto-headers and auto-footers and set the starting page number Lesson 7 8: Add custom headers and footers Lesson 7 9: Specify different headers and footers for the first, odd and even pages Lesson 7 10: Print only part of a worksheet Lesson 7 11: Add row and column data labels and grid lines to printed output Lesson 7 12: Print several selected worksheets and change the page order. Lesson 7 13: Suppress error messages in printouts Session 7: Exercise Session 7: Exercise answers Index