or
Create an Account
(866) 440-0302
or
Create an Account
Access Portal
(866) 440-0302
or
Create a Member Account
Access Portal

Classes & Events

If you're looking to learn, you’ve come to the right place!

Check off details about the type of class you’re looking for in the box at the left—delivery method, credit hours and date range—along with descriptive words describing your preferred topic. We’ll return a list of upcoming, available classes that match your topic. If you have questions about the class descriptions, or if you are interested in booking private group training for any of the classes, call us at (866) 440-0302.

Back to Class Search
[ VIEW CART ]
Search/Filter
Scroll down after selecting filters to view results.
Keyword Search
Category
Type
Delivery
Recertification Accreditation
Location Of In-Person Class/Event
Need more ways to search? Use our filters and the advanced search at the link below.
Advanced Search
MS Excel Macros and Intro to VBA: Building Tools and Eliminating Repetition

Excel macros and VBA are utilized to automate repetitive tasks, customize Excel's functions, and streamline data processing. With VBA, custom functions and procedures can be created, making complex calculations and data manipulation possible, extending Excel's capabilities, and making it a more powerful and efficient tool for data analysis and reporting.

Program Level: Intermediate

Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience.

Contents:

  • Understanding Macros 
    • What is a Macro?  
      • What is VBA  
        • Displaying the Developer Ribbon Tab  
        • Macro Security 
        • Recording a Macro  
      • Storing Macros  
        • The Personal Macro Workbook  
        • Using Macro-Enabled Workbooks  
      • Running Macros  
    • Creating a Macro Icon for the Toolbar   
  • Creating Macros 3 ways 
    • Absolute Macros 
      • Create a macro for a report or repetitive data set 
    • Relative reference macros 
      • Create a macro that will work on any column 
    • Relative reference macro starting from a selection  
      • Create a macro that will format any selection 
  • Create Functional tools 
    • Create a macro to clean and trim a column 
    • Create a macro to add leading zeros to a column 
  • Introduction to the VBA interface 
    • Visual Basic button / Developer Ribbon 
    • Setting up and understanding the VBA Editor 
    • Using the Project Window / Hiding the Properties Window 
    • Opening / closing and saving your work 
  • Using pre-built code to do what excel does not 
    • Saving a workbook before closing 
    • Create a backup copy with today’s date in the title 
    • Create a new workbook for each worksheet 
    • Create a Table of Contents for you worksheets in a workbook 
    • Moving data from multiple sheets to a single sheet 
    • Text to columns on all columns to apply number format 
    • Create a new sheet for each item in an Autofilter 
    • Copy all Charts to PowerPoint 
  • Visual Basic Forms  
    • What is a VB Form?  
    • Building a Basic Form 
    • Working with Modules 
    • Renaming Modules  
    • Changing Form Properties  
    • Form Controls  
      • Text Boxes  
      • Labels  
      • Combo Boxes  
      • Check Boxes  
    • Displaying the forms 
      • Make your form appear 
      • Closing the form 
      • Adding VB Code to your Form  

Note: This course will be taught using the windows operating system environment

Excel macros and VBA are utilized to automate repetitive tasks, customize Excel's functions, and streamline data processing. With VBA, custom functions and procedures can be created, making complex calculations and data manipulation possible, extending Excel's capabilities, and making it a more powerful and efficient tool for data analysis and reporting. Program Level: Intermediate Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience. Contents: Understanding Macros  What is a Macro?   What is VBA   Displaying the Developer Ribbon Tab   Macro Security  Recording a Macro   Storing Macros   The Personal Macro Workbook   Using Macro-Enabled Workbooks   Running Macros   Creating a Macro Icon for the Toolbar    Creating Macros 3 ways  Absolute Macros  Create a macro for a report or repetitive data set  Relative reference macros  Create a macro that will work on any column  Relative reference macro starting from a selection   Create a macro that will format any selection  Create Functional tools  Create a macro to clean and trim a column  Create a macro to add leading zeros to a column  Introduction to the VBA interface  Visual Basic button / Developer Ribbon  Setting up and understanding the VBA Editor  Using the Project Window / Hiding the Properties Window  Opening / closing and saving your work  Using pre-built code to do what excel does not  Saving a workbook before closing  Create a backup copy with today’s date in the title  Create a new workbook for each worksheet  Create a Table of Contents for you worksheets in a workbook  Moving data from multiple sheets to a single sheet  Text to columns on all columns to apply number format  Create a new sheet for each item in an Autofilter  Copy all Charts to PowerPoint  Visual Basic Forms   What is a VB Form?   Building a Basic Form  Working with Modules  Renaming Modules   Changing Form Properties   Form Controls   Text Boxes   Labels   Combo Boxes   Check Boxes   Displaying the forms  Make your form appear  Closing the form  Adding VB Code to your Form   Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-macros-and-intro-to-vba-building-tools-and-eliminating-repetition/
MS Excel Pivot Tables

