$49
Understanding Lean / Agile Business Analysis

The process of defining IT requirements is evolving rapidly. User Stories, Epics, Features, and Scenarios replace requirement statements. The timing of business analysis activities is shifting. In this overview course, you will learn how to reduce waste in your Business Analysis practices to optimally support the new lean and agile software development world.

 Type
  • Instructor-led
 Duration
  • 1.00
 Audience
  • All
 Goals
  • Understand how lean principles affect business analysis and the requirements definition process
  • Explain how lean requirements such as Features - User Stories - Epic Scenarios etc. look in a lean/agile world
  • Apply lean principles to known business analysis techniques

Excel 2019 Advanced

Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of the most business-useful advanced features of Microsoft Excel that delve into high-level consolidation, analysis, and reporting of financial information.

 Type
  • Instructor-led
 Duration
  • 8.00
 Audience
  • All
 Goals
  • Take your spreadsheet knowledge to the next level
  • Learn to use statistical and financial functions
  • Master data analysis tools such as PivotTables and Pivot Charts
  • Put Scenario Manager - Goal Seek and Solver to work

Complete Excel 2019 for Beginners

This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets to bring your knowledge to an intermediate level. Exercises and sample files at every step along the journey.

 Type
  • Instructor-led
 Duration
  • 7.00
 Audience
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • Learn the basics of Excel 2019 up to an intermediate level
  • Become more confident with your spreadsheets
  • Start performing data analysis in Excel today

$69
Agile Scrum - from Zero to Scrum Master

In this course, you will learn how to compare traditional/waterfall workflow and approach methods with Agile/Scrum methods. You will then dive deeper into your understanding of the Agile/Scrum methods so that you can get a complete understanding of Agile and prepare for your future Scrum Master certification with an extensive review of questions. 

 Type
  • Instructor-led
 Duration
  • 2
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
  • System Administrators
 Goals
  • Understand the differences between Traditional and Agile Workflows and Approaches
  • Understand the complete basics of Agile Scrum
  • Prepare for Agile certification through extensive practice questions

Excel 2016 Advanced

Go beyond the basics and supercharge your Excel capabilities. With this expert-led training course, you’ll gain an in-depth understanding of the most useful and advanced business features of Microsoft Excel that can help you delve into high-level data consolidation, analysis, and reporting of financial information.

 Type
  • Instructor-led
 Duration
  • 9 hrs
 Audience
  • All
 Goals
  • Take your spreadsheet knowledge to the next level
  • Learn to use statistical functions
  • Master financial functions
  • Master data analysis tools such as PivotTables and Pivot Charts
  • Put Scenario Manager Goal Seek and Solver to work

Lean Business Use Cases in an Agile World

Lean Use Cases are becoming the de facto standard for communicating functional requirements in Lean and Agile environments. Writing a Business Use Case is a skill that anyone in an organization can easily acquire. This example-rich course explains the who, what, when, how, and why of Lean Use Case models.

 Type
  • Instructor-led
 Duration
  • 3.50
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • Determine how to handle alternate and exception situations
  • Apply Business Event Analysis to discover Lean Use Cases based on business activities
  • Analyze business scenarios to discover Lean Use Cases
  • Document user interaction in Lean Use Cases descriptions and diagrams
  • Define and defend the need for Lean Use Cases

$79
Data Flow Diagrams - Process Modeling Techniques

This course uses a concrete business scenario to present a simple, easy-to-learn approach for creating Data Flow Diagrams depicting workflow and data manipulation from interviews with Subject Matter Experts. Learn to bridge the gap between IT and the end-user community. If you are tasked with communicating workflows or functional requirements to others, this course is for you. 

 Type
  • Instructor-led
 Duration
  • 1.50
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • Document existing business processes and workflows in a Data Flow Diagrams DFD
  • Explode a high level Data Flow Diagram to its lower level details to reveal underlying processes and procedures
  • Balance DFD’s to identify missing processes and reduce late project change requests
  • Use Horizontal Balancing to discover missing data and minimize redundancies
  • Express metadata to reveal informational details that developers need to build the solution

