B & E 105

About B&E 105

This course prepares pre-major students in the Gatton College of Business & Economics to use Microsoft Excel at a high level of proficiency. To access the instructional videos and practice files, logon to Canvas with your LinkBlue user id and password. There you will also find additional information on downloading and installing Office 2016 to your PC (or accessing the Windows version of Microsoft Office 2016 through the Citrix Receiver on your Mac).

Office Hours: Mondays from 9-11am and Thursdays from 3-5pm in the Gatton College of Business, Room 345K. If you are unavailable at those times, please email BE105@uky.edu to schedule an appointment.



Syllabus Exam Review Form


Basic Skills Unit 1

Simple calculations, cell references (relative, absolute, mixed), basic functions, tables, basic formatting, scatter plots, and histograms.



Study Guide


Supply and Demand Unit 2

ROUND, MOD, and ROW functions, naming cells, conditional formatting, protecting cells, concatenation, more formatting options, graphing, goal seek, data validation, and macros.



Study Guide


Retirement Planning Unit 3

IF functions, VLOOKUP, cell alignment, grouping rows, spinners, and retirement planning tables.



Study Guide


Stock Portfolio Unit 4

VALUE, COUNTIF, WEBSERVICE, and FILTERXML functions, adding data from the web, PivotTables, pie charts, and stock charts.



Study Guide


Assorted Tools Unit 5

Nested functions, INDEX(MATCH()), assorted functions, graphics, grouping, printing, and forecasting.



Study Guide