Pivot tables are the perfect solution when summarizing and analyzing large amounts of data. You can access a whole new information set in just a few clicks. Pivot tables extract meaning from that endless jumble of numbers on your screen allowing you to group your data differently, drawing helpful conclusions more quickly. If you work with large amounts of data in Excel, you need to know Pivot Tables to work more efficiently.  

Prerequisites: This course requires that you are familiar with Excel. You should have successfully completed Excel I and II or used the software for over six months.

Program Level: Advanced



Contents:

  • PivotTable Fundamentals
  • Creating a Basic Pivot Table
  • Introduce Slicers and other New Pivot Table Tools
  • Customize the Pivot Table View
  • Layout Changes
  • Changing Summary Calculations
  • Using Running Totals, % Of, and Rank Options
  • Grouping, Sorting, and Filtering Pivot Tables
  • Calculations within Pivot Tables
  • Calculated Fields and Calculated items
  • Using Pivot Charts
  • Advanced Pivot Table Tips & Techniques
  • Solutions to Common Pivot Table Problems

Note: This course will be taught using the windows operating system environment

Pivot tables are the perfect solution when summarizing and analyzing large amounts of data. You can access a whole new information set in just a few clicks. Pivot tables extract meaning from that endless jumble of numbers on your screen allowing you to group your data differently, drawing helpful conclusions more quickly. If you work with large amounts of data in Excel, you need to know Pivot Tables to work more efficiently.   Prerequisites: This course requires that you are familiar with Excel. You should have successfully completed Excel I and II or used the software for over six months. Program Level: Advanced  Contents: PivotTable Fundamentals Creating a Basic Pivot Table Introduce Slicers and other New Pivot Table Tools Customize the Pivot Table View Layout Changes Changing Summary Calculations Using Running Totals, % Of, and Rank Options Grouping, Sorting, and Filtering Pivot Tables Calculations within Pivot Tables Calculated Fields and Calculated items Using Pivot Charts Advanced Pivot Table Tips & Techniques Solutions to Common Pivot Table Problems Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-pivot-tables/
MS Excel Quick Tips

Most Excel users could save minutes every day and hours weekly if they learn some of the available time-saving tips and features. In this two-hour session, we share powerful tips, tricks, and shortcuts to help you utilize more of what Excel can do, allowing you to get your work done quicker.  

Prerequisites: The student must be a current Excel user, and have taken Excel Level 1 or have equivalent experience.

Program Level: Intermediate

Contents:

  • Excel Quick Tips
  • Understanding the power behind Flash-fill
  • Using Autofill for all of its capabilities including creating custom lists
  • Navigate worksheets with shortcuts for both mouse and keyboard
  • Copy or move data using dragging instead of traditional commands
  • Best practices for selecting large ranges of data
  • Using functions and keystrokes to enter dates and times with options for fixed or volatile results
  • Formatting multiple worksheets at one time for consistency and time saving
  • Transpose information instead of retyping

Note: This course will be taught using the windows operating system environment

Most Excel users could save minutes every day and hours weekly if they learn some of the available time-saving tips and features. In this two-hour session, we share powerful tips, tricks, and shortcuts to help you utilize more of what Excel can do, allowing you to get your work done quicker.   Prerequisites: The student must be a current Excel user, and have taken Excel Level 1 or have equivalent experience. Program Level: Intermediate Contents: Excel Quick Tips Understanding the power behind Flash-fill Using Autofill for all of its capabilities including creating custom lists Navigate worksheets with shortcuts for both mouse and keyboard Copy or move data using dragging instead of traditional commands Best practices for selecting large ranges of data Using functions and keystrokes to enter dates and times with options for fixed or volatile results Formatting multiple worksheets at one time for consistency and time saving Transpose information instead of retyping Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-quick-tips/
MS Excel Tips & Tricks

