Tag: Excel Formulas

Another 15 Excel 2016 Tips and Tricks

Here’s another 15 Excel 2016 Tips & Tricks. This is a compliation of 15 additional Excel 2016 tips and tricks that didn’t make it in my previous Top 25 Excel tips and tricks video. If you haven’t seen it, you’ll want to click the link listed at the end of this video, in the description…

Read MoreView 100 Comments

Top 15 Advanced Excel 2016 Tips and Tricks

This is the top 15 advanced Excel 2016 tips and tricks. As a follow up from the top 25 Excel 2016 tips and tricks video, here’s some additional advanced features. If you missed the original top 25, follow the link at the end of this video and be sure to check out my tips and…

Read MoreView 4 Comments

Intermediate Excel Skills, Tips, and Tricks Tutorial

In this video tutorial we’re going to take a look at the intermediate Skills tips and tricks that you need to know in order to use excel Properly and efficiently if you haven’t already watched my other excel video. It’s called the Beginner’s guide to Excel and I highly recommend that you start with that…

Read MoreView 100 Comments

Top 25 Excel 2016 Tips and Tricks

After years of using Excel in a corporate environment here are my top 25 Excel 2016 tips and tricks. Welcome to Sele training. I’m about to show you some useful tips and tricks for Excel 2016. They’re in no particular order so be sure to watch all the way through to the end of the…

Read MoreComment

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

Welcome to Excel Magic Trick number 1394. If you want to download this Excel workbook, Excel Magic Trick 1393-94 so you could follow along, click on the link below the video. Wow, we have a crazy video here. We’ve got to calculate formulas for traditional pivot table calculations, such as percentage of column total, percent…

Read MoreView 14 Comments

Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records

Welcome to Excel Magic Trick number 1,405. Hey, if you want to download this Excel workbook so you can follow along, click on the link below the video. Hey, we got to see how to use sumif to calculate monthly revenue from daily sales and then monthly ad costs from monthly amounts. Now, here’s our…

Read MoreView 20 Comments