★★★★★ Learn Microsoft Office 2010 with this comprehensive course from "OfficeWorld". Application include 51 video lessons with over 16 hours of introductory through advanced instruction. You get our complete courses in Excel, Access, Word, Windows Explorer, PowerPoint and Mail Merge. Watch, listen and learn as your expert instructors guide you through each lesson step-by-step. Reinforce your learning with the video of our fifteen printable classroom instruction manuals (Introductory, Intermediate and Advanced). This complete Microsoft Office course covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office.
Whether you are completely new to Microsoft Office or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch the easy-to-use interface, click to start a video lesson or open one of the manuals and you’re on your way to mastering Office.
Access Course Syllabus & Sample Lessons
- Class #01: Windows Explorer and Introduction To Office 2010
- Class #02: Using Windows Explorer For File Management
- Class #03: Creating System Of Folders For File Management Using Windows Explorer
- Class #04: Introduction To Word, Ribbons, QAT, Non-Printing Characters, Clipboard & More
- Class #05: Word Formatting, Insert Picture, Navigation, Selection Tricks, Backup Files
- Class #06: Word Hyperlinks and Save As Web Page
- Class #07: Spell Check, Custom Dictionary -- Auto Correct For Spelling and Shorthand
- Class #08: Word Three Levels Of Formatting: Character, Paragraph, Section
- Class #09: Word Research Paper Tricks Footnotes, Citations, Bibliographies, Styles, Find
- Class #10: Word Tables & Paste Special Link Excel Table Into Word Document
- Class #11: Word Tabs: Left, Right, Center, Decimal, Bar
- Class #12: Word Objects & Word Wrap
- Class #13: Word Theme affects Shapes, Tables, Smart Art, Numbered Lists and Styles
- Class #14: Word Print Preview and Print Dialog Box Are The Same
- Class #15: Word Business Letter & Letterhead
- Class #16: Word Style Tricks: Send Word To PowerPoint & Table Of Contents
- Class #17: How To PowerPoint Tricks
- Class #18: Excel Intro Project 01: Data, Formatting, Formulas, Page Setup
- Class #19: Excel Intro Project 02: Formulas, Charts, Page Setup Net Income
- Class #20: What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions
- Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?
- Class #22: Excel Formulas: Math Operators and Order Of Operations
- Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF
- Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
- Class #25: Excel Cell References: Relative, Absolute, Mixed
- Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions
- Class #27: Excel Stylistic Formatting & Page Setup For Reports
- Class #28: Excel Number Formatting: Formatting As Façade
- Class #29: Excel ROUND Function How And When To Use It.
- Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days
- Class #31: Excel Time Number Format & Payroll Time Sheet Calculations
- Class #32: Excel Percentage Number Format (6 Examples)
- Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting
- Class #34: How Data Must Be Setup To Use Excel Data Analysis Features
- Class #35: Excel Sort and Filter (Data Analysis)
- Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
- Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
- Class #38: Excel IF Function Formula Made Easy (7 examples)
- Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)
- Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data
- Class #41: Introduction to Databases and Access
- Class #42: Access Create Database, Import Table, Create Table, Data Validation For Table
- Class #43, Access One To Many Relationship Between Tables
- Class #44, Access Create Forms (User Interface), Enter Data Tricks
- Class #45, Creating Queries In Access (16 Examples)
- Class #46: Access Create Report Based On A Query
- Class #47: Export Data From Access To Excel, PDF or Text File
- Class #48: Import Excel Data Into Access & Compare & Contrast Formulas in Access & Excel
- Class #49: Word Letter Mail Merge w Excel Data (Number Format Problem & Field Code Fix)
- Class #50: Word Letter Mail Merge w Excel Data (Number Format Problem TEXT function Fix)
- Class #51: Word E-Mail Mail Merge from Data In an Access Database
Take a look in the Windows Store for more "OfficeWorld" training apps on all your favorite software tools.
Features:
- Clear and vivid full HD video
- Full course and Updates Frequently
- Easy as 1 2 3
- Removal of ads
- Search keyword "OfficeWorld" in Window store for more useful eduacation app !!!
- THANKS FOR ALL REVIEWING AND RATING !!!