The Ultimate Microsoft Excel 2013 & 2016 Mastery Course

BY
Udemy

Learn how to use the 2013 and 2016 editions of Microsoft Excel to work with a wide range of data projects.

Mode

Online

Fees

₹ 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The Ultimate Microsoft Excel 2013 & 2016 Mastery Course online certification is developed by Simon Sez IT, an e-learning service that provides users in over 180 countries with digital training in major business applications which is offered by Udemy and is intended for those who want to improve their knowledge and expertise in the principles and strategies relating to Microsoft Excel 2013 and Excel 2016. The Ultimate Microsoft Excel 2013 & 2016 Mastery Course online classes focus on teaching important analyses such as depreciation, rankings, and regression used in analyzing and planning.

The Ultimate Microsoft Excel 2013 & 2016 Mastery Course online training includes 38 hours of rich video-based training content, as well as 9 articles and 10 downloadable resources, and covers topics such as the ribbon interface, quick access toolbar, data entry, cell formatting, calculating depreciation, data management, and data analysis. Individuals will be able to develop visual charts and databases that communicate data and financial records easily and effectively at the end of this course.

The highlights

  • Certificate of completion
  • Self-paced course
  • 38 hours of pre-recorded video content
  • 9 articles
  • 10 downloadable resources

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

After completing The Ultimate Microsoft Excel 2013 & 2016 Mastery Course online training, individuals will gain an understanding of the tools and techniques used by Microsoft Excel for various data operations such as data management, data analysis, and depreciation calculation. Individuals will learn how to use the ribbon interface and the quick access toolbar, as well as the basics of data entry and cell formatting. In addition, individuals will be able to use graphs, charts, tables, statistical functions, financial functions, and formulas in their worksheets as well.

The syllabus

Excel 2013: Introduction to Excel 2013 Beginner Course

  • Introduction to Excel 2013
  • Watch Me: Essential Information for a Successful Training Experience
  • Excel 2013 Exercise Files
  • Downloadable Course Transcripts
  • What's New

Excel 2013: Using Touch

  • Overview of Principles

Excel 2013: Getting Started

  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
  • Templates; Creating, Opening, and Saving a Workbook

Excel 2013: Help

  • Online, Offline, and Contextual Help

Excel 2013: Settings and Preferences

  • Excel Options

Excel 2013: The Ribbon and Toolbars

  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar

Excel 2013: Backup and Recovery

  • Create Backup Option; Auto-Recover and Autosave

Excel 2013: Entering and Deleting Data

  • Entering Text and Numbers
  • Date Formats
  • Formatting Cells; Editing and Deleting Data
  • Fill
  • Flash Fill

Excel 2013: Formatting a Worksheet

  • Themes and Cell Styles
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns
  • Wrap Text and Alignment
  • Merging Cells; Applying Themes and Styles
  • Borders

Excel 2013: Copy, Paste and Paste Special

  • Copy, Cut and Paste

Excel 2013: Proofing

  • Spell checking

Excel 2013: Managing Worksheets

  • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Excel 2013: Comments

  • Inserting Comments

Excel 2013: Viewing and Printing

  • Workbook Views, Zoom and Freeze
  • Printing; Headers, Footers and Margins

Excel 2013: Formulas and Functions

  • Overview of Formulas and Functions
  • Cell References
  • Names
  • Finding Errors; New Excel Functions

Excel 2013: Working with Workbooks

  • Multiple Workbooks and Windows; Comparing Workbooks

Excel 2013: Find and Replace

  • Go to; Find and Replace Options

Excel 2013: Conditional Formatting

  • Applying, Clearing and Managing Rules

Excel 2013: Graphing and Charting

  • Chart Types; Chart Recommendation
  • Basic Formatting
  • Selecting Data, Positioning and Printing Charts

Excel 2013: File Types

  • Saving Workbooks; PDF and CSV Formats

Excel 2013: Managing Data

  • Sorting
  • Filtering
  • Tables

Excel 2013: Functions Case Study

  • VLOOKUP
  • Text Function
  • Date and Time Functions
  • Logical Functions

Excel 2013: Analyzing Data

  • Financial Analysis Case Study - Part 1
  • Financial Analysis Case Study - Part 2
  • Quick Analysis Tool

Excel 2013: Shapes and Pictures

  • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Excel 2013: Sharing and Protecting

  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive

Excel 2013: More Backstage View Options

  • Trust Center; Export; Inspect Workbook

Excel 2013: Closing

  • Summary; More Help
  • Excel 2013

Excel 2013 Advanced: Introduction

  • Prerequisites of Excel 2013 Advanced Course
  • Watch Me: Essential Information for a Successful Training Experience
  • Excel 2013 Advanced Exercise Files
  • Downloadable Course Transcripts
  • Course review

