Microsoft Excel 2016 for Beginners: Master the Essentials

Microsoft Excel 2016 for Beginners: Master the Essentials

194 Enrolled
9 Hours
Deal Price$15.00
Suggested Price
$100.00
You save 85%
Microsoft Excel 2016 for Beginners: Master the Essentials
$15.00$100.0085% OFF
Microsoft Excel 2016 for Beginners

65 Lessons (9h)

  • Introduction
    Acquiring Excel 2016 and Information on Installation and Upgrade12:02
    Exercise Files2:28
    Course exercise files
    Course demo files
  • What's New
    New and Improved Features in Excel 20162:55
  • Using Touch
    Overview of Principles of Using Touchscreen5:36
  • Getting Started
    Creating and Saving a Workbook15:16
    Opening a Workbook10:13
  • Using Help
    Online Help and Contextual Help6:27
  • Excel Options
    Personalizing your use of Excel10:50
  • The Ribbon and Toolbars
    Basics of using the Ribbon14:56
    Quick Access Toolbar5:45
    Tell Me Feature6:49
    Mini Toolbars and Contextual Menus3:47
    Status Bar5:02
  • Entering and Editing Data
    Basics of Entering and Editing Data in a Workbook13:29
    Exercise 011:50
    Formatting Dates12:36
    Formatting Numbers13:48
    Exercise 021:43
  • Backup and Recovery
    AutoSave, Recover Unsaved Workbook, and Create a Backup Copy7:35
  • Fill and Series
    Working with Fill and Series9:09
    Flash Fill4:04
  • Viewing and Printing
    Workbook Views, Zoom, and Freeze8:41
    Printing14:30
    Exercise 032:56
  • Cut, Copy, and Paste
    Methods of Cutting, Copying, and Pasting13:32
  • Formatting a Worksheet
    Delete and Clear13:45
    Insert, Hide, Column Width and Row Height, and Merge12:46
    Alignment12:05
    Themes and Styles11:19
    Exercise 041:44
  • Formulas and Functions
    Basics of Fomulas and Functions11:15
    Complex Examples of Formulas13:36
    Exercise 053:26
  • Managing Worksheets
    Rename, Insert, Move, and Reference a Worksheet8:40
  • Working with Multiple Workbooks
    Working with Multiple Workbooks15:48
  • Saving Workbooks
    Saving in Different File Types12:59
  • Proofing
    The Spell Checker13:11
  • Inserting Comments
    Inserting Comments4:54
    Exercise 063:02
  • Basic Functions in Excel
    The VLOOKUP Function14:07
    Text Functions8:17
    Date and Time Functions6:47
    Logical Functions15:51
  • Graphs and Charts
    Creating Graphs and Charts12:10
    Customizing a Cluster Column Chart15:42
    Customizing a Pie Chart13:36
    New Chart Types in Excel 20162:01
    Exercise 72:28
  • Sorting and Filtering Data
    Managing Data by Sorting9:39
    Managing Date by Filtering11:59
    Customizing Tables13:23
  • Shapes and Pictures
    Inserting Shapes and Pictures15:00
    Exercise 080:47
  • Formatting Cells Based on Content
    Conditional Formatting15:32
  • Protection and Security
    Protecting Worksheets9:36
    Protecting Workbooks10:21
  • Naming Items
    Giving Items Names6:31
    Exercise 090:47
  • Finding and Replacing Words
    Find and Replace7:10
  • Borders
    Adding Borders10:44
  • Workbook Inspection
    Inspecting a Workbook6:08
  • Privacy Options
    Trust Center Privacy Options5:46
  • Sharing Options
    Sharing a Workbook8:30
  • Conclusion
    Course Conclusion and Closing0:56
  • Course Quiz
    Microsoft Excel 2016 Quiz
Microsoft Excel 2016 for Beginners: Master the Essentials
$15.00$100.0085% OFF
View similar items
DescriptionInstructorImportant DetailsRelated Products

Master the Essentials of Microsoft Excel 2016 in This Easy-to-Follow Course

S
SimonSezItSince 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Description

Microsoft Excel 2016 is the newest, most advanced version of the world's leading spreadsheet software. This course assumes you have never worked with any version of Excel, and will take you from a complete beginner to a wizard with the most up-to-date features available. By course's end, you'll have a valuable new bullet point on your resume.

  • Access 65 lectures & 9 hours of content 24/7
  • Install & run Microsoft Excel 2016 for the first time
  • Use Touchscreen, open a Workbook, & use Help to get additional answers when you need them
  • Personalize Excel for your own use
  • Discuss all Ribbons & Toolbars, entering & editing data, backup & recovery, & more
  • Practice w/ included exercise files

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Compatibility

  • Internet required

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...