Other Trainings
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..
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..
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..
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..
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..
Are You Kidding Me?: Communication Tricks for Sticky Situations
This webinar is for you if you ever find yourself in a difficult emotional situation where a cool head is necessary.This session will include a discussion of how the brain and central nervous system react in difficult situations to help participants understand the natural responses driven by these parts of the body. As you learn some of the very basic information built into your human DNA, you will begin ta..
Bringing your PowerPoint Presentation to Life
Even in today's online world, live, face-to-face presentations are still so crucial. That includes presentations of all types: training, sales, staff meetings, stock holder summaries, new company policies, church or organization meetings, fundraisers, etc. Microsoft PowerPoint is still the gold-standard of presentation tools. Because it comes with Microsoft Office and Office 365, most computers have access ..
Business Writing Email Revising, Editing and Proofreading
Communicating through email is fast and convenient and there are rules and etiquette that should need to be followed otherwise it may give a bad impression about the sender to the recipient. After completing this course, you will have learned: how to manage emails, the principles or 'rules of thumb' to ensure professional, clear and effective emails.Learning ObjectivesEmail - Email etiquetteWrit..
Communicate Your Way To The Top: Effective Communication Strategies That Will Help You Speak Up and Stand Out
The quality of our life is determined by the quality of our communication. Effective communication as a female leader in the workplace is no longer a beneficial skill, it’s an essential one.In this session, you will learn how to both demonstrate and demand respect, regardless of your audience. Understand how and when it pays to be assertive, and what that looks like. Uncover the key techniques that will ena..
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..
Developing Empathy and Active Listening Skills – Communication Skills
This webinar includes:Empathy involves understanding and sharing the feelings, perspectives, and experiences of othersIt goes beyond sympathy, as it requires actively connecting with and relating to others' emotionsEmpathy helps create a sense of trust, psychological safety, and mutual understanding in interpersonal interactionsIt promotes a culture of inclusivity, respect, and compassion within teams and o..
Easy Delegation With Microsoft Outlook
Microsoft Outlook can be a powerful partner in your quest to improve your delegation skills and the need to have employees finish assignments on time. Combine the power of Outlook, which everyone opens daily, with this instruction and delegation will become part of your natural workflow.The training is hands-on as attendees are encouraged to use two screens or be able to toggle back and forth between the in..
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 ..
Excel - Automate Repetitive Tasks with Macros
A macro allows you to automate Excel, allowing you to spend more time on other things. So if you find yourself repeatedly performing the same actions or tasks in your spreadsheets, if you have a time-consuming Excel-based process that you want to automate, then it’s time to learn how to create macros.There are two ways to create a macro in Excel - the Macro Recorder and the Macro Editor and this session cov..