Transparent Consulting, Managed Services, and Staffing for Your Business and Technology Needs.

Transparent Consulting, Managed Services, and Staffing for Your Industrial Design and Prototyping Needs.

Transparent Consulting, Managed Services, and Staffing for Your Private Family Office Needs.

Microsoft Office Productivity Training

Microsoft Windows 10

DescriptionTime Outcome
Access - Introduction

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.
Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.
A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
1 day
Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data.
Create and format custom reports.
Access - Intermediate
Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
1 day
Design a relational database. Join tables to retrieve data from unrelated tables. Validate data entered into a database. Use advanced queries to manipulate your data. Organize a database for efficiency and performance, and to maintain data integrity. Customize reports to organize the displayed information and produce specific print layouts.
Access - Advanced
You've covered many of the basic functions of Microsoft® Office Access® 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training, added to that which you've gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

1 day
Customize a form layout to improve usability and efficiency of data entry.
Share data across applications.
Use macros to improve user interface design.
Use VBA to enhance tasks.
Organize data into appropriate tables to ensure data dependency and minimize redundancy.
Lock down and prepare a database for distribution to multiple users.
Create and modify a database switchboard and set the start-up options.
Excel - Introduction
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.
1 day
Get started with Microsoft Office Excel 2016.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
Excel - Working with Functions
Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.
1 day
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date & Time Functions
Topic E: Work with Text Functions
Excel - Working with Charts
Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.
1 day
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers

