EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up

Microsoft Excel 2013 Training

Home Courses FINANCE Excel Courses Microsoft Excel 2013 Training

charts

Course Overview

This is a online course is to gain comprehensive Practical understanding of Microsoft Excel 2013. The aim is to learn essential concepts in Microsoft Excel 2013 users right from scratch. The tutorials will help you learn about Getting Started with excel 2013, Data Entry, Calculations, Formulas, Formatting, Formatting Table formats, Percentages & Absolute References, Conditional Formatting, Graphs & Charts, Presentation, Introduction to Useful Excel 2013 Functions, Data Functions Dashboard Course, Pivot Table, specialized graphs and charts, Financial functions using Excel and creating Excel Dashboard.

269
12 hours + 15h 37m | 175 Videos | 86061 Views | Appropriate for all  All Levels| English[Auto-generated]
trigger text
hidden content

Why Microsoft Excel 2013 Training Course?

Microsoft Excel 2013 is a comprehensive course on learning excel which any novice can understand. By the end of this course you will be in a position to use the powerful features and functions very comfortably and for your practice case studies and working files have been included.

This course begins with getting started with excel and then it explains all excel functions and formulas in a comprehensive manner with practical examples and case studies. We will start right from scratch i.e. understanding the population of data on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sum if, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. Then, the course will take you through some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table have been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course.
Our aim of providing this course is to make you understand what excel is and how it can be used effectively in current business world. The only expectation from you is to be passionate to learn, be committed to the training and invest your time. We will be covering the following modules in this course on Microsoft Excel 2013 :

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  • Overview of Microsoft Excel 2013
  • Case Study to understand the entire course structure
  • Data Entry, formulas, functions, calculations and formatting in Excel 2013
  • Graphs & Charts in Excel 2013
  • Shortcuts
  • Common errors in Excel 2013
  • Functions for Working with Text
  • Excel 2013 – Pivot Table and Pivot charts
  • Names and Dynamic Range
  • Auditing and Trouble Shooting Formulas
  • Important Excel Tools
  • Excel 2013 – Charts & Graphs
  • Excel 2013 – Excel Dashboard
  • Assigning Macros to Buttons to Navigate and Dashboard
  • Financial functions using Excel

What are the pre-requisites for the Microsoft Excel 2013 Course?

  • Passion to learn.
  • A computer with internet
  • Any beginner can take this course

What am I going to get from this Microsoft Excel 2013 course?

  • Over 15 hours of content
  • Learn formatting, if, sum if, graphs and charts, sorts, pivot table, freeze and split etc
  • You will learn everything from data entry to calculations to formula
  • Study prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table
  • Understand smart features like Charts and Graphs, Dashboard and Financial Functions in this course
  • Gain command over powerful features and functions in Excel 2013

Who should take up this course?

  • Students, MBA’s, BBA’s, Gradates & Post- graduates, Working Professionals from any business domain., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker
  • Anyone interested in more powerful features and functions of Excel 2013
Where do our learners come from?
Professionals from around the world have benefited from eduCBA’s MS Excel 2013 Comprehensive Excel courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many.

Back to top ^

View Offline

View courses without internet connection with a Lifetime Membership
View courses without internet connection with a Lifetime Membership

View Offline - Internet-free viewing with your iOS or Android App

Watch offline with your iOS/Android app.

Start Your Free Trial Now

You can download courses from your iOS/Android App.

Primary Sidebar

Merger Modeling - Comcast Corp and Time Warner Inc.

Curriculum

1. Overview

  •  Reference File1
  •  Reference File2
  • Overview

2. Getting Started

  • Opening Excel
  • Familiarity With Excel Interface And Ribbons
  • Surfing An Excel Worksheet And How To Use Help In Ms Excel

3. Case Study

  • Case Study

4. Data Entry

  • Data Entry In Excel

5. Populating The Case Study In Excel

  • Populating The Case Study In Excel

