Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Language
English
Taught by
Simon Sez IT
Rating
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
- 10 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
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
