Learn how to create pivot tables, filter and organize data, and transport formatted data into a word document! Students can bring their own laptop or use the computers in McCoy Lab in Andrews library. Lead by Educational Technology’s Digital Media Assistant Amelia Mitchell!

Agenda:

• Topics Covered:
  • Creating Data
  • Rows and Columns
  • Flash fill
  • Formula Basics
  • Data Filters
  • Data Sorting
  • Pivot Tables
  • Graphs
  • Excel Shortcut Keys
  • Formatting in Word

• Create an example excel file:
  1. Create a blank excel sheet
  2. Create a header (Insert>Table>check header>Ok)
  3. Name the headers

• Flipping rows and columns

• Flash Fill:
  • When a pattern is spotted excel can fill in the data/ continue the pattern

• Formulas:
  • How to write a formula
  • Go over most common formulas
    • Addition
    • Subtraction
    • Multiplication
    • Division
  • More formulas (https://youtu.be/Jl0Qk63z2ZY)

• Data Filters:
  • Allows you to display certain pieces of information

• Data Sorting
  • Custom lists
    • Adding/deleting levels

• Pivot Tables
  • These are tables which summarize, and allow you to count, sum, and average amongst other calculations according to the data you require.
  •  Graphs
    • From Pivot table and normal tables
    • Most Common Excel Shortcut Keys
      • Copy
      • Paste
      • Cut
      • Undo
      • Redo
        • More shortcuts if people are interested: https://www.ablebits.com/office-addins-blog/30-most-useful-excel-keyboard-shortcuts/

Other Shortcut Keys

• New Workbook (command n or control n)
• //new sheet short cut
• Format Cell (command 1 or control 1)
• Convert cells into table (command t or control t)
• Auto complete (tab)
• Select all/ entire worksheet (command a or control a)
• Copy from above cell (command d or crtl d)
• Copy from left cell (command r or crtl r)

Formatting into Word

• • Copy & paste
  • Adding boarders to make it neater