Ready to work in Microsoft Excel, Word, and Outlook
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|A course overview - what we are going to cover and why.|
|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|
|We save time by properly formatting paragraph spacing. Then we insert tables, and work with tabs (no spaces to align text here!).|
|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|
|Send emails fast. Don't waste time finding the right icon button, we show you keyboard shortcuts to dramatically improve your productivity.|
|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.|
|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.|
|Create tasks direct from your inbox by flagging emails. Prioritize and categorize your task list making it your critical business tool.|
|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|
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.|
|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.|
|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.|
|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.|
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.
|Create bar charts, pie charts, and bar / line chart combos! Format charts with ease. Create charts with two axes.|
|Section 5: Summary|
|Review what you have learnt - it's a lot of material!|
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.