Excel Training

$160.00
Excel - 10 Key Worksheet Functions to Skyrocket Your Productivity

 March 22 2024
 01 : 00 PM EST    
 90 Minutes
Excel - 10 Key Worksheet Functions to Skyrocket Your Productivity

An often-asked question by Excel users is "Which Excel worksheet functions are truly essential?" In a world of over 500 built-in Excel functions, the key is to identify the ones that truly impact your productivity and success while discarding the rest. Let's sift through the clutter, leaving behind the rarely-used and highly specialized functions, to uncover a select set of Excel tools that are universally ..

$160.00
AI to improve MS Excel

 March 29 2024
 01 : 00 PM EST    
 60 Minutes
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..

$160.00
I Didn’t Know Excel Could Do That!

 April 04 2024
 12 : 00 PM EST    
 90 Minutes
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..

$160.00
Excel - Master the Latest and Greatest 365-Only Functions

 April 10 2024
 01 : 00 PM EST    
 90 Minutes
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..

$160.00
Key Essentials Of Formulas Functions & Automatic Calculation In Ms Excel

 April 10 2024
 11 : 30 AM EST    
 90 Minutes
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 ..

$160.00
Python in Excel Crash Course

 April 25 2024
 01 : 00 PM EST    
 60 Minutes
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, ..

$160.00
Statistics for the Non-Statistician

 May 01 2024
 01 : 00 PM EST    
 60 Minutes
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..

$160.00
Excel – Mastering Logic Functions

 May 15 2024
 01 : 00 PM EST    
 60 Minutes
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..

$160.00
Intermediate Functions, Lookups and Linking In Ms Excel

 May 15 2024
 11 : 30 AM EST    
 90 Minutes
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..

$160.00
Pivot Tables

 May 20 2024
 12 : 00 PM EST    
 60 Minutes
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 ..

$160.00
Comprehensive Review Excel Charts

 May 31 2024
 01 : 00 PM EST    
 60 Minutes
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..

$160.00
Excel - Mastering Lookup Functions

 June 12 2024
 01 : 00 PM EST    
 60 Minutes
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..

$160.00
Lookup Functions, Formula Tracing and Named Ranges In Excel

 June 12 2024
 11 : 30 AM EST    
 90 Minutes
Lookup Functions, Formula Tracing and Named Ranges In Excel

When it comes to dynamically looking 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.Gaining this knowledge is a fundamental and highly marketable sk..

$160.00
Excel Power Query Data Cleaning Basics

 June 20 2024
 01 : 00 PM EST    
 60 Minutes
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..

$160.00
The Data Ribbon and PivotTables

 June 25 2024
 01 : 00 PM EST    
 60 Minutes
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..

Showing 1 to 15 of 106 (8 Pages)