Learn Excel 2007 Essential Skills With The Smart Method

Description

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.

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