Recent Changes

Monday, September 18

Friday, September 15

  1. page Excel Skills edited ... {Formatting EXCEL for Printing.docx} Manipulating Pivot Tables Instructions for the Read t…
    ...
    {Formatting EXCEL for Printing.docx}
    Manipulating Pivot Tables
    Instructions for the Read to Achieve Score Summary Sheet
    Read to Achieve Score Summary Spreadsheet
    {2013-12-11_0856.png}

    Straight to the SourceStraight to the Source
    The "Help Tab" is built directly into the Excel Ribbon and is a great first place to check for instant help. Most of the objects on the Help Tab are specific links to content on Microsoft's website. If the Help tab is not installed on your computer you can download it here.
    (view changes)
    1:04 pm
  2. page Excel Skills edited ... Open the Demo Spreadsheet File {Demo spreadsheet.xlsx} Excel Short Cuts CTRL+Z = undo CT…
    ...
    Open the Demo Spreadsheet File
    {Demo spreadsheet.xlsx}
    Excel Short Cuts
    CTRL+Z = undo
    CTRL+C = cut
    CTRL+P= paste
    CRLT+F= find

    Excel Activities for Beginning Users
    Includes:
    ...
    Protecting cells & sheets
    Creating graphs
    Watch this to learn about: Conditional Formatting
    Watch this to learn about: Creating Graphs
    Watch this to learn about: Protecting cells & columns

    Excel Activities for Advanced Users
    Includes:
    vLookup
    Pivot Tables
    Advanced formulasWatch this to learn: about vLookup
    Watch this to learn about: Pivot Tables

    Data Tips - ExcelData Tips - Excel
    {Data-Protecting Worksheets.docx}
    (view changes)
    12:40 pm