Excel - Data Analysis/Pivot Tables
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic Pivot Tables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create Pivot Charts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
.5 daysPrepare data for Pivot Table reporting and create Pivot Tables from various data sources.
Analyze data by using Pivot Tables.
Work with Pivot Charts.
Excel - Automating Tasks
Excel 2016 includes a range of features that enable you to automate a wide variety of workbook tasks. From ensuring that only the correct data is entered into your worksheets, to eliminating repetitive tasks, this course will help you master Excel's automation features so that you can save valuable time and keep your data intact.
1 day
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Excel - Forecasting & Linking Data
If you have a large and complex Excel workbook, then you'll inevitably be juggling numerous variables and values to analyze or even anticipate different business scenarios. In this course, you'll learn the skills you need to make the best use of the Excel features that support advanced planning, scheduling, forecasting, and other types of data analysis.
1 day
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecasting Data Trends
Excel - VBA
This class is designed for advanced users of Excel who want to further automate their work in Excel using macros.
TBDGetting Started with VBA
Working with Procedures and Functions
Understanding Objects
Using Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Working with Forms and Controls
Working with the PivotTable Object
Debugging Code
Handling Errors
OneNote
In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office.
1 day
Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.
Outlook - Intermediate
In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate many management tasks, work with calendars and contacts, manage tasks, protect data with archiving and data files, as well as share and delegate access to your workspaces. In short, you'll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.
This course builds upon the foundational knowledge presented in the Microsoft ® Office Outlook® 2016: Part 1 course and will help you customize a communication system well-suited to your work styles. In addition, this course will help you prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Outlook 2016.
1 day
Modify messages and set global options.
Organize, search, and manage messages.
Manage your mailbox.
Automate message management.
Work with calendar settings.
Manage contacts and groups.
Manage activities by using tasks.
Share workspaces with others.
Manage Outlook data files.
PowerPoint - Introduction
Gone are the days of flip charts or drawing on a white board to illustrate your point. Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2016, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.
1 day
Identify the basic features and functions of PowerPoint 2016.
Develop a PowerPoint presentation.
Perform advanced text editing operations.
Add graphical elements to your presentation.
Modify objects in your presentation.
Add tables to your presentation.
Add charts to your presentation.
Prepare to deliver your presentation
PowerPoint - Intermediate
Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft® Office PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.
1 day
Modify the PowerPoint environment.
Customize design templates.
Add SmartArt and math equations to a presentation.
Work with media and animations.
Collaborate on a presentation.
Customize a slide show.
Secure and distribute a presentation.
SharePoint - BasicsIn many professional environments today, people work collaboratively in teams. Information technology and applications facilitate this by allowing people to easily share, access, edit, and save information. Microsoft® SharePoint® 2016 is a platform specifically designed to facilitate collaboration, allowing people to use familiar applications and Web-based tools to create, access, store, and track documents and data in a central location. In this course, you will learn about and use a SharePoint Team Site to access, store, and share information and documents.
SharePoint is a complex platform with many features and capabilities. A strong understanding of those features and capabilities will allow you to work more efficiently and effectively with SharePoint, and with the documents and data stored in SharePoint. Furthermore, effective use of new social networking capabilities will allow you to identify, track, and advance issues and topics most important to you, and collaborate with colleagues more effectively.
1 day
Interact with SharePoint Team Sites.
Work with documents, content, and libraries.
Interact in SharePoint.
Work with lists.
Integrate SharePoint with Microsoft Office.
SharePoint - Site Owners
Microsoft® SharePoint® 2016 is a platform designed to facilitate collaboration and allow people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. As such, SharePoint has many distinct features that must be enabled and configured, and many content structures that can be selected, added, and configured. In this course, you will learn how to create, configure, and manage a SharePoint team site so that your team or organization can share information and collaborate effectively.
SharePoint content structures and configuration options are complex. Site owners must understand what features, options, and content structures are available in SharePoint, and how to properly configure them. With SharePoint sites, features, and content structures properly implemented, users will be able to securely share files, collaborate on documents, and access information they need to work with their colleagues more effectively.
1 day
Create and configure new sites.
Add and configure document libraries.
Add and configure lists.
Create custom lists and forms.
Assign permissions and access rights.
Extend SharePoint functionality with web parts.
Visio - Level One
From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.
In today’s workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
1 day
Identify the basic elements of Visio and their use.
Create a workflow diagram.
Build organization charts.
Design a floor plan.
Build a cross-functional flowchart.
Design a network diagram.
Style a diagram.
Visio - Level Two
Microsoft® Visio® stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures—anything that can be represented by shapes connected by lines. Most importantly, these shapes can be rearranged and with corresponding lines remaining intact. Visio has improved over the years as features common among Microsoft® Office applications have been added. Today, Visio is well integrated with other members of the Office family as well as Microsoft's cloud-based services. This greatly enriches the sharing and publishing of Visio drawings.
In Microsoft® Visio® 2016: Part 1, you learned the basic skills needed to create and modify various Visio drawings. In Microsoft® Visio® 2016: Part 2, you will learn about more advanced features—making you a more efficient and effective Visio user.
1 day
Design advanced plans and diagrams.
Enhance the look of drawings.
Create shapes, stencils, and templates.
Connect drawings to external data.
Leverage development tools.
Share drawings.
Use diagram standards (optional)
Word - Introduction
Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam.
1 day
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Format text and paragraphs.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Create and format tables.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
Word - Columns & Tables
These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing.
Microsoft® Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
1 day
Topic A: Insert a Table
Topic B: Modify a Table
Topic C: Format a Table
Topic D: Convert Text to a Table
Word - Simplifying Tasks
This class helps you minimize the time and effort spent creating and editing documents. You will learn how to effectively work with repetitive text and formatting using Quick Part building blocks and Styles, how to create a "skeleton" document for future use as a template, how to ensure consistent formatting using Themes, and how to create forms quickly and easily by setting up Content Controls.
Topic A: Automate Tasks by Using Macros
Topic B: Create a Macro
Word - Working with Long Documents
After you master the basics of using Microsoft® Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, you're ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization.
Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.
1 day
Topic A: Insert Blank and Cover Pages
Topic B: Insert an Index
Topic C: Insert a Table of Contents
Topic D: Insert an Ancillary Table
Topic E: Manage Outlines

X