O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning Microsoft Excel 2016

Video Description

In this Learning Microsoft Excel 2016 training course, expert author Guy Vaccaro will teach you everything you need to know to begin creating and managing spreadsheets in Excel 2016. This course is designed for the absolute beginner, meaning no experience with Excel is required.

You will start by learning how to manage workbooks and worksheets, then jump into learning how to enter and edit data in cells. From there, Guy will teach you about formulas and functions, formatting, and page setup and printing. This video tutorial will also cover workbook and worksheet management, mathematical formulas, security, and charts in detail. Finally, you will learn about advanced formulas, including using an IF formula, text manipulation using functions, and date manipulation functions.

Once you have completed this computer based training course, you will have learned everything you need to know to be able to create and manage spreadsheets in Microsoft Excel 2016. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents

  1. Start Here
    1. Get Started With Excel 2016 00:08:14
    2. New: Tell Me Feature 00:05:05
    3. Excel Workbook And Worksheets 00:05:57
    4. Customizing Color Schemes And Quick Toolbar 00:05:06
    5. Using The Included Working Files 00:02:18
    6. About The Author 00:01:29
    7. How To Access Your Working Files 00:01:15
  2. Managing Workbooks And Worksheets
    1. Creating And Saving New Workbooks 00:05:46
    2. Opening Workbooks And Save As Options 00:05:37
    3. Saving And Opening Onedrive Files 00:04:33
    4. Navigating An Excel Workbook 00:05:55
    5. Adding Removing And Renaming Worksheets 00:07:26
    6. Using The 2016 Templates 00:05:31
  3. Entering And Editing Data In Cells
    1. Entering And Editing Text Numbers And Dates 00:08:47
    2. Cut Copy Paste Vs Drag And Drop 00:07:39
    3. Special Features Of The Fill Handle 00:09:31
    4. Managing Columns And Rows 00:09:46
    5. Searching Within A Worksheet Workbook 00:07:22
  4. Math: The Basics
    1. Normal Mathematic Operators 00:10:07
    2. Starting With Basic Functions 00:09:05
    3. Copying Formula 00:06:54
    4. Displaying Formula And Functions 00:04:58
  5. Formatting
    1. Cell And Range Selection 00:06:59
    2. Modifying Typeface Size Colors 00:07:52
    3. Number Formats Alignment And Orientation 00:08:29
    4. Merging And Wrapping Cell Contents 00:05:48
    5. Cell Borders 00:06:23
    6. Applying Editing Date Formats 00:06:15
    7. The Format Painter 00:06:39
    8. Clearing Finding And Replacing Formatting 00:03:59
  6. Workbook And Worksheet Management
    1. Worksheet Navigating Copying Moving And Tab Color 00:07:31
    2. Side By Side Comparison Of Worksheets 00:03:48
    3. Modifying More Than One Sheet At A Time 00:07:31
  7. Page Setup And Printing
    1. Controlling Print And Screen Headings 00:04:48
    2. Orientation Margins And Scaling 00:06:02
    3. Headers And Footers 00:06:43
    4. Using Page Break And Page Layout Views Effectively 00:06:27
    5. Printing Parts Of A Worksheet 00:04:37
    6. Spellchecking And Smart Lookup 00:05:26
  8. Mathematical Formulas
    1. The Sum Function 00:06:15
    2. Other Mathematical Functions Average Min Max 00:06:25
    3. Various Count Functions 00:03:50
    4. Absolute Referencing 00:06:16
    5. Formula Across Multiple Sheets 00:08:52
    6. 3D Referencing In Action 00:09:35
    7. The Advantages Of Named Cells And Ranges 00:07:32
  9. Security
    1. Protection Of Whole Or Part Worksheets 00:07:15
    2. Protection For The Whole Excel Workbook 00:05:54
  10. Charts In Excel
    1. Using The Recommended Charts Option 00:06:41
    2. Create A Chart Quickly Or Slowly 00:05:58
    3. Formatting A Chart 00:05:49
    4. Modifying The Chart Type 00:05:12
    5. Formatting Chart Elements 00:07:14
    6. Adding A Trendline 00:06:37
    7. The Pie Chart 00:07:40
    8. Sparklines Mini Charts 00:06:24
    9. The New Forecast Sheet 00:04:53
    10. New To 2016 Chart Types 00:09:11
  11. Graphics Objects
    1. Inserting And Enhancing Images 00:05:50
    2. Inserting Shapes And Screenshots 00:08:19
    3. Using SmartArt Graphics 00:08:54
    4. Formatting Graphical Objects 00:05:26
    5. Stacking Grouping And Flowcharts 00:08:15
    6. A Mathematical Formula With A Graphic Object 00:03:33
  12. Excel As A Database
    1. Fixing Onscreen And In Print Rows And Columns 00:05:36
    2. Sorting Data 00:06:59
    3. Filter Data To Reduce Dataset Size 00:07:49
    4. Removing Duplicate Entries 00:03:08
    5. Using Subtotals In A Worksheet Of Data 00:07:07
    6. Using Text To Columns 00:06:02
    7. The New Get And Transform For Using Web Data 00:05:35
  13. Advanced Formula
    1. Using An IF Formula 00:06:55
    2. New IFs For Multiple Criteria 00:05:31
    3. DATEDIF A Useful Hidden Function 00:07:25
    4. Text Manipulation Functions 00:08:36
    5. Use Of Text To Format Numbers 00:05:00
    6. Date Manipulation Functions 00:05:45
    7. Introducing SUMIF COUNTIF AVERAGEIF 00:08:51
    8. Use Of Rank To Calculate Placings 00:08:06
    9. Flash Fill The Magic Touch 00:05:26
  14. What's Next
    1. Office Apps For Excel 2016 00:05:41
    2. Are You Ready To Go Advanced 00:03:02