The Ultimate Microsoft Excel 2013 & 2016 Mastery Course

Master Microsoft Excel 2013 and 2016 The Easy Way - On Your Schedule. 4 Courses, 37 Hours of Training.

What you'll learn
Discover new and improved features in Excel 2013 and 2016
How to effectively use Excel 2013 or 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
Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface
Tips for mouse and touch screen users
Graphs and charts using templates or custom designs
Pivot tables and slicing
Working with flash fill
Working with dates and times
Averages, percentiles, and LINEST functions
Calculating depreciation
Inserting and formatting tables
Sparklines and data bars
How to import and export data to and from Excel
Discover practical methods for financial & statistical​ Functions
Using financial functions to determine payments
Practice what you learned with included exercise files
Requirements
Microsoft Excel 2013 or 2016 desktop version for Windows installed and ready to use on your computer.
Description
Learn Microsoft Excel 2013 & 2016 Inside and Out with This 4 Course Training Bundle
Includes 4 Courses: The Excel 2013 & 2016 Beginner Courses & The Excel 2013 & 2016 Advanced CoursesIncludes 37-Hours of High Quality Training by Your Professional TrainerTaught by a Professional TrainerPractice Along With Included Exercise FilesWatch and Learn with Demo Project Files That are IncludedProgresses Logically from Beginning to Advanced TopicsStarts Right at the Beginning with an Easy Intro to the SoftwareDeepen Your Knowledge and Master More Advanced SkillsLearn to Create Charts and GraphsCreating Charts and GraphsEffectively Create and Use Functions and FormulasImport and Export Data Create and Effectively Use Pivot TablesHow to Use Excel for Data AnalysisDiscover Practical Methods for Financial  & Statistical Functions   This bundle includes:  4 individual courses
37 hours of video tutorialsOver 200 individual video lectures
Exercise files to practice what you learnedPrintable course transcriptions to follow along and take notesCertificate of completionContents and Overview for the 9-Hour Excel 2016 Beginner Course
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.Contents and Overview for the 9-Hour Excel 2016 Advanced Course
Colorful charts, sleek graphs, and cutting-edge databases that offer
insight into financial information are a breeze when you learn the
secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced
course. That's because you'll get the tools you need to master Excel's
powerful data functions in this information-packed 9-hour video training
class.   Your expert instructor will kick the course off by leading you
through graph and chart basics. Then, you'll explore Excel's array of
detailed formatting tools and discover how to make these work for you
when graphing and charting financial information. Next, you'll explore
the roles played by trends, relationships, and differences in charts,
and how to work with sparklines for data visualization and data bars.
The course will also take you through detailed discussions of pivot
tables, bubble charts, radar charts, and more.  Contents and Overview for the 10-Hour Excel 2016 Beginner CourseImpress the people you work with by cultivating advanced spreadsheet skills. During this 10-hour training
course, you’ll learn to create Excel spreadsheets with ease. Our expert
instructor will show you Excel 2013 features to navigate you through
the program. Starting with the basics, you’ll discover how to enter and
format data in the quickest manner possible.
Next you’ll be introduced to the power of Excel’s functions and
formulas to help you calculate data and derive useful information. To
help you present it all in a visually appealing format, your instructor
will then walk you through how to create sophisticated charts and
graphs, and publish them online. Finally, you’ll learn to analyze and
review worksheets for data discrepancies so you can prevent problems
before they arise.  Turn your long lists of numbers into slick, engaging visuals that
bring data to life. Whether you need to create budgets, financial
projections, invoices, calendars, schedules, or lists, our elaborate
Excel 2013 training course will give you the skills you need to stand
out at work.  Contents and Overview for the 9-Hour Excel 2013 Advanced CourseThrough 52 lectures and over 12.5 hours of content, this course will
take you through learning how to use functions in everyday work
environments. Personal and professional financial functions are covered
including payments, future value and depreciations. Students will learn
statistical functions like averages, percentiles, and regression.In order to improve efficiency, students will also cover concepts for
connecting to external data like other workbooks or web data; tables
including style, selection and sizing. Pivot tables and data analysis
will be key concepts helpful to the work environment.For help with reporting, students will learn surface charts, stock
charts, radar charts and bubble charts and graphs. Lastly, students will
cover important web applications.Upon completion of this course, students will be able to create
colorful charts and databases that communicate data and financial
records efficiently and effectively. Students will be able to apply data
to various reporting forms like tables, graphs and pivot tables in
order to show important analysis like depreciation, percentiles and
regression for use with strategizing and planning. Students who finish
this course will have an advanced knowledge of the versatility of Excel
that is immediately applicable to their work with the database. ** Updated July 2017. English close captions added** Updated June 2017. Course transcripts now available.Here’s what our students are saying…“A comprehensive and well-structured course, and the  examples and explanations are clearly presented; and the instructor is  very engaging, easy to listen to and even entertaining (which is always a  plus for keeping one’s interest).”- Arnold Schwartz“Even though English is not my first language I can  understand every single word. Moreover, the teacher is fantastic. The  best investment for sure.”- Jesse Prestes da Silva“I have been using Excel for many years at a low intermediate level. In just the first few minutes, I am amazed at the new key combos that I have learned to make moving around the worksheets faster. Wow!”- RobDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.

