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.
Simple calculations, cell references (relative, absolute, mixed), basic functions, tables, basic formatting, scatter plots, and histograms.
ROUND, MOD, and ROW functions, naming cells, conditional formatting, protecting cells, concatenation, more formatting options, graphing, goal seek, data validation, and macros.
IF functions, VLOOKUP, cell alignment, grouping rows, spinners, and retirement planning tables.
VALUE, COUNTIF, WEBSERVICE, and FILTERXML functions, adding data from the web, PivotTables, pie charts, and stock charts.
Nested functions, INDEX(MATCH()), assorted functions, graphics, grouping, printing, and forecasting.