Juan Hinojosa, Technologist and Math Instructor
I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 3-25-2014. You can use it to review the activities covered in class:
I’m pleased to announce below is the link to the worksheet developed during the Monday workshop on 3-24-2014. You can use it to review the activities covered in class:
I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 3-15-2014. You can use it to review the activities covered in class:
File developed in the advanced excel class: Advanced Excel 3-15-2014.
I’m pleased to announce below is the link to the worksheet developed during the Tuesday workshop on 3-11-2014. You can use it to review the activities covered in class:
I’m pleased to announce below is a link to the worksheet developed during Saturday’s 3/8/2014 workshop. You can use it to review the activities covered in class: autofill, column/pie chart, formulas, functions [sum(), now(), vlookup()], name range, pivot table, sorting, filtering, and conditional formatting.
This was a great class. Thank you for letting me know you found it fun and interesting!
I’m pleased to announce below are links to the worksheets developed during the Wednesday workshops on 2-26-2014 and 3-5-2014. You can use it to review the activities covered in class:
I’m pleased to announce below are links to the worksheets developed during the Tuesday workshops 2-25-2014 and 3-4-2014. You can use them to review the activities covered in class:
Below is a copy of the worksheet developed during Saturday’s 11/9/2013 workshop. You can use it to review the activities covered in class: autofill, formulas, functions [sum(), now(), vlookup()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
This was a great class!
Below is the link to the file developed in the advanced excel class:
It has been provided so you can review the work done in class.
Below is a copy of the worksheet developed during Saturday’s 10/12/2013 workshop. You can use it to review the activities covered in class: autofill, formulas, functions [sum(), now(), vlookup()], name range, pivot table/pivot chart, sorting, filtering, and conditional formatting.
The group did a great job!
Below is a copy of the worksheet developed during Sunday’s 7/21/2013 workshop. You can use it to review the activities covered in class: autofill, formulas, functions [sum(), countif(), now(), vlookup()], name range, pivot table, sorting, filtering, and conditional formatting.
The group did a great job!
Below are links to the three files developed in the advanced excel class:
They have been provided to review the work done in class.
Recording a Macro
Review vlookup
Summarizing data with Pivot Tables
Links using hyperlinks and name ranges
Below is a copy of the worksheet developed during Saturday’s 6/15/2013 workshop. You can use it to review the activities covered in class: vlookup, pivot table, sorting, name range, conditional formatting and filtering.
The group did a nice job!
Below are two files developed in the second class.
advanced excel 5-5-2013 macro and what if analysis
advanced excel 5-5-2013 various examples
They have been provided to review the work done in class.
Below is the file developed in class.
It has been provided so you can practice the exercises done in class:
It was nice working with the group on Sunday April 21th. Below is a copy of the worksheet developed during the workshop. You can use it to practice and review the activities covered in class: vlookup, pivot table, sorting, and filtering.
It was nice working with the group on Sunday April 14th. Below is a copy of the worksheet developed during the workshop. You can use it to practice and review the activities covered in class.
Below is the link to the file developed in class:
It has been provided so you can practice the exercises done in class.
It contains macros, a pivot table, and a custom Excel function created with VBA.
I am pleased to announce below is the link to the “30 Year Interest Rate” file developed in class:
It has been provided so you can practice the exercises done in class.
It contains macros, a pivot table, conditional formatting, date and conditional functions.
It was nice working with the group today. Below is a copy of the database developed during the workshop. You can use it to practice the activities done in class.