Ready to work in Microsoft Excel, Word, and Outlook
4.1 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
147 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ready to work in Microsoft Excel, Word, and Outlook to your Wishlist.

Add to Wishlist

Ready to work in Microsoft Excel, Word, and Outlook

A short sharp accelerated course on Microsoft Word, Excel and Outlook. Focuses on what you need to know to be productive
4.1 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
147 students enrolled
Created by Alastair Matchett
Last updated 7/2013
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • A basic understanding of Microsoft Windows
  • A copy of Microsoft Office 2010

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 is the target audience?
  • Anyone who works in an office environment and wants to complete common tasks faster and more effectively
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
2 Lectures 07:32
A course overview - what we are going to cover and why.
Preview 03:37

Bonus! Keyboard shortcuts in Windows! Flip between programs effortlessly. Find programs in a flash and open windows explorer in one second!
Preview 03:55
Microsoft Word - Communicating by letter and writing and formatting reports
2 Lectures 38:13
We save time by properly formatting paragraph spacing. Then we insert tables, and work with tabs (no spaces to align text here!).
Preview 16:24

We learn how to format a report with styles so your headings are consistent. We then create an automated table of contents and a cover page.
Creating and formatting a report
Microsoft Outlook - Organizing yourself and communicating by email
5 Lectures 50:41
Send emails fast. Don't waste time finding the right icon button, we show you keyboard shortcuts to dramatically improve your productivity.
Sending emails

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.
Managing your inbox

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.
Viewing and organizing your calendar

Create tasks direct from your inbox by flagging emails. Prioritize and categorize your task list making it your critical business tool.
Prioritizing your tasks

Create contacts without having to retype their email or name. Categorize your contacts into key lists: business, personal, or by project.
Managing your contact lists
Microsoft Excel - Creating budgets and organizing data
8 Lectures 01:14:46
An overview of what we will cover in the Excel segment of the program

Felt frustrated by the amount of formatting you have to do in Excel? Save masses of time by pre-formatting 90% of your work.
Formatting the Normal Style

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.
Creating a template for your formatted spreadsheet

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.
Building budgets

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.

Is your spreadsheet of data a mess? Clean it up quickly - and ensure you can easily filter and create reports. 
Cleaning up your data

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.
Data analysis in Excel

Create bar charts, pie charts, and bar / line chart combos! Format charts with ease. Create charts with two axes. 
Creating readable charts in Excel
1 Lecture 03:30
Review what you have learnt - it's a lot of material!
About the Instructor
Alastair Matchett
4.1 Average rating
6 Reviews
165 Students
2 Courses
Financial trainer

Alastair Matchett started his finance career at JP Morgan’s London advisory unit after attending the internationally renowned Morgan Finance Program in New York. In addition to working as investment banker, he also helped design and manage training for the bank. Alastair went on to manage a portfolio of private equity investments for Investors in Industry and negotiate equity financing for leveraged buyouts. Since co-founding AMT, Alastair has designed complete training programs for both analyst and associate entry classes for some of Wall Street’s major investment banks. Alastair is the author of AMT's Introduction to Accounting for Finance, widely known as Wall Street’s popular “green book” for new analysts and the Valuation Midnight Manual. Alastair loves to horse-ride and to trek the wilds when on holiday.