Tips and Tricks on MS Excel 2013 from Mr. Biz Analyst

Common Tips and Tricks from Mr. Biz Analyst course focuses on the best practices for using Excel as a data analysis tool
4.5 (2 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.
291 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 19
  • Length 2 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 9/2015 English

Course Description

Microsoft Excel just might be the ultimate piece of software ever developed. Enormous portion of the economy rely on the program, and becoming skilled at Excel has become a license to grow in the business. So while there are a lot of basic tricks that you have to know, there are also a few tricks that will set you head and shoulders above the competition.

This course explains powerful tools that have become engrained in business processes worldwide. Businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company anniversaries and party times

The industries and functional specializations such as Information Technology, Administration, accounting, Finance, Marketing, Operations, Human Resource Management, Health care benefit the most by using Excel.

What are the requirements?

  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment

What am I going to get from this course?

  • Understand Excel’s backstage view
  • Appreciate some of the frequently used functions in Excel
  • Explore the protection features of Excel
  • Able to work with Business data and prepare relevant Charts

What is the target audience?

  • Anyone who uses MS Excel as part of their job or profession can choose this course to get a hold of validation techniques and increase their productivity
  • There is no eligibility criteria

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: Course Introduction
Course Introduction
Preview
02:29
Section 2: Understanding Cell References
Introduction
Preview
13:09
Section 3: The Backstage view - Analysis Perspective
The Backstage view - Analysis Perspective
10:38
Section 4: Excel protection features
Excel protection features
Preview
06:33
Section 5: Exporting Excel data to other formats
Exporting Excel data to other formats
07:12
Section 6: Tabs, Toolbars and Ribbons
Tabs, Toolbars and Ribbons
06:31
Section 7: Entering Formulas - Thumb Rules
Entering Formulas - Thumb Rules
12:23
Section 8: Best Practices for Spreadsheet Models
Best Practices for Spreadsheet Models
07:40
Section 9: Frequently used Functions in Excel
Frequently used Functions in Excel
Preview
08:51
Section 10: Creating and Formatting Charts containing business data
Creating and Formatting Charts
11:47
Section 11: Formatting data as Tables
Formatting data as Tables
12:01
Dataset
1 page
Section 12: Additional Material
Keyboard Shortcuts
21 pages
What's new in Excel 2013
Preview
Article
Use a formula to apply conditional formatting in Excel 2013
Article
Section 13: Practice test
Practice test 1
25 questions
Practice test 2
20 questions
Section 14: Exercises
Exercises
1 page
Quick Bonus for You!
Article
Section 15: Course Conclusion
Review Appreciated
Article
Bonus Lecture on Tips and Tricks on MS Excel 2013 from Mr. Biz Analyst
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Ready to start learning?
Take This Course