Microsoft Excel 2010 for Beginners Masterclass
4.3 (37 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,500 students enrolled
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.3 (37 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,500 students enrolled
Last updated 6/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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.
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!

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
Curriculum For This Course
Expand All 29 Lectures Collapse All 29 Lectures 01:38:51
+
Introduction
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
03:04

Minimum, Trigonometry, Degrees, & Exponentials
04:57

Future Value
02:38

Logarithms, Radians, Square Roots
03:42
+
Large Data Functions
4 Lectures 10:12
Correlate, Count, GCD
02:51

If, Info, LCM, Median
02:34

Mode, Slope, Standard Deviation
01:50

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

Scatter Plots, Editing a Data Series
02:47

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

More Chart Settings & Stylistics Intro
02:46

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

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

Grouping, Borders, Styling, & Visual Separation
04:40

Freeze Panes & Sorting
04:38
4 More Sections
About the Instructor
Andy Norris
4.1 Average rating
254 Reviews
8,073 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.

Michael Shen
3.9 Average rating
266 Reviews
8,618 Students
6 Courses
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.