event logo
February 15 - 17, 2022

Microsoft Excel 2019 & 365: Level 2

Gulf Coast State College • 5230 West U.S. Hwy. 98 Panama CityFL  32401 Organized by Gulf Coast State College Continuing Education $25 instant refund on this event with gift card.

About this event

Microsoft Excel 2019 & 365: Level 2 covers key intermediate Excel skills. Among others, topics in Level 2 include themes, cell styles, and number formats, as well as functions for dates, numbers, and text. Textbook included. Pre-requisites: Basic computer skills. Course Objectives By the end of this course, you will be able to:  Apply and customize themes  Create and use cell styles  Apply cell borders and fill  Create custom number formats  Customize the page setup  Edit document properties  Identify date serial numbers  Apply custom date formatting  Enter times  Create functions using dates  Perform date and time calculations  Create customized conditional formatting rules  Edit rules using the Conditional Formatting Rules Manager  Create financial functions  Create one-variable and two-variable data tables  Use the What-If Analysis tools to create scenarios  Adjust input values using Goal Seek  Use functions to format text  Create conditional functions using IF and IFS criteria  Create formulas using nested functions  Find and correct errors in formulas  Use 3-D cell references in formulas  Create formulas using lookup functions  Use the Outline feature  Create subtotals  Use the Quick Analysis tool  Much, much more!

When

February 15 - 17, 2022

Tuesday, Thursday

Add to calendar

Location

Gulf Coast State College

5230 West U.S. Hwy. 98 Panama CityFL  32401

View Map

Show More Show Less

Sessions

Get $25 cash refund on this event

Price

$130.00
Register

Media

1 Photos and Videos
media item

More events from this organizer