Other Trainings
Exploring Excel: Data Analysis - Automating Excel-Based Financial Statements
In the financial world, information is king. And getting that information as quickly as possible is extremely important. Also, formatting the data into meaningful reports is equally as important. Microsoft Excel is your key to breaking down large amounts of data into meaningful information as quickly as possible. Excel has some built-in functions and tools made just for the financial professional. This webi..
Exploring Excel: Logic Formulas - IF, AND, OR, and Beyond
Microsoft Excel has the possibility of processing your data in many ways with built-in formulas. But, you have to know how to use them. It may be hard to figure out these formulas. This webinar will show you exactly how to utilize the logical formulas and functions in Excel to help you get the most out of your data so you can make meaningful decisions.Areas CoveredIFAndOrNested IFConditional FormattingCondi..
Going From Excel Pivot Tables To KPI Dashboards
IBM states that the data professional jobs projected to grow fastest are Business Intelligence (BI) Data Analytics and Data Visualization/Dashboards. The Demand for Data Analytics and BI Dashboard work alone is projected to grow by 44% over the next two years! 1. Source: IBM: The Quant Crunch, how the demand for data science skills is disrupting the job market.If you have a career that involves creating rep..
Google Sheets for Accountants
This course provides a concise overview of Google Sheets, a cloud-based spreadsheet application by Google. Similar to Excel, the tool allows users to enter numbers, apply formulas, prepare graphs, create charts, use pivot tables and more. While Excel is the default tool and industry standard for most accountants, Sheets has many underrated capabilities which are clearly superior to Excel. These include onli..
How to Become an Influential & Empowered Leader – With or Without a Title
With shifting corporate cultures requiring change management expertise, this webinar focuses on the mindsets, practices and emotional intelligence of the leader or aspiring leader. Discover not only how to facilitate and empower positive change, but how to start by becoming the “changed one” yourself.Stringent notions of management and top-down pyramid corporate structures are constantly being challenged. D..
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..