Overview

Section 1: Excel 2013: Introduction to Excel 2013 Beginner Course

Lecture 1 Introduction to Excel 2013

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Excel 2013 Exercise Files

Lecture 4 Downloadable Course Transcripts

Lecture 5 What's New

Section 2: Excel 2013: Using Touch

Lecture 6 Overview of Principles

Section 3: Excel 2013: Getting Started

Lecture 7 Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns

Lecture 8 Templates; Creating, Opening, and Saving a Workbook

Section 4: Excel 2013: Help

Lecture 9 Online, Offline, and Contextual Help

Section 5: Excel 2013: Settings and Preferences

Lecture 10 Excel Options

Section 6: Excel 2013: The Ribbon and Toolbars

Lecture 11 Ribbon Interface

Lecture 12 Quick Access Toolbar

Lecture 13 Mini Toolbar

Section 7: Excel 2013: Backup and Recovery

Lecture 14 Create Backup Option; Auto-Recover and Autosave

Section 8: Excel 2013: Entering and Deleting Data

Lecture 15 Entering Text and Numbers

Lecture 16 Date Formats

Lecture 17 Formatting Cells; Editing and Deleting Data

Lecture 18 Fill

Lecture 19 Flash Fill

Section 9: Excel 2013: Formatting a Worksheet

Lecture 20 Themes and Cell Styles

Lecture 21 Inserting, Deleting, Hiding and Adjusting Rows and Columns

Lecture 22 Wrap Text and Alignment

Lecture 23 Merging Cells; Applying Themes and Styles

Lecture 24 Borders

Section 10: Excel 2013: Copy, Paste and Paste Special

Lecture 25 Copy, Cut and Paste

Section 11: Excel 2013: Proofing

Lecture 26 Spell checking

Section 12: Excel 2013: Managing Worksheets

Lecture 27 Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Section 13: Excel 2013: Comments

Lecture 28 Inserting Comments

Section 14: Excel 2013: Viewing and Printing

Lecture 29 Workbook Views, Zoom and Freeze

Lecture 30 Printing; Headers, Footers and Margins

Section 15: Excel 2013: Formulas and Functions

Lecture 31 Overview of Formulas and Functions

Lecture 32 Cell References

Lecture 33 Names

Lecture 34 Finding Errors; New Excel Functions

Section 16: Excel 2013: Working with Workbooks

Lecture 35 Multiple Workbooks and Windows; Comparing Workbooks

Section 17: Excel 2013: Find and Replace

Lecture 36 Go to; Find and Replace Options

Section 18: Excel 2013: Conditional Formatting

Lecture 37 Applying, Clearing and Managing Rules

Section 19: Excel 2013: Graphing and Charting

Lecture 38 Chart Types; Chart Recommendation

Lecture 39 Basic Formatting

Lecture 40 Selecting Data, Positioning and Printing Charts

Section 20: Excel 2013: File Types

Lecture 41 Saving Workbooks; PDF and CSV Formats

Section 21: Excel 2013: Managing Data

Lecture 42 Sorting

Lecture 43 Filtering

