Many users assume that Microsoft Excel information is already in a Table. It has lines and rows and columns â oh my! Truthfully, the core power of Excel only comes out when you convert that information into Tables and PivotTables. Itâs so easy to filter and sort your information that Read more…
Formulas and Functions are the meat and potatoes of Microsoft Excel. They are the tools that give the program power to achieve our goals. Weâll review the basics of Formulas and Functions in this class before diving headlong into more advanced Functions. This class also takes a look at special Read more…
Beginning with the simple explanation of what accessibility means and why it is important, attendees learn to build accessible documents using Microsoft Office 365 and Adobe Acrobat Pro DC. Common stumbling blocks like alt text, repetitive blank characters and document structure will be addressed, and simple PDF documents will be Read more…
Long thought to be the province of supergeeks, macros will come alive in this exciting class. You will learn how to record macros, be introduced to the Visual Basic programming language, and write simple code statements The Developer tab on the Ribbon Recording Macros Playing back Macros with Keystrokes Adding Read more…
Now that youâve got all of that information, what are you going to do with it? Senior managers and entry-level personnel all benefit from taking this class, where youâll learn the ins and outs of Pivot Tables and Charts, as well as how to import data from databases. Creating Pivot Read more…
Collecting data and storing it is just one part of the Microsoft Excel toolkit. In fact, all those columns of numbers wouldnât be worth much if we couldnât communicate them to other people. This class will explore the impressive array of tools built in to the program that will help Read more…
Formulas and Functions are the meat and potatoes of Microsoft Excel. They are the tools that give the program power to achieve our goals. Weâll review the basics of Formulas and Functions in this class before diving headlong into more advanced Functions. This class also takes a look at special Read more…
Peek behind the spreadsheet and learn Microsoft Excel the right way. Because so many adult learners are self-taught, there are often basic skills that we fail to pick up. This class assumes you have opened the program but arenât secure that you know all the basics. Keyboard Shortcuts Creating Read more…
Primarily a presentation meant to explain what accessibility is, what the rules are, and how the parts play together. Useful for newcomers and managers who need to understand what their staff are up against when making documents accessible. Accessibility in a Nutshell Who is Accessibility For? Accessibility Checkers File Formats Read more…
Microsoft has created a special language to write formulas and measures for PivotTable and Power PivotTable data called DAX. Though remarkably similar to regular Excel formulas, these new functions include filtering in the function and bridging the gap between database languages like SQL and traditional Excel. If you are a Read more…
A dashboard is the holy grail of data. You allow non-data users to interact with your data in a way that provides meaningful button-driven interfaces with visual Pivot Charts and Power Maps. Power Query is the behind the scenes beast that makes all of this possible, and even provides you Read more…
When youâve progressed beyond the bare basics of PivotTables you start to realize how much more is possible by linking information from disparate sets and formatting it for other users to understand. The world of data will open up as you learn about the 3-D data model and the building Read more…
Microsoft Excel allows you to perform many amazing calculations by combining logical functions with operation functions. For example, âcount how many projects were completed ahead of time,â can be restated as âif a project was completed ahead of time, then count it.â Once you understand the lingo, the world of Read more…
Matching data between two sets of information is one of the first tools that most advanced Microsoft Excel users learn. For example, it allows you to take an account number from one list and look up the payments from another list. It forever relieves you of manually filtering data and Read more…
Many users assume that Microsoft Excel information is already in a Table. It has lines and rows and columns â oh my! Truthfully, the core power of Excel only comes out when you convert that information into Tables and PivotTables. Itâs so easy to filter and sort your information that Read more…
If a picture is worth a thousand words, why are you writing so much? Charts are a great way to convey complex data in a meaningful visual format. In fact, studies have proven conclusively that readers will look at a chart and trust it before they will the accompanying data. Read more…
Weâve all seen the worksheet where someone painstakingly color-coded information based on its status, amount, or next steps. But what to do when the next set of data comes in? Why, re-do all that work, of course! But when you learn about Conditional Formatting, youâll learn that all that work Read more…
There are almost 500 functions built into Microsoft Excel, but the vast majority of work is carried out by these top-ten powerhouses. Starting with the venerable Sum function, youâll quickly move into Aggregate functions that will count how many, calculate the highest number and average large sums. But functions are Read more…
People who can make Microsoft Excel dance are the envy of their co-workers. Truth be told, these 10 simple steps will propel you into their ranks as you learn that you donât have to do everything the hard way. Come to the easy side of Excel and learn the secrets Read more…
Round out your understanding of creating accessible documents with the tools and techniques to be certain any reader can access your content. This class will also introduce the special information you need to know to create accessible Excel and PowerPoint documents.