The Complete Microsoft Word 2019 Course

Using Microsoft Word the right way can save you hours and help you produce more impactful documents and reports. It’s likely you're currently only using less than 20% of the functionality in Microsoft Word. Unlocking that 80% could have a huge impact on your productivity and career. In this course, you start with the basics and perform exercises along the way that help improve your efficiency and professionalism of the documents you produce. 

 Type
  • Instructor-led
 Duration
  • 7.50
 Audience
  • End users
  • Executives and Managers
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • How to properly work with bullets and numbering - watermarks and styles
  • Learn to format paragraphs and manage lists and tables
  • Learn all about formatting paragraphs - envelopes and labels
  • Insert graphics - pictures - shapes - icons and 3D models new in 2019
  • Create an Index or Contents page and protect your document

Microsoft Access 2019 Advanced Training

In this advanced Access course, we look at using both the ODBC and SQL Server. We also take a deeper dive into using Macros and VBA in Access, splitting databases and advanced form creation. This course is intended for students who have a working knowledge of Access but need to utilize it’s more advanced features.

 Type
  • Instructor-led
 Duration
  • 8.0
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
  • System Administrators
 Goals
  • Understand how to split front and back-end databases
  • Gain a working knowledge of macros and VBA in Access
  • Take your Microsoft Access knowledge to the next level
  • Get a good understanding of how ODBC and SQL Server work with Access

Microsoft PowerPoint 2019 Beginner - Intermediate

Microsoft PowerPoint is a popular business tool that can help make the difference between a sale won and lost, or a new initiative launched or pushed aside. PowerPoint includes many tools and features to help in these scenarios yet so few people make full use of this amazing tool. In this in-depth PowerPoint 2019 course, you will learn the most business-relevant PowerPoint techniques, and then practice what you learn through exercises at the end of each chapter.

 Type
  • Instructor-led
 Duration
  • 7
 Audience
  • All
 Goals
  • Learn to create stunning presentations that impact your audience
  • Learn to bring your presentations to life by mastering the different interactive elements of PowerPoint
  • Learn presentation best practice and how PowerPoint can help rather than hinder your delivery

Microsoft Project 2019 Beginner to Intermediate

Whether your project is big or small, business or personal, there are so many many ways that Microsoft Project can ensure project success. In this comprehensive beginner to intermediate course, we give you a detailed grounding in how to best utilize this popular Project Management software and understand its main functionalities. 

 Type
  • Instructor-led
 Duration
  • 9.0
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
  • System Administrators
 Goals
  • Be confident in providing basic project reporting to key stakeholders
  • Understand how to use MS Project to manage your projects
  • Understand the main functionality of MS Project including tasks
  • Learn how to use the critical path method
  • Be able to manage and assign costs to your projects

Microsoft Access 2019 for Beginners

In this Microsoft Access 2019 beginners course, we start at the very beginning and assume you know nothing about Access. We take a project approach to this course, and you build your own project out as we go. By the end of this course, you will have built out your own database with relevant functionality.

 Type
  • Instructor-led
 Duration
  • 8
 Audience
  • Consultants
  • Developers
  • End users
  • Executives and Managers
  • IT/Business analysts
  • Project Managers
  • Project team members
  • System Administrators
 Goals
  • Learn to create your first Access database
  • Master importing data into Access tables
  • Learn to create relationships between tables in Microsoft Access
  • Learn to create forms and sub-forms to feed data to your Access tables

Tableau 10 Desktop Training

This step-by-step course that will take you into the incredible world of Tableau Desktop. Even after the first section of our course, you will understand how to connect to data and build within Tableau! Learn by doing! Our training comes with multiple data sets for you to download with lessons and exercises that challenge you to learn in a fun and engaging way. After the introductory section, every module is independent so you can start from wherever you’d like. 

 Type
  • Instructor-led
 Duration
  • 7.5
 Audience
  • All
 Goals
  • Gain confidence in building out charts in Tableau
  • Understand how to slice and interact with your data
  • Learn to create dashboards to tie together multiple visuals

