Outlook Training
An Introduction to Excel Macros and VBA
A macro is an action or a set of actions that you can use to automate routine tasks. Macros are recorded in the Visual Basic for Applications programming language. The easiest way to create a macro is to record the steps. Excel stores information about each step you take as you perform a series of commands. The steps you do are saved in Visual Basic code. You then run the macro to repeat, or "playback," the..
Business Intelligence Resources 2018
Business Intelligence Resources 2018 is the New Economy wave of the Internet. One must learn to use these various online business research tools in a manner that will not only aid but to enhance the various activities and sectors of your business activities. The fast pace of new start ups to maintaining your present position in today’s New Economy…. Business intelligence resources and tools have become a “m..
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..
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..
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 ..
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 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 ..