Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Language
English
Taught by
Simon Sez IT
Rating
1 views
Course Overview
The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out—Quickly, No Travel or Classes.
Master the Ins and Outs of Microsoft Office 2013
- Spreadsheets with Excel 2013
- Emails and Calendars with Outlook 2013
- Documents with Word 2013
Contents and Overview
The course is designed for individuals and office professionals who need to master the capabilities of Microsoft Office 2013.
Through 26 hours of video lectures, you'll learn the essentials with these 3 popular courses:
- Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
- Outlook 2013: Get organized with your emails and calendar so you can start getting more done.
- Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.
When you complete this course, you'll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013.
What People Are Saying:
★★★★★ “The lesson is very clear. Easy to understand and perfect for beginners like me.” –Rachelle Deciembre
★★★★★ “It’s very straight forward from what I have seen so far. Great resource for someone who has never used excel with clear explanations.” -Jennifer Janczak
** Updated June 2017. Course transcripts now available.
Course Content
- 103 section(s)
- 231 lecture(s)
- Section 1 Introduction to Excel 2013
- Section 2 Using Touch
- Section 3 Getting Started
- Section 4 Help
- Section 5 Settings and Preferences
- Section 6 The Ribbon and Toolbars
- Section 7 Backup and Recovery
- Section 8 Entering and Deleting Data
- Section 9 Formatting a Worksheet
- Section 10 Copy, Paste and Paste Special
- Section 11 Proofing
- Section 12 Managing Worksheets
- Section 13 Comments
- Section 14 Viewing and Printing
- Section 15 Formulas and Functions
- Section 16 Working with Workbooks
- Section 17 Find and Replace
- Section 18 Conditional Formatting
- Section 19 Graphing and Charting
- Section 20 File Types
- Section 21 Managing Data
- Section 22 Functions Case Study
- Section 23 Analyzing Data
- Section 24 Shapes and Pictures
- Section 25 Sharing and Protecting
- Section 26 More Backstage View Options
- Section 27 Closing
- Section 28 Excel Advanced: Introduction
- Section 29 Excel Advanced: Functions
- Section 30 Excel Advanced: Personal and Professional Financial Functions
- Section 31 Excel Advanced: Date and Time Functions
- Section 32 Excel Advanced: Statistical Functions for Description and Prediction
- Section 33 Excel Advanced: Text Functions
- Section 34 Excel Advanced: Lookup Functions
- Section 35 Excel Advanced: Logical Functions
- Section 36 Excel Advanced: Connecting to External Data
- Section 37 Excel Advanced: Tables
- Section 38 Excel Advanced: Pivot Tables
- Section 39 Excel Advanced: Data Analysis
- Section 40 Excel Advanced: Charts
- Section 41 Excel Advanced: Graphs
- Section 42 Excel Advanced: Pivot Charts
- Section 43 Excel Advanced: Sparklines
- Section 44 Excel Advanced: Web App
- Section 45 Excel Advanced: Conclusion
- Section 46 Outlook 2013: Introduction
- Section 47 Outlook 2013: Using Touch
- Section 48 Outlook 2013: Help
- Section 49 Outlook 2013: Getting Started
- Section 50 Outlook 2013: The Ribbon and Toolbars
- Section 51 Outlook 2013: Options
- Section 52 Outlook 2013: Keyboard Shortcut and Key Tips
- Section 53 Outlook 2013: Basic Tasks in Outlook
- Section 54 Outlook 2013: RSS Feeds
- Section 55 Outlook 2013: Printing
- Section 56 Outlook 2013: Outlook Data Files
- Section 57 Outlook 2013: Account Management
- Section 58 Outlook 2013: Managing Folders
- Section 59 Outlook 2013: Backup and Restore
- Section 60 Outlook 2013: Archiving
- Section 61 Outlook 2013: Import and Export
- Section 62 Outlook 2013: Calendar Management
- Section 63 Outlook 2013: Reminders and To-do Management
- Section 64 Outlook 2013: Search
- Section 65 Outlook 2013: Categories
- Section 66 Outlook 2013: Task Management
- Section 67 Outlook 2013: Contacts
- Section 68 Outlook 2013: Email Management and Advanced Features
- Section 69 Outlook 2013: Safety and Security
- Section 70 Outlook 2013: Conclusion
- Section 71 Word 2013: Introduction
- Section 72 Word 2013: Using Touch
- Section 73 Word 2013: Getting Started
- Section 74 Word 2013: Help
- Section 75 Word 2013: Options
- Section 76 Word 2013: The Ribbon and Toolbars
- Section 77 Word 2013: Backup, AutoSave and AutoRecover
- Section 78 Word 2013: Entering and Editing Data
- Section 79 Word 2013: Copy, Cut and Paste
- Section 80 Word 2013: Navigation and Find
- Section 81 Word 2013: Keyboard Shortcuts
- Section 82 Word 2013: Views
- Section 83 Word 2013: Spell Checker
- Section 84 Word 2013: Formatting
- Section 85 Word 2013: Lists
- Section 86 Word 2013: Managing Document
- Section 87 Word 2013: Page Setup and Printng
- Section 88 Word 2013: Templates, Themes and Styles
- Section 89 Word 2013: PDF in Word
- Section 90 Word 2013: Tables
- Section 91 Word 2013: Graphics
- Section 92 Word 2013: Charts
- Section 93 Word 2013: Resume
- Section 94 Word 2013: Read Mode
- Section 95 Word 2013: Mail Merge
- Section 96 Word 2013: Collaboration, Reviewing and Sharing
- Section 97 Word 2013: Long Documents
- Section 98 Word 2013: Desktop Publishing
- Section 99 Word 2013: Hyperlinks
- Section 100 Word 2013: Security
- Section 101 Word 2013: Conclusion
- Section 102 BONUSES
- Section 103 Additional Training
What You’ll Learn
- Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface., Tips for mouse and touch screen users., Graphs and charts using templates or custom designs., SkyDrive and other tools for sharing work., Pivot tables and slicing., Working with flash fill., Bonus exercise files., Working with dates and times, Calculating depreciation, Averages, percentiles, and LINEST functions, Payments, Inserting and formatting tables, Sparklines and data bars, Pivot charts, Inserting images and videos directly from the internet, Opening and editing PDFs, Read mode, resume reading, object zoom, and collapsible headings, Protecting data with back-up and AutoRecover, Sharing work through email, blogs, and SkyDrive, Document security and editing restrictions, Setting up email accounts, POP and Gmail, Using touch devices, Importing contacts, Calendar appointments and attachments, Tasks and reminders, Email signatures, ‘Sneak a Peek’ and workspace customization, RSS feeds, Archiving and the Trust Center, Spam and junk mail removal
Skills covered in this course
Reviews
-
TTania David
i wish i could apply all this inmy work
-
SSriram Srinivasan
Yes, It is understandable and love to know many new concepts by Ms office.
-
VVeronica Watke
I removed a star because I’m working from a Mac on the latest version and it can be difficult to follow along but otherwise it is great
-
RRey Rivera
Yes it was , needed most of this info for personal and business use
