Kansas State University

search

IT News

July 26: Explore Microsoft Excel (basic training)

An introductory training for Microsoft Excel is scheduled 1:30-3:30 p.m. Friday, July 26, in 306 Calvin.

""About Microsoft Excel

Microsoft Excel is the foremost spreadsheet program in use today.

It is commonly used to…

  • Conduct calculations
  • Clean data
  • Graph or plot data (to identify data patterns)
  • Create data visualizations (both static and interactive)
  • Apply visual styles to data tables and data visualizations
  • Create interactive data visualizations (interactive pivot tables, interactive dashboards with sliders, and others)
  • Create simple macros for continuing data handling (with Visual Basic programming language)
  • Process data for analytics in other software programs
  • Enable the share-ability of information
  • Access online survey data (in analyze-able format), and more…

This session will cover basics about getting started with Excel…handling data…and creating data visualizations.  Then, the session will proceed to some of the more complex features of the tool, based on participant needs.

Some areas of interest may include 3D mapping, pivot tables, dashboards with sliders, VLOOKUP/HLOOKUP, or other features, in the second hour.

Licensure for Microsoft Excel 

All K-Staters have access to Microsoft Excel as part of Office 365, both as a downloadable app and the cloud version.

Online Registration Available

Those who have access to HRIS may register for this event there.  Or those who want an official record of their attendance may sign up at the event.  All are welcome.

Handouts for this session are available online in either a PDF version or an MS Word one:

Questions?

Any questions may be sent to shalin@ksu.edu or 785-532-5262.  All are welcome!