Learning Excel tips is highly beneficial for anyone working with data or spreadsheets regularly. Understanding keyboard shortcuts, formula shortcuts, data manipulation techniques, and data analysis features can save time and reduce errors. Whether you're a beginner or an experienced user, this class will empower you to work smarter, not harder. 

Prerequisites: The student must be a current Excel user, and have taken Excel Level 1 or have equivalent experience.

Program Level: Intermediate

Contents:

  • Workbooks and File Secrets 
  • Customizing Excel for Efficiency 
  • Filters and slicers
  • The Most Effective Shortcut Keys 
  • Tips for Selecting and Navigating Efficiently 
  • Finding and Filling blank cells
  • Understanding the power of Flash Fill and Autofill
  • Using the Quick Analysis Feature 
  • Using Conditional Formatting
  • Finding Duplicate records
  • Using Data Validation
  • How to effectively use Excel Indenting 

Note: This course will be taught using the windows operating system environment

Learning Excel tips is highly beneficial for anyone working with data or spreadsheets regularly. Understanding keyboard shortcuts, formula shortcuts, data manipulation techniques, and data analysis features can save time and reduce errors. Whether you're a beginner or an experienced user, this class will empower you to work smarter, not harder.  Prerequisites: The student must be a current Excel user, and have taken Excel Level 1 or have equivalent experience. Program Level: Intermediate Contents: Workbooks and File Secrets  Customizing Excel for Efficiency  Filters and slicers The Most Effective Shortcut Keys  Tips for Selecting and Navigating Efficiently  Finding and Filling blank cells Understanding the power of Flash Fill and Autofill Using the Quick Analysis Feature  Using Conditional Formatting Finding Duplicate records Using Data Validation How to effectively use Excel Indenting  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-tips-tricks/
MS Excel VLOOKUPs & More

Excel LOOKUPs are powerful and versatile functions that can save time and effort when working with large datasets, and they are some of Excel's most valuable and least understood functions. They are used to search for specific values within a data range and return related information from another location. In this session, we will explore ways to return data using advanced techniques like VLOOKUP, XLOOKUP, NAMED RANGES, MATCH, and INDEX functions, and more. 

Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience.

Program Level: Advanced

Contents:

  • How does a lookup function work
  • Create a VLOOKUP to return a single item of data
  • Create a row of VLOOKUP’s
  • Create a drop-down list to facilitate your VLOOKUP search criteria selection
  • Create VLOOKUP’s that return a column of data
  • Create a VLOOKUP that finds the closest match
  • Create VLOOKUP that returns multiple columns
  • Create VLOOKUP’s nesting the Match function to return multiple out of order columns
  • Use XLOOKUP to return multiple columns of data
  • Use XLOOKUP with multiple criteria
  • Use Index and Match as a substitute for VLOOKUP
  • Use Index and Match to find data left of your lookup column
  • Use XLOOKUP to find data left of your lookup column
  • VLOOKUP Tips

Note: This course will be taught using the windows operating system environment

Excel LOOKUPs are powerful and versatile functions that can save time and effort when working with large datasets, and they are some of Excel's most valuable and least understood functions. They are used to search for specific values within a data range and return related information from another location. In this session, we will explore ways to return data using advanced techniques like VLOOKUP, XLOOKUP, NAMED RANGES, MATCH, and INDEX functions, and more.  Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience. Program Level: Advanced Contents: How does a lookup function work Create a VLOOKUP to return a single item of data Create a row of VLOOKUP’s Create a drop-down list to facilitate your VLOOKUP search criteria selection Create VLOOKUP’s that return a column of data Create a VLOOKUP that finds the closest match Create VLOOKUP that returns multiple columns Create VLOOKUP’s nesting the Match function to return multiple out of order columns Use XLOOKUP to return multiple columns of data Use XLOOKUP with multiple criteria Use Index and Match as a substitute for VLOOKUP Use Index and Match to find data left of your lookup column Use XLOOKUP to find data left of your lookup column VLOOKUP Tips Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-vlookups-more/
MS OneNote

