Other Trainings
AI to improve MS Excel
Data Entry and Cleaning: AI can automate the process of entering data into Excel, reducing manual effort and the risk of errors. It also assists in cleaning data by identifying and correcting inconsistencies, duplicates, or missing values. Complex Calculations: AI can handle complex calculations and data manipulations that would be time-consuming and prone to error if done manually.Pattern Recognition: AI e..
I Didn’t Know Excel Could Do That!
This Webinar describes, Keyboard Shortcuts: Learn and use keyboard shortcuts to perform common tasks quickly. For example, Ctrl+C for copy, Ctrl+V for paste, Ctrl+Z for undo, etc.Flash Fill: This feature helps you automatically fill values in a column based on patterns you establish. It's great for cleaning and formatting data quickly.AutoSum: Use the AutoSum function (Alt + =) to quickly sum a range o..
Excel - Master the Latest and Greatest 365-Only Functions
Elevate your Excel prowess with this training. Aimed at users already versed in Excel's core functions (SUM, X/VLOOKUP, COUNTIF etc), this course introduces users to some of the new innovative functions added since 2020, exclusively available to Microsoft 365 and Excel 2021 users. These cutting-edge tools are designed to streamline your formula creation process, enhance your data interaction, and expand you..
Key Essentials Of Formulas Functions & Automatic Calculation In Ms Excel
Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at an introductory level.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 in Excel and is ..
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..
Python in Excel Crash Course
The "Python in Excel: Crash Course" significantly enhances data analysis and automation by integrating Python's programming strengths with Excel's widespread utility. This course serves as a crucial tool for both professionals and enthusiasts eager to master modern data processing techniques efficiently. With Python's simplicity and its powerful libraries, users gain an unmatched ability to automate tasks, ..
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 ..
Comprehensive Review Excel Charts
The first part will familiarize you with most of Excel charts’ gallery. The idea is for understand where, when and how to use these Excel charts. The second part is to understand Chart Terminology, Elements and Styles – how to use them and modify the charts with them. At this point you will be comfortable creating and manipulating any of the Excel charts.Next part enables you to take any “predictable” chart..
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..