Excel Training
Linking and Consolidating Data in Excel Workbooks
Excel provides the ability to connect a cell to data entered into another cell. A linked cell behaves as if it actually contains the data in the original cell. A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern while cells on each worksheet contain the same..
Lookup Function Essentials In Excel 2013 to 2016
When it comes to dynamically look up and retrieving information from small or huge tables of data Lookup functions can elevate you to a new world of accuracy, productivity and time savings in Excel.To work efficiently with lookup functions you must start with clear understanding, good habits, and application of correct structure and syntax.This course effectively teaches lookup techniques and demonstrates p..
Make Outlook a Partner in Productivity
Are you one of those people who regularly sign up for time management seminars but you still can’t get a handle on all your projects and tasks? Then sign up for this webinar and get real help, not theory.Effective time management demands that you understand time management principles AND have a tool to implement those principles, this webinar combines both. You are given fundamental time management principl..
Managing Excel Data: Sorting, Filtering, Subtotaling and Creating Tables
To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. Managing data is becoming more important than ever as data collection becomes more automated. What can you do with all that data? You need to know how to rearrange the data (Sort), see just what you want to see (Filter), create quick summaries (Subtotals). Learn to use tables to add even more options for manag..
Microsoft Excel For HR Professionals: 9 Essential Functions You Must know
Recruitment, training & development, compensation & benefits, payroll, employee relations, staff retention, etc. HR professionals are often seemed to have the easiest jobs in the company.Or is it?In reality, what goes behind the scenes is the endless amount of human resource information system (H.R.I.S.) inputs, preparing reports for the management, and spending face-time with employees just to get ..
Microsoft Excel: Data Management Features (Sorting, Filtering, Tables, Subtotals…)
Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. It’s all the more important as data collection has become more automated and you’re getting swamped with tons of data. But what can you do with all that data? You need to know how to re-arrange the data (sort), see..
Office 365 Demystified: Groups, Teams & SharePoint
Often the user community has moved from a well-understood structure of network shared drives and email attachments to, what must seem like, the wild west. In this program, we will pull back the covers on the structures used to organize people and share information in an Office 365 world. You’ll get a look at Teams App, Outlook, SharePoint, and how these work together to create a collaboration platform for y..
Outlook Best Practices: Get Organized With Microsoft Outlook
This 60 minute Get Organized with Outlook session will encourage and enlightened Outlook users on how to use Microsoft Outlook to more confidently and efficiently organize their information and commitments. Participants will learn smarter tips, tricks, and systems to better manage their tasks, follow-ups, contacts, notes, and calendar items. Don't worry, this is not a boring computer class (you'll have fun!..
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..
Planning, Prioritizing and Execution with the Outlook Calendar and Tasks
Do you face daily dilemmas trying to figure out where to start on your task list? Task lists can be overwhelming with a great range of items to complete. Some can wait but others are urgent and demand immediate attention. When you have 5 or 6 urgent requests at one time, the choice of which one to work on first can be agonizing. The principles taught in this program solve the puzzle for you. You will learn ..
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..
Stay Safe and Secure by Building Error-proof Spreadsheets
The worst error you can get in Excel is the wrong information. In this session, you’ll first learn what can go wrong in your Excel workbooks that might deliver inaccurate information and how to prevent it. You’ll discover ways to build integrity checks to make sure your data stays reliable. We’ll cover the pros and cons of each protective measure, enabling you to make the right decision for your workbooks. ..
Stop Microsoft Outlook Illiteracy from Slowing Productivity
Anything new introduced into your schedule has the potential to slow down your productivity. This is disconcerting to individuals who have the producer’s mindset and makes them shy away from the new, impairing their movement into the future. In the case of the complex Microsoft Outlook software, time spent learning how to use it pays huge dividends in productivity, even when upgrading from one version to a ..
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,..