Loading Events

« All Events

Virtual Working Series: MS Excel for the Workplace

June 10 @ 1:00 pm - June 24 @ 2:00 pm

|Recurring Event (See all)

An event every week that begins at 1:00 pm on Wednesday, repeating indefinitely

| $79

Date: Wed. 6/10/20-6/24/20; 1-2PM (three 60-minute sessions)
Location: Live Stream, Remote Session
Instructor: Elaine Moore
Course Code: WIT301-69

Cost: $79
Register Now

Part 1 This is the beginner’s webinar. We will explore the Tabs and Ribbons 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.

Part 2 This is an intermediate webinar. We will explore how to freeze and unfreeze cells, conditional formatting, protecting a worksheet, grouping data, 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.

Part 3 This is the more advanced webinar. We will 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. We will also explore 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.

Details

Start:
June 10 @ 1:00 pm
End:
June 24 @ 2:00 pm
Cost:
$79
Event Categories:
, , ,
Event Tags:
Website:
https://www.capecod.edu/web/ccpe/courses#excel

Organizer

The Center for Corporate and Professional Education
Phone:
508-375-5013
Email:
ccpe@capecod.edu
Website:
https://www.capecod.edu/web/ccpe/fiber-optic

Venue

Online
Font Resize
Contrast