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
Adobe Acrobat DC

This course will teach fundamental concepts and terminology of Adobe Acrobat. Participants will learn PDF basics and explore the Acrobat interface. They will learn how to create, navigate, and organize PDF documents, to modify PDF content by rearranging, editing, and formatting existing text; including adding headers, footers, watermarks, and backgrounds. They will explore document review techniques, including using comments and markups, adding bookmarks and links, and managing security issues by using password encryption and signatures.  

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: 

  • The Acrobat environment 
  • Advanced navigation 
  • Finding text 
  • Customizing the environment 
  • Creating PDF documents 
  • Printing to PDF from other applications 
  • The Create PDF commands 
  • Saving to the Cloud 
  • Editing text, images 
  • Editing text and images 
  • Editing page design 
  • Modifying PDF documents 
  • Moving document pages 
  • Inserting and manipulating pages 
  • Exporting PDF to other programs 
  • Optimizing PDF file size 
  • Document navigation tools 
  • Working with bookmarks 
  • Working with links 
  • Document security 
  • Managing comments and markups 

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

This course will teach fundamental concepts and terminology of Adobe Acrobat. Participants will learn PDF basics and explore the Acrobat interface. They will learn how to create, navigate, and organize PDF documents, to modify PDF content by rearranging, editing, and formatting existing text; including adding headers, footers, watermarks, and backgrounds. They will explore document review techniques, including using comments and markups, adding bookmarks and links, and managing security issues by using password encryption and signatures.   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:  The Acrobat environment  Advanced navigation  Finding text  Customizing the environment  Creating PDF documents  Printing to PDF from other applications  The Create PDF commands  Saving to the Cloud  Editing text, images  Editing text and images  Editing page design  Modifying PDF documents  Moving document pages  Inserting and manipulating pages  Exporting PDF to other programs  Optimizing PDF file size  Document navigation tools  Working with bookmarks  Working with links  Document security  Managing comments and markups  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/adobe-acrobat-dc/
Adobe Illustrator Level 1

Adobe Illustrator is a software application for creating drawings, illustrations, and artwork widely used by graphic designers, web designers, visual artists, and professional illustrators worldwide to produce high-quality artwork. Illustrator includes many sophisticated drawing tools that can reduce the time needed to create illustrations. This course covers the fundamentals of using Illustrator to create and manipulate vector graphics. Participants will learn to navigate the Illustrator environment, design, and transform basic shapes, edit drawn paths, apply color and gradients, work with text, and use layers.  

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 to Know the Work Area 

  • Using tools 
  • Moving around in a document 
  • Setting up the interface 
  • Using Artboards 

Selecting Artwork 

  • Selection options 
  • Align and distribute 
  • Grouping objects 

Using Shapes to Create Artwork 

  • Creating basic shapes 
  • Adding strokes 
  • Using the Shaper tool 
  • Tracing an image 
  • Drawing modes 

Editing Shapes and Paths 

  • Splitting and joining paths 
  • Combining shapes 

Transforming Artwork 

  • Working with artboards 
  • Rulers and guides 
  • Scale, Reflect, Rotate and Shear 

Using Drawing Tools 

  • Straight lines and curves with the Pen tool 
  • Editing paths and points 
  • Freeform paths 

Using Color 

  • Using existing colors 
  • Creating custom colors 
  • Global swatches 
  • Spot colors 

Adding Type 

  • Area type and Point type 
  • Font character options 
  • Reshaping type characters 
  • Preset Envelope warped type 
  • Type on a path 

Working with Layers 

  • Adding and ordering layers 
  • Move content between layers 

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

