Day 2 - February 14, 2015

 

DUE Thursday, February 19: MICe ASSIGN 2

 

DAY'S OBJECTIVE

Excel 2013: Worksheet formatting, tables, data manipulation.

 

SECTION 1 GAMEPLAN

  • Worksheet formatting and manipulation
  • Data Formats

 

DISCUSSION

 

Review

  • Worksheet creation
  • Worksheet setup
  • Worksheet names, adding, deleting

 

Themes/Variants

  • Themes
  • Font Variants
  • Color Variants

 

Column/Row Handling - Home Tab
Word allows you to add and subtract rows and columns, and perform other column activities like merging and preset formatting.

  • There are basic Excel pre-created styles based on the theme/colors chosen.
  • You can format cells or a whole table.

 

Data Formats

Excel is great for working with data because you can set data formats for efficient handling.

  • Number formats: currency, accounting, percentage
  • Text formats: General, special, custom
  • Date formats: dates, times.

 

DEMO

Modify a basic Excel spreadsheet document to look at basic Excel data tasks.

  • Download databasics.xlsx and save it in your MIC102e/demos folder under the same name.
  • Modify themes and variants
  • Play with columns and rows - insert, delete
  • Show/Hide
  • Freezing columns

 

 

BACK TO TOP

 

#######################################

SECTION 2 GAMEPLAN

  • Worksheet tables
  • Sorting/Filtering
  • Inserting Tables
  • Table Tools

 

DISCUSSION

 

Data - Data Tab

Excel allows you to manipulate data - how it is sorted, imported, filtered, validated, and grouped.

  • You can import existing data from the web, another spreadsheet, a database, XML, and more (advanced).
  • You can sort rows and columns, such as for alphabetizing.
  • You can filter tables to show only certain rows or tables based on criteria you set - the rest is simply hidden, not gone.
  • You can remove duplicates of data.
  • You can group info to create subtotals, before totaling those.
  • You can use flash-fill to add large amounts of consecutive data.

 

Basic Sorts - Data tab

  • Allows you to sort a full spreadsheet based on data in a column or row, like Last Names.
  • Sorting useful for alphabetizing.

 

Tables in worksheets - Insert tab

  • You can do tables manually in worksheets with one-touch borders and shading.
  • Manual tables allow you to do data sorting and filtering.
  • Excel also allows you to convert existing data into a "table" format
  • You can also create a "table" format before inputting data
  • Use the Table contextual tab for specific changes to the layout and design.

 

DEMO

Modify a basic Excel spreadsheet document to look at basic Excel table tasks.

  • Download tablebasics.xlsx and save it in your MIC102e/demos folder under the same name.
  • Copy/move sheet
  • Modify data to look like a table
  • Insert a table
  • Turn data into an Ecxel table
  • Table editing, sorting, etc.

 

BACK TO TOP

 

#######################################

SECTION 3 GAMEPLAN

  • Inserts
  • Inserts Editing
  • Templates

 

DISCUSSION

 

Inserts - Insert Tab
You can add text, image, and other content to your documents.

  • Breaks: You can insert page breaks, section breaks, and blank pages.
  • Images: image saved size, inserts as own entity (not affecting text), resize as needed.
  • Clip art: Provides access to local and online libraries.
  • Shapes and Smart-Art: For drawing objects, workflows, etc.
  • Charts: Can create a chart and tie it to a table of data.
  • Text-related: text box, header/footer, word art, drop caps, symbols, etc.
  • Page-related: Header and Footer info.

 

Inserts Contextual Menus/Ribbons

  • Text
  • Drawing
  • Design
  • Formatting

 

DEMO

Modify a basic Excel spreadsheet document to look at basic Excel inserting tasks.

  • Download insertsbasics.xlsx and save it in your MIC102e/demos folder under the same name.
  • Modify data into a full table
  • Insert different things
  • Learn about insert contextual menu/ribbon options.

 

DEMO 2

Create one or more template-based workbooks.

  • Find/Open a Weekly Class Schedule.
  • Find/Open a Grocery List.

 

DEMO 3

Work through an online tutorial on your own..

 

MICe ASSIGN 2 Prep: How to use assignment instructions, and get started.

 

OTHER

If we have time left over, we may start Assignment 2 work in class. No promises

 

 

BACK TO TOP

 

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

 

TO DO

 

Tasks

  • MICe ASSIGN 2: Basic Formulas, due Thursday, February 19, 25 points.

 

Resources

 

 

BACK TO TOP