Excel Training
Surviving Avalanche Email
Is managing your Inbox and digging out from an avalanche of email a full-time job? Then sign up for this webinar and learn how to survive the heavy load of tasks and the constant stream of trivia that arrives via email. You will gain insight into how to work from a clean Inbox and how to reduce what flows into your Inbox while expediting email processing. Outlook provides many Inbox features that can help y..
Take Control of Unwieldy Excel Spreadsheets
Learn how to manage databases in Excel with this webinar. Learn the tools that will help large amounts of data seem more manageable, and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros. Become a master of working with databases in Excel.Learning ObjectivesCreate and use Excel tables, as well as add, edit,..
Tracking Actual Project Progress in Project 2013
Tracking compares what actually happens during your project against what was planned.Protect your well-planned project from becoming a disaster!Thorough project planning is essential, however, keeping your project on track is critical and often more challenging.After planning, reality sets in, bringing likely risks, delays, and budget blow-outs. To effectively manage a project, you must regularly monitor ac..
Using VLOOKUP, MATCH, and INDEX
Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX, and MATCH are some of the most well-known (and most useful) functions in Excel which are used to return data from other locations in worksheets. VLOOKUP enables you to quickly and easily look for value down a column of data and return a value from the same row in a different column. P..