Other Trainings
KPI Dashboards: How To Go From Pivot Tables to Excel Interactive, BI Dashboards
In this training session, you'll learn how to create a stunning, interactive professional-looking dashboard using Excel. This training will provide you with a solid foundation that you can use to build your own dashboards and reports.No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, a presentation is everything. Although there..
Laying Out a Financial Model
The problem with modeling in Excel is no two spreadsheets look the same. This makes it difficult for end users to understand and modelers to take over others work. This course considers the four key principles required for laying out a good financial model and provides practical tips and tricks to get your spreadsheets on the right track from the very start. The session revolves around building the rudiment..
Let’s Upgrade to Excel 2016 / 2019
When you have Office365, you automatically get the newest version of Excel. If you are upgrading from Excel 2010 or even an earlier version, then you will see many new changes. The menus have changed, there are new functions, etc. It can be very confusing. This webinar will make the transition seamless and easy. Areas Covered New MenusNew FunctionsFormatted tables/SlicerN..
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 ..
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..