Spring 2017
Dr. Richard L. Sleight
CRN #46536 Mondays, Wednesdays, and Fridays, March 27 to April 14, 8:00AM-9:20AM, in McKenna 113.
CRN #47517 Mondays, Wednesdays, and Fridays, March 27 to April 14, 9:30AM-10:50AM, in McKenna 113.

Exam dates:  Most Mondays, Wednesdays, and Fridays from April 19 to June 2 at 8:00AM in McKenna 113. 
RSVP at SL8@spu.edu.

Course materials in Canvas, download Microsoft Office 365, download G•Metrix SMS, run G•Metrix.  

Spring 2017 Syllabus

SBGE Spreadsheet Competency Requirement

BUS 1700 vs. Excel 2016 Self-study

Mondays, Wednesdays,
and Fridays
Topics (Tentative Schedule)
Lessons 1 & 2 March 27

Introduction, vocabulary, screen layout, navigation

Number formats, AutoFill, finding and moving data

Lessons 2 & 3 March 29

Backstage view, Page Setup (intro), customizing Excel, templates

Lessons 4 & 5 March 31

Simple formulas, absolute cell reference, named ranges
Introduction to functions: SUM, AVERAGE, COUNT, MAX, MIN

Lessons 5 & 6 April 3

Advanced functions: conditional functions, text functions.
Formatting cells and ranges, conditional formatting, hyperlinks

Lessons 6 & 7 April 5

Formatting worksheets, Themes, Page Setup (advanced)

Lessons 8 & 9 April 7

Manage worksheets; exaample of the GMetrix sample exams.

Lessons 9 & 10 April 10

Import and manage data, sort, filter, tables, subtotals

Lessons 10 & 11 April 12

 Inspect documents: hidden properties, accessibility, compatibilitySparklines, creating and modifying charts

Lessons 11 & 12 April 14

More with charts.
Adding and editing images: pictures, SmartArt, Shapes, etc.

Review the online G·METRIX sample exams, especially the three Excel 2016 project-based exams which are most similar to the MOS 77-727 exam.

The MOS 77-727 exam is offered Wednesday, April 19 to Friday, June 2 at 8:00AM and 9:10AM.  (It will not be offered on these Fridays: May 12, 19, or 26.)  To be allowed a free retake if a score of 700 or higher is not achieved on the first attempt, that first try must be made on or before Friday, May 5.  Reserve a seat to take the exam by emailing your instructor and choosing an exam date and either 8:00 a.m. or 9:10 a.m. for your exam time.  Please specify a first and second choice.  No more than ten students may sign up for any particular exam hour, and reservations to SL8@spu.edu must be made at least 24 hours in advance.

Recommended YouTube videos on Excel

Hun Kim, Bill Jelen - "Mr. Excel", Excel Is Fun, Simon Sez IT: Excel 2013 Training Tutorials