2015
O'Reilly Media
Guy Vaccaro
5:30
English
In this Learning Microsoft Excel 2016 for Mac training course, expert author Guy Vaccaro will teach you everything you need to know to be able to work in Excel 2016, including managing your own workbooks, formatting worksheets, and creating and using formulas. This course is designed for the absolute beginner, meaning no previous experience with Excel is required.
You will start by learning how to manage Excel workbooks and worksheets, including creating and saving a new workbook, saving Excel files in other formats, and using the Excel 2016 templates. From there, Guy will teach you how to enter and edit data in cells. This video tutorial also covers how to use basic mathematical operators, format worksheets, and use mathematical formulas. Finally, you will cover advanced formatting and security, including activating worksheet and workbook protection and password protecting the workbook file.
Once you have completed this computer based training course, you will have gained the knowledge necessary to manage your own workbooks and worksheets in Microsoft Excel 2016 for Mac. Working files are included, allowing you to follow along with the author throughout the lessons.
01. Your Excel 2016 Journey Starts Here
0101 Quick Introduction To The New Excel 2016 Interface
0102 Do I Need A Microsoft Account?
0103 About Your Author
0104 Using The Included Working Files
0105 How To Access Your Working Files
02. Managing Excel Workbooks And Worksheets
0101 Creating And Saving A New Workbook
0102 Opening And Closing Workbooks
0103 Saving And Opening Excel Files To And From OneDrive And iCloud
0104 Saving Excel Files In Other Formats
0105 Adding, Deleting, Moving, And Copying Worksheets
0106 Using The Excel 2016 Templates
03. Entering And Editing Data In Cells
0301 Entering Text, Numbers, And Dates
0302 Editing The Contents Of Cells
0303 Undo And Redo Your Actions
0304 Cut, Copy, And Paste
0305 Drag And Dropping Cells
0306 The Fill Handle
0307 Inserting And Deleting Rows And Columns
0308 Changing Column Widths And Row Heights
0309 Hiding And Unhiding Rows, Columns And Sheets
0310 Searching For Values In A Workbook
04. Math Basics
0401 Getting Started With Basic Mathematical Operators
0402 Order Of Operation With BODMAS
0403 Introduction To Basic Formula
0404 The New Formula Builder And Quick SUMs
0405 Copying Formula And Functions
0406 Displaying Formulae On A Worksheet
05. Formatting Worksheets
0501 Selecting Cells For Formatting
0502 Modifying Typeface, Font Size And Colors
0503 Cell Alignment, Orientation And Merging
0504 Using Number Formats
0505 Adding And Removing Borders
0506 Applying Date Formats To Cells
0507 Format Painter And Fill Formatting
0508 Clearing Cell Contents And Formatting
06. Page Setup And Printing
0601 Paper Size, Margins, Orientation And Scaling
0602 Using A Print Area And Printing Titles
0603 Using The Page Break Tools
0604 Creating Headers And Footers - Method 1
0605 Creating Headers And Footers - Method 2
0606 Other Print Options And Checking Spelling
0607 Generating A PDF From A Worksheet
07. Mathematical Formulas
0701 The SUM Function
0702 Other Mathematical Functions - AVERAGE, MIN And MAX
0703 Useful Count Functions
0704 Averages, Mean, Mode, And Median
0705 Using PI In Formula
0706 Absolute Referencing Explained
0707 Formulas Across Worksheets
0708 3D Referencing
0709 Making Use Of Named Ranges
0710 Dates, Shapes, And Formula
0711 IF Statements
08. Advanced Formatting
0801 Adding, Editing, Deleting, And Printing Comments
0802 Creating Your Own Custom List
0803 Converting To A Table For Formatting
09. Security
0901 Activate And Deactivate Worksheet And Workbook Protection
0902 Protecting Part Of A Worksheet To Aid Data Entry
0903 Password Protecting The Workbook File
10. Excel 2016 Summary
1001 What You Have Learned
Download File Size:939.88 MB
|
