Application " Microsoft Excel 2013 Training Course " include 180 video lessons with over 9 hours of introductory through advanced instruction. You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more. Simply launch the easy-to-use interface, click to start a video lesson and you’re on your way to mastering Excel.
Playlist:
CHAPTER 1- Getting Acquainted with Excel
Lesson 1.1- About Excel
Lesson 1.2- The Excel Environment
Lesson 1.3- The Title Bar
Lesson 1.4- The Ribbon
Lesson 1.5- Scroll Bars
Lesson 1.6- The Quick Access Toolbar
Lesson 1.7- Touch Mode
Lesson 1.8- The Formula Bar
Lesson 1.9- The Workbook Window
Lesson 1.10- The Status Bar
Lesson 1.11- The Workbook View Buttons
Lesson 1.12- The Zoom Slider
Lesson 1.13- The Mini Toolbar
Lesson 1.14- Keyboard Shortcuts
CHAPTER 2- File Management
Lesson 2.1- Creating New Workbooks
Lesson 2.2- Saving Workbooks
Lesson 2.3- Closing Workbooks
Lesson 2.4- Opening Workbooks
Lesson 2.5- Recovering Unsaved Workbooks
Lesson 2.6- Using the “Window” Command Group
Lesson 2.7- Switching to Full Screen View
Lesson 2.8- Working With Excel File Formats
CHAPTER 3- Data Entry
Lesson 3.1- Selecting Cells
Lesson 3.2- Entering Text into Cells
Lesson 3.3- Entering Numbers into Cells
Lesson 3.4- AutoComplete
Lesson 3.5- Pick from Drop-Down List
Lesson 3.6- Flash Fill
Lesson 3.7- Selecting Ranges
Lesson 3.8- Ranged Data Entry
Lesson 3.9- Using AutoFill
CHAPTER 4- Creating Formulas
Lesson 4.1- Ranged Formula Syntax
Lesson 4.2- Simple Formula Syntax
Lesson 4.3- Writing Formulas
Lesson 4.4- Using AutoSum
Lesson 4.5- Inserting Functions
Lesson 4.6- Editing a Range
Lesson 4.7- Formula AutoCorrect
Lesson 4.8- AutoCalculate
Lesson 4.9- Function Compatibility
CHAPTER 5- Copying & Pasting Formulas
Lesson 5.1- Relative References and Absolute References
Lesson 5.2- Cutting, Copying, and Pasting Data
Lesson 5.3- AutoFilling Cells
Lesson 5.4- The Undo Button
Lesson 5.5- The Redo Button
CHAPTER 6- Columns & Rows
Lesson 6.1- Selecting Columns & Rows
Lesson 6.2- Adjusting Column Width and Row Height
Lesson 6.3- Hiding and Unhiding Columns and Rows
Lesson 6.4- Inserting and Deleting Columns and Rows
CHAPTER 7- Formatting Worksheets
Lesson 7.1- Formatting Cells
Lesson 7.2- The Format Cells Dialog Box
Lesson 7.3- Clearing All Formatting from Cells
Lesson 7.4- Copying All Formatting from Cells to Another Area
CHAPTER 8- Worksheet Tools
Lesson 8.1- Inserting and Deleting Worksheets
Lesson 8.2- Selecting Multiple Worksheets
Lesson 8.3- Navigating Worksheets
Lesson 8.4- Renaming Worksheets
Lesson 8.5- Coloring Worksheet Tabs
Lesson 8.6- Copying or Moving Worksheets
CHAPTER 9- Setting Worksheet Layout
Lesson 9.1- Using Page Break Preview
Lesson 9.2- Using Page Layout View
Lesson 9.3- The Page Setup Dialog Box
CHAPTER 10- Printing Spreadsheets
Lesson 10.1- Previewing and Printing Worksheets
CHAPTER 11- Helping Yourself
Lesson 11.1- Using Excel Help
CHAPTER 12- Creating 3D Formulas
Lesson 12.1- Creating 3D Formulas
Lesson 12.2- 3D Formula Syntax
Lesson 12.3- Creating 3D Range References
CHAPTER 13- Named Ranges
Lesson 13.1- Naming Ranges
Lesson 13.2- Creating Names from Headings
Lesson 13.3- Moving to a Named Range
Lesson 13.4- Using Named Ranges in Formulas
Lesson 13.5- Naming 3D Ranges
Lesson 13.6- Managing Named Ranges
CHAPTER 14- Conditional Formatting and Cell Styles
Lesson 14.1- Conditional Formatting
Lesson 14.2- Finding Cells with Conditional Formatting
Lesson 14.3- Clearing Conditional Formatting
Lesson 14.4- Using Table and Cell Styles
CHAPTER 15- Paste Special
Lesson 15.1- Using Paste Special
Lesson 15.2- Pasting Linked Formulas
CHAPTER 16- Sharing Workbooks
Lesson 16.1- Sharing Workbooks
Lesson 16.2- Highlighting Changes
Lesson 16.3- Reviewing Changes
Lesson 16.4- Using Comments
Lesson 16.5- Compare and Merge Workbooks
CHAPTER 17- Auditing Worksheets
Lesson 17.1- Auditing Worksheets
Lesson 17.2- Tracing Precedent and Dependent Cells
Lesson 17.3- Tracing Errors
Lesson 17.4- Error Checking
Lesson 17.5- Using the Watch Window
Lesson 17.6- Cell Validation
CHAPTER 18- Outlining Worksheets
Lesson 18.1- Using Outlines
Lesson 18.2- Applying and Removing Outlines
CHAPTER 19- Consolidating Worksheets
Lesson 19.1- Consolidating Data
CHAPTER 20- Tables
Lesson 20.1- Creating a Table
Lesson 20.2- Adding an Editing Records
Lesson 20.3- Inserting Records and Fields
Lesson 20.4- Deleting Records and Fields
CHAPTER 21- Sorting Data
Lesson 21.1- Sorting Data
Lesson 21.2- Custom Sort Orders
CHAPTER 22- Filtering Data
Lesson 22.1- Using AutoFilters
Lesson 22.2- Using the Top 10 AutoFilter
Lesson 22.3- Using a Custom AutoFilter
Lesson 22.4- Creating Advanced Filters
Lesson 22.5- Applying Multiple Criteria
Lesson 22.6- Using Complex Criteria
Lesson 22.7- Copying Filter Results to a New Location
Lesson 22.8- Using Database Functions
CHAPTER 23- Using What-If Analysis
Lesson 23.1- Using Data Tables
Lesson 23.2- Using Scenario Manager
Lesson 23.3- Using Goal Seek
CHAPTER 24- Table-Related Functions
Lesson 24.1- The Hlookup and Vlookup Functions
Lesson 24.2- Using the IF, AND, and OR Functions
CHAPTER 25- Sparklines
Lesson 25.1- Inserting and Deleting Sparklines
Lesson 25.2- Modifying Sparklines
CHAPTER 26- Creating Charts In Excel
Lesson 26.1- Creating Charts
Lesson 26.2- Selecting Charts and Chart Elements
Lesson 26.3- Adding Chart Elements
Lesson 26.4- Moving and Resizing Charts
Lesson 26.5- Changing the Chart Type
Lesson 26.6- Changing the Data Range
Lesson 26.7- Switching Column and Row Data
Lesson 26.8- Choosing a Chart Layout
Lesson 26.9 Choosing a Chart Style
Lesson 26.10 Changing Color Schemes
Lesson 26.11- Printing Charts
Lesson 26.12- Deleting Charts
CHAPTER 27- Formatting Charts in Excel
Lesson 27.1- Formatting Chart Objects
Lesson 27.2- Inserting Objects into a Chart
Lesson 27.3- Formatting Axes
Lesson 27.4- Formatting Axis Titles
Lesson 27.5- Formatting a Chart Title
Lesson 27.6- Formatting Data Labels
Lesson 27.7- Formatting a Data Table
Lesson 27.8- Formatting Error Bars
Lesson 27.9- Formatting Gridlines
Lesson 27.10- Formatting a Legend
Lesson 27.11- Formatting Drop and High-Low Lines
Lesson 27.12- Formatting Trendlines
Lesson 27.13- Formatting Up/Down Bars
Lesson 27.14- Formatting the Chart and Plot Areas
Lesson 27.15- Naming Charts
Lesson 27.16- Applying Shape Styles
Lesson 27.17- Applying WordArt Styles
Lesson 27.18- Saving Custom Chart Templates
CHAPTER 28- Data Models
Lesson 28.1- Creating a Data Model from External Relational Data
Lesson 28.2- Creating a Data Model from Excel Tables
Lesson 28.3- Relating Tables in a Data Model
Lesson 28.4- Managing a Data Model
CHAPTER 29- PivotTables and PivotCharts
Lesson 29.1- Creating Recommended PivotTables
Lesson 29.2- Manually Creating a PivotTable
Lesson 29.3- Creating a PivotChart
Lesson 29.4- Manipulating a PivotTable or PivotChart
Lesson 29.5- Changing Calculated Value Fields
Lesson 29.6- Formatting PivotTables
Lesson 29.7- Formatting PivotCharts
Lesson 29.8- Setting PivotTable Options
Lesson 29.9- Sorting and Filtering Using Field Headers
CHAPTER 30- PowerPivot
Lesson 30.1- Starting PowerPivot
Lesson 30.2- Managing the Data Model
Lesson 30.3- Calculated Columns and Fields
Lesson 30.4- Creating KPIs
Lesson 30.5- Creating and Managing Perspectives
Lesson 30.6- PowerPivot PivotTables and PivotCharts
CHAPTER 31- Power View
Lesson 31.1- Starting Power View
Lesson 31.2- Adding Report Visualizations
Lesson 31.3- Changing the Layout of Report Visualizations
Lesson 31.4- Using Undo and Redo in Power View
Lesson 31.5- Formatting the Power View Sheet
Lesson 31.6- Creating Multiples in a Chart
CHAPTER 32- Slicers and Timelines
Lesson 32.1- Inserting and Deleting Slicers
Lesson 32.2- Modifying Slicers
Lesson 32.3- Inserting and Deleting Timelines
Lesson 32.4- Modifying Timelines
CHAPTER 33- Security Features
Lesson 33.1- Unlocking Cells
Lesson 33.2- Worksheet Protection
Lesson 33.3- Workbook Protection
Lesson 33.4- Password Protecting Excel Files
CHAPTER 34- Making Macros
Lesson 34.1- Recording Macros
Lesson 34.2- Running and Deleting Recorded Macros
Lesson 34.3- The Personal Macro Workbook
Take a look in the Windows Store for more "For-You" training apps on all your favorite software tools.
Features:
- Microsoft Excel 2013 Training Course
- Learning Microsoft Excel 2013 Training Course