Excel Training
Starting With Excel - The Vital Essentials
You can use Excel for basic tables, spreadsheets, calculations and charts through to powerful data management, Pivot Tables, professional graphs and automation of repetitive tasks. Confident skills in this most popular and powerful Microsoft application are becoming an essential requirement in business, government and education. Gain a solid foundation to efficiently build your knowledge to work smarter, bo..
Excel Formulas and Functions
More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.Maybe ther..
Dynamic Array Functions - A Game Changer in Formula Creation
Excel today is not the Excel of yesterday and Dynamic Array Functions are one of the relatively new must-know game-changing features. Dynamic Array Functions will not only simplify the way that you build formulas, but they will also simplify the way you build and work with Excel files. With Dynamic Arrays, you can extract unique values, sort and filter data, lookup multiple values, and build dynamic lists t..
Excel Pivot Tables
In today’s world, there are tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and pr..
Pivot Tables Essentials for Data Analytics in Excel
PivotTables are considered by many to be the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes.A PivotTable displays a summary of a selected data set in a condensed format of rows, columns, data fields and pages. These components can be “pivoted” with your mouse allowing you to expand, isolate, calculate, and group the particul..
Mastering Engaging Chart Essentials in Excel
Imagine impressing your team, executives and clients with your new skills, presenting data visually in engaging professional charts!Effective charting is a strongly “in-demand” and valuable skill to possess in the government, private and education sectors.Charts (graphs) can present information for decision makers and researchers in appealing presentations, making it easier to interpret data. A visually-ori..
Power Query – No Code Automation Every User Needs to Know About
Turn bad data into great data in minutes!Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files and web pages?Does the phrase "it's taking too long" describe how you feel about the time it takes to get your data into the right format for your reports?Do you regularly perform repetitive time-consuming "data cleaning and transforming" tasks such..
Excel Power Pivot and Power Query
In today’s world, there are tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and pr..
PowerBI
In today's busy world, we are sometimes overwhelmed with huge amounts of data, sometimes that data can come from more than one table, or even more than 1 data source. Trying to make sense of this data can be an overwhelming task.Microsoft PowerBI will allow to use to pull in all of your data , and then create great reports and dashboards from that data. This course will show you how to connect your data fro..
Excel Charts
There’s the famous saying, “A Picture is worth a thousand words”. Well, that is very true in Microsoft Excel. A chart can really show the meaning of large amounts of data much better than looking at the actual data can. This webinar will be all about creating and managing different types of charts in Excel.Everybody at work is always looking for charts to represent the data. Excel has excellent charting cap..
Basics of Production Process Validation
The presentation shall cover the following aspects of production process validation:What is Production Process Validation?Why is it Required? When is a production process validation required? Regulatory Sources (Europe - ISO13485: 2016, US/FDA – 21CFR820, IMDRF) The Process of Validation: IQ - Installation Qualification, OQ – Operation Qualification, PQ – Performance QualificationWhat should be done f..
Excel Shortcuts
This course will show you many ways to be more efficient in Microsoft Excel.Areas CoveredKeyboard ShortcutsFormatted TablesCreate a quick data Entry formVlookupSort / FilterSubtotalsIntro to Pivot tablesCourse Level- Beginner/ IntermediateWho Should Attend Business owners CEO’s / CFO’s / CTO’sManagers of all levelsAnybody who uses Excel on a regular basis, and want to be more efficient and..
Crazy Chaos In Your Inbox? Calm The Chaos Today!
Studies show most people spend about 50% of their work time writing and answering emails, substantiating the fact that email is an indispensable part of the workday. Processing email can be tedious, boring, and often mind-numbing yet writing and responding to emails with speed and acumen is pivotal to your success.In this day we spend together, you will learn how to:Survive the email avalanche that dumps in..
Excel - Automation Beyond the Macro Recorder - VBA 101
VBA is Microsoft’s programming and automation language that is built into all the MS Office applications. Although Excel’s Macro Recorder allows you to automate a task by recording a series of keystrokes and mouse clicks, that’s where its functionality and power ends. To be able to do anything more, you need to harness the power of VBA.VBA is a fully-featured programming language that includes functionality..
Excel - Creating an Interactive Dashboard
No matter what business you are in, a dashboard is a critical tool in your communication armory and as with any communication tool, presentation is everything. Although there are many tools that can be used to create a dashboard, Excel is commonly used due to its power, its flexibility, and the fact that most people have it installed on their computers. This training focuses on what you need to know to..