What you'll learn

Discover new and improved features in Excel 2016.
How to effectively use Excel 2016 on a touchscreen device.
How create, save, and open a workbook.
Learn how to personalize your use of Excel using Excel Options.
How to use and how to customize the Quick Access Toolbar.
Complete data entry, cell formatting, working with multiple worksheets and the "Ribbon" interface.
The basics of entering and editing data in a workbook.
Discover how to format dates and numbers.
Learn practical methods in which you can backup and recover your Excel spreadsheets.
Effectively use autofill and flashfill so you are more productive.
Discover the essentials of using fomulas and functions.
How to rename, insert, move, and reference an Excel 2016 worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
How to protect and secure your Excel data

Requirements

Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.

Description

**Course includes downloadable project files and quizzes to test your knowledge as well as LIFETIME access**Why Simon Sez IT for Excel?We know Excel. We've been teaching it for over 10 years and your expert instructor Toby has taught thousands of people to learn Microsoft products.We don't rush through content. We take the time to ensure you understand important principles before moving on.Follow along. We provide downloadable practice files so you can practice as you learn.Customer reviewsHere's what our students are saying about us:★★★★★ "I bought the course because I wanted to learn more about the use of Excel to assist me in my job. So far, I am very happy with the instructions. They are very detailed and easy to follow. I am able to pause to make notes and rewind if needed. I have used Excel with basic knowledge of the system, but I feel that when I am done with this course I will be able to create better spreadsheets and documents." -Doris Santangelo ★★★★★ "I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For the monetary investment, this is a great course for beginners." -David F. Wilson ★★★★★ "I have been using Excel for some time and this course has shown me just how much I did not know or was unaware of. A terrific learning experience. Thanks for the opportunity!" -Allan Thomson ★★★★★ "I enjoyed to course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you." -John Brown ★★★★★ "Course is well done and since you can go back and review at any time or after the course is done is helpful for us slow learners." -Rick ClarkeMaster Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video CourseLearn to navigate Excel 2016Learn what's new in Excel 2016Learn how to navigate and personalize Excel for your needsLearn to enter and edit dataLearn to create amazing looking charts and graphs from tables of dataLearn how a function and formula worksLearn to protect and secure your data in ExcelLearn how Excel categorizes and handles dates and other number formattingLearn to use the fill handle and flash fillLearn essential Excel formulas such as VLOOKUP, IF, SUMIF, COUNTIF and so many moreLearn to clean, filter and sort your data to perform basic data analysisLearn to create beautiful, color coded spreadsheets using Conditional FormattingLearn how to safely share a workbook.Excel 2016 From The BeginningThis course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer, Toby, will start at the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you'll be using Excel 2016 like a pro with advanced functions. At Simon Sez IT we know Excel and we know learning it can't be rushed, so we take the time to explain how everything works. This is an in-depth introduction to the world's most powerful spreadsheeting software, not a quick walk through. If other Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process.Contents and

Overview

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. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 32 chapters of video lessons and 9 exercise files to gradually become a proficient user. 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 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, fill and series, and printing your projects. We also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.Upon completion of this course you will know the essentials of Microsoft Excel 2016. ** Updated July 2017. English close captions added** Updated February 2016. Course transcripts now available.

Overview

Section 1: Introduction
Lecture 1 Acquiring Excel 2016 and Information on Installation and Upgrade
Lecture 2 WATCH ME: Essential Information for a Successful Training Experience
Lecture 3 DOWNLOAD ME: Course Exercise Files
Lecture 4 DOWNLOAD ME: Course Demo Files
Lecture 5 Downloadable Course Transcripts
Lecture 6 Free Keyboard Shortcut Guides
Section 2: What's New
Lecture 7 New and Improved Features in Excel 2016
Section 3: Using Touch
Lecture 8

Overview

