Excel Level 2

January 12, 2022

This training will focus on working with the multiple tab workbook and looking at different methods of adding, deleting, copying, and moving worksheets and look at the advantages of grouping tabs. Creating names for ranges of cells and learn different ways to use them. Different ways of sorting and filtering data, create more complex formulas, and work with Tables. Lastly, the training will teach how to Link files and worksheets together, Protect a workbook, worksheet and cells that contain formulas, turn on Track Changes and use Conditional Formatting.

This training will include:

  • Finding & Replacing Data
  • Working with Multiple sheets (Moving, Copying and Deleting)
  • Grouping worksheets
  • Creating 3D References
  • Creating And Working With Named Ranges
  • Paste List
  • Using Advanced Functions (If, Vlookup, Datedif)
  • Sorting and Filtering
  • Working with Tables
  • Linking Files and worksheets
  • Editing Links
  • Protecting a file, worksheet, and Formulas
  • Hiding and unhiding columns and rows
  • Sharing Workbooks
  • Track Changes
  • Conditional Formatting
  • Inserting and Deleting comments

Presenter: Susan Majetic, Computer Instructor

Time:

  • January 12th, 2022, 9:00am-4:00pm
  • January 27th, 2022, 9:00am-4:00pm

To Register: Please use the standard registration form. Completed forms can be sent via fax to # (204) 984-9487, or emailed to training@metisauthority.com Deadline for training registrations are 7 working days prior to the training.

 


View More Events

Unite Interactive