About This Course
The Microsoft Excel 2013 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
Get started today and learn how to master Microsoft Excel 2013!
Our Promise to You
By the end of this course, you will have learned how to use Microsoft Excel 2013.
10 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 learn how to use Microsoft Excel 2013!
Course Curriculum
3h 32m
Section 1 - Starting Off | |||
Introduction To Excel 2013 | 00:00:00 | ||
Recap Of Software Layout | 00:00:00 | ||
Section 2 - Home Tab | |||
Home Tab | 00:00:00 | ||
Wrap Text And Cell Format | 00:00:00 | ||
Section 3 - Insert Tab | |||
Insert Tab | 00:00:00 | ||
Section 4 - Page Layout Tab | |||
Page Layout Tab | 00:00:00 | ||
Page Sizing | 00:00:00 | ||
Gridlines | 00:00:00 | ||
Bring Forward & Send Backward | 00:00:00 | ||
Section 5 - Formulas Tab | |||
Formulas Tab | 00:00:00 | ||
Function Dropdowns | 00:00:00 | ||
Trace Precedents & Dependents | 00:00:00 | ||
Formula Checking | 00:00:00 | ||
Calculation Options | 00:00:00 | ||
Section 6 - Data Tab | |||
Data Tab | 00:00:00 | ||
Sorting & Filtering | 00:00:00 | ||
Text To Columns | 00:00:00 | ||
Data Validation | 00:00:00 | ||
Section 7 - Review Tab | |||
Review Tab | 00:00:00 | ||
Protect & Share Workbooks | 00:00:00 | ||
Section 8 - View Tab | |||
View Tab | 00:00:00 | ||
Freeze Panes & Split | 00:00:00 | ||
Section 9 - File Tab | |||
File Tab | 00:00:00 | ||
New & Open | 00:00:00 | ||
Saving | 00:00:00 | ||
Printing | 00:00:00 | ||
Section 10 - Options | |||
Share, Export, & Options | 00:00:00 | ||
Formula Options | 00:00:00 | ||
Proof & Save Options | 00:00:00 | ||
Language & Advanced Options | 00:00:00 | ||
Copy Paste & Chart Options | 00:00:00 | ||
Display Options | 00:00:00 | ||
Formula & Calculation Options | 00:00:00 | ||
Toolbar Options & Add-ins | 00:00:00 | ||
Section 11 - Math | |||
Simple Math | 00:00:00 | ||
Functions Using Cells | 00:00:00 | ||
Using Parenthesis | 00:00:00 | ||
Sum & Average | 00:00:00 | ||
Min, Max, Absolute Value | 00:00:00 | ||
Trig Functions | 00:00:00 | ||
Inverse Trig | 00:00:00 | ||
Convert | 00:00:00 | ||
Degrees & Radians | 00:00:00 | ||
Exponential Function | 00:00:00 | ||
Future Value | 00:00:00 | ||
Future Value Example | 00:00:00 | ||
Present Value | 00:00:00 | ||
Complex Numbers | 00:00:00 | ||
Logarithms | 00:00:00 | ||
Square Root | 00:00:00 | ||
Section 12 - Data Set Functions | |||
Correlate | 00:00:00 | ||
Count & Countblank | 00:00:00 | ||
Greatest Common Denominator | 00:00:00 | ||
If Function | 00:00:00 | ||
Info | 00:00:00 | ||
Least Common Multiple | 00:00:00 | ||
Median | 00:00:00 | ||
Mode | 00:00:00 | ||
Slope | 00:00:00 | ||
Standard Deviation | 00:00:00 | ||
Random Number | 00:00:00 | ||
Randbetween | 00:00:00 | ||
Rounddown & Roundup | 00:00:00 | ||
Section 13 - Graphs & Charts | |||
Inserting Graphs | 00:00:00 | ||
Vertical Formatting | 00:00:00 | ||
Manage Graph Data | 00:00:00 | ||
Using Select Data Source | 00:00:00 | ||
Modifying Graphs | 00:00:00 | ||
More Axis Options | 00:00:00 | ||
Graphing Equations | 00:00:00 | ||
Improving Graph Display | 00:00:00 | ||
Additional Graph Features | 00:00:00 | ||
Changing Chart Types | 00:00:00 | ||
Section 14 - Tables & Data | |||
Formatting Tables | 00:00:00 | ||
Cell Borders | 00:00:00 | ||
Excel Tables | 00:00:00 | ||
Excel Table Freeze Pane | 00:00:00 | ||
Excel Table Sorting | 00:00:00 | ||
Trendlines | 00:00:00 | ||
Section 15 - Example Sheets | |||
Timesheet Setup | 00:00:00 | ||
Timesheet Calculation | 00:00:00 | ||
Equation Example | 00:00:00 | ||
Equation Example With Name Manager | 00:00:00 | ||
Equation Calculation | 00:00:00 | ||
Dragging Calculations | 00:00:00 | ||
Timeplot Profiles | 00:00:00 | ||
Matrix Math | 00:00:00 | ||
Complex Calculation Example | 00:00:00 |
Excellent!
Excellent Course. Worth the price. The instructor does a good job of explaining the material. He breaks things down, which makes it much easier to understand Excel.
This course will also make a good reference.
So helpful!
I had some self-taught knowledge of Excel, but this course really provided a great foundation for some more advanced options I didn’t know about. Made my job a lot easier! 🙂
Very Good
The course was easy to understand and to follow. I had my excel sheet open and the video displayed in split screen and followed the instructions on the videos and completed the tasks one by one.
Easy to understand
Easy to understand