Advanced Excel

January 28th, 2016 Leave a comment Go to comments

The Advanced Excel module contains tutorials covering advanced data manipulation topics in Excel. I have posted all four tutorials in this module for your reference. The current week’s assignment is indicated by arrows and a due date next to it. If you choose to work ahead, make sure you submit the correct assignment on the week it is due.

Tutorials for Excel 2013

  • Tutorial 1 – Advanced Functions
    • Tutorial 1 – Projectile Motion Excel File
    • Tutorial 1 – Class Spreadsheet Excel File
    • Tutorial 1 – Assignment Excel File
  • Tutorial 2 – Advanced Formatting
    • Tutorial 2 – Shopping Trends Excel File
  • Tutorial 3 – Solver
    • Tutorial 3 – Polynomial Excel File
    • Tutorial 3 – Manufacturing Excel File
  • Tutorial 4 – Macros
    • Tutorial 4 – TestScores

Tutorials for Excel 2007/2010 (same tutorial will work for both)

  • Tutorial 1 – Advanced Functions
    • Tutorial 1 – Projectile Motion Excel File
    • Tutorial 1 – Class Spreadsheet Excel File
    • Tutorial 1 – Assignment Excel File
  • Tutorial 2 – Advanced Formatting
    • Tutorial 2 – Shopping Trends Excel File
  • Tutorial 3 – Solver
    • Tutorial 3 – Polynomial Excel File
    • Tutorial 3 – Manufacturing Excel File
  • Tutorial 4 – Macros
    • Tutorial 4 – TestScores

To complete the tutorials, download and read though the linked PDF file. The PDF files are formatted for printing if you would like a hard copy. While reading through the tutorial, you are encouraged to experiment with the features presented in the actual software application.

At the end of each tutorial, an assignment is included. To submit the assignment, follow the Blackboard Instructions link in the Software menu above. The link for assignment submission each week will be available on Mondays at 3:00PM and will be due on the following Friday by 11:59 PM.

For each tutorial, there is a quiz on Blackboard. Instructions on how to complete the Blackboard quiz appear in the Blackboard Instructions page linked under the Software menu option. The link for each week’s quiz will be available on Mondays at 3:00PM and will be due on the following Friday by 11:59 PM.

 

  1. No comments yet.
You must be logged in to post a comment.