of Principles of Using Touchscreen
Section 4: Getting Started
Lecture 9 Creating and Saving a Workbook
Lecture 10 Opening a Workbook
Section 5: Using Help
Lecture 11 Online Help and Contextual Help
Section 6: Excel Options
Lecture 12 Personalizing your use of Excel
Section 7: The Ribbon and Toolbars
Lecture 13 Basics of using the Ribbon
Lecture 14 Quick Access Toolbar
Lecture 15 Tell Me Feature
Lecture 16 Mini Toolbars and Contextual Menus
Lecture 17 Status Bar
Section 8: Entering and Editing Data
Lecture 18 Basics of Entering and Editing Data in a Workbook
Lecture 19 Exercise 01
Lecture 20 Formatting Dates
Lecture 21 Formatting Numbers
Lecture 22 Exercise 02
Section 9: Backup and Recovery
Lecture 23 AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Section 10: Fill and Series
Lecture 24 Working with Fill and Series
Lecture 25 Flash Fill
Section 11: Viewing and Printing
Lecture 26 Workbook Views, Zoom, and Freeze
Lecture 27 Printing
Lecture 28 Exercise 03
Section 12: Cut, Copy, and Paste
Lecture 29 Methods of Cutting, Copying, and Pasting
Section 13: Formatting a Worksheet
Lecture 30 Delete and Clear
Lecture 31 Insert, Hide, Column Width and Row Height, and Merge
Lecture 32 Alignment
Lecture 33 Themes and Styles
Lecture 34 Exercise 04
Section 14: Formulas and Functions
Lecture 35 Course review
Lecture 36 Basics of Fomulas and Functions
Lecture 37 Complex Examples of Formulas
Lecture 38 Exercise 05
Section 15: Managing Worksheets
Lecture 39 Rename, Insert, Move, and Reference a Worksheet
Section 16: Working with Multiple Workbooks
Lecture 40 Working with Multiple Workbooks
Section 17: Saving Workbooks
Lecture 41 Saving in Different File Types
Section 18: Proofing
Lecture 42 The Spell Checker
Section 19: Inserting Comments
Lecture 43 Inserting Comments
Lecture 44 Exercise 06
Section 20: Basic Functions in Excel
Lecture 45 The VLOOKUP Function
Lecture 46 Text Functions
Lecture 47 Date and Time Functions
Lecture 48 Logical Functions
Section 21: Graphs and Charts
Lecture 49 Creating Graphs and Charts
Lecture 50 Customizing a Cluster Column Chart
Lecture 51 Customizing a Pie Chart
Lecture 52 New Chart Types in Excel 2016
Lecture 53 Exercise 07
Section 22: Sorting and Filtering Data
Lecture 54 Managing Data by Sorting
Lecture 55 Managing Date by Filtering
Lecture 56 Customizing Tables
Section 23: Shapes and Pictures
Lecture 57 Inserting Shapes and Pictures
Lecture 58 Exercise 08
Section 24: Formatting Cells Based on Content
Lecture 59 Conditional Formatting
Section 25: Protection and Security
Lecture 60 Protecting Worksheets
Lecture 61 Protecting Workbooks
Section 26: Naming Items
Lecture 62 Giving Items Names
Lecture 63 Exercise 09
Section 27: Finding and Replacing Words
Lecture 64 Find and Replace
Section 28: Borders
Lecture 65 Adding Borders
Section 29: Workbook Inspection
Lecture 66 Inspecting a Workbook
Section 30: Privacy Options
Lecture 67 Trust Center Privacy Options
Section 31: Sharing Options
Lecture 68 Sharing a Workbook
Section 32: Wrap Up
Lecture 69 Closing
Lecture 70 Printable List of Excel 2016 Keyboard Shortcuts
Section 33: Extras
Lecture 71 EXTRA LESSON: Designing Better Spreadsheets Webinar Recording
Lecture 72 EXTRA LESSON: Data Cleaning in Excel Webinar Recording
Lecture 73 EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording
Lecture 74 EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
Section 34: Additional Training
Lecture 75 READ ME: This Additional Training Is Optional
Lecture 76 Ten Excel Tips and Tricks - Part 1
Lecture 77 Ten Excel Tips and Tricks - Part 2
Lecture 78 Ten Excel Tips and Tricks - Part 3
Those new to using Microsoft Excel 2016.,No previous knowledge of Excel required. This course is created for absolute beginners.,If you want to refresh your memory and understanding of Excel.,Users of earlier versions of Excel looking to update their skills.


Homepage:

https://www.udemy.com/course/microsoft-excel-2016-for-beginners/