Publisher`s description - Microsoft Excel 2013: Training Course
★★★★★ Learn Microsoft Excel 2013 with this comprehensive course from "WorldOffice". Application include 180 video lessons with over 9 hours of introductory through advanced instruction. This course covers all the basics you need to start entering your data and building organized workbooks. "WorldOffice" teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros. You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.
Access Course Syllabus & Sample Lessons
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 "WorldOffice" training apps on all your favorite software tools.
Feature:
Clear and vivid full HD video
