Microsoft Excel Training
Microsoft Excel training provided by Joselyn Travis of ICBA
Description
Excel Basics – 5 minutes
- Change and modify page layouts
- Share an excel via email for collaboration
- Password protect an excel
- Change excel version using Save As option
- Preset templates for worksheets
Working with Excel – 5 minutes
- Column and row selection in a worksheet
- Sorting and filtration of data
- Dealing with duplicates (highlighting and deletion)
- Row/column width and height formatting
- Freeze panes in a sheet
- Table formatting of rows and columns using presets
How to create a pivot table – 5 minutes
- Clean up data and identifying columns to be used
- Selection of the column and rows to be included
- Modifying data to be displayed across different worksheets
VLOOKUP in Excel – 5 minutes
- Show and demonstrate VLOOKUP using multiple sheets
- Identifying key columns from multiple sheets
- Easily import date into your sheet
Combine and Extract Data in Excel – 5 minutes
- Combine two or more cells in a sheet
- Extract data from beginning and end of a cell
Q&A Session – 5 minutes
- Spend 5 minutes taking questions from registrants
Zoom Information
Zoom Meeting Information:
Join: https://icba.zoom.us/j/913865795
Dial: +1 669 900 6833 or +1 646 558 8656
Meeting ID: 913 865 795