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

Educational Technology

Collaborating with faculty and students to explore questions of pedagogy, practice, and technology.

  • About
  • I’d like to
  • Events
  • Staff
    • Professional Staff
    • Student Digital Media 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
    • Consultation request
  • Technology Services
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
  • Loaner Equipment

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

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in settings.

Educational Technology
Powered by  GDPR Cookie Compliance
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.