Outlook Training
Outlook For Finance Professionals
As a finance professional, if you want to get more done in less time and stay on top of your closeout deadlines every month, sign up for this webinar and learn the details of using Microsoft Outlook for increased productivity. Microsoft Outlook is a critical partner for your financial software and it deserves specific instruction to take advantage of the productivity benefits of little-known Outlook feature..
PM Skills for BAs-Planning, Estimating, and Controlling BA Work
Is poor project management impacting your effectiveness? What can you do about it? How’s that working out? Historically, Business Analysts (BAs) and Project Managers (PMs) focus on and are trained in separate skill sets. BAs focus on requirements definition, whereas PMs concentrate on budgets, schedules, resources, and tasks. Having both PM and BA present on a project presumably enables covering all bases w..
Power Query - How to Import and Clean Data Quickly
Do you import data into Excel from other sources (such as CSV files, text files, web pages, databases, or SharePoint)? Does the data that you import need to be "cleaned" before it can be used? (cleaning refers to things like removing duplicate rows, removing blank rows, removing unnecessary columns, converting cases, changing date formats, and more).Do you spend more time than necessary performing data clea..
Putting Business and Analysis back in Business Analysis
Do you sense business analysis and business analysts are falling behind? Is it as fulfilling as you’d like or expect, and do others give it the respect it needs and deserves? For instance, increasingly business analysts seem left out of Agile projects. These all can be signals business analysis is failing to provide adequate business value. It may merely reflect difficulty communicating value that actually ..
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..