Category: Excel Review Materials

  • Intermediate Excel 4-16-2016

    I’m pleased to announce the file created during the Intermediate Excel workshop on 4-16-2016 is now available to practice with.  Here is the link:  Intermediate Excel 4-16-2016.

  • Advanced Excel 7-26-2015

    I’m pleased to announce the two files from the Advanced Excel workshop on 7-26-2015 are now available to practice with: Advanced Excel 7-26-2015 a Advanced Excel 7-26-2015 b

  • Intermediate Excel 6-14-2015

    I’m pleased to announce the files created during the Intermediate Excel workshop on 6-14-2015 are now available to practice with: Intermediate Excel 6-14-2015 part a Intermediate Excel 6-14-2015 part b

  • Advanced Excel 4-25-2015

    I’m pleased to announce the file created during the Advanced Excel workshop on 4-25-2015 is now available to practice with.  Here is the link:  Advanced Excel 4-25-2015.

  • Intermediate Excel 4-18-2015

    I’m pleased to announce the file created during the Intermediate Excel workshop on 4-18-2015 is now available to practice with.  Here is the link:  Intermediate Excel 4-18-2015.

  • Intermediate Excel 3-31-2015

    It was a pleasure doing PivotTables, vLookups, name range, and conditional formatting with the class. Below is a link to the Excel workbooks developed during the workshop. Use them to practice some of the activities covered in class. Merrick Intermediate Excel 3-31-2015 a Merrick Intermediate Excel 3-31-2015 b

  • Intermediate Excel 3-24-2015

    It was a pleasure working with the class!  Below is a link to the Excel workbook developed during the workshop. Merrick Intermediate Excel 3-24-2015 You can use the file to review the activities covered in class: pivot table/pivot chart, sorting, filtering, and creating a Gantt chart.

  • Excel Pivot Table workshop 12-13-2014

    I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 12-13-2014. You can use it to review a few of the activities covered in class: creating pivot tables working with pivot table fields modifying pivot table layout linking a chart to your pivot table changing data values and…

  • Introduction to Excel 11-25-2014

    I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 11-25-2014. You can use it to review a few of the activities covered in class: navigation and data entry sort and filter sum function autofill and formulas Introduction to Excel 11-25-2014

  • Advanced Excel 10-25-2014

    Below are the files developed during Saturday’s 10/25/2014 Advanced Excel workshop. You can use the files to review the activities covered in class: nested if functions, pivot tables, name range references, pivot charts, mail merge, macros, pivot table sorting, filtering, and grouping. advanced excel 10-25-2014 (1) advanced excel 10-25-2014 (2) advanced excel 10-25-2014 (3) advanced…

  • Intermediate Excel 10-18-2014

    Below are the two workbooks developed during Saturday’s 10/18/2014 Intermediate Excel workshop. You can use the files to review the activities covered in class: autofill, formulas, functions [vlookup(), now()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting. intermediate-excel-10-18-2014 (1) intermediate-excel-10-18-2014 (2)

  • Intermediate Excel 10-18-2014 (chart)

    intermediate excel 10-18-2014 (chart)

  • Intermediate Excel 10-18-2014

    intermediate excel 10-18-2014

  • Advanced Excel 8-9-2014

    Below are links to the files developed in the advanced excel class. It has been provided so you can review the work done in class. Summarizing data with Pivot Tables Group feature with Pivot Tables Formulas and nested functions Linking cells: name range/name box and hyperlinks Nested conditional functions Creating macros and buttons Creating a…

  • Intermediate Excel 7-26-2014

    Below is the workbook developed during Saturday’s 7/26/2014 Intermediate Excel workshop. You can use the file to review the activities covered in class: autofill, formulas, functions [if(), vlookup(), countif], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting. Intermediate Excel 7-26-2014

  • Advanced Excel 6-28-2014

    Below is a link to the file developed in the advanced excel class. It has been provided so you can review the work done in class. Summarizing data with Pivot Tables Group feature with Pivot Tables Formulas and nested functions Linking cells: name range/name box and hyperlinks Nested conditional functions Advanced-Excel-6-28-14

  • Intermediate Excel 6-14-2014

    Below are workbooks developed during Saturday’s 6/14/2014 Intermediate Excel workshop. You can use the files to review the activities covered in class: autofill, formulas, functions [sum(), vlookup()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting. Intermediate Excel 6-14-2014 (a) Intermediate Excel 6-14-2014 (b) Gantt-Chart Intermediate Excel 6-14-2014 (c)

  • Microsoft Excel Intermediate 4-9-2014 Day 3

    I’m pleased to announce below is the link to the worksheet developed during the Wednesday workshop on 4-9-2014.  You can use it to review the activities covered in class: Name Ranges Date & Time functions Date & Time shortcuts Conditional Format Goal Seek Intermediate Excel 4-9-2014  

  • Microsoft Excel Intermediate 4-8-2014

    I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 4-8-2014.  You can use it to review the activities covered in class: creating a gantt chart sorting using formulas with dates creating actual and expected gannt charts Files: Gantt Chart 4-8-2014 (xlsx) Gantt Chart 4-8-2014 (1) (pdf) Gantt Chart 4-8-2014 (2) (pdf)…

  • Microsoft Excel Intermediate 4-2-2014 Day 2

    I’m pleased to announce below is the link to the worksheet developed during the Wednesday workshop on 4-2-2014.  You can use it to review the activities covered in class: creating a bar chart and pie chart sorting filtering Intermediate Excel 4-2-2014