Skip navigation

Bookboon.com Download free eBooks and textbooks

Choose a category

Excel 2016 Core Part One

Excel 2016 Core Part One
4.9 (103 reviews)
ISBN: 978-87-403-1174-7
1 edition
Pages : 151
  • Price: 129.00 kr
  • Price: €13.99
  • Price: £13.99
  • Price: ₹250
  • Price: $13.99
  • Price: 129.00 kr
  • Price: 129.00 kr

Download for FREE in 4 easy steps...

We are terribly sorry, but in order to download our books or watch our videos, you will need a browser that allows JavaScript.
After entering your email address, a confirmation email will be sent to your inbox. Please approve this email to receive our weekly eBook update. We will not share your personal information with any third party.
eLib
Unlock your organization's learning potential
See Demo

Corporate eLibrary

Discover our employee learning solutions

This is a Premium eBook

Bookboon Premium - Gain access to over 800 eBooks - without ads

You can get free access for a month to this - and 800 other books with the Premium Subscription. You can also buy the book below

  • Start a 30-day free trial. After trial: 39.99 kr p/m
  • Start a 30-day free trial. After trial: €5.99 p/m
  • Start a 30-day free trial. After trial: £4.99 p/m
  • Start a 30-day free trial. After trial: ₹299 p/m
  • Start a 30-day free trial. After trial: $3.99 p/m
  • Start a 30-day free trial. After trial: 39.99 kr p/m
  • Start a 30-day free trial. After trial: 39.99 kr p/m
eLib
Unlock your organization's learning potential
Click here!

Corporate eLibrary

Discover our employee learning solutions

About the book

  1. Description
  2. Content
  3. About the Author

Description

This user guide will take you through all the things you need to know when using Excel at a simple level.

You will learn how to:

  • Get around Excel 2016
  • Add text and numbers to spreadsheets
  • Use Autofill to copy formula and create series
  • Create a basic formula
  • Use Average Minimum and Maximum
  • Work with Worksheets
  • And much more

Content

  1. First things first
    1. Starting Excel
    2. The Excel Window
    3. The Ribbon
    4. Customizing the Quick Access toolbar
    5. Customizing the Ribbon
    6. Using Zoom
    7. Assigning shortcut keys using The Alt Key
    8. Adding values to workbook properties
    9. The Advanced Properties Dialogue box
  2. Saving
    1. Saving a Workbook for the First Time
    2. Saving Your Workbook Once It Has A Name
    3. Save as different file formats
    4. Saving Files to remote locations
    5. Maintaining backward compatibility
  3. Backstage view
    1. The Backstage View
    2. Excel Options
  4. Share the workbook with others
    1. Share with People
    2. Share with People via File Menu
    3. Share with People from within the workbook
    4. Share Via Email
    5. Open a Shared Workbook
  5. Create Worksheets and Workbooks
    1. Creating new blank workbooks
    2. Creating New Workbooks Using Templates
    3. Changing worksheet order
    4. Move or copy to a different workbook
    5. Set how many worksheets you start with
    6. Importing a .CSV file
  6. Adding data
    1. Adding Text
    2. Adding Numbers
    3. Moving Around a Spreadsheet
    4. Cursor Shapes (Mouse Shapes)
    5. Selecting Data in a Worksheet
  7. Navigating your Workbook
    1. Searching for data within a workbook
    2. Inserting hyperlinks
    3. Using Go To
    4. Using the Name Box to Navigate
  8. Workbook Views
    1. Introduction to Views
    2. Page Breaks
    3. Creating Custom Views
  9. Working with Data
    1. Cut and Paste
    2. Using Paste Special
  10. Formatting Cells and Worksheets
    1. The Font Group
    2. The Alignment Group
    3. The Number Group
    4. Wrapping Text in a Cell
    5. Format Painter
  11. Merge or Split Cells
    1. Merging Cells
    2. Merge Across
    3. Un merge Cells
  12. Headers and Footers
    1. Headers and Footers
  13. Printing Headings
    1. Print Titles
  14. Hide and Unhide Rows and Columns
    1. Hiding Columns
    2. Un hide Columns
    3. Hiding Rows
    4. Unhide Rows
  15. Page Setup Options for Worksheets
    1. Page Orientation
    2. Changing the Header and Footer Size
    3. Setting Print Scaling
  16. Print a Worksheet or a Workbook
    1. Printing
    2. Printing individual worksheets
  17. Cell Styles
    1. Apply Cell Styles
    2. Create Cell Styles
  18. Autofill
    1. Copy Data using Autofill
    2. Fill Series using Autofill
    3. Copy Formatting using Autofill
  19. Flash Fill
    1. Flash Fill
  20. Formulas
    1. Formulas Introduction
    2. How is a formula made up?
  21. Create Formulas
    1. Add, Subtract, Multiply, Divide
    2. Make Changes to Formulas in a Cell
    3. Make Changes to Formulas in the Formula Bar
    4. Using Autofill to Copy Formulas
  22. Enforce Precedence
    1. Order of Evaluation (Order of Precedence) (BODMAS)
  23. Absolute Cell References
    1. Absolute Cell References
    2. How to Create an Absolute Cell Reference
    3. Relative Cell References
  24. Basic Functions
    1. Basic Functions
    2. Using Basic functions via the Auto sum Button
  25. Managing Worksheets and Workbooks
    1. Introduction Worksheets
  26. Create and format worksheets
    1. Adding worksheets to existing workbooks
    2. Delete Worksheets
    3. Copying and moving worksheets
    4. Rename a Worksheet
    5. Grouping Worksheets
    6. Changing worksheet tab colour
    7. Hiding worksheets
    8. Sum across Worksheets
  27. Manipulate window views
    1. Splitting the window
    2. Open Two Copies of the Same Workbook

About the Author

Shelley Fishel has more than a dozen years’ experience in helping people to get more from their computers. After working for an IT training organization Shelley decided to ‘do her own thing’ when she realized the limitations of delivering standard courses.

“Why waste time and money on training people in areas that are not relevant to them? It’s common sense to invest that time and effort on what they really need.”

That was the ‘light bulb moment’ and the IT Training Surgery’s unique approach has resulted in a growing business with a team of highly qualified IT trainers.

“If trainees get bored they forget most of what they learn. We like to offer a range of training approaches to suit different people and, most of all; we aim to make training fun!”

Shelley and her team have worked hard to achieve accreditation by the Learning and Performance Institute for the IT Training Surgery, as a recognized high quality provider of IT training,

To find out more about our training give us a call on 020 8203 1774 or visit our website www.theittrainingsurgery.com

This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.