Lecture 44 Tables

Section 22: Excel 2013: Functions Case Study

Lecture 45 VLOOKUP

Lecture 46 Text Function

Lecture 47 Date and Time Functions

Lecture 48 Logical Functions

Section 23: Excel 2013: Analyzing Data

Lecture 49 Financial Analysis Case Study - Part 1

Lecture 50 Financial Analysis Case Study - Part 2

Lecture 51 Quick Analysis Tool

Section 24: Excel 2013: Shapes and Pictures

Lecture 52 Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Section 25: Excel 2013: Sharing and Protecting

Lecture 53 Protecting Worksheets

Lecture 54 Protecting Workbooks

Lecture 55 Sharing and SkyDrive

Section 26: Excel 2013: More Backstage View Options

Lecture 56 Trust Center; Export; Inspect Workbook

Section 27: Excel 2013: Closing

Lecture 57 Summary; More Help

Section 28: Excel 2013 Advanced: Introduction

Lecture 58 Prerequisites of Excel 2013 Advanced Course

Lecture 59 WATCH ME: Essential Information for a Successful Training Experience

Lecture 60 DOWNLOAD ME: Excel 2013 Advanced Exercise Files

Lecture 61 Downloadable Course Transcripts

Lecture 62 Course review

Section 29: Excel 2013 Advanced: Functions

Lecture 63 List of Functions; Common Types of Arguments; Basic Use of Functions

Lecture 64 Advanced Aspects of Functions; Searching for a Function

Lecture 65 Autosum

Section 30: Excel 2013 Advanced: Personal and Professional Financial Functions

Lecture 66 Payment

Lecture 67 Future Value

Lecture 68 Principle Payment

Lecture 69 Depreciations

Section 31: Excel 2013 Advanced: Date and Time Functions

Lecture 70 How Dates and Times are Stored

Lecture 71 Dates and Times Calculation

Lecture 72 Exercise on Date and Time Functions; Date and Time Settings

Section 32: Excel 2013 Advanced: Statistical Functions for Description and Prediction

Lecture 73 Average

Lecture 74 Percentile

Lecture 75 Regression

Lecture 76 LINEST Function

Lecture 77 Example of Functions for Inferential Statistics

Section 33: Excel 2013 Advanced: Text Functions

Lecture 78 Text Function Case Study - 1

Lecture 79 Text Function Case Study - 2

Section 34: Excel 2013 Advanced: Lookup Functions

Lecture 80 Lookup and Reference Functions

Section 35: Excel 2013 Advanced: Logical Functions

Lecture 81 Logical Functions

Section 36: Excel 2013 Advanced: Connecting to External Data

Lecture 82 Connecting to Other Workbooks

Lecture 83 Connecting to Access Data

Lecture 84 Connecting to Web Data

Section 37: Excel 2013 Advanced: Tables

Lecture 85 Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row

Lecture 86 Inserting Columns and Rows; Resizing Tables

Lecture 87 Table Reference

Lecture 88 Table Styles

Lecture 89 Table Selection

Section 38: Excel 2013 Advanced: Pivot Tables

Lecture 90 Basic Principles of Pivot Tables

Lecture 91 Presentational Side of Pivot Tables

Lecture 92 Filtering in Pivot Tables; Slices

Section 39: Excel 2013 Advanced: Data Analysis

Lecture 93 What if

Lecture 94 Scenario Manager

Lecture 95 Goal Seeker

Lecture 96 Solver

Section 40: Excel 2013 Advanced: Charts

Lecture 97 Area Charts

Lecture 98 Surface Charts

Lecture 99 Stock Charts - Part 1

Lecture 100 Stock Charts - Part 2

Lecture 101 Radar Charts

Lecture 102 Bubble Charts

Section 41: Excel 2013 Advanced: Graphs

Lecture 103 Regression and Scatter Chart

Section 42: Excel 2013 Advanced: Pivot Charts

Lecture 104 Creating Pivot Charts

Section 43: Excel 2013 Advanced: Sparklines

Lecture 105 Using Sparklines

Section 44: Excel 2013 Advanced: Web App

Lecture 106 Creating Workbooks using a Web App

Lecture 107 Sharing your Workbook

