VBA with Microsoft Excel (v1.2)

In this course, students will use Adobe Acrobat Pro DC to convert technical documents to PDF files, enhance PDF documents, create interactive PDF forms, and prepare PDF files for commercial printing.

Adobe Acrobat Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat, you will ensure the integrity of your documents regardless of who views them.

In this course, students will create a basic report by connecting to a database and modifying the report's presentation.

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.

Organizations use reporting tools to access data sources and generate customized reports. SAPCrystal Reports 2020 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2020 helps you build advanced reports with ease.

In this course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will use subreports and cross-tabs, SQL queries.. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly.

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

This first course will take the attendees from the creating of a Foxit PDF, into editing, and then delivering the documents.

There are many authors of PDF documents that want to take their knowledge of FOXIT to the next level.   This course will allow those authors to become professionals in the FOXIT product.

This one-day course will provide attendees with the skill set to be able to create simple to complex forms using Foxit Editor.  Attendees will learn the ‘how’ and maybe the more important the ‘why’ to create forms.  Students will be provided will a series of documents that they will review before sending to Foxit to be made into workable, sensible, concise and accurate PDF forms

As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.

A one-day, hands-on workshop for business analysts that covers the full capabilities of Power BI.

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. Participants already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help participants gain a competitive edge. Participants will not only be able to summarize data 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.

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge.

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify 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, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

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. 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 builds upon the foundational knowledge presented in the Microsoft Office Excel 2019: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel 2019: Part 1 and Microsoft Office Excel 2019: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

This course is designed to familiarize students with the basic features and functions of Microsoft Project Professional 2016 so they can use it effectively and efficiently in a real-world environment.

Welcome to Microsoft Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment.

Welcome to Microsoft Project 2019/2021: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment. This course covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project and share it with your supervisor (and others) for review and approval.

This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

Microsoft SharePoint online is a platform designed to facilitate collaboration, allowing you 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 and content structures that can be selected, added, and configured. In this course, you will learn how to create, configure, and manage SharePoint sites so that your team or organization can share information and collaborate effectively.

In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft SharePoint is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location.

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 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. 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.

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online.

This course is intended for those interested in expanding their knowledge base and technical skills about Microsoft Project. Starting with the basic concept, you will gain hands-on experience with all the functions needed to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.

This one day course will expose attendees to the theory, best practises and the tools to create an accessible PDF file using the Foxit application.

This course is designed for existing Microsoft SharePoint site users who need to create and manage a SharePoint team site. 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.

In 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.

The objective of this course is to immerse students into accessibility issues and how to create easy to read and accessible Excel spreadsheets.

During this one-day course students will interact with a variety of Word documents and review components that would render the document inaccessible.

The use of PDF forms is popular within industry today. This course will not teach students how to make a PDF form, but rather how to make a PDF form that is accessible for everyone.

This one day session takes accessible document preparation to the next level. During this course students will move from creating simple Office documents, to PDF documents that are fully accessible and meet the current mandates. Attendees will learn a variety of techniques to make documents accessible and also learn about the pitfalls to avoid along the way.

This one-day course will take students into detailed feature of PowerPoint to insure accessible presentations. Attendees will work with some advanced tools and include narration and subtitling for both visually impaired and hearing-impaired audiences.

This course is to provide attendees with the basic concepts and compliances to meet current accessibility dictated by government branches.