Day 3 - February 21, 2015

 

DUE Thursday, February 26: MICe ASSIGN 3

 

DAY'S OBJECTIVE

Excel 2013: Basic formulas, basic charts & graphs, and output.

 

SECTION 1 GAMEPLAN

  • Info Lookups
  • Basic Formulas

 

DISCUSSION

 

Formulas - Formula Tab
Excel allows you to handle both simple and complex mathematical calculations, such as general ledger work, comparison tables, averages, and much more.

  • You can quickly set a sum for a row or column of numbers.
  • You can create a function on your own, if you write your own calculations.
  • You can choose from several types of calculation info, like financial, date, math, and more. This is dependent on you knowing what you want the document to accomplish.
  • You can set calculation options, based on selecting a column, row, or specific cells of data.
  • You can use formulas to change the appearance of data, like concatenating.

 

Excel Operators

 

Cell References

  • Cell References are a way to refer to the contents of a cell.
  • Absolute: Absolute references remain constant, no matter where they are copied
  • Relative: Relative references change when a formula is copied to another cell. 
  • Selection: You select one or more cells while creating a formula or a location reference in another table and/or worksheet.
  • Named: You can Define a Name of a cell so that the cell remains stable in a formula that you copy and paste for further use in other cells in a column. This would be an Absolute reference. Otherwise, the pasted formula will changed the cell's location reference to be relative to the new row it is seeking to create the formula for. Example: =Fee*20, where the cell I5 hase been named FEE, is more stable than =I5*20.
  • Circular Reference: This happens when a formula is trying to calculate itself, and you have an Excel feature called iterative calculation turned off. It can also happen during indirect references in a formula. Check it out!

 

DEMO

Modify a basic Excel spreadsheet document to look at basic Excel cell lookups and formulas.

  • Download formulabasics.xlsx and save it in your MIC102e/demos folder under the same name.

 

DEMO 2

Look at a formula-populated Template.

  • Find and open the Student Calendar template

 

BACK TO TOP

 

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

 

SECTION 2 GAMEPLAN

  • Pivot Tables
  • Basic Charts

 

DISCUSSION

 

Pivot Tables

  • Pivot Tables are a data summarization tool.
  • A pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet and display the summarized data results in a second "pivot table".
  • Pivot tables can also be useful for creating unweighted cross tabulations.
  • Detailed explanation of Pivot Tables.
  • Pivot Table Tutorial.

 

Charts - Insert tab

  • Charts allow for a visual representation of specific table data. To create a chart in Excel you need to HAVE a table/table data to work with.
  • Pre-designed chart styles
  • Recommended charts
  • Create chart from data
  • Modifying chart info source location
  • Chart formatting

 

Charts - Examples

 

DEMO

Modify a basic Excel spreadsheet document to look at basic Excel pivot tables and charts.

  • Download chartbasics.xlsx and save it in your MIC102e/demos folder under the same name.

 

BACK TO TOP

 

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

 

SECTION 3 GAMEPLAN

  • Print Output - Print Range

 

DISCUSSION

 

Output - File tab
You can test and adjust your documents and review your content before it goes live.

  • Review Tab: spelling, language, grammar, comments.
    • You can also create a document checking/sharing process where you show your highlighted changes and crossouts.
    • You can compare document versions.
  • Find/Replace: You can find and replace text as needed (Home tab).
  • Acrobat – saving on PDF for email
  • Save As: for different versions, including older, current, RTF, text, and HTML.

 

Review as needed.

 

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

 

OTHER

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

 

 

BACK TO TOP

 

 

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

 

TO DO

 

Tasks

  • MICe ASSIGN 3: Formulas & Charts, due Thursday, February 26, before 11:55am 25 points.

 

Resources

 

 

BACK TO TOP