OneNote is a digital note-taking app that provides a single place for keeping all of your notes, research, plans, and information — everything you need to remember and manage in one place. In this session, you will develop digital notetaking, note-collaboration, and note-synchronizing skills with Microsoft OneNote, which will allow you to create and update notes, manage lists and outlines, and much more. 

Contents:

  • Navigate the OneNote Environment
  • Use Predesigned Templates for OneNote Notebooks
  • Customize the User Interface within OneNote
  • Modify Formatting in a Notebook
  • Add Audio and Video to a Notebook
  • Add Quick Notes and Links
  • Use Tags, Symbols, Drawing Tools, and Pen Options
  • Use Outlook Integration
  • Organize and Search Notebooks

Note: This course will be taught using the windows operating system environment

OneNote is a digital note-taking app that provides a single place for keeping all of your notes, research, plans, and information — everything you need to remember and manage in one place. In this session, you will develop digital notetaking, note-collaboration, and note-synchronizing skills with Microsoft OneNote, which will allow you to create and update notes, manage lists and outlines, and much more.  Contents: Navigate the OneNote Environment Use Predesigned Templates for OneNote Notebooks Customize the User Interface within OneNote Modify Formatting in a Notebook Add Audio and Video to a Notebook Add Quick Notes and Links Use Tags, Symbols, Drawing Tools, and Pen Options Use Outlook Integration Organize and Search Notebooks Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-onenote/
MS Outlook Level 1

Outlook stores, receives, and sends emails, but it is a personal information management tool because it also includes calendars, meeting invitations, tasks, contacts, and notes. This session teaches learners how to read, create, send, and forward email messages. Participants will then learn to manage notifications and attachments, configure options, and use the search bar. Participants will also learn to manage contacts, work with tasks, create appointments, and schedule meetings. 

Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

 

Contents:

  • Outlook Interface
  • Views
  • Help
  • Creating and sending messages
  • Attachments
  • Handling attachments
  • E-mail management
  • Setting message options
  • Managing junk e-mail
  • Using Search Bar
  • Printing messages and attachments
  • Contacts
  • Creating a single contact
  • Using contact groups
  • Using the People Pane
  • Tasks
  • Creating tasks
  • Managing tasks
  • Appointments and events
  • Creating and sending appointments/events
  • Using Calendar views
  • Scheduling meetings
  • Managing meetings

Note: This course will be taught using the windows operating system environment

Outlook stores, receives, and sends emails, but it is a personal information management tool because it also includes calendars, meeting invitations, tasks, contacts, and notes. This session teaches learners how to read, create, send, and forward email messages. Participants will then learn to manage notifications and attachments, configure options, and use the search bar. Participants will also learn to manage contacts, work with tasks, create appointments, and schedule meetings.  Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.   Contents: Outlook Interface Views Help Creating and sending messages Attachments Handling attachments E-mail management Setting message options Managing junk e-mail Using Search Bar Printing messages and attachments Contacts Creating a single contact Using contact groups Using the People Pane Tasks Creating tasks Managing tasks Appointments and events Creating and sending appointments/events Using Calendar views Scheduling meetings Managing meetings Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-outlook-level-1/
MS Outlook Level 2

Building on the skills and concepts taught in Outlook I, participants will learn how to customize Outlook, use Quick Steps, create Folder pane shortcuts, share calendars, customize their messages and signatures, and set up automatic replies. Participants will then learn how to set rules for organizing messages and use advanced techniques for managing and maintaining their mailboxes. Participants will also learn to search, use filters, and apply categories. 

Prerequisites: Familiarity with Outlook. Successful completion of Outlook I recommended.

Contents:

  • Customizing Outlook
  • The Outlook environment
  • General options and account settings
  • Quick Steps
  • The Folder pane and Navigation bar
  • Customizing messages
  • Message appearance
  • Signatures
  • Voting buttons
  • Out-of-office messages
  • Setting rules
  • Managing your mailbox
  • Archiving and Saving your emails
  • Organizing items
  • Folders
  • Searching
  • Advanced filtering
  • Categories
  • Notes
  • Sharing your calendar and contacts

Note: This course will be taught using the windows operating system environment

