★★★★★ Learn Microsoft Office 2013 with this comprehensive course from "SmartOffice Edu", Application include 51 Class lessons with over 14 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: Introduction To Windows Explorer, Folders, Files, Ribbon, QAT, Save As
- Class #02: Windows Explorer For File Management
- Class #03: Windows Explorer: Build System Of Folders To Keep Track Of Files
- Class #04: Intro To Word: Non-Printing Characters, Navigation & Selection Tricks, More
- Class #05: Word Flyer Project, Formatting Text, Insert Picture, Formatting Keyboards
- Class #06: Spell Check Task Pane in Word 2013 & Auto Correct To Create Shorthand
- Class #07: Word Hyperlinks & Save As Web Page
- Class #08: Three Levels Of Formatting In Word: Character, Paragraph & Section
- Class #09: Word Research Paper Tricks
- Class #10: AutoCorrect versus AutoText
- Class #11: Word Nonbreaking Space & Nonbreaking Hyphen Keyboards
- Class #12: Word Paste Special "Text Only" Keyboards: Right-Click key, Ctrl Smart Tag
- Class #13: Word Tables and Excel Tables In Word With Paste Special Link
- Class #14: Word Set Tabs: Left, Center, Right, Decimal, Bar, Leader, and the Ruler
- Class #15: Word 2013: Letterhead, Save As Template, Business Letter
- Class #16: Bulleted, Numbered and Multileveled Lists
- Class #17: Word 2013 Heading Styles To Create Automatic TOC & PowerPoint
- Class #17.5: Word 2013 Basic PowerPoint Formatting
- Class #18: Creating A PowerPoint Presentation
- Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup
- Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule
- Class #21: Excel Basics 03: Count & Add: COUNT, COUNTA, SUM, COUNTIFS, SUMIFS functions
- Class #22: Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report
- Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon
- Class #24: Excel Basics 6: Excel Keyboard Shortcuts Are Fast! 10 Examples.
- Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis
- Class #26: Excel Basics 08: Default Alignment In Excel. Numbers stored As Text Trouble
- Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table
- Class #28: Excel Basics 10: Style Formatting: By Hand, Cell, Table & Conditional Format
- Class #29: Excel Basics 11: Number Formatting & Formulas Don't Get Tricked By The Façade
- Class #30: Excel Basics 12: ROUND function: When and How to use it in Business
- Class #31: Excel Basics 13: Examples of Excel Formulas & Formula Elements
- Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas
- Class #33: Excel Basics 15: Entering Cell References in Formulas & Edit Mode Status Bar
- Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text
- Class #35: Excel Basics 17: Search for Excel Functions: PMT & MEDIAN Functions
- Class #36: Excel Basics 18: Excel Defined Names & Built-in Functions
- Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions
- Class #38: Excel Basics 20: Relative, Absolute and Mixed Cell References
- Class #39: Excel Basics 21: Orientate Formula Inputs To Allow Mixed Cell References
- Class #40: Excel Basics 22: Don't Violate Excel's Golden Rule
- Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples)
- Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples)
- Class #43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more
- Class #44, Excel Basics 26: IF Function Made Easy 8 Examples
- Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - ClassHow To Use VLOOKUP
- Class #46: Introduction to Databases and Access 2013
- Class #47: Access 2013: Create Database, Import Excel, Create Table, Forms, Relationships
- Class #48: Creating Queries In Access 2013 (15 Examples)
- Class #49: Create Report Based On A Query in Access 2013
- Class #50: Export Data From Access To Excel, PDF or Text File
- Class #51: Fix Word 2013 Mail Merge Number Format Problem: Excel & Access Data Source
Take a look in the Windows Store for more "SmartOffice Edu" 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 "SmartOffice Edu" in Window store for more useful eduacation app !!!
- THANKS FOR ALL REVIEWING AND RATING !!!