Book Image

Microsoft Excel Beginners 2016 [Video]

By : Simon Sez IT
Book Image

Microsoft Excel Beginners 2016 [Video]

By: Simon Sez IT

Overview of this book

This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you at the very beginning: installing the program, creating your first workbook, and entering data. Before you know it, you'll be using Excel 2016 like a pro, including its advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business. This course starts with where to find Microsoft Excel and installing the program. Then you learn, step-by-step, simple 1-2-3 methods for getting up-and-running with Excel 2016. It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation, we discuss what is new with 2016, using the touchscreen, opening a workbook, and how to use Help to get additional answers when you need them. Then we show you how to personalize Excel for your own use with exciting Excel options. We discuss all the ribbons and toolbars, entering and editing data, backup and recovery, fills and series, and printing your projects. We also work with worksheets and formulas/functions. Upon completion of this course, you will know the essentials of Microsoft Excel 2016. All the codes and supporting files for this course are available at:https://github.com/PacktPublishing/Microsoft-Excel-Beginners-2016
Table of Contents (32 chapters)
15
Managing Worksheets
16
Working with Multiple Workbooks
17
Saving Workbooks
18
Proofing
19
Inserting Comments
24
Formatting Cells Based on Content
25
Protection and Security
27
Finding and Replacing Words
28
Borders
29
Workbook Inspection
30
Privacy Options
31
Sharing Options
32
Conclusion
Chapter 26
Naming Items
Content Locked
Section 1
Giving Items Names
Naming Items: Giving Items Names