0 like 0 dislike
0 like 0 dislike
Practice using Get & Transform (Also called Power Query)

4 Answers

0 like 0 dislike
0 like 0 dislike
I don’t think you will have to practice much to get up to speed if you have been out a few years. Also given some companies are still using excel 2007, you should be fine.
0 like 0 dislike
0 like 0 dislike
I prefer the 2019 version to 2016 due to the UI changes but they’re pretty much identical. Weird your job is mentioning power query editor, it seems like most employers knowledge of excel ends with “pivot tables and vlookups” like they’re some complex feature….

Edit: I will say an underutilized aspect of excel is array formulas tho. You can replicate sumifs logic on closed external workbooks
0 like 0 dislike
0 like 0 dislike
I learned a lot from watching ExcelisFun YouTube channel. And by actually using it and googlong what I need to do.
0 like 0 dislike
0 like 0 dislike
youtube videos and stackexchange is pretty much how i learned how to use powerquery

Related questions

0 like 0 dislike
0 like 0 dislike
20 answers
balkissoon asked Jun 21, 2022
Considering leaving the actuarial profession. What are some interesting fields you've heard of former actuaries going into? How did they get into the new field?
balkissoon asked Jun 21, 2022
0 like 0 dislike
0 like 0 dislike
25 answers
Teoparedes_93 asked Jun 21, 2022
Spent too much time on this not to share with r/actuary - I hope you get a chuckle out of it!
Teoparedes_93 asked Jun 21, 2022
0 like 0 dislike
0 like 0 dislike
9 answers
_MarkBlunden asked Jun 21, 2022
How to get over after failing STAM
_MarkBlunden asked Jun 21, 2022
0 like 0 dislike
0 like 0 dislike
2 answers
driveshift asked Jun 21, 2022
I did this all wrong but got the right answer? Took half of .075, used d=(1+i)/i to get discount rate, and just added. Decimal was off, but i got the numbers right. Luck?...
driveshift asked Jun 21, 2022
0 like 0 dislike
0 like 0 dislike
3 answers
JonnyBunning asked Jun 21, 2022
How to get more experience with R?
JonnyBunning asked Jun 21, 2022

33.4k questions

135k answers

0 comments

33.7k users

OhhAskMe is a math solving hub where high school and university students ask and answer loads of math questions, discuss the latest in math, and share their knowledge. It’s 100% free!