Adobe Illustrator is a software application for creating drawings, illustrations, and artwork widely used by graphic designers, web designers, visual artists, and professional illustrators worldwide to produce high-quality artwork. Illustrator includes many sophisticated drawing tools that can reduce the time needed to create illustrations. This course covers the fundamentals of using Illustrator to create and manipulate vector graphics. Participants will learn to navigate the Illustrator environment, design, and transform basic shapes, edit drawn paths, apply color and gradients, work with text, and use layers.   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 to Know the Work Area  Using tools  Moving around in a document  Setting up the interface  Using Artboards  Selecting Artwork  Selection options  Align and distribute  Grouping objects  Using Shapes to Create Artwork  Creating basic shapes  Adding strokes  Using the Shaper tool  Tracing an image  Drawing modes  Editing Shapes and Paths  Splitting and joining paths  Combining shapes  Transforming Artwork  Working with artboards  Rulers and guides  Scale, Reflect, Rotate and Shear  Using Drawing Tools  Straight lines and curves with the Pen tool  Editing paths and points  Freeform paths  Using Color  Using existing colors  Creating custom colors  Global swatches  Spot colors  Adding Type  Area type and Point type  Font character options  Reshaping type characters  Preset Envelope warped type  Type on a path  Working with Layers  Adding and ordering layers  Move content between layers  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/adobe-illustrator-level-1/
Adobe InDesign Level 1

Adobe InDesign is a desktop publishing and typesetting software application used to create works such as books, newspapers, magazines, flyers, brochures, and posters. This course will teach fundamental concepts, terminology, and the basic features of Adobe InDesign CC. This course is for learners who want to create professional documents and print layouts. Participants will learn to create documents, place text and graphics, work with master pages, create custom colors, and print and export documents to PDF. 



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 to Know the Work Area

  • Using tools
  • Navigating through a document
  • Setting up the interface

Setting Up A Document

  • Creating and saving a new document
  • Working with Master pages
  • Adding, deleting, and rearranging pages
  • Page numbering with Sections

 Working with Objects

  • Using InDesign layers
  • Text frames and Graphics frames
  • Wrapping text
  • Transform and align objects

Editing and Flowing Text

  • Flowing text manually
  • Flowing text automatically
  • Adding columns
  • Adding jump lines

 Entering Text

  • Entering text
  • Importing text
  • The Story Editor

 Working with Typography

  • Character and paragraph options
  • Adding a Drop Cap
  • Using Tabs
  • Adding paragraph rules

 Working with Color

  • Creating and applying colors
  • Creating and applying gradients

 Adding Graphics

  • Adding graphics to a document
  • Comparing bitmap and vector graphics
  • Managing graphic links

 Printing and Exporting Basics

  • Creating and saving a PDF Preset
  • Creating and saving a Print Preset

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

Adobe InDesign is a desktop publishing and typesetting software application used to create works such as books, newspapers, magazines, flyers, brochures, and posters. This course will teach fundamental concepts, terminology, and the basic features of Adobe InDesign CC. This course is for learners who want to create professional documents and print layouts. Participants will learn to create documents, place text and graphics, work with master pages, create custom colors, and print and export documents to PDF.   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 to Know the Work Area Using tools Navigating through a document Setting up the interface Setting Up A Document Creating and saving a new document Working with Master pages Adding, deleting, and rearranging pages Page numbering with Sections  Working with Objects Using InDesign layers Text frames and Graphics frames Wrapping text Transform and align objects Editing and Flowing Text Flowing text manually Flowing text automatically Adding columns Adding jump lines  Entering Text Entering text Importing text The Story Editor  Working with Typography Character and paragraph options Adding a Drop Cap Using Tabs Adding paragraph rules  Working with Color Creating and applying colors Creating and applying gradients  Adding Graphics Adding graphics to a document Comparing bitmap and vector graphics Managing graphic links  Printing and Exporting Basics Creating and saving a PDF Preset Creating and saving a Print Preset Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/adobe-indesign-level-1/
Adobe InDesign Level 2

This course builds on the fundamentals taught in InDesign I. Participants will learn how to create detailed styles for text and graphics, set custom tabs and indents, work with color groups, and design tables. We'll look at graphics and transparency settings and work with custom forms and web documents. 



 Prerequisites: We ask that you have successfully completed Adobe InDesign I or are familiar with all concepts covered in the first course.

Contents: 

Unit1: Adjusting Graphics 

  • Grid layout 
  • Wrap text around a graphic 
  • Transform frame shapes 

Unit 2: Typography 

  • Stroke and fill text 
  • Using glyphs 
  • Column adjustments 
  • Custom tabs 

Unit 3: Color 

  • Color groups 
  • Color themes 

Unit 4: Styles 

  • Paragraph & Character styles 
  • Object styles 

Unit 5: Modifying Graphics 

  • Updating graphics 
  • Background graphics 
  • InDesign libraries 

Unit 6: Tables 

  • Creating tables 
  • Formatting tables 
  • Add graphics to table cells 
  • Table and cell styles 

Unit 7: Transparency 

  • Transparency settings 
  • Blending modes 
  • Effects 

Unit 8: Adobe PDF Forms 

  • Set up the workspace 
  • Add form fields 
  • Submit and export a form 

Unit 9: Fixed Layout EPUB 

  • Adding animation 
  • Adding buttons 
  • Exporting an EPUB file 

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

This course builds on the fundamentals taught in InDesign I. Participants will learn how to create detailed styles for text and graphics, set custom tabs and indents, work with color groups, and design tables. We'll look at graphics and transparency settings and work with custom forms and web documents.    Prerequisites: We ask that you have successfully completed Adobe InDesign I or are familiar with all concepts covered in the first course. Contents:  Unit1: Adjusting Graphics  Grid layout  Wrap text around a graphic  Transform frame shapes  Unit 2: Typography  Stroke and fill text  Using glyphs  Column adjustments  Custom tabs  Unit 3: Color  Color groups  Color themes  Unit 4: Styles  Paragraph & Character styles  Object styles  Unit 5: Modifying Graphics  Updating graphics  Background graphics  InDesign libraries  Unit 6: Tables  Creating tables  Formatting tables  Add graphics to table cells  Table and cell styles  Unit 7: Transparency  Transparency settings  Blending modes  Effects  Unit 8: Adobe PDF Forms  Set up the workspace  Add form fields  Submit and export a form  Unit 9: Fixed Layout EPUB  Adding animation  Adding buttons  Exporting an EPUB file  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/adobe-indesign-level-2/
Adobe Photoshop Level 1

Adobe Photoshop is the industry-standard image editing software used worldwide by photographers and designers who want to perfect their digital images. Learners will modify digital images to add creative effects and repair defects. After completing this course, participants can use Photoshop to make selections, create and transform layers, apply image adjustments, retouch, repair photographs, and resize images. 

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 to Know the Work Area 

  • Using tools 
  • Moving around in an image 
  • Setting up the interface 

Basic Photo Corrections 

  • Understanding resolution 
  • Straighten and crop 
  • Adjust color and tone 

Basic Selections 

  • Selection tools 
  • Moving and adjusting selections 
  • Cropping an image 

Layer Basics 

  • The Layers panel 
  • Viewing and moving layers 
  • Layer opacity and blending modes 
  • Basic filters 
  • Adding text 
  • Adding a gradient to a layer 
  • Layer styles 
  • Adjustment layers 
  • Flattening and saving files 

Quick Fixes 

  • Red eye correction 
  • Brighten an image 
  • Liquify and blur 
  • Content-aware fill 

Using Type 

  • Point type and paragraph type 
  • Type as a clipping mask 
  • Type on a path 
  • Warped type 

Preparing Files for Printing 

  • Proof your image 
  • Color gamut basics 
Adobe Photoshop is the industry-standard image editing software used worldwide by photographers and designers who want to perfect their digital images. Learners will modify digital images to add creative effects and repair defects. After completing this course, participants can use Photoshop to make selections, create and transform layers, apply image adjustments, retouch, repair photographs, and resize images.  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 to Know the Work Area  Using tools  Moving around in an image  Setting up the interface  Basic Photo Corrections  Understanding resolution  Straighten and crop  Adjust color and tone  Basic Selections  Selection tools  Moving and adjusting selections  Cropping an image  Layer Basics  The Layers panel  Viewing and moving layers  Layer opacity and blending modes  Basic filters  Adding text  Adding a gradient to a layer  Layer styles  Adjustment layers  Flattening and saving files  Quick Fixes  Red eye correction  Brighten an image  Liquify and blur  Content-aware fill  Using Type  Point type and paragraph type  Type as a clipping mask  Type on a path  Warped type  Preparing Files for Printing  Proof your image  Color gamut basics 
Copy URL: https://letscatapult.org/events/adobe-photoshop-level-1/
Computer Basics: Windows and more

This class is recommended for learners with little or no prior computer/software experience who need to organize files and folders, search for items on their computers, and use and personalize Windows. Participants will also learn how to browse the Web and understand viruses and malware. 

 

Contents:

  • Computer basics
  • Computer components
  • What makes computers work
  • Managing computer contents
  • Storing items on your computer
  • Working with folders
  • Working with files
  • Searching for content and using Help
  • Searching for data on your computer
  • Customizing Windows
  • Shortcuts
  • System settings
  • Using the Internet
  • Browsing the Web
  • Security and maintenance

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

This class is recommended for learners with little or no prior computer/software experience who need to organize files and folders, search for items on their computers, and use and personalize Windows. Participants will also learn how to browse the Web and understand viruses and malware.    Contents: Computer basics Computer components What makes computers work Managing computer contents Storing items on your computer Working with folders Working with files Searching for content and using Help Searching for data on your computer Customizing Windows Shortcuts System settings Using the Internet Browsing the Web Security and maintenance  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/computer-basics-windows-and-more/
Cyber-Security Essentials

Cybersecurity refers to ensuring information integrity, confidentiality, and availability. Cyberattacks are a significant threat for which employers and employees must maintain awareness and constantly be on guard. In this session, we will explore your vulnerability and explain what you can do to prevent cyberattacks. 

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

Cybersecurity refers to ensuring information integrity, confidentiality, and availability. Cyberattacks are a significant threat for which employers and employees must maintain awareness and constantly be on guard. In this session, we will explore your vulnerability and explain what you can do to prevent cyberattacks.  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/cyber-security-essentials/
DocuSign Fundamentals

In this era of the digital workspace, an increasingly common practice is digital document signing. DocuSign is one of the leading electronic signing services that allows organizations to manage electronic agreements. Digitally signed documents are generally considered legally binding, just as if they had been signed by the recipient’s own hand, and DocuSign includes a built-in chain-of-custody audit trail for signing details, for both senders and recipients.  

 

Contents:

  • DocuSign Fundamentals 
  • Activating an Account 
  • Basic DocuSign Steps 
  • Managing Your DocuSign Documents 
  • Saving a Template 
  • DocuSign Reports 
  • DocuSign Settings 
  • Risks with eSignatures 

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

In this era of the digital workspace, an increasingly common practice is digital document signing. DocuSign is one of the leading electronic signing services that allows organizations to manage electronic agreements. Digitally signed documents are generally considered legally binding, just as if they had been signed by the recipient’s own hand, and DocuSign includes a built-in chain-of-custody audit trail for signing details, for both senders and recipients.     Contents: DocuSign Fundamentals  Activating an Account  Basic DocuSign Steps  Managing Your DocuSign Documents  Saving a Template  DocuSign Reports  DocuSign Settings  Risks with eSignatures  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/docusign-fundamentals/
Going Paperless and Printing Less

Are you overwhelmed by paper everywhere? Do you keep copies of everything? In this session, we will give you tips on using technology to decrease your reliance on paper and all the guilt that piles up with it. It's time to go paperless! 

 

Contents:

  • Motivation: Why Go Paperless? 
  • Evaluation: Which Documents Can Go Paperless? 
  • Overcoming Obstacles to Going Paperless 
  • Getting Started Now: Helpful Steps 
  • When You Absolutely Must Print 
  • Finally, What About That Backlog? 

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

Are you overwhelmed by paper everywhere? Do you keep copies of everything? In this session, we will give you tips on using technology to decrease your reliance on paper and all the guilt that piles up with it. It's time to go paperless!    Contents: Motivation: Why Go Paperless?  Evaluation: Which Documents Can Go Paperless?  Overcoming Obstacles to Going Paperless  Getting Started Now: Helpful Steps  When You Absolutely Must Print  Finally, What About That Backlog?  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/going-paperless-and-printing-less/
MS Excel Charting

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, making comparisons and trends much more straightforward. In this class, you'll learn how to insert, modify, and format charts far beyond the default information allowing you to communicate information effectively.  

Prerequisites: Must be a current Excel user and have taken Excel I or have equivalent experience

Program Level: Intermediate

Contents:

  • Create Charts 
  • Chart Types 
  • Chart Elements 
  • New Features 
  • Formatting Charts
  • Intro to Pivot Charts 

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

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, making comparisons and trends much more straightforward. In this class, you'll learn how to insert, modify, and format charts far beyond the default information allowing you to communicate information effectively.   Prerequisites: Must be a current Excel user and have taken Excel I or have equivalent experience Program Level: Intermediate Contents: Create Charts  Chart Types  Chart Elements  New Features  Formatting Charts Intro to Pivot Charts  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-charting/
MS Excel Dashboards

An Excel dashboard is a single page that helps managers and business leaders track key KPIs (Key Performance Indicators) or metrics to make informed decisions. It contains charts/tables/views backed by raw data. Learners will create a business dashboard to visualize and analyze sets of data. A well-designed dashboard provides on-demand access to all core metrics inter-departmentally.  

Prerequisites: Has successfully completed Excel I and/or II and had more than six months using Excel

Program Level: Intermediate

Contents:

  • Dashboard Environment
  • Creating Dashboards
  • Chart Types
  • Inserting Charts into Dashboards
  • Sorting and Filtering Pivot Tables
  • Inserting Pivot Tables and Pivot Charts into Dashboards
  • Formulas and functions
  • Conditional Formatting

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

An Excel dashboard is a single page that helps managers and business leaders track key KPIs (Key Performance Indicators) or metrics to make informed decisions. It contains charts/tables/views backed by raw data. Learners will create a business dashboard to visualize and analyze sets of data. A well-designed dashboard provides on-demand access to all core metrics inter-departmentally.   Prerequisites: Has successfully completed Excel I and/or II and had more than six months using Excel Program Level: Intermediate Contents: Dashboard Environment Creating Dashboards Chart Types Inserting Charts into Dashboards Sorting and Filtering Pivot Tables Inserting Pivot Tables and Pivot Charts into Dashboards Formulas and functions Conditional Formatting Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-dashboards/
MS Excel for HR

Is your HR Department wasting time manipulating canned reports from HCM and payroll systems? Do you need help accessing and analyzing data quickly? Are data errors causing you concerns? Whether auditing, reconciling bills, calculating bonuses and PTO, or analyzing turnover data, Excel offers tools to help. Based on guidance from HR experts and our interaction with supporting members, we identified the most common and helpful Excel tips that can benefit new and experienced HR individuals.  

 

The course explores using lookups to pull information out of multiple workbooks, bringing in delimited information from other sources, filtering information, using date calculations to figure out things like tenure and turnover, visually representing data to make it simple to review, and many tips and tricks that can help most every Excel user increase their productivity and decrease errors.

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

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

Is your HR Department wasting time manipulating canned reports from HCM and payroll systems? Do you need help accessing and analyzing data quickly? Are data errors causing you concerns? Whether auditing, reconciling bills, calculating bonuses and PTO, or analyzing turnover data, Excel offers tools to help. Based on guidance from HR experts and our interaction with supporting members, we identified the most common and helpful Excel tips that can benefit new and experienced HR individuals.     The course explores using lookups to pull information out of multiple workbooks, bringing in delimited information from other sources, filtering information, using date calculations to figure out things like tenure and turnover, visually representing data to make it simple to review, and many tips and tricks that can help most every Excel user increase their productivity and decrease errors. 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 Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-for-hr/
MS Excel Level 1

This course will familiarize learners with Excel, helping them to create, enter, and edit text, values, and formulas, save workbooks, and move and copy data and formulas. They will work with ranges (contiguous versus non-contiguous), rows, and columns. Participants will also learn to use simple functions and easily apply formatting techniques to worksheet data. They will review workbooks for spelling errors, modify page setup, and learn how to print professional-looking worksheets.  

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:

  • Spreadsheet terminology
  • The Excel environment
  • Navigating a worksheet
  • Entering and editing text and values
  • Entering and editing formulas
  • Saving and updating workbooks
  • Moving, copying, and viewing data and formulas
  • Absolute references
  • Inserting and deleting ranges, rows, and columns
  • AutoSum and other common functions
  • Text formatting
  • Row and column formatting
  • Number formatting
  • Additional formatting options
  • Preparing to print
  • Page Setup options
  • Printing worksheets

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