Section 45: Excel 2013 Advanced: Conclusion

Lecture 108 Closing

Section 46: Excel 2016: Introduction

Lecture 109 Acquiring Excel 2016 and Information on Installation and Upgrade

Lecture 110 WATCH ME: Essential Information for a Successful Training Experience

Lecture 111 DOWNLOAD ME: Excel 2016 Course Exercise and Demo Files

Lecture 112 Downloadable Course Transcripts

Lecture 113 Course exercise files

Section 47: Excel 2016: What's New

Lecture 114 New and Improved Features in Excel 2016

Section 48: Excel 2016: Using Touch

Lecture 115 Overview of Principles of Using Touchscreen

Section 49: Excel 2016: Getting Started

Lecture 116 Creating and Saving a Workbook

Lecture 117 Opening a Workbook

Section 50: Excel 2016: Using Help

Lecture 118 Online Help and Contextual Help

Section 51: Excel 2016: Excel Options

Lecture 119 Personalizing Your Use of Excel

Section 52: Excel 2016: The Ribbon and Toolbars

Lecture 120 Basics of using the Ribbon

Lecture 121 Quick Access Toolbar

Lecture 122 Tell Me Feature

Lecture 123 Mini Toolbars and Contextual Menus

Lecture 124 Status Bar

Section 53: Excel 2016: Entering and Editing Data

Lecture 125 Basics of Entering and Editing Data in a Workbook

Lecture 126 Exercise 01

Lecture 127 Formatting Dates

Lecture 128 Formatting Numbers

Lecture 129 Exercise 02

Section 54: Excel 2016: Backup and Recovery

Lecture 130 AutoSave, Recover Unsaved Workbook, and Create a Backup Copy

Section 55: Excel 2016: Fill and Series

Lecture 131 Working with Fill and Series

Lecture 132 Flash Fill

Section 56: Excel 2016: Viewing and Printing

Lecture 133 Workbook Views, Zoom, and Freeze

Lecture 134 Printing

Lecture 135 Exercise 03

Section 57: Excel 2016: Cut, Copy, and Paste

Lecture 136 Methods of Cutting, Copying, and Pasting

Section 58: Excel 2016: Formatting a Worksheet

Lecture 137 Delete and Clear

Lecture 138 Insert, Hide, Column Width and Row Height, and Merge

Lecture 139 Alignment

Lecture 140 Themes and Styles

Lecture 141 Exercise 04

Section 59: Excel 2016: Formulas and Functions

Lecture 142 Basics of Fomulas and Functions

Lecture 143 Complex Examples of Formulas

Lecture 144 Exercise 05

Section 60: Excel 2016: Managing Worksheets

Lecture 145 Rename, Insert, Move, and Reference a Worksheet

Section 61: Excel 2016: Working with Multiple Workbooks

Lecture 146 Working with Multiple Workbooks

Section 62: Excel 2016: Saving Workbooks

Lecture 147 Saving in Different File Types

Section 63: Excel 2016: Proofing

Lecture 148 The Spell Checker

Section 64: Excel 2016: Inserting Comments

Lecture 149 Inserting Comments

Lecture 150 Exercise 06

Section 65: Excel 2016: Basic Functions in Excel

Lecture 151 The VLOOKUP Function

Lecture 152 Text Functions

Lecture 153 Date and Time Functions

Lecture 154 Logical Functions

Section 66: Excel 2016: Graphs and Charts

Lecture 155 Creating Graphs and Charts

Lecture 156 Customizing a Cluster Column Chart

Lecture 157 Customizing a Pie Chart

Lecture 158 New Chart Types in Excel 2016

Lecture 159 Exercise 07

Section 67: Excel 2016: Sorting and Filtering Data

Lecture 160 Managing Data by Sorting

Lecture 161 Managing Date by Filtering

Lecture 162 Customizing Tables

Section 68: Excel 2016: Shapes and Pictures

Lecture 163 Inserting Shapes and Pictures

Lecture 164 Exercise 08

Section 69: Excel 2016: Formatting Cells Based on Content

Lecture 165 Conditional Formatting

Section 70: Excel 2016: Protection and Security

Lecture 166 Protecting Worksheets