Building on the skills and concepts taught in Outlook I, participants will learn how to customize Outlook, use Quick Steps, create Folder pane shortcuts, share calendars, customize their messages and signatures, and set up automatic replies. Participants will then learn how to set rules for organizing messages and use advanced techniques for managing and maintaining their mailboxes. Participants will also learn to search, use filters, and apply categories.  Prerequisites: Familiarity with Outlook. Successful completion of Outlook I recommended. Contents: Customizing Outlook The Outlook environment General options and account settings Quick Steps The Folder pane and Navigation bar Customizing messages Message appearance Signatures Voting buttons Out-of-office messages Setting rules Managing your mailbox Archiving and Saving your emails Organizing items Folders Searching Advanced filtering Categories Notes Sharing your calendar and contacts Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-outlook-level-2/
MS Outlook Time Savers

Most Outlook users could save minutes daily and multiple hours weekly if they learn some of the available time-saving tips and features. In this two-hour session, we share powerful tips, tricks, and shortcuts to utilize more of what Outlook can do, helping you work more efficiently.  

Contents:

  • Delay sending a message
  • Quickly pull up commonly typed text to reuse in any new email
  • Create appointments based off of received emails
  • Set Conditional Formatting for specific people or subjects.
  • Use natural phrases in calendar events
  • View multiple non-consecutive dates for scheduling
  • Conversation view benefits and pitfalls
  • Have outlook automatically add everyone you email and all of your contacts to your safe senders list

Note: This course will be taught using the windows operating system environment

Most Outlook users could save minutes daily and multiple hours weekly if they learn some of the available time-saving tips and features. In this two-hour session, we share powerful tips, tricks, and shortcuts to utilize more of what Outlook can do, helping you work more efficiently.   Contents: Delay sending a message Quickly pull up commonly typed text to reuse in any new email Create appointments based off of received emails Set Conditional Formatting for specific people or subjects. Use natural phrases in calendar events View multiple non-consecutive dates for scheduling Conversation view benefits and pitfalls Have outlook automatically add everyone you email and all of your contacts to your safe senders list Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-outlook-time-savers/
MS Power BI

As technology progresses and becomes more interwoven with daily lives, more data about business and personal activities is collected. This "big data" era directly results from the popularity and growth of cloud computing, which provides abundant computational power and storage, allowing organizations to capture and store data. Leveraging that data can provide timely insights and competitive advantages. 

 

Creating data-backed visualizations is vital for data scientists or professionals to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software serves this purpose. Power BI connects to a wide range of data sources, enabling users to quickly visualize connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. 

Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience.

 

Course Objectives: 

 In this course, you will analyze data with Microsoft Power BI. You will: 

  • Analyze data with self-service BI. 
  • Connect to data sources. 
  • Perform data cleaning, profiling, and shaping. 
  • Visualize data with Power BI. 
  • Enhance data analysis by adding and customizing visual elements. 
  • Model data with calculations. 
  • Create interactive visualizations. 

Note: This course will be taught using the windows operating system environment

As technology progresses and becomes more interwoven with daily lives, more data about business and personal activities is collected. This "big data" era directly results from the popularity and growth of cloud computing, which provides abundant computational power and storage, allowing organizations to capture and store data. Leveraging that data can provide timely insights and competitive advantages.    Creating data-backed visualizations is vital for data scientists or professionals to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software serves this purpose. Power BI connects to a wide range of data sources, enabling users to quickly visualize connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.  Prerequisites: The student must be a current Excel user and have taken at least Excel I and II or have equivalent experience.   Course Objectives:   In this course, you will analyze data with Microsoft Power BI. You will:  Analyze data with self-service BI.  Connect to data sources.  Perform data cleaning, profiling, and shaping.  Visualize data with Power BI.  Enhance data analysis by adding and customizing visual elements.  Model data with calculations.  Create interactive visualizations.  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-power-bi/
MS PowerPoint Level 1

PowerPoint is a computer program that allows you to create and show slides to support a presentation. You can combine text, graphics, and multimedia content to create professional presentations. This course covers the essential functions and features of PowerPoint. After an introduction to PowerPoint's components, participants will create a presentation, add content; arrange, insert, delete slides; and apply themes. Then, they will learn how to create and edit shapes, insert, and modify WordArt objects and pictures, and work with tables, charts, and diagrams. They'll learn how to proof, show, and share their presentations. 

Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

