Office 2013 Complete Tutorial - Windows Explorer, Word, PowerPoint, Excel, and Access

ExcelIsFun via YouTube

Start learning Write review

Learn essential computer applications through this comprehensive video series covering Windows Explorer, Word, Excel, PowerPoint, and Access 2013. Master file management fundamentals including folder organization, navigation techniques, and efficient file handling strategies. Develop Word processing skills from basic formatting and spell-checking to advanced features like hyperlinks, tables, templates, and automatic table of contents creation. Build Excel proficiency starting with grid basics, formulas, and cell references, then progress to advanced functions like VLOOKUP, SUMIFS, PivotTables, charts, and data analysis techniques. Explore PowerPoint presentation creation and formatting while understanding the integration between Office applications. Gain Access database fundamentals including table creation, relationships, queries, forms, and report generation. Practice mail merge operations connecting Word with Excel and Access data sources to create personalized documents and emails. Each lesson provides hands-on examples and practical applications suitable for business environments, with step-by-step instruction on keyboard shortcuts, formatting techniques, and productivity tips designed for students in computer applications courses.

Syllabus

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