Microsoft Excel Level 2, Mini Session 2

Hyperlinks and renaming the link: to sheet, web, email

Conditional format rules and colors: both older and newer methods

Validation with error messages for checking data entry

            Using dates, cell length, numbers within a range, lists

Link to Word

Protect with Password for open or edit

Sheet Protection for non-entry and/or for editing only certain areas

Pivot Tables using classic view or new view

Click here to enroll in this Zoom session.