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.3 (3 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.
138 students enrolled
$20
Take This Course
  • Lectures 18
  • Contents Video: 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2013 English

Course 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.

What are the requirements?

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

What am I going to get from this course?

  • 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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:37
A course overview - what we are going to cover and why.
03:55
Bonus! Keyboard shortcuts in Windows! Flip between programs effortlessly. Find programs in a flash and open windows explorer in one second!
Section 2: Microsoft Word - Communicating by letter and writing and formatting reports
16:24
We save time by properly formatting paragraph spacing. Then we insert tables, and work with tabs (no spaces to align text here!).
21:49
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.
Section 3: Microsoft Outlook - Organizing yourself and communicating by email
12:32
Send emails fast. Don't waste time finding the right icon button, we show you keyboard shortcuts to dramatically improve your productivity.
10: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.
15: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.
05:37
Create tasks direct from your inbox by flagging emails. Prioritize and categorize your task list making it your critical business tool.
06:54
Create contacts without having to retype their email or name. Categorize your contacts into key lists: business, personal, or by project.
Section 4: Microsoft Excel - Creating budgets and organizing data
01:57
An overview of what we will cover in the Excel segment of the program
11: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.
03: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.
17: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.
03: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.
12:12
Is your spreadsheet of data a mess? Clean it up quickly - and ensure you can easily filter and create reports. 
14: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.
10:41
Create bar charts, pie charts, and bar / line chart combos! Format charts with ease. Create charts with two axes. 
Section 5: Summary
03:30
Review what you have learnt - it's a lot of material!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Alastair Matchett, 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.

Ready to start learning?
Take This Course