- Introduction to Excel 2013
- Watch Me: Essential Information for a Successful Training Experience
- Excel 2013 Exercise Files
- Downloadable Course Transcripts
- What's New
Online
₹ 455 3,499
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 8 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
- 8 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
certificate availability
certificate providing authority
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.
Who it is for
The syllabus
Excel 2013: Introduction to Excel 2013 Beginner Course
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