Other Trainings
Take a Deep Dive into Little Known Microsoft Outlook Features with HUGE Productivity Benefits
Microsoft Outlook is a powerful, comprehensive software tool because it combines email, a calendar, and tasks.The goal is to make your professional life more productive and fulfilling as you gain the ability to get more done in less time. You will conquer your task list in record time as you learn advanced Outlook techniques and how to: Use the features in the expanded ribbon in these Outlook folders: Mail,..
Statistics for the Non-Statistician
The Excel Data Analysis ToolPak Add-in allows Excel users to solve statistical analysis problems without the need for a statistical background or being familiar with conventional Excel statistical functions. This tool can solve your problems applicable to finance, statistics, engineering, and more.The “Descriptive Statistics” feature of the Data Analysis ToolPak, allows you to analyze data and get all the s..
Managing Team Workflow with Microsoft Outlook
No doubt you and your team are proficient at using Microsoft Outlook for email and meetings, but did you know you and your team are leaving about 85% of the power of Microsoft Outlook unused. Outlook is a powerful program that can simulate a programming language if you know how to use it. This webinar helps individuals customize Outlook for their personality and their job. It helps you manage those who repo..
Excel – Mastering Logic Functions
Have you ever needed to Automate entering different values into a cell depending on a certain criterion?Count the number of times a word, number or date appears in a range (and keep it current)?Add up a set of numbers that match a criterionReplace the ugly #NA or #DIV/0 with something more aesthetically pleasing?These are just some of the things that you can do using Excel's built-in Logic functions.Areas C..
Intermediate Functions, Lookups and Linking In Ms Excel
To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of correct structure and syntax.This webinar effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you need to understand the depth and scope of these Excel features. Gaining this knowledge is a fundamental and highly marketable skill set..
Technical Writing in a Pharmaceutical Environment
Those persons who attend the webinar will understand how Technical Writing in a pharmaceutical environment differs from normal correspondence. They will learn how different Technical Writing is from novels, newspaper, and magazine articles as well as other forms of communication. The primary purpose of these forms of communication is to entertain. The primary purposes of Technical Writing are to inform (rep..
Pivot Tables
An Excel pivot table is a powerful data analysis tool that allows users to summarize and analyze large sets of data in a spreadsheet. It helps users organize and aggregate data from a table or range into a more meaningful format, making it easier to understand and draw insights.Pivot tables are useful for quickly analyzing and visualizing large datasets, identifying patterns, and gaining insights into your ..
Technical Writing in an Industrial Environment
Those persons who attend the webinar will understand how Technical Writing in an industrial environment differs from normal correspondence. They will learn how different Technical Writing is from novels, newspaper, and magazine articles as well as other forms of communication. The primary purpose of these forms of communication is to entertain. The primary purposes of Technical Writing are to inform (report..
Using Excel Tables
This webinar describes,Structured Data Organization: Excel tables provide a structured way to organize and manage data. They automatically expand to include new data, making it easy to maintain and update your datasets without manually adjusting formulas or ranges.Dynamic Range Names: When you convert a range of data into an Excel table, it automatically assigns dynamic range names to each column. This make..
Training for New Technical Writers
The webinar is intended for personnel who have little or no training in Technical Writing. The people who attend the webinar will learn the value of hands-on training to become competent Technical Writers. Technical Writers learn to do by doing. That means that Technical Writers must create Technical Documents repeatedly in order to learn the techniques necessary to become Technical Writers. Attendees will ..
Excel - Mastering Lookup Functions
"How do I look up a value in list ONE and pick up a related value from list TWO""How do I avoid my lookup formula displaying an ugly error when it can't find a match?""I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?"These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering..
Excel ChatGPT PivotTables Advanced Data Management Functions and Much More
Harness the awesome power of AI to take Excel to a new level and boost your efficiency working smarter and faster.Mastering AI is now a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including public service, banking, accounting, financial analysis, and business administration.Understanding the correct setup, options, question formats, capabilitie..
Excel Power Query Data Cleaning Basics
In today’s data-driven landscape, mastering the art of data cleaning and preparation is critical. The "Excel Power Query Data Cleaning Basics" webinar is a pivotal resource for anyone looking to harness Excel's Power Query for advanced data management. This session goes beyond introducing Power Query’s features, aiming to arm participants with practical skills to revolutionize data analysis and enhance thei..
The Data Ribbon and PivotTables
The workshop is based on the instructor’s recent book.“Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards”The objective of this workshop is to use the features of the data ribbon and the PivotTable of Excel for what we call datamining. Using the process of extracting and discovering patterns in..
Excel ChatGPT Data Management Charting Protection and Formulas
Gain easy-to-understand and practical “hands-on” knowledge of ChatGPT and Artificial Intelligence (AI) with a focus on significantly enhancing capabilities in Microsoft Excel.Harness the awesome power of AI to take Excel to a new level and boost your efficiency … working smarter and faster.Mastering AI is now a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions ..