This virtual seminar will show you how to take a written formula and transform it into an Excel formula. If you have a formula that needs to be entered into Excel, this is the course to learn how to transform that formula.

Course format: This course is offered using Zoom.

This is the beginner's webinar/seminar. We will explore the Tabs and Ribbons in order to learn where different commands are located. We will also cover Keyboard and Keyboard commands and other basic items you will use to format a spreadsheet. How to create a formula using the Order of Operations, and how to create a basic worksheet and chart.

This is the beginner's webinar/seminar.  We will explore the Tabs and Ribbons in order to learn where different commands are located.  We will also cover Keyboard and Keyboard commands and other basic items you will use to format a spreadsheet.  How to create a formula using the Order of Operations, and how to create a basic worksheet and chart.

Come listen and learn and explore business functions in Excel to help you lookup items in a table or list, transcribe formulas from a book to Excel, and more.  This one-hour virtual listening session will investigate how to use functions like: Vlookup, Sum, Average, If and others.

Course Format: This course is offered using Zoom.  

Come listen and learn in this virtual seminar and see how to build a chart that everyone can understand using Excel.  You will be able to create a chart to reveal data trends in any business.  These charts will change when the data changes.  They can be linked into other software packages to enhance your reports.

Class Format: This course is offered using Zoom.

This in-person seminar will explore how to freeze and unfreeze cells, conditional formatting, protecting a worksheet, and many functions.  Some of these functions are commonly used and other are not used very much. This is to give you experience using different functions. We will also explore how to create a multiple sheet workbook and link the formulas between the sheets. This will include the difference between Relative and Absolute cell referencing, Pivot Tables and Charts, and a review of Protecting a worksheet.  You will also learn how to use the IF and Vlookup functions among a few other.

Course format: This program is offered in-person. 

This virtual seminar will explore how to freeze and unfreeze cells, conditional formatting, protecting a worksheet, and many functions.  Some of these functions are commonly used and other are not used very much. This is to give you experience using different functions. We will also explore how to create a multiple sheet workbook and link the formulas between the sheets. This will include the difference between Relative and Absolute cell referencing, Pivot Tables and Charts, and a review of Protecting a worksheet.  You will also learn how to use the IF and Vlookup functions among a few other.

Course format: This program is offered using Zoom. 

This virtual, interactive and hands-on session will explore additional formulas and functions and address absolute verse relative cell referencing, multiple worksheets and displaying of data using charts. It is appropriate for users that need to customize their worksheets, present data through charts, and/or develop long-range spreadsheets for data tracking. Attendees will learn how to expand their knowledge and use of functions and the creation of charts.

Individuals are encouraged to bring current spreadsheet projects with them to work on in real-time, privately with the instructor.

Topics covered include, but are not limited to:

• Functions in Excel
• Cell Referencing
• Creating and Linking Multiple Sheets in a Workbook
• Creating Charts
• Filtering and Sorting Data
• Inserting and Using a Pivot Table

All individuals participating in this training via Zoom are encouraged to have a second monitor, iPad or other tablet device to watch while you participate on your own computer.

Who Should Attend
This course is designed for individuals who are looking to learn more and enhance their MS Excel skills in the workplace. 

Class Format
This course is offered using Zoom.