Site map with links to Microsoft Excel classroom delivered Excel training courses, free tutorial, programming standard and log in area

info@LearnMicrosoftExcel.com Home Site Map Free Tutorials With Video Buy The Book Classroom Courses Contact Site Map Feedback Click here to provide feedback on our books or the free tutorial Book-owners support files Book-owners log-in Book-owners sample file download page General Home   Contact   Buy A Book - order a book here       Learn Excel 2007 Essential Skills with The Smart Method           Table of Contents          View front cover       View rear cover         Learn Excel 2007 Expert Skills with The Smart Method              Table of Contents         View front cover        View rear cover    Training Course Prices and Training Centre Locations Main quotation page - get a price quote or book a course anywhere in the world in five clicks Free Tutorial Learn Excel 2007 with The Smart Method       Free tutorials        Introduction             Contents            Contents as PDF file (recommended over HTML)            How to Use This Course - Important Information            How to use this course as PDF file (recommended over HTML)      Session 1:  Basic Skills           Sample Files           Entire Session 1 as PDF File (recommended over HTML below)           Session Objectives           Lesson 1 1: Start Excel and check your program version           Lesson 1 2: Maximize, minimize, re-size, move, close and zoom 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, remove and navigate worksheet tabs           Lesson 1 8: Use the Ribbon           Lesson 1 9: Understand Ribbon components           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           Sample Files           Entire Session 2 as PDF file (recommended over HTML)           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 into 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: Use AutoSum to sum a non-contiguous range and re-size a column             Lesson 2 9: Use AutoSum to quickly calculate averages           Lesson 2 10: Create your own formulas             Lesson 2 11: Create functions using Formula AutoComplete             Lesson 2 12: Use AutoFill for text and numeric series           Lesson 2 13: Use AutoFill to adjust formulas           Lesson 2 14: Use AutoFill Options           Lesson 2 15: Speed up your Auto Fills and create a custom fill series           Lesson 2 16: Use the zoom control             Lesson 2 17: Print out a worksheet             Session 2: Exercise           Session 2 Exercise Answers             Session 2: Endpiece All material on this web site © Copyright 2008 The Smart Method Limited, All Rights Reserved.  Designed and maintained by Miriad Web Design