$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

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

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