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.
Screenshots

#