Training Office 2013: Excel Essential

★★★★★ Learn Microsoft Excel 2013 with this comprehensive course from "WorldOffice Team". 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 Team" 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 Team" training apps on all your favorite software tools.


  • Clear and vivid full HD video
  • Full course and Updates Frequently
  • Easy as 1 2 3
  • Removal of ads
  • Search keyword "WorldOffice Team" in Window store for more useful eduacation app !!!

Similar Apps View all