INTRODUCTION TO MS EXCEL                
FALL 2016                
                         
# TODAY'S CLASS: Tuesday, November 29                
                         
    Warm-up & Questions                
                         
    A. How did your HW go (share your Excel project with Bob)?                
                         
    B. Let's look at student projects                
     - The goal of these projects is for each student to work on                 
    something of interest to him or her                
     - This is not a competition                
        Current student projects   LINK          
       - Note: each project is in a separate sheet tab                
                         
                         
  14a.                    
    Add up a group of numbers (cont'd)                
     - This is a common request                
     - Excel can do this with the "SUM" function                
       - To otal a group of numbers, use the Autosum tool ( Σ )                
        Sum of Aunts and Uncles 3   LINK          
                         
  Terminology            
    Vocabulary                
     - Download this file to the "Intro to Excel" folder (Save As)                
        Terminology   LINK          
                         
  15.                      
    Practice formatting an "outline" layout                
     - Use this example to practice formatting skills                
       - Adjust column width                
       - Format and entire column (Bold or Italic)                
       - Use different font colors                
       - Set "cell fill" colors                
       - Use borders (All Borders or Outside Border)                
        Copy the formatting   LINK          
                         
  16.                      
    The check register balance                
     - Excel can update the check register's balance using a formula                
       - If the transaction was a debit, the formula must subtract from the                
      balance                
       - If the transaction was a credit, the formulat must add to the balance            
     - Is it possible to do subtraction and addition at the same time?                
        The Check Register Balance Formula   LINK          
                         
                         
    HOME WORK                
                         
    CHALLENGE 5c: Share some of your Excel project work with Bob                
     - Here is what you have done to turn one of your topics into an      HOME          
    Excel project     WORK          
       - On a small piece of paper, you logged a little of this information                
       - Using your log & another piece of paper, you started to design a                
      spreadsheet in Excel                
       - You followed this guideline: "Keep it simple.  I repeat, keep it                 
      SIMPLE."                
       - You use Save As to create file versions                
     - Here is the final step:                
       - Send Bob one of your versions as an email attachment                
                         
        Click here if you need help sending an email attachment   LINK          
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
                         
  PREVIOUS CLASSES                
                         
        Tuesday, November 22, 2016                
                         
  13.                      
    Climbing the ladder of Excel skills                
     - We start with simple ideas (mechanics), and then practice skills                  
    with simple projects                
     - Download two files to the My Documents folder                
      beginning-mechanics (concepts)                
      beginning-projects (mini-exercises)                
                         
        Beginning mechanics   LINK          
                         
        Beginning projects   LINK          
                         
  14.                      
    Add up a group of numbers                
     - This is a common request                
     - Excel can do this with the "SUM" function                
       - To make it easy, there is a command on the Home ribbon                
        Total a group of numbers: the Autosum tool ( Σ )                
                         
        Tuesday, November 15, 2016                
                         
  12.                      
    Here is Bob's overview of what it means to use Excel                
     - Excel is amazingly flexible at storing different kinds of data                
     - It gives us many options for presenting and formatting data                
        Brief overview of Excel   LINK          
                         
        Tuesday, November 08, 2016                
                         
    Warm-up & Questions                
                         
    A. How did your HW go (generate a little data for your project)?                
                         
    B. Students create every kind of Excel project imaginable                
     - Let's take a look                
        Projects from previous classes   LINK          
       - Take notice of projects that are:                
         - simple                
         - do not involve money                
                         
                         
    HOME WORK                
                         
    CHALLENGE 5b: Put some data into Excel                
     - This is the next step for creating a simple project                
      a. Use your "small data log".  Take another piece of paper, and                 
      start to design a spreadsheet in Excel.                
         - Then put it into an Excel worksheet                
      b. Keep it simple.  I repeat, keep it SIMPLE.                
      c. Be willing to experiment and try new things                
         - In other words, there is no "right way"                
         - Use Save As to create file versions                
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
        Tuesday, November 01, 2016                
                         
    Warm-up & Questions                
    A. Can you share your 3 topic ideas with Bob?                
     - If you didn't write your 3 topics yet, don't worry                
       - You will leave tonight with at least 1 topic                
       - Then you can begin Challenge 5a (HW, below)                
                         
    B. Calculate how many times a day your heart beats                
     - Click the hyperlink, then click "Save As".  Save the file to the                 
    Intro to Excel folder                
     - In Windows Explorer go to the Intro to Excel folder                
       - Double-click on the file (and "Enable Editing")                
       - Follow the directions in the file                
        Calculate Your Daily Heart Rate   LINK          
                         
                         
  12.                      
    Climbing the ladder of Excel skills                
     - We start with simple ideas (mechanics), and then practice skills                  
    with simple projects                
     - Download two files to the My Documents folder                
      beginning-mechanics (concepts)                
      beginning-projects (mini-exercises)                
                         
        Beginning mechanics   LINK          
                         
        Beginning projects   LINK          
                         
    HOME WORK                
                         
    CHALLENGE 5a: Choose one topic idea and narrow it down                
     - Many times a topic idea is too broad to create a simple project                
    1.  Choose one of your information areas (topics) for your Excel                 
    project                
    2. Record a small amount of data to narrow it down                
      a. On a small piece of paper, begin to log a little of this information                
         - The key is to NARROW DOWN your topic!                
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
        Tuesday, October 25, 2016                
                         
  11.                      
    Let's explore formulas: simple math                
     - Excel is a kind of calculator                
     - In Excel we use a formula to calculate a result from other data                
       - Note: the result is called the "value" of the formula                
         - The cell displays the value                
         - The Formula Bar displays the formula                
     - A formula ALWAYS begins with the equal sign ( = )                
        Simple math & Simple formulas                
         - Simple math means addition, subtraction, multiplication &                 
        division                
         - Remember these symbols: +, -, *, and /                
                         
    HOME WORK                
                         
    CHALLENGE 4: Write down three (3) topic ideas on a piece of paper              
       - "Three kinds of information I MIGHT use Excel to record or track"                
         - This is a 5-minute exercise.  Use a small piece of paper.                
         - Please think about what kinds of information you like to record               
        or track                
         - Then write that down as one of your three topics                
         - That's it!  Don't do anything more.                
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
        Tuesday, October 18, 2016                
                         
    Warm-up & Questions                
    A. How did your HW go (make a contact list)?                
                         
    B. Parking lot topics from 2 weeks ago                
      1. Delete a column                
      2. Insert a column                
      3. Put password protection on a file                
                         
                         
  8.                      
    Preparing for CHALLENGE 4                
     - You are an Information Being because our world is built around               
    information!                
       - We each live in a world that is flooded with information                
       - Did you ever notice that there are certain kinds of information                 
      that you actually *choose*?                
         - It could be anything!  Take a look at your day-to-day life.  See                 
        what  information matters to *you*.                
     - CHALLENGE 4: Write down three (3) topic ideas on a piece of                 
    paper                
       - "Three kinds of information I MIGHT use Excel to record or                 
      track"                
         - This is a 5-minute exercise.  Use a small piece of paper.                
         - Please think about what kinds of information you like to record               
        or track                
       - This will be your Home Work                
                         
  9.                      
    Excel formulas - a simple beginning                
     - A formula is something you type in a cell that tells Excel to                 
    calculate a value                
     - A formula always starts with an equal (  =  ) sign                
     - Practice                
      1. Start Excel                
      2. Click on cell F1.  This makes F1 the active cell.                
      3. Type this:                
        48 + 50                
      4. Tap the <Enter> key or <Tab> key on your keyboard                
      5. Now, click on cell G1                
      6. Type this:                
         = 48 + 50                
      7. Tap the <Enter> key or <Tab> key on your keyboard                
     - Why do cells F1 and G1 look different?                
       - Because F1 says to Excel: "Show what I typed."                
         - The cell value is the text you typed                
       - On the other hand, G1 says to Excel: "Do this calculation &                 
      show the resulting value in the cell."                
         - The cell value is the "result returned by the formula"                
                         
  10.                      
    Save As                
     - You can both protect yourself from wrecking your Excel file and                 
    empower yourself to experiment in Excel                
        Ways to save files ( = use Save As…)   LINK          
                         
    HOME WORK                
                         
    CHALLENGE 4: Write down three (3) topic ideas on a piece of paper              
       - "Three kinds of information I MIGHT use Excel to record or track"                
         - This is a 5-minute exercise.  Use a small piece of paper.                
         - Please think about what kinds of information you like to record               
        or track                
         - Then write that down as one of your three topics                
         - That's it!  Don't do anything more.                
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
        Tuesday, October 04, 2016                
                         
       
 
               
                         
                         
                         
                         
                         
                         
                         
                         
                         
                         
                         
                         
    Warm-up & Questions                
    A. How did your HW go (make a shopping list)?                
                         
    B. It's easy to get started in Excel                
       - You are an Excel user                
       - Here is your third challenge:                
        CHALLENGE 3: Make a Contact List in Excel                
         - A contact list stores information on how you can contact                 
        people, for instance, addresses and phone numbers                
         - What if you put people's email addresses in your list?                
         - Excel turns them into email hyperlinks                
         - Email hyperlinks are a big problem for most computer users                
         - Open Excel and get started.  Then we'll save the file.                
                         
                         
  7.                      
    Review: A formal introduction to the software                
        How Excel Works                
        1. Cells, 2. Enter, 3. Tab, 4. Formula Bar, 5. Column width                
     - Practice                
       - Let's make a list of people's first names & birthdays                
                         
    HOME WORK                
                         
    CHALLENGE 3: Make a Contact List in Excel                
        CHALLENGE 3: Make a Contact List in Excel                
         - Open Excel and get started.  Then save the file.                
         - Do you remember what we said about getting rid of email                 
        hyperlinks?                
        1. Undo after you hit <Enter>                
        2. Insert ribbon > Hyperlink > Remove Link                
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
        Tuesday, September 27, 2016                
                         
    Warm-up & Questions                
    A. How did your HW go (make a to-do list)?                
                         
    B. It's easy to get started in Excel                
       - You are an Excel user                
       - Here is your second challenge:                
        CHALLENGE 2: Make a Shopping List in Excel                
         - Open Excel and get started.  Then we'll save the file.                
                         
                         
  6.                      
    Now, we'll give a more formal introduction to the software                
        How Excel Works                
        1. Cells, 2. Enter, 3. Tab, 4. Formula Bar, 5. Column width                
       - Questions:                
        1. What happens when you type in a cell?                
        2. What happens when you hit the <Enter> key?                
        3. What happens when you hit the <Tab> key?                
        4. How do you remove or replace a cell's data?                
        5. What happens when you type in the Formula Bar?                
        6. How do you adjust the column width?                
                         
        Tuesday, September 20, 2016                
                         
  2.                      
    About Windows Explorer / File Explorer                
     - Windows Explorer is the tool for viewing and using the file                 
    management system                
       - In a Windows Explorer window you see icons for files and icons                 
      for folders                
       - Double-click a file's icon to open software in another window and                
      to see or work with that file                
       - Double-click a folder's icon to "go down" to a sub-folder of the                 
      current folder and see what it contains.  All this happens in the                 
      same Windows Explorer window.                
         - Rule: the only place you double-click is in the double-click                
        area of a Windows Explorer                
     - Parts of the Windows Explorer window                
       - Double click area shows what is contained in the current                
      location                
       - The "Path" shows where you are (the last thing in the path),                
      and possibly where you came from to get here                
       - The Navigation pane gets you to locations in the file                 
      management system with just a single click                
                         
  3.                      
     - We need a reliable method of navigating in Windows Explorer to                
    the My Documents folder (called Documents in Windows 8 or 10)                
      1. Click on the left-most arrow in the path, and see a list of                 
      locations                
      2. In the list, click on "Desktop"                
      3. In the double-click area, double-click on the icon showing a                 
      man sticking his head in a folder                
         - This takes you to your profile folder                
      4. Double click on the My Documents (Documents) icon                
         - This drops you down into that sub-folder                
         - The path will now end with My Documents (Documents)                
                         
  4.                      
    Delete the contents of the "Intro to Excel" folder                
     - This folder is a sub-folder of the My Documents folder                
       - After you navigate in Windows Explorer to the My Documents                
      folder, double-click on the "Intro to Excel" icon and go down to                
      that sub-folder                
       - To delete all of the old files there, do this                
        a. Ctrl-A (select all)                
        b. Tap the <Delete> key on the keyboard                
        c. Answer "yes" to send these files to the Recycle Bin                
                         
  5.                      
    It's easy to get started in Excel                
     - You are an Excel user                
       - Let's prove it!                
     - Here is your first challenge:                
        CHALLENGE 1: Make a To-Do List in Excel                
         - Open Excel and get started.  Then we'll save the file.                
                         
    HOME WORK                
                         
    CHALLENGE 1: Make a To-Do List in Excel                
        CHALLENGE 1: Make a To-Do List in Excel                
         - Open Excel and get started.  Then save the file.                
                         
                         
                         
    LOG YOUR COMPLETION OF EACH ASSIGNMENT   LINK          
                         
                         
        Tuesday, September 13, 2016                
                         
  1.                      
    Getting ready for the class                
     - Course outline & grading procedure                
        Course outline   LINK          
        80% attendance + complete 50% of homework = you pass!                
     - Look over the web site                
       - Type this address in the Address Bar of Internet Explorer & tap                 
      the <Enter> key on the keyboard                
        nahlej.net