Calgarypuck Forums - The Unofficial Calgary Flames Fan Community
Old 02-12-2018, 11:41 AM   #1
firebug
Powerplay Quarterback
 
firebug's Avatar
 
Join Date: Aug 2002
Location: Mayor of McKenzie Towne
Exp:
Default Created Excel Tutorial Channel on Youtube

With some of the spare time I have on my hands currently I decided to create a channel providing free tutorials on Excel techniques.

As a bit of background, I hold the CFA charter and have more than 10 years experience in modelling and financial analysis. Additionally I'm certified by MS at the 'Expert' level in both Excel and Word.

Anyways, I just launched this playlist this morning that will feature tutorials on MS Office features in 2-minutes or less.



Constructive criticism would be greatly appreciated (and of course likes/subscribes wouldn't hurt my feelings).

I've about 10 of these mapped out to get me going (2 -3 new ones per week initially), but please let me know if there are techniques that you'd like to see added.

Added:
Excel's SUMIF function
Excel's MOD function
Excel's Table Slicer
Excel's Sparklines
__________________
"Teach a man to reason, and he'll think for a lifetime"

~P^2

Last edited by firebug; 02-21-2018 at 09:49 PM.
firebug is offline   Reply With Quote
The Following 15 Users Say Thank You to firebug For This Useful Post:
Old 02-12-2018, 11:50 AM   #2
firebug
Powerplay Quarterback
 
firebug's Avatar
 
Join Date: Aug 2002
Location: Mayor of McKenzie Towne
Exp:
Default

While not geared to have as general an interest as the '2 minute' videos, I've also been working on a series of tutorials based on Power Pivot, Power Query and Power BI.

These are based on the chapters in Collie and Singh's excellent book on those Excel utilities.

__________________
"Teach a man to reason, and he'll think for a lifetime"

~P^2
firebug is offline   Reply With Quote
The Following 2 Users Say Thank You to firebug For This Useful Post:
Old 02-13-2018, 10:10 AM   #3
Northendzone
Franchise Player
 
Northendzone's Avatar
 
Join Date: Aug 2009
Exp:
Default

Quote:
Originally Posted by firebug View Post
to me the sumifs function would be a nice progression from this.
__________________
If I do not come back avenge my death
Northendzone is offline   Reply With Quote
Old 02-13-2018, 11:40 AM   #4
firebug
Powerplay Quarterback
 
firebug's Avatar
 
Join Date: Aug 2002
Location: Mayor of McKenzie Towne
Exp:
Default

Quote:
Originally Posted by Northendzone View Post
to me the sumifs function would be a nice progression from this.
I was hoping to actually have that one as a SUMIFS but found I couldn't get it under the 2-minute mark... I may have to start a '5-minute foundations' series to delve into some of the more involved functions.

If you are looking for a couple walk-throughs I have some examples as part of my Excel Expert Certification tutorial series...
SUMIFS (starting at 4:35)
COUNTIFS and AVERAGEIFS
__________________
"Teach a man to reason, and he'll think for a lifetime"

~P^2
firebug is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 03:42 AM.

Calgary Flames
2023-24




Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright Calgarypuck 2021