Microsoft Office

Description This training aims to help participants learn the fundamental features of Tableau, enhancing their data visualization and analysis skills. Throughout the course, participants will be introduced to the Tableau interface, learn different methods for connecting to various data sources, and apply basic analysis techniques to create effective visualizations through hands-on exercises. By working with...

This is a 5-day instructor-led training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and...

Office 365 provides organisations with a suite of business applications including Outlook Online, Office Online Apps, Skype for Business and OneDrive. These online solutions are extended through the interface with Microsoft Office. This 1 day course is designed to assist existing Microsoft Office 2013 users to gain an understanding of the functionality available in Office...

VBA is the programming Interface for Access. This Microsoft Access VBA training course will teach you how to manipulate your Access database using VBA (Visual Basic for Applications) code, automating the database.  Access VBA extends the features of the database, providing you with the full power of Visual Basic programming to manipulate Access objects.  ...

Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. You can use it as a personal data management tool, or you can use it to develop applications for a department or an entire organization. In this course, you will use Access 2016 to manage your data by...

In many professional environments today, people work collaboratively. 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...

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 can be selected, added, and...

This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016, 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 2016 during the planning phase of...

Microsoft PowerPoint provides a wealth of tools to help you deliver content in almost any situation. By taking advantage of the tools that PowerPoint has to offer you will be able to create presentations that not only stand out from the crowd, but also don’t take up all of your time to create. By the...

Student will learn how to create interactive forms, webpages, and macros, use reviewing tools, and create document references like Table of Contents, Indices and Footnotes.   Delegates will learn Work with Forms Mail Merge Work with Webpages Macros Reviewing Documents Use Reference Tools Customizing

In this course, you will learn fundamental Word skills. You will: 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,...

Learn how to create visually compelling diagrams, maps and drawings using Microsoft Visio. Our expert instructors will teach you to quickly and easily integrate structured business graphics into documents and presentations to communicate ideas in a more effective and compelling way. Learn advanced shape properties and interactions, create custom shapes and stencils, use styles, connect...

If you've mastered the basics of creating Power BI reports, you may like to find out what else it can do - but you should only consider attending this course if you use Power BI regularly.  Delegates will also learn how to improve the user experience through the use parameter tables, how to customize the...

Learn to leverage the power of Power BI. Discover how you can quickly gather, cleanse and transform your data with just a few clicks. This course is designed to provide participants with a fundamental understanding of the capabilities of Power BI. Students will discover how to quickly gather, cleanse and transform data with just a...

Learn how to use Excel 2016 advanced PivotTable and PivotChart functionality to summarize, analyze and present large amounts of raw data. In this course, you will learn advanced PivotTable features and how to create PivotCharts. PivotTables and PivotCharts are tools you can use to analyze and summarize your raw data. You will learn how to...

Learn how to use the Excel add-ins Power Pivot and Power Query to manipulate, query, distribute and visualize your data. Power Pivot, Power Query, Power View, 3D maps are free add-ins that expand and combine the features and capabilities of Excel. It includes the ability to import, manipulate and work with large amounts of data...

VBA stands for Visual Basic for Applications. It's a programming language that enables you to control just about everything in Excel. You'll learn how to create Macros that can be run from things like a button on a spreadsheet, the Excel Ribbon - in fact, lots of places. Learning Excel VBA will enable you to...

This course will teach you how to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. You will also learn how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply...

Students will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets. Also in this course you will learn how to use formulas and some advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize a workbook.   Delegates will learn Upon...