Excel 2013 Advanced: Functions

  • List of Functions; Common Types of Arguments; Basic Use of Functions
  • Advanced Aspects of Functions; Searching for a Function
  • Autosum

Excel 2013 Advanced: Personal and Professional Financial Functions

  • Payment
  • Future Value
  • Principle Payment
  • Depreciations

Excel 2013 Advanced: Date and Time Functions

  • How Dates and Times are Stored
  • Dates and Times Calculation
  • Exercise on Date and Time Functions; Date and Time Settings

Excel 2013 Advanced: Statistical Functions for Description and Prediction

  • Average
  • Percentile
  • Regression
  • LINEST Function
  • Example of Functions for Inferential Statistics

Excel 2013 Advanced: Text Functions

  • Text Function Case Study - 1
  • Text Function Case Study - 2

Excel 2013 Advanced: Lookup Functions

  • Lookup and Reference Functions

Excel 2013 Advanced: Logical Functions

  • Logical Functions

Excel 2013 Advanced: Connecting to External Data

  • Connecting to Other Workbooks
  • Connecting to Access Data
  • Connecting to Web Data

Excel 2013 Advanced: Tables

  • Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
  • Inserting Columns and Rows; Resizing Tables
  • Table Reference
  • Table Styles
  • Table Selection

Excel 2013 Advanced: Pivot Tables

  • Basic Principles of Pivot Tables
  • Presentational Side of Pivot Tables
  • Filtering in Pivot Tables; Slices

Excel 2013 Advanced: Data Analysis

  • What if
  • Scenario Manager
  • Goal Seeker
  • Solver

Excel 2013 Advanced: Charts

  • Area Charts
  • Surface Charts
  • Stock Charts - Part 1
  • Stock Charts - Part 2
  • Radar Charts
  • Bubble Charts

Excel 2013 Advanced: Graphs

  • Regression and Scatter Chart

Excel 2013 Advanced: Pivot Charts

  • Creating Pivot Charts

Excel 2013 Advanced: Sparklines

  • Using Sparklines

Excel 2013 Advanced: Web App

  • Creating Workbooks using a Web App
  • Sharing your Workbook

Excel 2013 Advanced: Conclusion

  • Closing
  • Excel 2013 Advanced Quiz

Excel 2016: Introduction

  • Acquiring Excel 2016 and Information on Installation and Upgrade
  • Watch Me: Essential Information for a Successful Training Experience
  • Excel 2016 Course Exercise and Demo Files
  • Downloadable Course Transcripts
  • Course exercise files
  • Section 46 Quiz

Excel 2016: What's New

  • New and Improved Features in Excel 2016

Excel 2016: Using Touch

  • Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

  • Creating and Saving a Workbook
  • Opening a Workbook

Excel 2016: Using Help

  • Online Help and Contextual Help
  • Section 50 Quiz

Excel 2016: Excel Options

  • Personalizing Your Use of Excel
  • Section 51 Quiz

Excel 2016: The Ribbon and Toolbars

  • Basics of using the Ribbon
  • Quick Access Toolbar
  • Tell Me Feature
  • Mini Toolbars and Contextual Menus
  • Status Bar
  • Section 52 Quiz

Excel 2016: Entering and Editing Data

  • Basics of Entering and Editing Data in a Workbook
  • Exercise 01
  • Formatting Dates
  • Formatting Numbers
  • Exercise 02
  • Section 53 Quiz

Excel 2016: Backup and Recovery

  • Basics of Entering and Editing Data in a Workbook
  • Exercise 01
  • Formatting Dates
  • Formatting Numbers
  • Exercise 02
  • Section 53 Quiz
  • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
  • Section 54 Quiz

Excel 2016: Fill and Series

  • Working with Fill and Series
  • Flash Fill
  • Section 55 Quiz

Excel 2016: Viewing and Printing

  • Workbook Views, Zoom, and Freeze
  • Printing
  • Exercise 03
  • Section 56 Quiz

Excel 2016: Cut, Copy, and Paste

  • Methods of Cutting, Copying, and Pasting
  • Section 57 Quiz

Excel 2016: Formatting a Worksheet

  • Delete and Clear
  • Insert, Hide, Column Width and Row Height, and Merge
  • Alignment
  • Themes and Styles
  • Exercise 04
  • Section 58 Quiz

Excel 2016: Formulas and Functions

  • Basics of Fomulas and Functions
  • Complex Examples of Formulas
  • Exercise 05
  • Section 59 Quiz

Excel 2016: Managing Worksheets

  • Rename, Insert, Move, and Reference a Worksheet
  • Section 60 Quiz

