Certificate Program in Advanced MS Excel

A Comprehensive Online Program designed for Professionals
0.0 (0 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
6 students enrolled
$50
Take This Course
  • Lectures 51
  • Length 15 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

Course Introduction:

MS Excel reigns supreme when it comes to business tool usage in the industry. Employees with this skill are required from small companies to big International companies. Knowledge of Excel is required from entry level staff to Senior Managers across industries. It is an essential tool in every job.


Program Benefits:

  • Easy to understand content
  • Step wise learning module
  • Downloadable Content
  • Use Excel productively
  • Out of the box functionality usage to help you in reporting, project management,
  • Gain insights from vast array of data with ease
  • Analyze data like a professional
  • Make powerful dashboards
  • Write Awesome Formulas
  • Flexible 24/7 access

Topics Covered

The course will cover 3 levels of Learning Excel:

 Level 1 Basic Course on Excel

 Level 2 Intermediate Course on Excel

 Level 3 Advanced Course on Excel

Learning Outcomes

After completion of course the students will be able to

 Analyse data like professionals

 Make Powerful Dashboards

 Make profitable business impact

Benefits to Learners

 Knowledge and practice of MS Excel.

 Learning and practicing MS Excel with real time scenarios.

 Great value-add for student’s Resume which can help him/her get a great career.

 Student gets 1 Certificate from MaGE after an online MCQ bases assessment

Level1: Basic Course on Excel

This course is intended for novice information workers who want to learn beginning level

Excel skills. After completing this course, students will be able to:

 Create workbooks

 Modify workbook content

 Modify worksheet content

 Zoom in on a worksheet

 Arrange multiple workbook windows

 Add buttons to the Quick Access Toolbar

 Customize the ribbon

 Maximize usable space in the program window

 Enter and revise data

 Move data within a workbook

 Find and replace data

 Correct and expand upon worksheet data

 Define Excel tables

 Format cells

 Apply workbook themes and Excel table styles.

 Add images to worksheets

 Add headers and footers to printed pages

 Prepare worksheets for printing

 Print worksheets

 Print parts of worksheets

 Print charts

Level 2: Intermediate Course on Excel

This course shows students how to of perform calculations on data, locate and validate

data, create styles and format and filter data, reorder and summarize data, and combine

data from multiple sources. After completing this course, learners will be able to:

 Name groups of data

 Create formulas to calculate values

 Summarize data that meets specific conditions

 Find and correct errors in calculations

 Define styles

 Make numbers easier to read

 Change the appearance of data based on its value

 Limit data that appears on your screen

 Manipulate worksheet data

 Define valid sets of values for ranges of cells

 Sort worksheet data

 Organize data into levels

 Look up information in a worksheet

 Use workbooks as templates for other workbooks

 Link to data in other worksheets and workbooks

 Consolidate multiple sets of data into a single workbook

 Group multiple sets of data

Level 3: Advanced Course on Excel

This course provides students with the skills to analyse alternative data sets, create

dynamic worksheets by using PivotTables, create charts and graphics, automate

repetitive tasks, work with other Microsoft Office programs, and collaborate on

workbooks. After completing this course, learners will be able to:

 Define an alternative data set

 Define multiple alternative data sets

 Vary your data to get a desired result by using Goal Seek

 Find optimal solutions by using Solver

 Analyse data by using descriptive statistics

 Analyse data dynamically by using PivotTables

 Filter, show, and hide PivotTable data

 Edit PivotTables

 Format PivotTables

 Create PivotTables from external data

 Create charts

 Customize the appearance of charts

 Find trends in your data

 Summarize your data by using Sparklines

 Create dynamic charts by using Pivot Charts

 Create diagrams by using SmartArt

 Create shapes and mathematical equations

 Enable and examine macros

 Create and modify macros

 Run macros when a button is clicked

 Run macros when a workbook is opened

 Include Office documents in workbooks

 Store workbooks as parts of other Office documents

 Create hyperlinks

 Paste charts into other documents

 Share workbooks

 Manage comments

 Track and manage colleagues’ changes

 Protect workbooks and worksheets

 Authenticate workbooks

 Save workbooks for the Web

This is an online course of duration 90 hrs with the following breakup:

 Learning Content Level 1 15 hrs

 Learning Content Level 2 15 hrs

 Learning Content Level 3 15 hrs

  • Additional Self assessment quizzes - 45 hrs

All learners upon successful completion of Post course assessments shall be getting a verifiable e-certificate from Manipal Global Education which will be globally valid.

What are the requirements?

  • Excel software recommended for practice

What am I going to get from this course?

  • This is a one of its kind tool which helps the student pick usage of MS Excel quickly and efficiently, without the support of an instructor.

What is the target audience?

  • A must for every professional from entry to senior level managers in any industry.
  • Management graduates – MBA, BBA
  • Engineering & IT graduates B.Tech./ B.E., BSc-IT, BCA, MCA, MSc-IT etc.
  • For students aspiring for entry level jobs in any domain this is mandatory.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Chapter 1: Working with Excel Files
23 pages

Working with Excel Files

06:21

User Interface-Video

03:15

BackStage View-Video

02:14

Help System-Video

Section 2: Chapter 2: Entering Data
11 pages

Entering Data

03:26

Editing Workbooks 1-Video

02:39

Editing Workbooks 2-Video

03:52

Formatting Data-Video

Section 3: Chapter 3: Working With Numbers
27 pages

Working With Numbers

03:47

Operators Formulas-Video

01:54

Paste Preview-Video

00:16

Excel Tables-Video

04:07

Math Functions 1-Video

06:12

Financial Functions-Video

06:55

Math Functions 2-Video

Section 4: Chapter 4: Formatting Data
29 pages

Formatting Data

03:17

Formatting Options 1- Video

06:28

Formatting Options 2-Video

Section 5: Chapter 5: Managing Your Data in Excel
21 pages

Managing Your Data in Excel

05:31

Managing Data 1-Video

02:25

Managing Data 2-Video

Section 6: Chapter 6: Working with Text and Date
16 pages

Working with Text and Date

05:49

Text Date Time-Video

Section 7: Chapter 7: Manipulating Data
8 pages

Manipulating Data

06:04

Relative Absolute Referencing-Video

Section 8: Chapter 8: Working with Charts
28 pages

Working with Charts

05:03

Charts 1-Video

05:35

Charts 2-Video

06:54

Trendlines-Video

Section 9: Chapter 9: Working with PivotTable
11 pages

Working with PivotTable

04:16

Pivot Tables-Video

04:07

Pivot Tables Charts-Video

Section 10: Chapter 10: What If Analysis
9 pages

What If Analysis

02:38

Goal Seek-Video

04:03

Scenario Manager-Video

Section 11: Chapter 11: Macros
8 pages

Macros

05:49

Macros-Video

Section 12: Chapter 12: Printing Excel Files
11 pages

Printing Excel Files

05:38

Printing Worksheets-Video

Section 13: Chapter 13: Managing Excel Files
6 pages

Managing Excel Files

04:05

File Formats-Video

Section 14: Chapter 14: Grouping and Outlining Data
8 pages

Grouping and Outlining Data

03:26

Grouping Data-Video

04:50

Linking Protecting-Video

Section 15: Chapter 15: Shortcut Keys & References
6 pages

Shortcut Keys & References

Section 16: Practice Files
42 questions

Certificate in Advanced MS Excel

Section 17: Mentor Class Videos
01:38:34

Video-01 -Working with Excel Files, Entering Data, Working with Numbers

01:40:23

Video-02 - Managing Data, Working with Text & Date and Manipulating Data

01:33:05

Video-02 (contd) - Managing Data, Working with Text & Date and Manipulating Data

01:20:20

Video-03 - Manipulating data, Working with charts & Pivot table

01:14:32

Video-04 - Working with Pivot table(contd..), What If Analysis & Macros

01:47:58

Video-05 - Printing & Managing files, Grouping & Outlining Data and Shortcut Keys

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Manipal Global, Professional Certificate Programs to enhance Your Skills

Manipal Global Education Services is a leading international provider of high-quality higher education services. These include:

  • A wide range of services for educational institutions in India
  • Vocational training across a number of sectors
  • Technology-driven services in areas such as testing and education delivery.

Headquartered in Bangalore, India, Manipal Global also owns and operates university campuses in Malaysia, Antigua, Dubai and Nepal. It currently services and supports over 300,000 students, many of them through its award-winning technology platform, EduNxt™.

Manipal Global believes industry relevance is the key to career-focused education in India and Worldwide.

Other strategic investments include MeritTrac, India´s leading testing & assessment company, and iRize, a unique employment exchange initiative in partnership with educational institutions, local partners and the government.

The Manipal Global mantra – Achieve, Enable and Transform – builds on this legacy and expertise.

Manipal Global creates a future for every life it touches. A future that inspires achievements, enables ambitions, and transforms lives, worldwide.

Ready to start learning?
Take This Course