The Ultimate Microsoft Excel 2013 Training Bundle - 19 Hours

BY
Udemy

Mode

Online

Fees

₹ 399 3699

Quick Facts

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

Course and certificate fees

Fees information
₹ 399  ₹3,699
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Excel 2013 Beginners: Introduction

  • Introduction to Excel 2013
  • WATCH ME: Essential Information for a Successful Training Experience
  • DOWNLOAD ME: Excel 2013 Exercise Files
  • Downloadable Course Transcript
  • What's New

Excel 2013 Beginners: Using Touch

  • Overview of Principles

Excel 2013 Beginners: Getting Started

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

Excel 2013 Beginners: Help

  • Online, Offline, and Contextual Help

Excel 2013 Beginners: Settings and Preferences

  • Excel Options

Excel 2013 Beginners: The Ribbon and Toolbars

  • Ribbon Interface
  • Quick Access Toolbar
  • Mini Toolbar

Excel 2013 Beginners: Backup and Recovery

  • Create Backup Option; Auto-Recover and Autosave

Excel 2013 Beginners: Enterting and Deleting Data

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

Excel 2013 Beginners: 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 Beginners: Copy, Paste and Paste Special

  • Copy, Cut and Paste

Excel 2013 Beginners: Proofing

  • Spell checking

Excel 2013 Beginners: Managing Worksheets

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

Excel 2013 Beginners: Comments

  • Inserting Comments

Excel 2013 Beginners: Viewing and Printing

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

Excel 2013 Beginners: Formulas and Functions

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

Excel 2013 Beginners: Working with Workbooks

  • Multiple Workbooks and Windows; Comparing Workbooks

Excel 2013 Beginners: Find and Replace

  • Go to; Find and Replace Options

Excel 2013 Beginners: Conditional Formatting

  • Applying, Clearing and Managing Rules

Excel 2013 Beginners: Graphing and Charting

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

Excel 2013 Beginners: File Types

  • Saving Workbooks; PDF and CSV Formats

Excel 2013 Beginners: Managing Data

  • Sorting
  • Filtering
  • Tables

Excel 2013 Beginners: Functions Case Study

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

Excel 2013 Beginners: Analyzing Data

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

Excel 2013 Beginners: Shapes and Pictures

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

Excel 2013 Beginners: Sharing and Protecting

  • Protecting Worksheets
  • Protecting Workbooks
  • Sharing and SkyDrive

Excel 2013 Beginners: More Backstage View Options

  • Trust Center; Export; Inspect Workbook

Excel 2013 Beginners: Closing

  • Summary; More Help
  • Excel 2013 Quiz

Excel 2013 Advanced: Introduction

  • Prerequisites of Excel 2013 Advanced Course
  • WATCH ME: Essential Information for a Successful Training Experience
  • DOWNLOAD ME: Excel 2013 Advanced Exercise Files
  • Downloadable Course Transcript
  • 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

Instructors

Mr Simon Sez IT
Instructor
Udemy

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