MS Excel Workshop - Beginner
Event Information
Description
Digital Business Association presents TechWeek Conference 2019!
The day includes hands-on and full day Microsoft Excel Workshop - Office 2016.
There will be a 30 minutes lunch break provided (bring your own lunch).
Location: L Building, Room 3012
Cost: $ 10 (Please note that tickets sales are final, non-refundable. It is not possible to issue refunds or workshop credits for any reason)
Delivered By: Microsoft Certified, Isabella Annouza
Workshop Content:
Below are the concepts that will be covered. There will be manuals available for students to borrow and share during the workshop, and the data files will be available on a shared drive that will be provided.
Workshop Content: Microsoft® Office Excel® 2016 Part 1 (Beginner)
Lesson 1: Getting Started with Microsoft Office Excel 2016
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
- Topic E: Use Excel Help
Lesson 2: Performing Calculations
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas
Lesson 3: Modifying a Worksheet
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
Lesson 4: Formatting a Worksheet
- Topic A: Modify Fonts
- Topic B: Add Borders and Colors to Worksheets
- Topic C: Apply Number Formats
- Topic D: Align Cell Contents
- Topic E: Apply Styles and Themes
- Topic F: Apply Basic Conditional Formatting
- Topic G: Create and Use Templates
Lesson 5: Printing Workbooks
- Topic A: Preview and Print a Workbook
- Topic B: Define the Page Layout
Lesson 6: Managing Workbooks
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
