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…
Picking up where the first class left off, Accessible PDFs and Forms dives straight into documents supplied by real world users. Attendees will tackle remediating troublesome scanned documents, creating accessible fill-in-the-blank PDFs, and working with document packages that have some of the most troublesome accessibility challenges built into them. Most Read more…
If a picture is worth a thousand words, why are you writing so much? New tools in Microsoft Word make it easier than ever to support your conclusions with thought-provoking images, clear charts, definitive tables and even video! Take your document to the future with these skills. Adding Clip Art Read more…
Our second PowerPoint class starts with using images in your slideshow and includes professional graphic design techniques to be certain your images support your presentation, not distract from it. In addition to photographs and clipart, this course covers animations and transitions as well as sound and video. All of the 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…
Reports give you the ability to aggregate the data you are interested in and print it out in creative and professional looking documents. You will start with form letters, but quickly move to adding charts and graphs based on your data. You will also learn the tips and tricks to Read more…
Access 2016 uses a special object type called Forms to represent data visually on screen. Forms are a great method to add exciting front-end user functionality to boring databases and offer ways to protect your data from well-intentioned mistakes. Starting with simple forms and the Forms Wizard, you will quickly Read more…
Understanding Queries in Access 2016 begins with learning how to ask simple questions about your data, like âhow many?â and âwhich ones?â As you explore topics like relationships and referential integrity, however, youâll learn how to select, update and delete records using queries. This class will also introduce you to Read more…
Moving published Word documents to PDF and addressing common issues that crop up. Published PDF -Accessibility Check Intro to Tags Panel Common Errors in and How to Fix Manual Checks Accessibility Report
Adding Tables and Structure an accessible Microsoft Word document using Office 365; plus reviewing the methods of creating a PDF from the Word document. This is part two of a two-part class on creating accessible Word documents. Table Formatting & Usage Table Content & Structure Moving to PDF Tools for Read more…
In the beginning we were using mail merge to customize letters to hundreds of people at a time. The advantages of Mail Merge have grown in the interim to where we should probably be calling them data merges. Microsoft has also simplified the mail merge process so that anyone can Read more…
You cannot communicate a message if your audience is asleep. Learn how to put the WOW into your presentations with animations, transitions, and command buttons. If youâve already discovered entrance effects, youâll learn that there is so much more, as you guide your audienceâs attention around a slide and through 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…
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.
The majority of the class will be spent working on repetitive content in Office documents. Did you know that one of the biggest barriers to comprehension may be the way you type the document??!! You’ll also get information about multi-media accessibility and learn about other barriers you may be creating Read more…
Everyone depends on the ability to skim through a document and find information quickly, no matter their need to use assistive technology. Learn the basics of tables and heding structure in Office, and simultaneously save yourself work in the PDF standard.