Contents:

  • Getting started
  • The PowerPoint environment
  • Creating presentations
  • Creating a basic presentation
  • Working with slides
  • Templates and themes
  • Editing slide content
  • Formatting text and lists
  • Editing efficiently / Modifying your Presentation
  • Working with shapes
  • Creating shapes
  • Formatting shapes
  • Applying content to shapes 
  • Graphics
  • WordArt
  • Pictures
  • Tables
  • Charts
  • SmartArt 
  • Preparing and printing presentations
  • Proofing presentations

Note: This course will be taught using the windows operating system environment

PowerPoint is a computer program that allows you to create and show slides to support a presentation. You can combine text, graphics, and multimedia content to create professional presentations. This course covers the essential functions and features of PowerPoint. After an introduction to PowerPoint's components, participants will create a presentation, add content; arrange, insert, delete slides; and apply themes. Then, they will learn how to create and edit shapes, insert, and modify WordArt objects and pictures, and work with tables, charts, and diagrams. They'll learn how to proof, show, and share their presentations.  Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Contents: Getting started The PowerPoint environment Creating presentations Creating a basic presentation Working with slides Templates and themes Editing slide content Formatting text and lists Editing efficiently / Modifying your Presentation Working with shapes Creating shapes Formatting shapes Applying content to shapes  Graphics WordArt Pictures Tables Charts SmartArt  Preparing and printing presentations Proofing presentations Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-powerpoint-level-1/
MS PowerPoint Level 2

This course builds on the skills and concepts in PowerPoint Level 1. Participants will learn to control global settings using slide masters and applying effects such as transitions and timings. They'll work with images, and learn to include media files and animation, and explore advanced tools for using SmartArt, tables, and charts. Learners will also integrate other Microsoft Office files, embed and link external resources, and create hyperlinks.  

Prerequisites: Familiarity with PowerPoint. It is suggested that you attend PowerPoint 1.

Contents:

  •  Slide Masters
  •  Notes Masters
  •  Creating Sections
  •  Transitions and timings
  •  Headers and Footers
  •  Custom slide shows
  •  Graphics and media
  •  Modifying graphics
  •  Insert Media
  •  Animations
  •  Customizing slide elements
  •  Integrating Microsoft Office files
  •  Embedding and linking content Hyperlinks
  • Finalizing and distributing presentations

Note: This course will be taught using the windows operating system environment

This course builds on the skills and concepts in PowerPoint Level 1. Participants will learn to control global settings using slide masters and applying effects such as transitions and timings. They'll work with images, and learn to include media files and animation, and explore advanced tools for using SmartArt, tables, and charts. Learners will also integrate other Microsoft Office files, embed and link external resources, and create hyperlinks.   Prerequisites: Familiarity with PowerPoint. It is suggested that you attend PowerPoint 1. Contents:  Slide Masters  Notes Masters  Creating Sections  Transitions and timings  Headers and Footers  Custom slide shows  Graphics and media  Modifying graphics  Insert Media  Animations  Customizing slide elements  Integrating Microsoft Office files  Embedding and linking content Hyperlinks Finalizing and distributing presentations Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-powerpoint-level-2/
MS Project Levels 1 and 2

Microsoft Project assists in developing plans, assigning resources to tasks, tracking progress, managing budgets, and analyzing workloads. This course teaches the basic commands and features of Microsoft Project. Participants will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. Learners will also apply filters and groups, and sort task and resource data. Finally, they will learn how to resolve resource conflicts. 

Prerequisites: The course requires that you are familiar with using personal computers and should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

 

Contents: 

Getting Started 

Project Management Concepts 

  • The Project window 
  • Project files 
  • The Help window 

Tasks 

  • Creating a task list 
  • Modifying a task list 
  • The Work Breakdown Structure 

Task Scheduling 

  • Task links 
  • Task relationships 
  • Task options 

Resource Management 

  • The base calendar 
  • Resources and calendars 
  • Project costs 

Views and Tables 

  • Working with views 
  • Working with tables 

Filters, Groups, and Sorting 

  • Filters 
  • Groups 
  • Sorting tasks and resources 

