Microsoft Excel 2010 for Beginners Masterclass
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
What Excel Looks LikePreview
|Section 2: Ribbon & Features|
Insert, Graphing, Page Layout, & FormulasPreview
More Formulas, Data, Review, & LayoutPreview
|Section 3: Saving & Printing|
How to Save & PrintPreview
|Section 4: Simple Math Operations|
Entering & Calculating Simple MathPreview
|Section 5: Common Math Functions|
Sum & Average
Minimum, Trigonometry, Degrees, & Exponentials
Logarithms, Radians, Square Roots
|Section 6: Large Data Functions|
Correlate, Count, GCD
If, Info, LCM, Median
Mode, Slope, Standard Deviation
Random Numbers, Rounding Up & Down
|Section 7: Graphing & Data|
Formatting Data for Graphing
Scatter Plots, Editing a Data Series
Editing a Scatter Plot Chart, Isolating Plots
|Section 8: Graphing Math Functions|
Equation Based Graphing & Chart Settings
More Chart Settings & Stylistics Intro
How to Change Chart Type
|Section 9: Formatting & Types of Graphs|
Scatter Plot Formatting In-Depth
Intelligent Line & Data Point Formatting
|Section 10: Borders & Formatting|
Cell Sizing, Font, Layout, & Merging
Grouping, Borders, Styling, & Visual Separation
Freeze Panes & Sorting
|Section 11: Trendlines|
What They Are & How They Work
|Section 12: Timesheet Example|
Using Excel For Simple Bookkeeping
|Section 13: Formula Calculation|
How to Calculate Formulas Easily in Excel
|Section 14: Matrix Math Operations|
Matrix Math & Complex Calculations
Sample Equation Graphing SheetPreview
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.
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.