Excel 2016: Working with Multiple Workbooks

  • Working with Multiple Workbooks
  • Section 61 Quiz

Excel 2016: Saving Workbooks

  • Saving in Different File Types
  • Section 62 Quiz

Excel 2016: Proofing

  • The Spell Checker

Excel 2016: Inserting Comments

  • Inserting Comments
  • Exercise 06

Excel 2016: Basic Functions in Excel

  • The VLOOKUP Function
  • Text Functions
  • Date and Time Functions
  • Logical Functions
  • Section 65 Quiz

Excel 2016: Graphs and Charts

  • Creating Graphs and Charts
  • Customizing a Cluster Column Chart
  • Customizing a Pie Chart
  • New Chart Types in Excel 2016
  • Exercise 07
  • Section 66 Quiz

Excel 2016: Sorting and Filtering Data

  • Managing Data by Sorting
  • Managing Date by Filtering
  • Customizing Tables
  • Section 67 Quiz

Excel 2016: Shapes and Pictures

  • Inserting Shapes and Pictures
  • Exercise 08
  • Section 68 Quiz

Excel 2016: Formatting Cells Based on Content

  • Conditional Formatting
  • Section 69 Quiz

Excel 2016: Protection and Security

  • Protecting Worksheets
  • Protecting Workbooks

Excel 2016: Naming Items

  • Giving Items Names
  • Exercise 09

Excel 2016: Finding and Replacing Words

  • Find and Replace
  • Section 72 Quiz

Excel 2016: Borders

  • Adding Borders
  • Section 73 Quiz

Excel 2016: Workbook Inspection

  • Inspecting a Workbook

Excel 2016: Privacy Options

  • Trust Center Privacy Options

Excel 2016: Sharing Options

  • Sharing a Workbook
  • Section 76 Quiz

Excel 2016: Wrap Up

  • Closing

Excel 2016 Advanced: Introduction to Excel 2016 Advanced Course

  • Prerequisites of the Course and Version of Excel
  • Watch Me: Essential Information for a Successful Training Experience
  • Excel 2016 Advanced Course Exercise and Demo Files
  • Downloadable Course Transcripts
  • Course Structure

Excel 2016 Advanced: Functions

  • Functions - Part 1
  • Functions - Part 2
  • Autosum
  • Section 79 Quiz

Excel 2016 Advanced: Date and Time Functions

  • How Date and Time Works
  • Basic Date and Time Functions
  • Complex Date and Time Functions
  • Section 80 Quiz

Excel 2016 Advanced: Text Functions

  • Using Text Functions - Part 1
  • Using Text Functions - Part 2
  • Section 81 Quiz

Excel 2016 Advanced: Logical Functions

  • Using Logical Functions
  • Exercise 01
  • Section 82 Quiz

Excel 2016 Advanced: Lookup Functions

  • HLOOKUP Function
  • VLOOKUP Function
  • Exercise 02
  • Section 83 Quiz

Excel 2016 Advanced: Financial Functions

  • Financial Functions and Terminology
  • Personal Financial Functions
  • Professional Financial Functions
  • Depreciation
  • Exercise 03
  • Section 84 Quiz

Excel 2016 Advanced: Statistical Functions

  • Statistical Functions for Description - Part 1
  • Statistical Functions for Description - Part 2
  • Statistical Functions for Forecasting - Part 1
  • Statistical Functions for Forecasting - Part 2
  • Exercise 04
  • One Click Forecasting
  • Statistical Functions for Inference
  • Section 85 Quiz

Excel 2016 Advanced: Connecting to External Data

  • Connecting to Other Workbooks
  • Connecting to Access Databases
  • Connecting to Web Data Sources
  • Get and Transform
  • Exercise 05
  • Section 86 Quiz

Excel 2016 Advanced: Tables

  • Introduction to Tables
  • Working with Tables
  • Table References
  • Table Styles
  • Exercise 06
  • Section 87 Quiz

Excel 2016 Advanced: Pivot Tables

  • Introduction to Pivot Tables
  • Working with Pivot Tables
  • Filters and Slicers
  • Pivot Charts
  • Exercise 07
  • Section 88 Quiz

Excel 2016 Advanced: Data Analysis

  • What If Analysis
  • Scenario Manager
  • Goal Seeker
  • Solver
  • Section 89 Quiz

Excel 2016 Advanced: Graphs and Charts

  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts
  • Exercise 09
  • Section 90 Quiz

Excel 2016 Advanced: Excel Web App

  • Web App - Part 1
  • Web App - Part 2
  • Section 91 Quiz

Excel 2016 Advanced: Conclusion

  • Closing Message

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books