6. Calculations

  • Calculations

7. Formulas

  • Formulas - Part 1
  • Formulas - Part 2

8. Formatting

  • Formatting Number Formats

9. Formatting Table Formats

  • Formatting Table Formats

10. Updating A Calculation

  • Updating A Calculation

11. Percentages & Absolute References

  • Percentages And Absolute References

12. Conditional Formatting

  • Conditional Formatting

13. If Function

  • If Function

14. Countif

  • Countif

15. Sumif

  • Sumif

16. Graphs & Charts

  • Graphs And Charts Part 1
  • Graphs And Charts Part 2
  • Graphs And Charts Part 3

17. Pie Chart

  • Pie Chart

18. Sorts

  • Sort Function

19. Filter Function

  • Filter Function

20. Pivot Table

  • Pivot Table Part 1
  • Pivot Table Part 2

21. Freeze & Split

  • Freeze And Split

22. Presentation

  • Table Formats
  • Indents And Formatting Charts

23. Print

  • Printing The Worksheet
  • Print Layout

24. Shortcuts

  • Shortcuts Part 1
  • Shortcuts Part 2
  • Shortcuts Part 3
  • Shortcuts Part 4
  • Shortcuts Part 5
  • Shortcuts Part 6

25. Common Errors

  • Common Errors

26. Introduction to Useful Excel 2013 Functions

  • Paste Special
  • Logical fucnitons IF and OR
  • Arithmetic Functions
  • Aggregation Functions
  • Cell Information Functions

27. Data Functions

  • Choose Function
  • Vlookup
  • Hlookup and Sum product
  • Hlookup and Sum product Continues
  • Match Index
  • Database Functions
  • Forecasting Function

28. What If Analysis

  • One Dimensional Data Table
  • Two Dimensional Data Tables
  • Solver
  • Goal Seek

29. Arrays

  • Arrays Introduction Part 1
  • Arrays Introduction Part 2
  • Arrays Rows and Coloumns
  • Arrays Transpose
  • Arrays Frequency

30. Functions for Working with Text

  • Text and String Functions Part 1
  • Text and String Functions Part 2

31. Excel 2013 - Pivot Table

  • Data Formatting
  • Creating Pivot Table
  • Recommended Data Table
  • Pivoting Pivot Table
  • External Data
  • Consolidation Sheets
  • Managing Pivot Table

32. Summarizing Data Using Pivot Table

  • Totals Display
  • Summary Display
  • Multiple Data Field
  • Data Grouping
  • Drill Down Data
  • Calculated Field

33. Data Filtering

  • Pivot Data Sorting
  • Customised Sorting
  • Limited Data Display
  • Rule Based Sorting
  • Data Slicer
  • Slicer Formatting
  • Filter Area
  • Removing Filters

34. Basics Pivot Table Formatting

  • Formatting Pivot Table
  • Layouts In Pivot Table

35. Advanced Pivot Table Formatting

  • Rule Based Conditional Formatting
  • Top Bottom Rule Based
  • Data Bars
  • Adding Color Scales
  • Icon Indicators

36. Introduction of Pivot Chart

  • Basic Pivot Chart
  • Pivoting Pivot Chart
  • Filter Pivot Chart Data
  • Formatting Pivot Chart
  • Different Chart Types

37. How to Print the Pivot Table

  • Print Table Part 1
  • Print Table Part 2
  • Print Separate
  • Print Headers

38. Using Macros In Pivot Tables

  • First Macro

39. Introduction of Power Pivot

  • Starting With Power Pivot
  • Why Use Power Pivot
  • Adding Table To Power Pivot
  • Creating Relationships Between Tables
  • Pivot TableIn Power Pivot
  • Get External DataIn Power Pivot

40. DAX in Power Pivot

  • Introduction To DAX
  • Reference To Dax Functions
  • Adding Calculated Column
  • Adding Calculated Field

