Product Description Microsoft Excel is one of the most used Math software packages in the world. It is an extremely powerful tool and easy to use once the user knows how to perform the many functions available. In this 6 Hour Video series, Jason Gibson will teach you how to use Excel 2013 through narrated video lessons. Every lesson teaches you the core functionality of Excel with real-world example spreadsheets, formulas, and charts. First, you'll get an overview of excel and a tour of the user interface. Next, you'll master entering data, performing calculations, formulas, formatting cells, charts, filtering data, and much more! 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 About the Actor Jason Gibson is the teacher at MathTutorDVD.com, which produces tutorial courses in Algebra, Calculus, Chemistry, and beyond!
Trustpilot
1 month ago
2 months ago