Recent Topics
Throttle sticking and scary
by NavyVet88 - 02/19/20 05:53 AM
New to me “vintage” oil mug
by dlundblad - 02/19/20 04:49 AM
Castrol 0W-20?
by TRDPRO85 - 02/19/20 02:44 AM
What is a dealer prep fee?
by WhyMe - 02/19/20 01:01 AM
Vintage Sinclair promo
by HiPowerShooter - 02/18/20 11:29 PM
why did my Ford iolm go to 9% after 3k miles?
by dogememe - 02/18/20 11:15 PM
HUBB reusable stainless steel filter?
by Vern_in_IL - 02/18/20 08:41 PM
Ultrasonic carb cleaning problems
by atikovi - 02/18/20 08:05 PM
Cheeseburger pie
by P10crew - 02/18/20 07:25 PM
The midwinter detail.
by dan_erickson - 02/18/20 05:27 PM
Tired of Using Cassette Player with iPhone
by Gebo - 02/18/20 05:04 PM
STP oil filter
by Stinky123 - 02/18/20 04:41 PM
How is this possible
by V10 - 02/18/20 04:07 PM
Monroe made in Turkey
by atikovi - 02/18/20 03:31 PM
NSFBitog
by Ursatdx - 02/18/20 03:25 PM
Wider rear tires?
by drop - 02/18/20 03:07 PM
Newest Members
GardenStateAudi, Strommen95, Idaholewis, Sprite, spbonus
70746 Registered Users
Who's Online Now
70 registered members (Astro14, Black_Thunder, Astro_Guy, 97K15004WD, Bailes1992, 9 invisible), 1,279 guests, and 17 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums67
Topics301,638
Posts5,199,609
Members70,746
Most Online4,538
Jan 20th, 2020
Donate to BITOG
Print Thread
Hop To
Intermediate/Advanced Excel online training/software #5327447 01/19/20 09:56 PM
Joined: Feb 2014
Posts: 3,549
L
Lolvoguy Offline OP
OP Offline
L
Joined: Feb 2014
Posts: 3,549
Does anyone know of a good software to learn some of the more advanced functions of Excel?
Recently I started a job where having that knowledge would be beneficial.

Some of the topics I'm looking to learn are:
Vlookups
Pivot tables
IFERROR
etc.

Any help would be greatly appreciated.
I prefer something that'll help me learn and apply in my own time, versus online courses with set schedules.
Something along the lines of a "Mavis Beacon teaches typing" format.

thanks in advance.


06 Lexus IS350- Wife
88 BMW 325is- Mistress
Say "no" to Turbo!
Re: Intermediate/Advanced Excel online training/software [Re: Lolvoguy] #5327481 01/19/20 11:11 PM
Joined: Nov 2017
Posts: 79
L
Lou_Boyle Offline
Offline
L
Joined: Nov 2017
Posts: 79
If you are already familiar with excel and just looking for help learning the advanced functions I would go to youtube and see if there is anything on there. I've found some surprisingly good software tutorials on other subjects there.


Think carefully about what you are doing, but be decisive. The road of life is paved with flat squirrels who couldn't make a decision.
Re: Intermediate/Advanced Excel online training/software [Re: Lolvoguy] #5327493 01/20/20 12:16 AM
Joined: Jul 2008
Posts: 1,374
R
rubberchicken Offline
Offline
R
Joined: Jul 2008
Posts: 1,374
Do you have a copy of a recent version of Excel at home ? That would help me guide you for suggestions.

Re: Intermediate/Advanced Excel online training/software [Re: Lolvoguy] #5327503 01/20/20 01:40 AM
Joined: Oct 2012
Posts: 2,989
D
Danno Offline
Offline
D
Joined: Oct 2012
Posts: 2,989
Not intended as a put down, but those functions are fairly basic Excel stuff. YouTube is a great place to learn.
Just to give you an example of Excel's capabilities, I used to maintain a database of 1400 trucks, import the weekly fuel records, weekly gps records (exceptions on rates of acceleration, speeding, idle time) and report out versus targets on a structured basis each Monday afternoon for the previous week's info. Records in the 100s of thousands. That level is getting into some interesting Excel programming.


2019 Jeep Grand Cherokee Summit 5.7L Hemi
2019 RAV4 Limited Hybrid
2016 Sorento SX V6 AWD
2010 Mazda 3 2.0L
Re: Intermediate/Advanced Excel online training/software [Re: Lolvoguy] #5327612 01/20/20 08:14 AM
Joined: Jul 2004
Posts: 1,033
S
shanneba Offline
Offline
S
Joined: Jul 2004
Posts: 1,033
Have you looked at the Microsoft Training as a start?

https://support.office.com/en-us/ar...home&ui=en-US&rs=en-US&ad=US


2003 BMW 330Ci
2013 HD Sportster XL1200C
Re: Intermediate/Advanced Excel online training/software [Re: Lolvoguy] #5327730 01/20/20 10:36 AM
Joined: Feb 2014
Posts: 3,549
L
Lolvoguy Offline OP
OP Offline
L
Joined: Feb 2014
Posts: 3,549
Thanks for the replies fellas, guess I'm off to youtube!


06 Lexus IS350- Wife
88 BMW 325is- Mistress
Say "no" to Turbo!
Re: Intermediate/Advanced Excel online training/software [Re: Lolvoguy] #5327830 01/20/20 12:34 PM
Joined: Jul 2007
Posts: 444
B
bcossa2001 Offline
Offline
B
Joined: Jul 2007
Posts: 444
Excel easy.com


"Facts are pesky things"

2003 Town & Country--143 k
2016 Fusion 8 k
2016 Fusion 34 k
2017 Santa Fe 8k
Re: Intermediate/Advanced Excel online training/software [Re: Danno] #5328354 01/20/20 10:24 PM
Joined: Jul 2008
Posts: 1,374
R
rubberchicken Offline
Offline
R
Joined: Jul 2008
Posts: 1,374
Originally Posted by Danno
Not intended as a put down, but those functions are fairly basic Excel stuff. YouTube is a great place to learn.
Just to give you an example of Excel's capabilities, I used to maintain a database of 1400 trucks, import the weekly fuel records, weekly gps records (exceptions on rates of acceleration, speeding, idle time) and report out versus targets on a structured basis each Monday afternoon for the previous week's info. Records in the 100s of thousands. That level is getting into some interesting Excel programming.


It sounds like your right at the cutoff between Excel and a true database. A few more years of data growth and you might exceed the max limits.

Previous Thread
Index
Next Thread

BOB IS THE OIL GUY® Powered by UBB.threads™