Learn Excel 2010 essential skills with the Smart method
By: Mike Smart
Publisher: Smart Method Ltd.
Published: 2011
Place of publication: Douglas [Isle of Man]
Language: eng
Number of pages: 309
ISBN-13: 9780955459979
Subjects: Business; Computer programs; Electronic spreadsheets; Microsoft Excel (Computer file)
Description: The Smart Method provides an entirely new and better way to learn Excel. Every lesson is presented on two facing sheets of A4 paper (the and has a sample file that models a real-world business problem.
Notes: Includes index.
Table of contents: title: Machine generated contents note: Feedback; title: Downloading the sample files; title: Problem resolution; title: Typographical Conventions Used In This Book; title: Putting The Smart Method to Work; title: Excel version and service pack; title: Sessions and lessons; title: Read the book from beginning to end; title: How this book avoids wasting your time; title: Why our classroom courses work so well; title: How this book mimics our classroom technique; title: Avoiding repetition; title: Use of American English; title: First page of a session; title: Every lesson is presented on two facing pages; title: Learning by participation; title: Session One Basic Skills; title: Session Objectives; title: Lesson 1-1 Start Excel and check your program version; title: Windows 7; title: Windows Vista; title: Windows XP; title: Lesson 1-2 Maximize, minimize, re-size, move and close the Excel window; title: Lesson 1-3 Understand the Application and Workbook windows; title: Lesson 1-4 Download the sample files and open/navigate a workbook; title: Lesson 1-5 Save a workbook.; title: Contents note continued: Lesson 1-6 Understand common file formats; title: Excel Workbook (the Open XML format); title: Excel Macro Enabled Workbook; title: Excel 97-2003 Workbook; title: Excel Binary Workbook; title: PDF; title: Other formats; title: Lesson 1-7 Pin a workbook and understand file organization; title: Lesson 1-8 View, move, add, rename, delete and navigate worksheet tabs; title: Lesson 1-9 Use the Versions feature to recover an unsaved Draft file; title: Lesson 1-10 Use the Versions feature to recover an earlier version of a workbook; title: Lesson 1-11 Use the Ribbon; title: Lesson 1-12 Understand Ribbon components; title: Normal button; title: Menu button; title: Split button; title: Check box; title: Command group; title: Dialog launcher; title: Drop down list; title: Drop down gallery; title: Rich menu; title: Lesson 1-13 Customize the Quick Access Toolbar and preview the printout; title: Lesson 1-14 Use the Mini Toolbar, Key Tips and keyboard shortcuts; title: Lesson 1-15 Understand views; title: Lesson 1-16 Use full screen view; title: Lesson 1-17 Use the help system.; title: Contents note continued: Session 1 Exercise; title: Session 1 Exercise answers; title: Session Two Doing Useful Work with Excel; title: Session Objectives; title: Lesson 2-1 Enter text and numbers into a worksheet; title: Lesson 2-2 Create a new workbook and view two workbooks at the same time; title: Lesson 2-3 Use AutoSum to quickly calculate totals; title: Lesson 2-4 Select a range of cells and understand Smart Tags; title: Lesson 2-5 Enter data into a range and copy data across a range; title: Lesson 2-6 Select adjacent and non-adjacent rows and columns; title: Lesson 2-7 Select non-contiguous cell ranges and view summary information; title: Lesson 2-8 AutoSelect a range of cells; title: Lesson 2-9 Re-size rows and columns; title: Lesson 2-10 Use AutoSum to sum a non-contiguous range; title: Lesson 2-11 Use AutoSum to quickly calculate averages; title: Lesson 2-12 Create your own formulas; title: Lesson 2-13 Create functions using Formula AutoComplete; title: Lesson 2-14 Use AutoFill for text and numeric series.; title: Contents note continued: Lesson 2-15 Use AutoFill to adjust formulas; title: Lesson 2-16 Use AutoFill options; title: Lesson 2-17 Speed up your AutoFills and create a custom fill series; title: Lesson 2-18 Use the zoom control; title: Lesson 2-19 Print out a worksheet; title: Session 2 Exercise; title: Session 2 Exercise answers; title: Session Three Taking Your Skills to the Next Level; title: Session Objectives; title: Lesson 3-1 Insert and delete rows and columns; title: Lesson 3-2 Use AutoComplete and fill data from adjacent cells; title: Lesson 3-3 Cut, copy and paste; title: Lesson 3-4 Cut, copy and paste using drag and drop; title: Lesson 3-5 Use Paste Values and increase/decrease decimal places displayed; title: Lesson 3-6 Transpose a range; title: Lesson 3-7 Use the Multiple Item Clipboard; title: Lesson 3-8 Use Undo and Redo; title: Lesson 3-9 Insert cell comments; title: Lesson 3-10 View cell comments; title: Lesson 3-11 Print cell comments; title: Lesson 3-12 Understand absolute and relative cell references; title: Lesson 3-13 Understand mixed cell references.; title: Contents note continued: Lesson 3-14 Create a template; title: What is a template?; title: Lesson 3-15 Use a template; title: Lesson 3-16 Freeze columns and rows; title: Lesson 3-17 Split the window into multiple panes; title: Lesson 3-18 Check spelling; title: Session 3 Exercise; title: Session 3 Exercise answers; title: Session Four Making Your Worksheets Look Professional; title: Session Objectives; title: Lesson 4-1 Format dates; title: Lesson 4-2 Understand date serial numbers; title: How Excel stores dates; title: The world began in 1900; title: In Excel every time is a date, and every date is a time; title: Lesson 4-3 Format numbers using built-in number formats; title: Formatting fundamentals; title: Lesson 4-4 Create custom number formats; title: Overview of custom formats; title: Lesson 4-5 Horizontally align the contents of cells; title: Lesson 4-6 Merge cells, wrap text and expand/collapse the formula bar; title: Lesson 4-7 Vertically align the contents of cells; title: Lesson 4-8 Understand themes; title: Font sets; title: Color sets; title: Effects.; title: Contents note continued: Lesson 4-9 Use cell styles and change themes; title: Lesson 4-10 Add color and gradient effects to cells; title: Lesson 4-11 Add borders and lines; title: Lesson 4-12 Create your own custom theme; title: Lesson 4-13 Create your own custom cell styles; title: Lesson 4-14 Use a master style book to merge styles; title: Lesson 4-15 Use simple conditional formatting; title: Lesson 4-16 Manage multiple conditional formats using the Rules Manager; title: Lesson 4-17 Bring data alive with visualizations; title: Lesson 4-18 Create a formula driven conditional format; title: Lesson 4-19 Insert a Sparkline into a range of cells; title: Lesson 4-20 Apply a common vertical axis and formatting to a Sparkline group; title: Lesson 4-21 Apply a date axis to a Sparkline group and format a single Sparkline; title: Lesson 4-22 Use the Format Painter; title: Lesson 4-23 Rotate text; title: Session 4 Exercise; title: Session 4 Exercise answers; title: Session Five Charts and Graphics; title: Session Objectives; title: Lesson 5-1 Create a simple chart with two clicks.; title: Contents note continued: Lesson 5-2 Move, re-size, copy and delete a chart; title: Lesson 5-3 Change the chart layout and add a data table; title: Lesson 5-4 Format chart element fills and borders; title: Lesson 5-5 Format 3-D elements and align text; title: Lesson 5-6 Move, re-size, add and delete chart elements; title: Lesson 5-7 Change a chart's source data; title: Lesson 5-8 Assign non-contiguous source data to a chart; title: Lesson 5-9 Change source data using the Select Data Source dialog tools; title: Lesson 5-10 Chart non-contiguous source data by hiding rows and columns; title: Lesson 5-11 Create a chart with numerical axis; title: Lesson 5-12 Deal with empty data points; title: Lesson 5-13 Add data labels to a chart; title: Lesson 5-14 Highlight specific data points with color and annotations; title: Lesson 5-15 Add gridlines and scale axes; title: Lesson 5-16 Emphasize data by manipulating pie charts; title: Lesson 5-17 Create a chart with two vertical axis; title: Lesson 5-18 Create a combination chart containing different chart types.; title: Contents note continued: Lesson 5-19 Add a trend line; title: Lesson 5-20 Switch chart rows/columns and add a gradient fill; title: Lesson 5-21 Create your own chart templates; title: Session 5 Exercise; title: Session 5 Exercise answers; title: Session Six Working With Multiple Worksheets and Workbooks; title: Session Objectives; title: Lesson 6-1 View the same workbook in different windows; title: Lesson 6-2 View two windows side by side and perform synchronous scrolling; title: Lesson 6-3 Duplicate worksheets within a workbook; title: Lesson 6-4 Move and copy worksheets from one workbook to another; title: Lesson 6-5 Hide and unhide a worksheet; title: Lesson 6-6 Create cross worksheet formulas; title: Lesson 6-7 Understand worksheet groups; title: Lesson 6-8 Use find and replace; title: Session 6 Exercise; title: Session 6 Exercise answers; title: Session Seven Printing Your Work; title: Session Objectives; title: Lesson 7-1 Print Preview and change paper orientation; title: Lesson 7-2 Use Page Layout view to adjust margins.; title: Contents note continued: Lesson 7-3 Use Page Setup to set margins more precisely and center the worksheet; title: Lesson 7-4 Set paper size and scale; title: Lesson 7-5 Insert, delete and preview page breaks; title: Lesson 7-6 Adjust page breaks using Page Break Preview; title: Lesson 7-7 Add auto-headers and auto-footers and set the starting page number; title: Lesson 7-8 Add custom headers and footers; title: Lesson 7-9 Specify different headers and footers for the first, odd and even pages; title: Lesson 7-10 Print only part of a worksheet; title: Lesson 7-11 Add row and column data labels and grid lines to printed output; title: Lesson 7-12 Print several selected worksheets and change the page order; title: Lesson 7-13 Suppress error messages in printouts; title: Session 7 Exercise; title: Session 7 Exercise answers.