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.
Category: Excel Review Materials
-
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:
-
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:
-
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.
-
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-2015You 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 refreshing your pivot table
- adding a slicer and timeline tool to your pivot table to enhance interactivity
-
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
-
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.
-
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) -
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 macro for a specific purpose
-
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.
-
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
-
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)
-
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
-
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)
- Gantt Chart 4-8-2014 (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