Ready to work in Microsoft Excel, Word, and Outlook

Name: Ready to work in Microsoft Excel, Word, and Outlook
Rating: 4.2 (54 reviews)

A short sharp accelerated course on Microsoft Word, Excel and Outlook. Focuses on what you need to know to be productive

Created byAlastair Matchett

Last updated 7/2013

English

What you'll learn

Write letters in Microsoft Word with tables and tabs
Format a report with style headings, create a table of contents, and a cover page
Manage your inbox with ease, create appointments and contacts without having to retype critical information
Create budgets in Excel - make them flexible so you can change assumptions
Analyze data in Excel and produce beautiful reports
View your calendar 14 days at a time, categorize your appointments by project

Course content

5 sections • 18 lectures • 2h 54m total length

Program introduction3:37
A course overview - what we are going to cover and why.
Bonus - windows productivity tools!3:55
Bonus! Keyboard shortcuts in Windows! Flip between programs effortlessly. Find programs in a flash and open windows explorer in one second!

Sending emails12:32
Send emails fast. Don't waste time finding the right icon button, we show you keyboard shortcuts to dramatically improve your productivity.
Managing your inbox10:38
Feel overwhelmed by email? Learn how to quickly filter your inbox. Delete junk mail all at once. File your email easily so you can find old communication quickly.
Viewing and organizing your calendar15:00
Learn how to view variable number of days at a time. Create calendar appointments direct from your inbox - with all the critical information already in the email.
Prioritizing your tasks5:37
Create tasks direct from your inbox by flagging emails. Prioritize and categorize your task list making it your critical business tool.
Managing your contact lists6:54
Create contacts without having to retype their email or name. Categorize your contacts into key lists: business, personal, or by project.

Introduction1:57

An overview of what we will cover in the Excel segment of the program
Formatting the Normal Style11:10
Felt frustrated by the amount of formatting you have to do in Excel? Save masses of time by pre-formatting 90% of your work.
Creating a template for your formatted spreadsheet3:03
Once you have done the heavy lifting of formatting the Normal style, ensure you never have to do it again by creating a reusable template.
Building budgets17:19
Ever felt terror when you try and create a budget in Excel? I'll show you how to create a simple flexible budget model. Simple formatting means your work will glitter with professionalism.
Printing3:56
When you print do you waste a forest of paper? Learn how to preview your print area, control where the page breaks and create headers and footers on the page.
Cleaning up your data12:12
Is your spreadsheet of data a mess? Clean it up quickly - and ensure you can easily filter and create reports.
Data analysis in Excel14:28

Now your data is cleaned up learn how to mine it. Create reports without having to change the underlying data format. Learn how to use Pivot tables and format dates.
Creating readable charts in Excel10:41
Create bar charts, pie charts, and bar / line chart combos! Format charts with ease. Create charts with two axes.

Requirements

A basic understanding of Microsoft Windows
A copy of Microsoft Office 2010

Description

Get productive quickly. If you are new to working in an office environment, or if you need to hone your skills - this course is for you. We take the most important work tasks and show you how to complete them using Microsoft Word, Excel, and Outlook in a more productive way than you thought possible.

Who this course is for:

Anyone who works in an office environment and wants to complete common tasks faster and more effectively

Ready to work in Microsoft Excel, Word, and Outlook

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 8min

Microsoft Word - Communicating by letter and writing and formatting reports2 lectures • 38min

Microsoft Outlook - Organizing yourself and communicating by email5 lectures • 51min

Microsoft Excel - Creating budgets and organizing data8 lectures • 1hr 15min

Summary1 lecture • 4min

Requirements

Description

Who this course is for: