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,..
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..
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 Pivot Table of Excel for what we call data mining. Using the process of extracting and discovering patterns..
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 a..
Excel – Reporting Simplified – Learn Pivot Tables from Scratch
Unlock the power of Excel's data analysis and Business Intelligence (BI) toolkit with Pivot Tables. Whether you're aiming to construct dynamic dashboards, conduct in-depth data analysis, or simply streamline data summaries for personal or business purposes, Pivot Tables are your key to success.In just a few clicks, without the need for complex formulas, you can effortlessly generate insightful reports, dyna..
Data Modeling with DAX and Power Pivot
The upcoming webinar on Data Modeling with DAX and Power Pivot offers a deep dive into the transformative techniques of advanced data analysis within the Microsoft ecosystem. This session aims to equip participants with the knowledge and skills to leverage Power Pivot and DAX—two pivotal tools that, when combined, provide unparalleled insights from complex data sets.Power Pivot enhances Excel's capabilities..
Lookup functions and 3-D Excel file
Lookup tables are a good way to search for information and to return specific data relating to the information you introduce or look for. The Lookup function is a quick way to find the information one needs, and is particularly efficient when dealing with large databases that would be extremely time-consuming to search manually. So far, most spreadsheets people deal with use models with rows and columns onl..
Excel Charts
Excel charts are visual representations of data created within Microsoft Excel. They allow users to present data in a graphical format, making it easier to analyze and interpret trends, patterns, and relationships. Excel offers a variety of chart types that can be customized to suit different data visualization needs. Some common types of Excel charts include: Column Chart, Bar Chart, Line Chart, Pie Chart,..