Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010 for Beginners Masterclass to your Wishlist.

Add to Wishlist

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,498 students enrolled
Last updated 6/2015
$10 $20 50% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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!

Who 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.
Students Who Viewed This Course Also Viewed
What Will I Learn?
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
View Curriculum
  • 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.
Curriculum For This Course
Expand All 29 Lectures Collapse All 29 Lectures 01:38:51
1 Lecture 02:06
Saving & Printing
1 Lecture 01:27
Simple Math Operations
1 Lecture 03:00
Common Math Functions
4 Lectures 14:21
Sum & Average

Minimum, Trigonometry, Degrees, & Exponentials

Future Value

Logarithms, Radians, Square Roots
Large Data Functions
4 Lectures 10:12
Correlate, Count, GCD

If, Info, LCM, Median

Mode, Slope, Standard Deviation

Random Numbers, Rounding Up & Down
Graphing & Data
3 Lectures 08:57
Formatting Data for Graphing

Scatter Plots, Editing a Data Series

Editing a Scatter Plot Chart, Isolating Plots
Graphing Math Functions
3 Lectures 10:37
Equation Based Graphing & Chart Settings

More Chart Settings & Stylistics Intro

How to Change Chart Type
Formatting & Types of Graphs
2 Lectures 08:09
Scatter Plot Formatting In-Depth

Intelligent Line & Data Point Formatting
Borders & Formatting
3 Lectures 13:28
Cell Sizing, Font, Layout, & Merging

Grouping, Borders, Styling, & Visual Separation

Freeze Panes & Sorting
4 More Sections
About the Instructor
3.9 Average rating
247 Reviews
8,040 Students
5 Courses
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.

3.6 Average rating
257 Reviews
8,581 Students
6 Courses

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.

Report Abuse