Ready to work in Microsoft Excel, Word, and Outlook
4.1 (4 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.
142 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 (4 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.
142 students enrolled
Last updated 7/2013
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
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 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
Expand All 18 Lectures Collapse All 18 Lectures 02:54:42
+
Introduction
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
21:49
+
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
12:32

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
10:38

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
15:00

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

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
06:54
+
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
Introduction
01:57

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
11:10

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
03:03

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
17:19

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.
Printing
03:56

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

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
14:28

Create bar charts, pie charts, and bar / line chart combos! Format charts with ease. Create charts with two axes. 
Creating readable charts in Excel
10:41
+
Summary
1 Lecture 03:30
Review what you have learnt - it's a lot of material!
Summary
03:30
About the Instructor
Alastair Matchett
4.1 Average rating
4 Reviews
159 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.