0121 323 2304 info@softext.co.uk
payment
microsoft-office-training-manual
  • microsoft-office-training-manual

Microsoft Excel Training Manuals

£21.00£69.00 £25.20

Clear
  • Description
  • Topics Covered

Product Description

Microsoft Excel Training Manuals

Using our Microsoft Excel training materials Learn step by step how to use and understand the Software.
Get the skills and knowledge you need to use Excel and get the maximum benefit from it.

Available in various levels covering Beginners, Intermediate and Advanced. (2003, 2007, 2010, 2013 and 2016)

We highly advise that the version training manual matches the Word version you are using.

So, who are they for?

We provide Microsoft Excel training courseware for individuals, Colleges, Universities and Training Providers. They have been written to be used in the classroom, in house and self-study environment.
Our Microsoft Excel manuals will teach step by step how to use and understand Microsoft Excel.

The manuals use an installer which contain exercise files for you use to work through the course.

Features

  • Easy to use and understand
  • Used by individuals and Training organisations
  • Contains exercise files to use throughout the manual
  • Printed A4 spiral bound
  • Custom Covers option (extra fees apply)

Training Providers

Custom Covers
Add your own branding. Simply send us an A4 pdf/word file and we will add this to the front cover of any order you require. As standard the manuals are delivered with our covers or in plain white format. * extra fees apply for own covers.

Custom Manuals
Create your own bespoke manuals to match your course. Choose the chapters/tasks you require and we will create the manual for you. There would be a one off fee to create the custom course and an agreed fixed price for printing. Contact us for more details

 

Microsoft Excel Beginners Contents

Contents

  1. Before You Start
  2. What is a Spreadsheet Program?
  3. Getting Started with Microsoft Excel
  4. Workbook Windows and Views
  5. Basic Spreadsheet Skills
  6. Using the Help System
  7. Opening, Saving and Closing Workbooks
  8. Workbook File Formats
  9. Creating New Workbooks
  10. Selecting Cells
  11. Cell Referencing
  12. Auto Sum and Auto Fill
  13. Formatting Numbers
  14. Formatting Cells
  15. Cell Alignment
  16. Cells, Rows and Columns
  17. Working with Worksheets
  18. Edit, Copy and Move Cells
  19. Proofing Workbooks
  20. Page Layout
  21. Printing and Previewing Worksheets
  22. Basic Options
  23. E-Mailing Workbooks

Microsoft Excel Intermediate Contents

Contents

  1. Before You Start
  2. Defined Names
  3. Sort Data and Remove Duplicates
  4. Excel Tables
  5. Chart Basics
  6. Chart Design
  7. Chart Layout
  8. Chart Format
  9. More About Charts
  10. Introduction to Functions
  11. Date Functions
  12. Logical Functions
  13. Information Functions
  14. Financial Functions
  15. Find and Replace
  16. Headers and Footers
  17. Adding Comments
  18. Conditional Formatting

Microsoft Excel Advanced Contents

Contents

  1. Before You Start
  2. Text to Columns
  3. Paste Special
  4. Data Validation
  5. Subtotals and Grouping
  6. Consolidate Data
  7. What-if Analysis – Data Tables
  8. What-if Analysis – Scenarios
  9. What-if Analysis – Goal Seek
  10. Text Functions
  11. Lookup Functions
  12. Maths and Trig Functions
  13. Statistical Functions
  14. Database Functions
  15. Formula Auditing and Error Tracing
  16. Linking Data
  17. Hyperlinks
  18. Getting External Data
  19. Pivot Tables and Pivot Charts
  20. Protecting and Sharing Worksheets and Workbooks
  21. Workbook Properties and Inspection
  22. Encrypting and Finalising Workbooks
  23. An Introduction to Macros
  24. Illustrations, Text Boxes and WordArt
  25. Custom Number Formats
  26. Custom Lists
  27. Working with Templates
  28. Tracking Changes
  29. Compare and Merge Workbooks