Categories Corporate
Professional eBook

Excel 2016 Introduction

(63 ratings)
2 reviews
223
Language:  English
This manual should be used as a point of reference following attendance of the introductory level Excel 2016 training course.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Få åtkomst till boken på vår läsplatta. Ingen reklam i boken.
Description
Content
Reviews

This manual should be used as a point of reference following attendance of the introductory level Excel 2016 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.

It may also be used as a self-help tutorial following the sections in the order presented will allow the user to build their skills in a logical fashion and by the end of this manual allow them to use Excel in a reasonably competent fashion.

The manual is divided into sections, each section covering an aspect of the introductory course. The table of contents lists the page numbers of each section and the table of figures indicates the pages containing tables and diagrams. It is suggested that new users follow the order of topics as listed to allow them to build their skills in a logical fashion.

  1. Introduction
    1. How to use this guide
  2. The basics
    1. Window elements
    2. Getting help
  3. Basic movement and usage
    1. Movement
    2. Data entry
    3. Editing
    4. Selection
  4. Formulae and functions
    1. Formulae
    2. Functions
    3. Absolute and relative references
  5. File operations
    1. Working with files
  6. Moving and copying data
    1. Cut, copy and paste
    2. Moving and copying between files
  7. Formatting
    1. Font group formats
    2. Number group formats
    3. Format cells dialog
    4. Formatting columns and rows
    5. Insert and delete cells, rows, columns or sheets
  8. Names
    1. Naming cells and ranges
    2. Name box
  9. Working with sheets
    1. Working with individual worksheets
    2. working with multiple sheets
    3. Protect worksheet data
    4. Views and windows tools
    5. Useful tools for large sheets
    6. Advanced navigation
  10. Printing
    1. Printing options
    2. Printing data (file print)
    3. Views
    4. Page set up dialog
    5. Margins tab
    6. Header/footer tab
    7. New methods for headers and footers in 2016
  11. Customising Excel
    1. Set Excel options
It is very Informative and helpful. Thank You
Nem og overskuelig.
More reviews
About the Author

Stephen Moffat, The Mouse Training Company