Digital Business Management

MS Excel Workshop Sessions Fall 2016

To all BComm Degree students,

 

I am pleased to announce our Fall 2016 series of Microsoft Office Excel Workshop sessions being held for the BComm students, taught by Ms. Isabella Annouza, Microsoft Certified Trainer (LinkedIn). These are full-day workshop, scheduled at the Lakeshore campus.

Details of the upcoming workshop:

  • Workshop: Excel Part 1 (beginners)
  • Date: Sunday Oct 2, 2016
  • Time: 9:00 AM – 3:30 PM (includes 30 minutes lunch break – bring your own lunch)
  • Cost: $20 (non-refundable, to be paid through your MyHumber account, will appear under course code TUTR B13 CRN 8066)
  • Location: Lakeshore Campus, lab L3012
  • Registration: through Eventbrite (please note that the Eventbrite link shows “FREE”. However, the cost of the workshop is $20, and will appear on your MyHumber account under course code “TUTR B13 CRN 8066”. It will not appear on your transcript. Therefore, the cost is to be paid through your MyHumber account, not through Eventbrite. Visit the following link for instructions on how to make a payment through MyHumber. Please note that it may take up to 10 business days for the charge to appear on your MyHumber account.
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® 2013 Part 1 (Beginner)

Lesson 1: Getting Started with Microsoft Office Excel 2013

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

Appendix A: Microsoft Office Excel 2013 Exam 77-420

Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428

Appendix C: Microsoft Excel 2013 Common Keyboard Shortcuts