Profile

Cover photo
Joe Z
131 followers|12,678 views
AboutPostsPhotosVideos

Stream

Joe Z

Shared publicly  - 
 
Point Guards:Tim Frazier - New Orleans Pelicans (Fanduel: 5400 Draftkings: 6600) takes on the Golden State Warriors with an Over/Under of 223.5 and a line of 17. They rank 29 against Point guards this year and 24 last year...
1
Add a comment...

Joe Z

Shared publicly  - 
 
The Vlookup function in Excel is great for pulling in data from a larger table. However one drawback to it is that it looks in the larger table and pulls over the first match it finds. But what if there are multiple instances in this larger table and you want to pull in the second …
1
Add a comment...

Joe Z

Shared publicly  - 
 
Tutorial showing how to set up a pivot chart from a Pivot Table, along with editing the chart...
See how to turn a pivot table into a Pivot chart to enable you to visually see the pivot data in a more pleasing way.
1
Add a comment...

Joe Z

Shared publicly  - 
 
Here is a video I shot to explain the MAX and LARGE functions in Excel. The Max function will give you the largest value in a range of values. The LARGE function will give you the nth largest value in a list of values. n represents whatever number you want. For example, if you want …
1
Add a comment...

Joe Z

Discussion  - 
 
Hi, here is a screenshot tutorial I wrote about how I used the OFFSET MATCH functions to pull in Employee sales on my spreadsheet
The OFFSET MATCH function is a very powerful tool which can be used in many ways. One way is to pull in a new range based on multiple criteria which you can specify. Let’s say we have the following: We have a table at the bottom which lists our employees and the number of sales …
1
Add a comment...

Joe Z

Shared publicly  - 
 
I'm giving away a 30 page Ebook on Excel Functions.  It's a preview of my first product which goes live Feb 4th 2015. Master Excel Functions
February 4th, 2015 - The day is coming! Put your e-mail address below and you will get: - 30 Page PDF Preview Ebook of 30 Top Excel Functions. - Discount when the product is released. - More information on this training as it comes out... Launching in.
1
Steven Khieu's profile photo
 
Hi Joe, how do I get a hold of you ?
Please let me know.

Thanks.
Add a comment...

Joe Z

Shared publicly  - 
 
See a Nested If Statement explained and learn an easy way to make one in Excel 2010
1
Add a comment...

Joe Z

Shared publicly  - 
 
New Blog post about using the basics of Contional Formatting
Excel allows you to format cells or ranges of cells based on what is in the cells. It gives you a large array of options on how you want to make a cell look, depending on what is in them. This can be very powerful to use in your spreadsheets and can enhance them incredibly. …
1
Add a comment...

Joe Z

Shared publicly  - 
 
In many tables that you work with, you only want to have unique values in a column.  However going through and finding all the duplicates can seem like a daunting task if the table is very large and you don’t know the quicker ways to do this.  Excel gives us multiple ways to deal with …
2
Add a comment...
Basic Information
Gender
Male
Links
YouTube
Contributor to