Excel Training
Power BI Introduction
This session is a comprehensive introduction to Power BI.The session is aimed at beginners and those new to Power BI, and with a background in Excel.We will create and publish a Power BI report from scratch using multiple different data sources including Excel files, PDFs, web data and a folder of CSV files.From this collection of data, we will clean the messy data, mould it into a cohesive data model, perf..
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, ..
Using Excel PivotTables to Easily Summarize and Analyze Data
The ability to analyze data is a powerful skill that helps make better decisions. Microsoft Excel is one of the top tools for data analysis and PivotTables are arguably the most popular analytic tool. The power of Excel PivotTables and their ability to summarize data in flexible ways enables quick exploration of data and produces valuable insights from the accumulated data. PivotTables are used in many diff..
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..
10 Features of Microsoft Outlook that Give You Screaming Productivity
Margaret Thatcher said: “Think of a day when you are supremely satisfied. It is not a day when you lounged around and did nothing, but a day when you had everything to do and you did it.” If this speaks to your daily purpose and emotional makeup, sign up for this webinar. Projects, deadlines, bosses, and your internal psychic all scream for ways to check off more items on your task list in a short amo..
10 Great Time Savers In Outlook 2013 And 2016
Do you use Outlook just for email or do you use it as the headquarters for your daily planning and execution of tasks? Whichever way you use Outlook, you will want to take advantage of the 10 in-depth tips outlined in this webinar that will make you more efficient and effective every day of your life. You’ll learn how to save precious minutes throughout the day, setting you free to use those minutes in prod..
10 Microsoft Outlook Features Attorneys Should Use
Time management for an attorney in a busy law office is a difficult task. Complicating the issue is managing the productivity of your legal team and the entire firm. If you would like more productivity at your law practice sign up for this webinar and learn the 10 most valuable Outlook features you must be using in your law practice. The outlook is a one-stop-shop for email, calendar, and tasks, and when yo..
10 Reasons OneNote is Perfect for Attorneys
Do you wish you could magically simplify your notetaking, sharing of files, and record keeping with a powerful software program? That magic is OneNote. If you have purchased OneNote in either the full-featured desktop version or the “universal” mobile-device-friendly edition and are wondering where the magic is, attend this webinar. You will discover the features that start the magic working, simplifying an..
17 Microsoft Outlook Quick Tricks Every Legal Professional Should Know
Superior technical and organizational skills are critical for the success of a busy legal office. This is a difficult task when you consider managing yourself PLUS the productivity of your entire legal team. If you would like increased productivity in your legal office, sign up for this webinar and learn the 17 most valuable Outlook features your entire firm must use.Outlook is a one-stop-shop for email, ca..
3 Hour Excel Automation Boot Camp
Conditional Formatting and Data ValidationIntroduction to Excel PivotTablesExcel Lookup Functions; VLOOKUP, MATCH, INDEXWith Conditional Formatting, you will learn how massive amounts of data can be analyzed to visually emphasize relationships, find exceptions, and spot trends. Conditional formatting can change the format of cells based on their values in multiple ways including font style, underline style,..
An Introduction to Excel Macros and VBA
A macro is an action or a set of actions that you can use to automate routine tasks. Macros are recorded in the Visual Basic for Applications programming language. The easiest way to create a macro is to record the steps. Excel stores information about each step you take as you perform a series of commands. The steps you do are saved in Visual Basic code. You then run the macro to repeat, or "playback," the..
Create a Dashboard with Excel
In this webinar, you will learn how to make all of your raw data and quickly turn that data into easy-to-use flexible summary reports using Pivot Tables and Charts. We will start with the basics and built up more complex pivot tables. Many people struggle with how to create Pivot Tables, or maybe they don’t even know what they can do, or maybe they think they are too difficult. I’m going to show you what th..
Creating Smart Presentations : Integrating Excel, Word and PowerPoint
Microsoft Office is known for its integration capabilities. We typically work with Excel, Word, and PowerPoint individually, and we may insert data from Excel into a Word report or a PowerPoint presentation. Each program has features specific to sharing data automatically among programs. This webinar will give attendees important time-saving techniques in creating truly smart presentations; determine when a..
Data Analysis in Excel – Working with Multiple Datasets
In the recent past, it was necessary to have some coding skills, and available data analyst or some very strong VLOOKUP skills in order to join related datasets to perform meaningful data analysis. With the new Get & Transform tools and Power Query (which you probably already have, but don’t know it!), you can do this sort of thing yourself with a few clicks. Over the past several versions of Excel, Mic..
Demystify Excel and Harness the Power Within
Excel spreadsheets have really become essential in the workplace. They are used for many purposes, from budgets to forecasts, from financial spreadsheets, to even more scientific purposes and everything in between. But, all spreadsheets require formulas and functions. Formulas are mathematical equations in Excel, and functions are built-in formulas. Building formulas is a crucial skill in Excel, one that ha..