Digital Business Management

MS Excel Workshop Sessions – 30 spots available

To all BComm Degree students,
 
I’m delighted to announce the first in a series of Microsoft Office Excel Workshop sessions being held for Bachelor of Commerce students.  These hands-on workshops, held as three 6-hour Saturday sessions for beginners, intermediate, and advanced level students respectively, will be spread over the winter semester and will be taught by a certified Microsoft Office Excel instructor. 
The next available workshop for beginners will be held on campus on Saturday Jan. 30 (9:00 AM – 3:30 PM) in L3012 (includes 30 minutes lunch break – please bring your own lunch)
 
Target students for the beginner session are students who wish to gain the foundational understanding of Microsoft Office Excel 2013. Particulars for the beginner workshop, including course content, are included at the end of this message.
 
There are 30 spots available and the cost for the first beginner session is $10 (non-refundable), payable by cash at the Business School office in H214.
 
To register, please email Hanadi Alnawab at hanadi.alnawab@humber.ca with the subject line “Excel Workshop Part 1”, include your full name and your program in your message. You will then be asked to see Stephanie in H214 between Jan 11 and Jan 13, 2016 to pay the $10 to confirm your registration. 
 
Below are the concepts that will be covered in the first beginner-level session. 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.
 
 

Workshop Content (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