41. Introduction of Power View

  • Introduction To Power View
  • Displaying Data Using Different Controls Part 1
  • Displaying Data Using Different Controls Part 2
  • Formatting Of Controls
  • Filters In Power View
  • Data Display Using Charts In Power View
  • Data Display Using Maps

42. Names and Dynamic Range

  • Naming a Cell and a Range
  • Naming Dynamic Ranges

43. Auditing and Trouble Shooting Formulas

  • Auditing Toolbars
  • Watch Window

44. Important Excel Tools

  • Text to Columns
  • Grouping Tabs
  • Subtotal Function
  • Hyperlinks
  • Data Validation Part 1
  • Data Validation Part 2
  • Random Numbers
  • Custom View
  • Protecting Worksheet and Workbook

45. Excel 2013 - Charts & Graphs

  • Introduction to Excel 2013

46. Chart Concept

  • Excel Chart Concepts

47. Basic Chart

  • Excel Basic Charts

48. Fine Tuning of Charts

  • Fine-tuning of Charts in Excel

49. Chart Options

  • Changing Chart Options – part 1
  • Changing Chart Options – part 2

50. Format Tab

  • Format Tab Option

51. Adjustment of Specific Chart Types

  • Column and Line Chart
  • Pie Diagram
  • Doughnut, Bubble and Radar Chart

52. Changing Chart Sources

  • Paste Chart Data
  • Multiple Source Data and Table Chart
  • Basic Dynamic Chart

53. Specialised Charts & Graphs

  • Dynamic Chart with Check boxes
  • Dynamic Pie Chart
  • Pareto Chart
  • Frequency Chart
  • Chart Filter
  • Gantt Chart
  • Advanced Dynamic Chart
  • Calculator Chart
  • Pivot Chart
  • Map Chart

54. Excel 2013 - Excel Dashboard

  • Introduction to Dashboard
  • Concepts of Excel Dashboard

55. Creating Basic Charts

  • 3D Charts
  • Area and Bar Chart
  • Combination Charts
  • Different Typs

56. Learning Pivot Table, Pivot Chart and Slicer

  • Pivot Table
  • Pivot Chart and Slicer

57. Using Form Controls

  • Checkbox
  • Check and Scroll 1
  • Scroll Chart

58. Basic Macros

  • Basic Macro Part 1

59. Assigning Macros to Buttons to Navigate and Dashboard

  • Basic Macro Part 2
  • Macro Navigation
  • Dashboard End

60. Financial functions using Excel

  • Introduction

61. Future Value, SI, CI, PV, NPER, RATE

  • Understanding Future Value
  • Future Value Continues
  • Calculating Simple and compound Interest
  • SI and CI Continues
  • Understanding PV
  • Calculate NPER and RATE
  • Lender and Borrower FV
X

Loading the player...

Related Job Oriented Programs

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Company
  • About us
  • Alumni Speak
  • Contact Us
  • Log in
  • Sign up
Work with us
  • Careers
  • Become an Instructor
EDUCBA for Enterprise
  • Enterprise Solutions
  • Explore Programs
  • Free Courses
  • Free Tutorials
  • EDUCBA at Coursera
  • EDUCBA at Udemy
Resources
  • Blog
  • Self-Paced Training
  • ExamTurf
  • Verifiable Certificate
  • Popular Skills Catalogue
  • Exam Prep Catalogue
Popular Categories
  • Lifetime Membership
  • All in One Bundles
  • Featured Skills
  • New & Trending
  • Fresh Entries
  • Finance
  • Data Science
  • Programming and Dev
  • Excel
  • Marketing
  • HR
  • PDP
  • VFX and Design
  • Project Management
  • Exam Prep
  • Learning Paths @ $49
  • All Courses
  • Terms & Conditions
  • Disclaimer
  • Privacy Policy & Cookie Policy
  • Shipping Policy

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW