• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
Wooster

Technology@​Wooster

Collaborating with the campus community to explore questions of​ pedagogy, best practices, and technology integration.

  • For Students
    • What Technology do I need at Wooster
    • Computer Labs
    • Downloads
    • Wireless
    • Printing
    • E-Mail
    • Gaming Consoles
    • Poster Printing
  • I’d like to
  • Events
  • Staff
    • Applications Development
    • Educational Technology
      • About
    • Information and Planning
    • Research and Planning
    • Technology Services
      • Digital Infrastructure
      • Media and Event Support
      • Technology Services – Media Services
      • Technology Services – Service Desk
    • Student Digital Media Assistants
    • Student Research Assistants
    • Student Technology Assistants
  • Resources
    • ArcGIS Online
    • Hoonuit online training
    • Moodle
    • Professional Development
    • Projects in a Box
    • Qualtrics
    • Select Survey
    • WordPress(Voices)
    • Workshops
  • Technologies
    • Classroom Technology
      • Document Cameras
      • Epson Technologies
      • SMART Technologies
      • Student Response Systems
      • Video Conferencing
    • Digital Media
      • Audio
      • Images
      • Mobile Apps
      • Presentation
      • Video
    • Virtual Reality
      • VR Resources
      • Virtual Worlds
    • Web 2.0
      • Information Management
      • Mashups
      • Media Sharing
      • Social Communication
      • Social Knowledge Building
    • Web Authoring
      • Blogging
      • CMS
      • Wikis
  • Contact Us
    • Ed Tech Consultation
    • Tech Services Consultation
  • Change Your Password
  • Spam & Junk Email
  • IT Policies
  • IT Blog
You are here: Home → Professional Development → Microsoft Excel Basics for staff

Microsoft Excel Basics for staff

Agenda

(may be covered in two sessions)

Excel 2016 Quick Start (Microsoft Support)

Basic Tasks in Excel (Microsoft Support)

  1. Tour of layout: task bar, formula bar, worksheet
  2. Define terms: cells, column, row, workbook, worksheet, active cell
  3. Entering data
    • Cell reference
    • Moving around in the worksheet: enter key, tab key, arrow keys
    • Editing data: making a change, replacing data, deleting data
    • Copy and paste
    • Fill
    • Drag and drop cells
    • Hide columns or rows
  4. Appearance
    • Resize column width or row height
    • Formatting cells
    • Labels – format text (bold, size), text wrap
    • Merge cells, border, fill color
  5. Sorting data
    • Freeze panes
    • Filters
    • Custom sort
    • multiple variables
  6. Calculations with formulas
    • Autosum
    • Multiply
  7. Creating a chart
Links below are to Hoonuit video tutorials. Login to Hoonuit via our Wooster portal and use your College credentials.

Excel 2016

Which version of Excel? Office 2016 is available for download for Windows and Mac

Excel 2016

New features in Excel 2016 for Mac

Office 365

  • OneDrive  OneDrive Training
  • Excel online  Microsoft Excel Online

How to create Charts/Tables

Creating charts and tables from data

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to print (Opens in new window)

Related

Filed Under: Professional Development, Uncategorized

Primary Sidebar

Interesting Videos

Resources

  • We can help with…
  • Professional Development
  • Projects in a Box
  • Workshops
  • I.S. Support
  • Request an Appointment
  • ArcGIS Online
  • Hoonuit online training
  • Qualtrics
  • Poster Printing
  • Request a Wiki
  • Loaner Equipment

Copyright © 2021 · Technology Theme 3.0.0 on Genesis Framework · WordPress · Log in

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo
You can revoke your consent any time using the Revoke consent button.Revoke cookies