Getting and Writing IT Requirements in a Lean / Agile World

This course provides a proven set of lean/agile business analysis techniques. After completion, you will know how to express business needs or business requirements as User Stories, Features, and ultimately as Given-When-Then structures. This is the language that allows developers to deliver the IT solutions the organization needs.

 Type
  • Instructor-led
 Duration
  • 4.00
 Audience
  • Consultants
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • Adapt 10 different requirements gathering techniques to Lean - Agile - Continuous Delivery software development
  • Express business needs/wants in formats to optimally support all Software Development Methodologies
  • Learn how to reduce time wasted on miscommunications that can be easily misinterpreted
  • Drill-down into requirements - features - user stories - and functions to identify and express test scenarios
  • Identify 17 types of Non-Functional Requirements and develop Given-When-Then test scenarios for them

Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced skills you need to become more valuable at work. You will learn more advanced ways of working with data, how to master charts and graphs and how to work with dynamic formulas and named ranges. The course includes great exercise files as takeaways.

 Type
  • Instructor-led
 Duration
  • 4.5
 Audience
  • All
 Goals
  • Start your journey in data analysis in Excel
  • Learn all about LOOKUP functions and INDEX MATCH
  • Master dynamic formulas
  • Bring your data to life with brilliant charts and graphs
  • Start using PivotTables and Power Query

Excel VBA Programming for Beginners

Do you work with data in Excel every day? Do you want to take your skills to the next level and improve your efficiency and reduce repetitive work? This course is designed for individuals and professionals who are new to Visual Basic for Applications (VBA) and who are seeking practical ways to automate frequently performed tasks in Microsoft Excel. Contains Exercise Excel Practice workbooks with solutions.

 Type
  • Instructor-led
 Duration
  • 4.00
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • Learn how to automate Excel tasks and operations that you perform frequently
  • Discover how to define and manage variables - subroutines and functions
  • Learn how input boxes and message boxes can interact with end users
  • Create cross-functional flowcharts

Excel VBA Programming - Intermediate

You are ready for this course if you have completed a beginner course in Visual Basic Programming for Applications (VBA) – or you’ve used VBA in your personal life or at work. Challenge yourself with the next logical step! Intermediate VBA steps you through a series of more powerful, more advanced features of VBA programming that can be used even in other Office applications. Includes downloadable exercise files and solutions.

 Type
  • Instructor-led
 Duration
  • 4.00
 Audience
  • Consultants
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
 Goals
  • Learn advanced methods for automating tedious Excel jobs
  • Understand how to write and implement Excel events
  • Learn how to design and implement specialized classes of objects
  • Discover how to customize the right click menu within cell ranges

Microsoft Project 2019 Advanced

If you’re a Project Manager and you’ve been using Microsoft Project but haven’t yet had time to learn all of the in-depth functionalities, then this Microsoft Project 2019 Advanced online course is for you. This course starts where our beginner's course ends and helps you handle more complex project management scenarios.

 Type
  • Instructor-led
 Duration
  • 8.0
 Audience
  • Consultants
  • Developers
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members
  • System Administrators
 Goals
  • Build upon the MS Project Beginning-Intermediate Course to have a more comprehensive understanding of Projects functionalities
  • To be confident in producing bespoke reports for important stakeholders from MS Project
  • Able to set up recurring tasks and automate work in MS Project
  • Be able to use Outline and WBS codes in your projects

Microsoft Outlook 2016

Do you spend hours a day dealing with emails? What if you could get some of those hours back? If you want to stay on top of your inbox and scheduling and spend less time wading through emails, then you need to learn how to use Microsoft Outlook properly. In this Microsoft Outlook course, we'll teach you how to get the most out of this essential productivity tool.

 Type
  • Instructor-led
 Duration
  • 9.5
 Audience
  • All
 Goals
  • Learn to automate tasks using Outlook features and functions
  • Improve your productivity by mastering the management of your Inbox
  • Learn to successfully manage your Contacts and Calendar entries