Microsoft Excel 2013 Tutorial Posted!

Excel is the most widely used math software in the world!

I’ve created a comprehensive tutorial of Excel 2013 features that  anyone can benefit from

View the Entire Excel 2013 Video Tutorial Here:

 

1. Intro and Overview of Excel 2013

Lesson 1: Introduction to Excel 2013 
Lesson 2: Overview of the User Interface 
Lesson 3: The Quick Access Toolbar 
Lesson 4: Worksheets Vs. Workbooks 
Lesson 5: The Formula Bar 
Lesson 6: The Status Bar 
Lesson 7: The Right-Click Menu and Mini-Toolbar 
Lesson 8: Using the Mouse and Pointers 
Lesson 9: Using the Help System 
Lesson 10: Opening and Saving Files 

2. Entering Data Into Cells

Lesson 11: Entering Data into Cells 
Lesson 12: Using Autofill to Enter Data 
Lesson 13: Entering Dates and Times 
Lesson 14: Undo and Redo 
Lesson 15: Using Comments in your Worksheets 

3. Performing Calculations with Formulas

Lesson 16: Performing Arithmetic with Basic Formulas 
Lesson 17: Using SUM and AVERAGE 
Lesson 18: Copying and Pasting Formulas 
Lesson 19: Calculating Year-to-Date Profit 
Lesson 20: Order of Operations 
Lesson 21: Using Relative and Absolute Addressing in Formulas 
Lesson 22: Max, Min, Median, and Standard Deviation of Data 

4. Formatting Cells

Lesson 23: Font Styles and Colors 
Lesson 24: Changing Column Width and Row Height 
Lesson 25: Alignment and Text Wrap 
Lesson 26: Working with Cell Borders 
Lesson 27: Numeric Formatting of Cells 
Lesson 28: Formatting Date and Time Cells 
Lesson 29: Conditional Formatting 
Lesson 30: Working with tables 
Lesson 31: Insert Shapes, Pictures, Arrows, SmartArt 

5. Adjusting the Layout of a Worksheet

Lesson 32: Insert and Delete Columns and Rows 
Lesson 33: Hiding and Unhiding Rows and Columns 
Lesson 34: Inserting, Moving, and Copying Cells 
Lesson 35: Find and Replace Data 

6. Page Setup and Printing Worksheets

Lesson 36: Page Layout View, Headers, and Footers 
Lesson 37: Page Break Preview 
Lesson 38: Page Setup and Printing Documents 

7. Creating Charts and Graphics

Lesson 39: Creating Charts and Graphs 
Lesson 40: Types of Charts in Excel 
Lesson 41: Formatting Charts in Excel 
Lesson 42: Changing Chart Title, Legend, Axes, and More 
Lesson 43: Creating Sparklines 

8. Adjusting the View of a Worksheet

Lesson 44: Freeze and UnFreeze Panes 
Lesson 45: Split Screen Vertically and Horizontally 
Lesson 46: Creating, Renaming, Deleting Worksheets 

9. Sorting Data and Using the IF Function

Lesson 47: Formulas with Inputs from Multiple Sheets 
Lesson 48: Using the IF Function for Logical Tests 
Lesson 49: Sorting Data 
Lesson 50: Calculating Subtotals in Lists 

10. Filtering Data and Intro to Pivot Tables

Lesson 51: Filtering Data 
Lesson 52: Split Data Into Multiple Columns 
Lesson 53: Introduction to Pivot Tables

 

Mastering Statistics, Vol 1 – Lessons Posted!

We’ve completed the Mastering Statistics Vol 1 course and posted all
lessons below!  Look for more statistics lessons in the future!

Members can view all lessons (click here):

Sect 1: Introduction to Statistics

Sect 2: Populations and Samples
Sect 3: Descriptive Vs. Inferential Statistics
Sect 4: Applying Definitions in Statistics
Sect 5: The Frequency Distribution
Sect 6: Relative and Cumulative Frequency Distributions
Sect 7: Pie Charts, Bar Graphs, and Pareto Charts
Sect 8: Histograms

Sect 9: Stem and Leaf Diagrams
Sect 10: Population Mean and Sample Mean
Sect 11: Calculating Means
Sect 12: Median and Mode
Sect 13: Data Range
Sect 14: Population and Sample Variance
Sect 15: Calculating Variance
Sect 16: Population and Sample Standard Deviation
Sect 17: Calculating Standard Deviation
Sect 18: Coefficient of Variation

Sect 19: Standard Deviation of Frequency Data
Sect 20: Empirical Rule of Standard Deviation
Sect 21: Empirical Rule Problems
Sect 22: Chebyshev’s Theorem of Standard Deviation
Sect 23: Quartiles of Data
Sect 24: Box and Whisker Plots
Sect 25: Standard Score (z-Score)