All of the theory in the world cannot prepare you for some of the oddball problems that you will encounter making a PDF accessible. In this workshop you’ll discover how to deal with table column headers that span multiple columns, tagging issues that are disguised as alternate text issues, missing Read more…
One of the reasons Microsoft Word is so powerful is that it can do so many different things, many of them unique to certain professions. Not everyone needs to know these skills, but when you do, you want to make sure youâve got the basics down. This class is for Read more…
This class has one thing that all document need: the big picture. Learn the difference between content and structure, and how they both play an important part in your document creation. Learn the power of the Outline view and experience how easy it is to create advanced features like Tables 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…
Every good database designer needs a tool belt with lots of tricks, and Macros are the 5-star tool you need to automate repetitive tasks. You will be introduced to writing Macros using the Visual Basic Editor and learn how to use Temporary variables and constants, as well as how to Read more…
Tackling the âhardâ topics of accessibility, this final class will put any employee over the goal line when it comes to creating accessible documents. No stone is left un-turned in problem solving involved documents. Form Prep Tools Fillable Forms and Screen Readers Creating Fillable PDFs Working with Links Converting Organization Read more…
Tables are one of the most challenging aspects of making complex PDFs accessible to all audiences. This class will look in-depth at the methods of converting table heavy documents into easily accessible formats. Working with Tables in PDFs Simple Table Errors and How to Fix Complex Table Errors and How Read more…
Legal documents are known for being boring and hard to style. Questions like âcan we move this section to the front of the documentâ can destroy list numbering and throw staff into a frenzy of manual formatting. Learn how to let Microsoft Word handle all of the formatting work for Read more…
Often the last thing people think of, a professional table of contents and other references are the lifeline that busy readers depend on to navigate your document. If youâve ever stayed up late going back over a document to build a table of contents or an index, youâll be glad Read more…
The bane of many an administrator or author, youâll find that Headers and Footers are quite simple when you learn their secrets. Change page numbering easily with the secretive section breaks and build professional looking documents with the odd and even page numbering and different first page features. This class 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…
Almost the first question out of everyone’s mouth during accessibility is “but what aboutâŚ?” and this session will answer those questions. You’ll learn how to work with special requirements of legal documents and how to deal with multi-lingual documents.
Accessible PDFs can be very simple to create, as you’ll learn in this session. The class will review the basics of accessible PDFs and remediate a document on letterhead. Assuming you have started with an accessible Microsoft Office document which you learned about in previous classes, you will also get Read more…