Lecture 167 Protecting Workbooks

Section 71: Excel 2016: Naming Items

Lecture 168 Giving Items Names

Lecture 169 Exercise 09

Section 72: Excel 2016: Finding and Replacing Words

Lecture 170 Find and Replace

Section 73: Excel 2016: Borders

Lecture 171 Adding Borders

Section 74: Excel 2016: Workbook Inspection

Lecture 172 Inspecting a Workbook

Section 75: Excel 2016: Privacy Options

Lecture 173 Trust Center Privacy Options

Section 76: Excel 2016: Sharing Options

Lecture 174 Sharing a Workbook

Section 77: Excel 2016: Wrap Up

Lecture 175 Closing

Section 78: Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

Lecture 176 Prerequisites of the Course and Version of Excel

Lecture 177 WATCH ME: Essential Information for a Successful Training Experience

Lecture 178 DOWNLOAD ME: Excel 2016 Advanced Course Exercise and Demo Files

Lecture 179 Downloadable Course Transcripts

Lecture 180 Course Structure

Section 79: Excel 2016 Advanced: Functions

Lecture 181 Functions - Part 1

Lecture 182 Functions - Part 2

Lecture 183 Autosum

Section 80: Excel 2016 Advanced: Date and Time Functions

Lecture 184 How Date and Time Works

Lecture 185 Basic Date and Time Functions

Lecture 186 Complex Date and Time Functions

Section 81: Excel 2016 Advanced: Text Functions

Lecture 187 Using Text Functions - Part 1

Lecture 188 Using Text Functions - Part 2

Section 82: Excel 2016 Advanced: Logical Functions

Lecture 189 Using Logical Functions

Lecture 190 Exercise 01

Section 83: Excel 2016 Advanced: Lookup Functions

Lecture 191 HLOOKUP Function

Lecture 192 VLOOKUP Function

Lecture 193 Exercise 02

Section 84: Excel 2016 Advanced: Financial Functions

Lecture 194 Financial Functions and Terminology

Lecture 195 Personal Financial Functions

Lecture 196 Professional Financial Functions

Lecture 197 Depreciation

Lecture 198 Exercise 03

Section 85: Excel 2016 Advanced: Statistical Functions

Lecture 199 Statistical Functions for Description - Part 1

Lecture 200 Statistical Functions for Description - Part 2

Lecture 201 Statistical Functions for Forecasting - Part 1

Lecture 202 Statistical Functions for Forecasting - Part 2

Lecture 203 Exercise 04

Lecture 204 One Click Forecasting

Lecture 205 Statistical Functions for Inference

Section 86: Excel 2016 Advanced: Connecting to External Data

Lecture 206 Connecting to Other Workbooks

Lecture 207 Connecting to Access Databases

Lecture 208 Connecting to Web Data Sources

Lecture 209 Get and Transform

Lecture 210 Exercise 05

Section 87: Excel 2016 Advanced: Tables

Lecture 211 Introduction to Tables

Lecture 212 Working with Tables

Lecture 213 Table References

Lecture 214 Table Styles

Lecture 215 Exercise 06

Section 88: Excel 2016 Advanced: Pivot Tables

Lecture 216 Introduction to Pivot Tables

Lecture 217 Working with Pivot Tables

Lecture 218 Filters and Slicers

Lecture 219 Pivot Charts

Lecture 220 Exercise 07

Section 89: Excel 2016 Advanced: Data Analysis

Lecture 221 What If Analysis

Lecture 222 Scenario Manager

Lecture 223 Goal Seeker

Lecture 224 Solver

Section 90: Excel 2016 Advanced: Graphs and Charts

Lecture 225 Area Charts

Lecture 226 Surface Charts

Lecture 227 Radar Charts

Lecture 228 Bubble Charts

Lecture 229 Sparklines

Lecture 230 Stock Charts

Lecture 231 Exercise 09

Section 91: Excel 2016 Advanced: Excel Web App

Lecture 232 Web App - Part 1

Lecture 233 Web App - Part 2

Section 92: Excel 2016 Advanced: Conclusion

Lecture 234 Closing Message

Those new to using Microsoft Excel 2013 or 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.,Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2013 or 2016 knowledge.