This course will familiarize learners with Excel, helping them to create, enter, and edit text, values, and formulas, save workbooks, and move and copy data and formulas. They will work with ranges (contiguous versus non-contiguous), rows, and columns. Participants will also learn to use simple functions and easily apply formatting techniques to worksheet data. They will review workbooks for spelling errors, modify page setup, and learn how to print professional-looking worksheets.   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: Spreadsheet terminology The Excel environment Navigating a worksheet Entering and editing text and values Entering and editing formulas Saving and updating workbooks Moving, copying, and viewing data and formulas Absolute references Inserting and deleting ranges, rows, and columns AutoSum and other common functions Text formatting Row and column formatting Number formatting Additional formatting options Preparing to print Page Setup options Printing worksheets Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-level-1/
MS Excel Level 2

This course will teach learners how to work with large worksheets in Microsoft Excel and efficiently use multiple worksheets and workbooks. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques, such as creating custom number formats. In addition, participants will learn how to create outlines and subtotals and create and apply cell names. They will sort, filter, consolidate, remove duplicate data, and create and format tables. Finally, they will learn how to audit worksheets for errors, and how to protect and share workbooks.  

Prerequisites: The course requires that you have successfully completed Excel I or had more than six months using Excel and are familiar with all Excel I materials.

Contents:

  • Managing workbooks and worksheets
  • Setting sheets up in a workbook
  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Cell and range names
  • Linking worksheets
  • Using multiple workbooks
  • Custom Number formatting
  • Using and Creating special formats
  • Transposing data
  • Create and Modify Tables
  • Creating Subtotals.
  • Summarizing large amounts of information
  • Custom Sorting
  • Filtering data
  • Removing Duplicate values
  • Auditing features and error checking
  • Comments and Notes
  • Worksheet and Workbook Protection

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

This course will teach learners how to work with large worksheets in Microsoft Excel and efficiently use multiple worksheets and workbooks. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques, such as creating custom number formats. In addition, participants will learn how to create outlines and subtotals and create and apply cell names. They will sort, filter, consolidate, remove duplicate data, and create and format tables. Finally, they will learn how to audit worksheets for errors, and how to protect and share workbooks.   Prerequisites: The course requires that you have successfully completed Excel I or had more than six months using Excel and are familiar with all Excel I materials. Contents: Managing workbooks and worksheets Setting sheets up in a workbook Viewing large worksheets Printing large worksheets Working with multiple worksheets Cell and range names Linking worksheets Using multiple workbooks Custom Number formatting Using and Creating special formats Transposing data Create and Modify Tables Creating Subtotals. Summarizing large amounts of information Custom Sorting Filtering data Removing Duplicate values Auditing features and error checking Comments and Notes Worksheet and Workbook Protection Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-level-2/
MS Excel Level 3

This Excel course is a day of finding ways to save time and energy digging into your data to get the desired result. You will be introduced to various functions that will quickly condense substantial amounts of data through a Pivot Table, pull out specific data through VLOOKUPs, conditional and logical functions, and save time through macros, data validation, and more. This class is a segue into our more focused courses for individual advanced Excel topics.  

Prerequisites: The course requires that you have successfully completed Excel I and II (or had more than six months using the software and are familiar with the concepts presented in Excel I and II).



Contents:

  • Logical functions 
  • Conditional functions 
  • Financial functions 
  • Text functions 
  • Date functions 
  • Lookup functions 
  • Data Validation 
  • PivotTables 
  • Running and recording a macro 

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

This Excel course is a day of finding ways to save time and energy digging into your data to get the desired result. You will be introduced to various functions that will quickly condense substantial amounts of data through a Pivot Table, pull out specific data through VLOOKUPs, conditional and logical functions, and save time through macros, data validation, and more. This class is a segue into our more focused courses for individual advanced Excel topics.   Prerequisites: The course requires that you have successfully completed Excel I and II (or had more than six months using the software and are familiar with the concepts presented in Excel I and II).  Contents: Logical functions  Conditional functions  Financial functions  Text functions  Date functions  Lookup functions  Data Validation  PivotTables  Running and recording a macro  Note: This course will be taught using the windows operating system environment
Copy URL: https://letscatapult.org/events/ms-excel-level-3/