Thursday, September 7

  1. page Excel Skills edited ... Excel Resources Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny…
    ...
    Excel Resources
    Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny fraction of its ability. Below you will find a series of resources that you can access on an as needed basis. Do not be concerned if you need to return to these resources on a regular basis, many of the best Excel tricks are complicated but can be easily achieved with a little help.
    Excel Training Workshop
    Watch this: Tour of the Demo Spreadsheet
    Open the Demo Spreadsheet File
    {Demo spreadsheet.xlsx}

    Excel Activities for Beginning Users
    Includes:
    ...
    Formulas
    Print settings
    Watch this to learn about: Freezing cells, Sorting & Filtering
    Watch this to learn about: Basic formulas & Print Settings

    Excel Activities for Intermediate Users
    Includes:
    (view changes)
    7:45 pm
  2. page Excel Skills edited ... Excel Resources Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny…
    ...
    Excel Resources
    Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny fraction of its ability. Below you will find a series of resources that you can access on an as needed basis. Do not be concerned if you need to return to these resources on a regular basis, many of the best Excel tricks are complicated but can be easily achieved with a little help.
    <!-- copy and paste. Modify height and width if desired. -->
    <object id="scPlayer" width="1919" height="1030" type="application/x-shockwave-flash" data="https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/jingswfplayer.swf" >
    <param name="movie" value="https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/jingswfplayer.swf" />
    <param name="quality" value="high" />
    <param name="bgcolor" value="#FFFFFF" />
    <param name="flashVars" value="thumb=https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/FirstFrame.jpg&containerwidth=1919&containerheight=1030&content=https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/Demo%20Tour.swf&blurover=false" />
    <param name="allowFullScreen" value="true" />
    <param name="scale" value="showall" />
    <param name="allowScriptAccess" value="always" />
    <param name="base" value="https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/" />
    Unable to display content. Adobe Flash is required.
    </object>

    Excel Activities for Beginning Users
    Includes:
    (view changes)
    6:40 pm
  3. page Excel Skills edited ... Excel Resources Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny…
    ...
    Excel Resources
    Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny fraction of its ability. Below you will find a series of resources that you can access on an as needed basis. Do not be concerned if you need to return to these resources on a regular basis, many of the best Excel tricks are complicated but can be easily achieved with a little help.
    <!-- copy and paste. Modify height and width if desired. -->
    <object id="scPlayer" width="1919" height="1030" type="application/x-shockwave-flash" data="https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/jingswfplayer.swf" >
    <param name="movie" value="https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/jingswfplayer.swf" />
    <param name="quality" value="high" />
    <param name="bgcolor" value="#FFFFFF" />
    <param name="flashVars" value="thumb=https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/FirstFrame.jpg&containerwidth=1919&containerheight=1030&content=https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/Demo%20Tour.swf&blurover=false" />
    <param name="allowFullScreen" value="true" />
    <param name="scale" value="showall" />
    <param name="allowScriptAccess" value="always" />
    <param name="base" value="https://content.screencast.com/users/kelly.burgess/folders/Jing/media/44dc6192-130a-4419-9c42-afcf2654065f/" />
    Unable to display content. Adobe Flash is required.
    </object>

    Excel Activities for Beginning Users
    Includes:
    (view changes)
    6:38 pm
  4. page Excel Skills edited ... {https://sites.google.com/a/gaston.k12.nc.us/gcs-secretary-resources/_/rsrc/1309203721981/exce…
    ...
    {https://sites.google.com/a/gaston.k12.nc.us/gcs-secretary-resources/_/rsrc/1309203721981/excel-resouces/Image%202.png} external image Image%202.png
    Other amazing resources found on Microsoft's website are:Excel Skill Builders video series - Learn various excel activities in a set of four online video series.Excel 2007 Help and How-to - A glossary style list of excel functions.Office Templates - Download some very cool Excel spreadsheets from this online repository.Ribbon Hero - Learning how to use Excel is now a game!!! Once installed, the game can be accessed from a tab in Excel's Ribbon. Loving this Ribbon thing? Try Ribbon Hero 2 and become a Microsoft Office Rock Star!!
    ...
    in Pictures -Tutorials-
    Tutorials
    based on pictures, not words.Quickwords
    .Quick
    Reference Card
    Advanced ResourcesConditional Formatting
    This is an excellent tool to use when analyzing Reading 3D, 1st and 2nd grade math assessments, ClassScape data etc.
    (view changes)
    6:19 pm

Tuesday, August 22

  1. page Excel for Beginners edited We want to answer these question: What is the average BT salary? What is the average non-BT salary…
    We want to answer these question: What is the average BT salary? What is the average non-BT salary?
    Download the spreadsheet below.
    {Demo spreadsheet.xlsx}
    STEPS:
    Make data pretty and clean.
    Just above the first row double click on a line separating the columns to make the headings readable.
    Make the headings in Row 1 bold.
    Center the data in columns F-I and M-N.
    Freeze the first row of data so if can be seen when you scroll down.
    Format columns L, M & O to currency.
    OOPS! It looks like there was a type-o. Mr. Johnson's salary is incorrect.
    To find the correct Mr. Johnson sort by last name then filter by subject.
    Change his current salary from $33.00 to $133.00.
    Now that our data is clean and pretty we can find the answer to our question.
    Enter the formula to calculate the change in salary by the increase in column M.
    Enter a formula to add the increase to the current salary.
    Drag the formula cells down to apply it the formulas all rows.
    Sort by BT column
    In a column to the right of the data enter: "Average BT Pay"
    In the cell to the right of "Average BT Pay" enter a formula to calculate the average Total Pay and include all the BTs.
    n a column to the right of the data enter: "Average non-BT Pay"
    In a column to the right enter a formula to calculate the average Total Pay and include all the non-BTs.
    Print the answer to your question.
    Select the 4 cells that contain the answer to your question.
    Click on the "File" tab in the top left of the screen.
    Select "Print"
    Under "Settings" click on the first drop down menu and choose "Print Selection"
    Make sure that the print preview is correct.
    Click "print" (Optional)

    (view changes)
    11:18 am

More