Skip to main content Help with accessibility Skip to main navigation
MLCSU Academy logo

MLCSU Academy

Excel - Apply Range Names and Advanced Formatting (Intermediate/Advanced) 28 Nov 24

Excel Microsoft 365 Microsoft Products
Add to Calendar

Event Date:

28 November 2024 2:30 PM - 3:30 PM

Closing Date:

26 November 2024

Description:

Range Names

  • Defining Range Names
  • Using Range Names in formulae and functions
  • Manage Range Names

Advanced Formatting

  • Conditional Formatting
  • Apply the Format Painter
  • Split and Freeze columns

Using Range Names in Excel has many advantages, making your workbooks easier to read, making formulas faster to type and debug, and allowing to create ranges with variable-size to make your spreadsheets dynamic and easy to update.

Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

Format Painter is used when you want to copy formatting from one item to another. For example if you have written text in Word, and have it formatted using a specific font type, color, and font size you could copy that formatting to another section of text by using the Format Painter tool.
In Split Panes, Excel splits its worksheet window vertically along the left-side of selected Column or horizontally along the top-side of selected Row. Freeze Panes just freezes Excel worksheet window vertically along the left-side of selected Column or horizontally along the top-side of selected Row.

Online training will be delivered via MS Teams. You will receive joining instructions before your selected session.

On successful completion of this course you will be able to:

  • Define and manage Range Names
  • Use Advanced Formatting features and apply conditional formatting
  • Adjust the view with split and freeze panes options
Course information

Category:

Online

Trainer:

Sharon Tew

About the trainer:

Sharon Tew

Email: sharon.tew@nhs.net

Mobile: 07778 368334

Location:

online