Outlook Training
Excel Boot Camp: Conditional Formatting and Data Validation, Smart-Art and Chart, Integrate Excel, PowerPoint and Word
• Conditional Formatting and Data Validation• Exploring SmartArt and Charts• Integrating Excel, PowerPoint, and WordThis training session covers THREE intermediate to advanced features of Excel that provide automation within the application.Using Conditional Formatting and Data ValidationWith Conditional Formatting, we’ll show you how massive amounts of data can be analyzed to visually emphasize relationshi..
Excel Charting Techniques for Infographics and Dashboards I - Unique, Fun and Dynamic Visualizations
"Every Picture Tells a Story" is a popular saying which is true not only in everyday life but in Excel too. Behind your set of numerical data is a story waiting to be told. The telling of this story needs to be to-the-point, easy to understand, and engaging.Data visualization is the representation of numerical data in a visual format so that your audience can quickly and easily understand it and gain insigh..
Excel Pivot Tables For HR Professionals
We’ll begin by understanding what exactly a Pivot Table is and why they’re so popular! You’ll learn how your data should be set up in order to take advantage of this and other Excel tools. You’ll even learn some valuable clean-up steps that turn data that’s not ideal into data that can support key decisions, become the infrastructure for dashboards, and answer questions in a snap. Once we go through the bas..
Excel PivotTables 2016: The Ace Analytical Tool of Excel
In this webinar, you will learn how to make all of your raw data and quickly turn that data into easy-to-use flexible summary reports using Pivot Tables and Charts. We will start with the basics and built up more complex pivot tables. Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what th..
Excel Savvy: Pivot Tables and Pivot Charts
In this webinar, you will learn how to make all of your raw data and quickly turn that data into easy-to-use flexible summary reports using Pivot Tables and Charts. We will start with the basics and built up more complex pivot tables. Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what th..
Explore What's New in Ms Office 365’s - 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. You will see how the menus have changed, the new functions, and the new features.Learning Object..
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..
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..
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 ..