-
NEW! Intermediate Excel workshop April 1st and 8th at 6 PM (Live on Zoom)
This virtual class meets remotely twice using live video conference on Fri 4/1 6 PM and Fri 4/8 6 PM. What does the Intermediate workshop cover? When does the Intermediate Excel Class meet? How do I register? What is the instructor’s experience? What does the Intermediate workshop cover? Topics focus on data computation and data…
-
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
-
Introduction to Access 6-28-2015
Below is a link to the databases developed in class. Introduction to Access 06-28-2015 Steps to access the databases in the zip file: Download the above zip file Right-click the “zip” file from step 1 above and select extract. Open the folder containing the extracted files. If you have Microsoft Access, the access files .accdb…
-
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
-
About the Instructor
Juan Hinojosa is a full time Instructional Technologist at an institution with over 20,000 students. He is a technology instructor, successfully completed several actuarial exams, taught over 340 Microsoft Excel and Access classes, and taught over 4,000 students. He combines his 10+ years of experience in spreadsheet and database design with classroom training, webinar training,…
-
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
-
Introduction to Access 3-28-2015
Below is a link to the two databases developed in class. VacationPlanning 03-28-2015 To access the databases download the above zip file, right-click the “zip” file and select extract. You can use the files to review: Tables Queries Relationships Sorting with a table Filtering with a table Sorting with a query Filtering with a query…
-
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.
-
Introduction to Access 3-10-2015
Below is a link to the two databases developed in class. Introduction to Access 3-10-2015 To access the databases download the zip file and then right-click that “zip” file and select extract. You can use the files to review: Tables Queries Relationships Sorting with a table Filtering with a table Sorting with a query Filtering…
-
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
-
Intermediate Access 11-8-2014 forms, subforms, reports, macros
It was a nice working with the group on Saturday November 8. Below is a copy of the database developed during the workshop. You can use it to practice and review the activities covered in class. Creating a one to many relationship Creating a form Creating a form with a subform Creating a report Adding…
-
Contact Mathematics Instructor & Technology Instructor Juan Hinojosa
Tutor for all level of College Mathematics Email nyactuary@yahoo.com Instructor Beyond the Basics – Be more confident using Excel and Access! www.nytechnologist.com/beyondthebasics
-
Our Sites
SAT Math Prep Course
-
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)