Kansas State University

search

IT News

Tag: spreadsheet

June 4: Exploring Microsoft Excel (Basics)

An introductory training for Microsoft Excel is scheduled 1:30-3:30 p.m. Friday, June 4, on Zoom.  

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…

Continue reading “June 4: Exploring Microsoft Excel (Basics)”

Excel tip: Counting cells

When working with data in a spreadsheet, you will often want to count how many cells are in a particular section. The count function in excel lets you count:

  • cells with numbers
  • blank cells
  • cells with text
Watch the video below to learn about the various count functions.

httpv://www.youtube.com/watch?v=nsUTFVNu9HU

For more tips on the use of MS Excel, check out the Excel blog.