Learn Excel 2007 Essential Skills with The Smart Method: Courseware tutorial for self-instruction to beginner and intermediate level - Brossura

Smart, Mike

Brossura

ISBN 10: 0955459915 ISBN 13: 9780955459917

Casa editrice: The Smart Method Ltd, 2008

Riassunto

Is this the right Excel 2007 book for you?

This Excel 2007 book was written for one purpose: to provide a 100% effective way to teach Excel 2007 skills to new learners with little or no past exposure to Excel. Excel 2007 is a huge application with thousands of features. It could take months, or even years of study to master every one of them. But there's some really good news!

The big secret is that office workers who use Excel 2007 every day for a living only use a small part of Excel's huge feature set. The great news is that, in general, they tend to all use the same set of features. This book makes it easy for absolutely anybody to very rapidly learn Excel 2007 to a standard that will greatly impress most employers - because it will focus your time and energy upon learning the right features.

Mike Smart has personally taught classroom courses, all over the world, for many of the world's largest companies. Mike has run courses for bankers, engineers, accountants, teachers, broadcasters, retailers, insurance brokers, telecom workers, offshore oil workers, power companies... and for many other professions. (Click on the back book cover above to see some of the companies Mike has helped). He has a unique insight into exactly which Excel features you need to know to describe yourself as a competent Excel user. This book will teach you all of those skills.

In this Essential Skills book you'll learn to create beautiful and functional Excel workbooks that will really make you stand out above your co-workers. Click on the front book cover above to see an example of an impressive worksheet that would be beyond the ability of most Excel users. After completing this course you'll be able to create worksheets that are just as professional in a matter of moments. Use Amazon's Look Inside feature to examine the book's table of contents. You'll have all of the Excel skills listed there when you have finished this book.

Absolutely anybody can master Excel using this book

By focusing only on the skills that are commonly used in the workplace it becomes possible to teach these carefully selected, most important features in depth, and in a simple way that absolutely anybody can understand.

And you'll learn all of those skills in only 300 pages without overwhelming you with hundreds of pages of information about Excel's less used features.

Mike's Excel 2007 Expert Skills book comprehensively teaches the rarer Excel skills that less than 10% of Excel users typically master (and many office workers will not have a need for). See the Excel 2007 Expert Skills book description here on Amazon for more information about this follow-on book.

Not just a book but a professional course

It isn't possible to write a course in the same way you would write a novel. Pages cannot all flow in an endless jumble of information (though they do in many other Excel books). To teach (and to learn) effectively every teacher knows that it is necessary to carefully plan a series of lessons. Each lesson must teach a single carefully defined objective.

This book was designed from the outset as a learning resource and is the same book that Mike uses to teach his classroom courses. It is also the text book of choice for schools, colleges, universities, corporations and government departments to teach their students and employees excellent Excel skills.

The unique layout of this book makes it perfect for both self-instruction and teaching. The book presents each self-contained lesson on two facing pages. Try Amazon's Look Inside feature above to look at a typical lesson. You'll quickly appreciate the immense value of this approach.

Su questo libro

L'autore

Mike Smart is the founder and CEO of The Smart Method.  In Mike's long career as an IT consultant, Mike specified, designed and delivered IT solutions for large corporations all over the world.  In 2002 Mike decided to specialize in IT training and founded The Smart Method.

Mike has personally taught classroom Excel courses to delegates from many of the world's largest companies in England, Europe and America. Mike has run courses for bankers, engineers, accountants, teachers, broadcasters, retailers, insurance brokers, aircraft manufacturers, government departments, on-line gaming companies, telecom workers, oil workers, car manufactures, power companies... and for many other professions. This has given him a unique insight into the diverse ways in which Excel is used by both large and small businesses.

By carefully observing the areas that students find the most difficult to understand, Mike has constantly refined his Smart Method teaching technique over a period of more than ten years.

In 2008 Mike realized that he could only ever teach a few thousand students in his classroom courses but could help millions of students by producing his Excel courses in book form. His first Excel books (covering Excel 2007) rapidly became best sellers and his books have topped best seller lists ever since.

In his spare time, Mike enjoys playing jazz piano, riding his motorbike and sliding down snowy mountains on two wooden sticks.

Contenuti

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

Dettagli dell?edizione

• Editore: The Smart Method Ltd
• Data di pubblicazione: 2008
• ISBN 10: 0955459915
• ISBN 13: 9780955459917
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 300