Microsoft Excel 2010 for Beginners Masterclass

A practical approach to using excel for organizing information, tracking trends over time, and performing calculations.
4.4 (36 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.
1,496 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 29
  • Length 1.5 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 5/2015 English

Course Description

The Microsoft Excel Masterclass course is designed for professionals that want to learn the ins and outs of excel to help boost your productivity and skills for work.

I'm sure if you are looking at this course, you already have some experience with excel but don't really know how to use excel to its full power.

There are so many different buttons and features in excel that it can become really overwhelming, confusing and frustrating.

I can relate.

I've been using excel since high school but it wasn't until I started getting properly trained that I really understood the different options, tools and functionalities excel really had.

It was a shift in my career.

It has made my job much easier and I now have a highly developed skill desired by employers.

If you don't understand how to really use excel, you'll slowly get left behind. I encourage you to take the next step in separating yourself from your peers by learning how to really use excel.

Here's what will be covered in this course:

  • Ribbons and Features
  • Saving and Printing
  • Simple Math Operations
  • Common Math Functions
  • Large Data Functions
  • Graphing and Data
  • Graphing Math Functions
  • Formatting and Types of Graphs
  • Borders and Formatting
  • Trendlines
  • Sample Applications of Excel
  • Formula Calculation
  • Matrix Math Operations

Our Promise to You
By the end of this course, you'll have the knowledge to improve your use of Excel for personal and work related tasks. This is a powerful tool that can be used in many ways!

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we'll give you a full refund. No questions asked.

Get started today and improve your skills with Excel!

What are the requirements?

  • Students will need to have access to excel and understand the basic principles of using a computer. A working knowledge of mathematics is helpful, but definitely not required.

What am I going to get from this course?

  • Generate stylized charts and graphs
  • Track trends and changes over time for your business or personal development
  • Perform simple and complex calculations
  • Organize large amounts of information or records
  • Navigate Excel software and manipulate a spreadsheet
  • Stylize and improve charts, graphs, and tables
  • Use excel to make simple calculators that perform a common calculation or series of calculations automatically from a given set of inputs
  • Plot mathematical functions
  • Plot data collected over a period of time to show trends
  • Make simple calculators that perform a common calculation or series of calculations automatically from a given set of inputs
  • Perform trendline analysis to create predictive formulas based on a series of data
  • Create bar graphs, pie charts, line graphs, and more

What is the target audience?

  • You should take this course if you are starting out in Excel, or you have been using Excel but you don't know how to do very much with it.
  • You should also take this course if you are looking improve upon your skills in order to do things fast, correct, and in a very visually organized manner.
  • If you are an entrepreneur looking to organize many different numbers in a simple to read and edit format, excel is going to be a game changer for you. If you're looking to start making plots of your sales or business actions over the course of a year, this course will show you how to do that with ease.
  • If you are a student or young profressional in a science or engineering field, both academic and professional, this course will be an asset to your success. Excel is one of the most powerful scientific tools that can be learned with ease. You will instantly find that clean organization and the elimination of simple math errors will take you to a higher level of performance no matter what stage you're at.
  • You should NOT take this course if you're purely looking for Excel VBA lectures. I do not cover VBA as it is a much more advanced subject that is beyond the scope of this course. Most students and working professionals do not need VBA for their purposes.

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: Introduction
What Excel Looks Like
Preview
02:06
Section 2: Ribbon & Features
Insert, Graphing, Page Layout, & Formulas
Preview
02:19
More Formulas, Data, Review, & Layout
Preview
02:05
Section 3: Saving & Printing
How to Save & Print
Preview
01:27
Section 4: Simple Math Operations
Entering & Calculating Simple Math
Preview
03:00
Section 5: Common Math Functions
Sum & Average
03:04
Minimum, Trigonometry, Degrees, & Exponentials
04:57
Future Value
02:38
Logarithms, Radians, Square Roots
03:42
Section 6: Large Data Functions
Correlate, Count, GCD
02:51
If, Info, LCM, Median
02:34
Mode, Slope, Standard Deviation
01:50
Random Numbers, Rounding Up & Down
02:57
Section 7: Graphing & Data
Formatting Data for Graphing
01:45
Scatter Plots, Editing a Data Series
02:47
Editing a Scatter Plot Chart, Isolating Plots
04:25
Section 8: Graphing Math Functions
Equation Based Graphing & Chart Settings
03:48
More Chart Settings & Stylistics Intro
02:46
How to Change Chart Type
04:03
Section 9: Formatting & Types of Graphs
Scatter Plot Formatting In-Depth
03:40
Intelligent Line & Data Point Formatting
04:29
Section 10: Borders & Formatting
Cell Sizing, Font, Layout, & Merging
04:10
Grouping, Borders, Styling, & Visual Separation
04:40
Freeze Panes & Sorting
04:38
Section 11: Trendlines
What They Are & How They Work
04:48
Section 12: Timesheet Example
Using Excel For Simple Bookkeeping
03:03
Section 13: Formula Calculation
How to Calculate Formulas Easily in Excel
06:31
Section 14: Matrix Math Operations
Matrix Math & Complex Calculations
07:42
Sample Equation Graphing Sheet
Preview
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andy Norris, Mechanical Engineer

My name is Andy Norris and I've been an engineer for 5 years. I graduated from SDSU with a bachelor's degree in mechanical engineering, and I am EIT certified in California. I currently work as a salary design engineer for a multinational diversified engineering and manufacturing corporation.

I have a passion for teaching and I hope my courses help you succeed in your professional life, as well as your personal life.

Instructor Biography

Michael Shen, Entrepreneur

I'm an entrepreneur focused on the online education industry. Aside from teaching several courses myself, I also partner with top instructors to help them with their marketing and sales.

My passion is helping students develop skills that can enrich their quality of life and helping instructors monetize their passions.

Ready to start learning?
Take This Course