Finalizing the Task Plan 

  • Finalizing schedules 
  • Handling resource conflicts 

Using Templates and Importing Data 

  • Working with templates 
  • Creating projects from other programs 

Managing a Project 

  • Setting baselines 
  • Updating an active project 
  • Monitoring progress 

Analyzing and Adjusting the Plan 

  • Analyzing the plan 
  • Delays and conflicts 
  • Team Planner view 

Working with Reports 

  • Standard reports 
  • Visual reports 

Customizing Project 

  • Custom views 
  • Macros 
  • Gantt chart formatting 
  • Custom fields 

Managing Multiple Projects 

  • Consolidating and sharing projects 
  • Sharing resources among projects 

Exchanging Project Information 

  • Collaboration 
  • Hyperlinks 
  • Exporting to Office applications 

Note: This course will be taught using the windows operating system environment

Microsoft Project assists in developing plans, assigning resources to tasks, tracking progress, managing budgets, and analyzing workloads. This course teaches the basic commands and features of Microsoft Project. Participants will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. Learners will also apply filters and groups, and sort task and resource data. Finally, they will learn how to resolve resource conflicts.  Prerequisites: The course requires that you are familiar with using personal computers and should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.   Contents:  Getting Started  Project Management Concepts  The Project window  Project files  The Help window  Tasks  Creating a task list  Modifying a task list  The Work Breakdown Structure  Task Scheduling  Task links  Task relationships  Task options  Resource Management  The base calendar  Resources and calendars  Project costs  Views and Tables  Working with views  Working with tables  Filters, Groups, and Sorting  Filters  Groups  Sorting tasks and resources  Finalizing the Task Plan  Finalizing schedules  Handling resource conflicts  Using Templates and Importing Data  Working with templates  Creating projects from other programs  Managing a Project  Setting baselines  Updating an active project  Monitoring progress  Analyzing and Adjusting the Plan  Analyzing the plan  Delays and conflicts  Team Planner view  Working with Reports  Standard reports  Visual reports  Customizing Project  Custom views  Macros  Gantt chart formatting  Custom fields  Managing Multiple Projects  Consolidating and sharing projects  Sharing resources among projects  Exchanging Project Information  Collaboration  Hyperlinks  Exporting to Office applications  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-project-levels-1-and-2/
MS Teams

Microsoft Teams is a collaboration and communication tool that allows local and remote teams to work together and share information using a common space. This session will cover what Microsoft Teams is, how to use and create teams, channels, and tabs, using Teams for communication, scheduling meetings, storing files, and file-sharing.

Note: This course will be taught using the windows operating system environment

Microsoft Teams is a collaboration and communication tool that allows local and remote teams to work together and share information using a common space. This session will cover what Microsoft Teams is, how to use and create teams, channels, and tabs, using Teams for communication, scheduling meetings, storing files, and file-sharing. Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-teams/
MS Word Level 1

This course covers the skills and concepts needed to use Microsoft Word. Participants will learn how to create, save, and navigate documents. They will also learn how to enhance a document's appearance by using various formatting options including tables, page layout, graphics, styles, and outlines. 

Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

Contents:

  •  The Word environment
  •  New documents
  •  Document navigation
  •  Working with text
  •  The Undo and Redo commands
  •  Cut, copy, and paste
  •  Find and replace
  •  Formatting text
  •  Character formatting
  •  Tab settings
  •  Paragraph spacing and indents
  •  Tables
  • Page layout
  • Headers and footers
  • Page setup (margins, page breaks, etc.)
  • Printing
  • Spelling and grammar

Note: This course will be taught using the windows operating system environment

This course covers the skills and concepts needed to use Microsoft Word. Participants will learn how to create, save, and navigate documents. They will also learn how to enhance a document's appearance by using various formatting options including tables, page layout, graphics, styles, and outlines.  Prerequisites: The course requires that you are familiar with using personal computers and have used a mouse and keyboard; basic typing skills are recommended. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Contents:  The Word environment  New documents  Document navigation  Working with text  The Undo and Redo commands  Cut, copy, and paste  Find and replace  Formatting text  Character formatting  Tab settings  Paragraph spacing and indents  Tables Page layout Headers and footers Page setup (margins, page breaks, etc.) Printing Spelling and grammar Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-word-level-1/