You've heard of Excel tables but never had a chance to use them? Learn how to structure Excel tables, understand the differences between normal ranges and tables, and the advantages of using tables to create more complex pivot tables and use the Power Query Feature. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24...
VLOOKUP is a must-have Excel function that's used to manipulate data. In this 90-minute webinar we'll explore VLOOKUP and the additional options that make it such a useful tool. We'll also look at some alternatives to VLOOKUP like INDEX/MATCH. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register,...
Discover the power of Styles - the efficient way to format and design Word documents. If you're a regular user of Word creating reports, proposals, manuscripts, etc. learning to use Styles is a game changer! Your productivity will SOAR if iInstead of using direct formatting, you use styles to format your document so you can quickly and easily apply a set of formatting choices consistently. PRE-REGISTRATION IS REQUIRED FOR...
Excel Function Overview (In Person Class) Excel Functions Overview: Setup, structure and syntax, common problems with functions, and troubleshooting tips Not as confident about Excel functions as you'd like to be? This in person class is designed for people who who have used Excel but don't feel they know enough about functions. We'll talk about...
Learn the basics of Pivot Table construction in Excel. We'll discuss data organization, define what a pivot table does, and create several examples of this need-to-know Excel feature. Familiarity with the Sorting and Filtering tools in Excel is recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Workshop Location:...
Dig into VLOOKUP, INDEX/MATCH and other important lookup functions. In this workshop, we'll dive into some of the most important lookup functions in Excel and their uses: VLOOKUP, INDEX/MATCH, and other similar functions. These functions are essential for searching for data in large datasets and bringing back related information. We'll explore the pros and cons of VLOOKUP, INDEX...
PowerPoint Beyond the Basics: Intermediate level overview including animation, Slide Masters, Sound, and Looped Presentations. This in-person class is designed to introduce key concepts crucial to building a working knowledge of Microsoft PowerPoint. In this class we'll talk about intermediate level concepts including animation, Slide Masters, sound, and looped presentations. PRE-REGISTRATION IS REQUIRED FOR ATTENDING...
Learn the basics of Pivot Table construction in Excel. We'll discuss data organization, define what a pivot table does, and create several examples of this need-to-know Excel feature. Familiarity with the Sorting and Filtering tools in Excel is recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you...
Learn how to use IF and other logical functions to add conditions to Excel tasks Add power and complexity to your Excel spreadsheets! In this 90-minute webinar we'll talk about about one of the most powerful functions in Excel - the IF function. We'll also talk about other logical functions like AND/OR as well as...
In this 90-minute webinar we'll dive deeper into Pivot Tables exploring Pivot Charts, Slicers, Timelines, Calculated Fields and Custom Grouping. Familiarity with basic pivot tables recommended. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter class shortly before class. Please...
Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text Text strings and dates can cause big problems in a spreadsheet if you're not aware of how to identify and manipulate them! In this 90-minute webinar we'll talk about basic text functions like CONCATENATE and date functions like TODAY....
Excel Advanced Concepts: Additional Data Analysis tools - Data validation, Subtotal and What-Ifs This 90-minute webinar focuses on some additional data tools available in Excel that are very useful but often overlooked. We'll talk about data validation, the Subtotal feature (an alternative to pivot tables), and the What-If tools. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS...
