I am an undergrad hire starting at McKinsey in September. I want to beef up my Excel and PowerPoint skills in the meantime and am considering taking an online course. I saw the options in the "Before Starting as A New Hire" section but both courses are fairly short (~2 hrs) and, since I have the time, I may try to find some more comprehensive courses. Any suggestions? Or are my concerns about the recommended courses unfounded?
Here is one of the other Excel courses I am considering: https://www.goskills.com/Course/Excel/Lessons
Thanks!
It depends on your field. If you are in the business or computer field, something like a Microsoft Excel (or some other program) certification could be very helpful. One site I've used is https://www.goskills.com/. They have different programs like excel, business writing, outlook, and etc, and you get a certification at the end. You have to pay, but assuming you are still in school, maybe your school or other program could sponsor students somehow. I've done one of these and it took about 12 hours total. Every interview I've ever had has been interested in it and asked me about, and it did help me get a job in my field right out of college.
If you are in the language field, passing the National Fluency Test in different languages is nice.
There are courses and certificates for almost anything. Just think about what you need in your field and go from there. The computer programs programs are probably the easiest to find, but I know that there are even certificates for things like conflict management or problem solving.
You can set default values by formatting the cell with a custom type. ie: select the cell(s) and instead of having them as a number, text, date, etc.... choose custom format and enter:
"[+]";"[-]";"[zero value]";"[text]"
There are four sections, separated by semi-colons. This shows:
[+]. if cell contains positive number
[-] if cell contains negative number
[zero value]. if cell contains a zero value
[text]. if cell contains text characters
You can change the messages within the speech marks to show different messages for each section. Or you can list the same message to appear in multiple sections. If you don't want to use any of the four sections, just remove that section so nothing is listed- but keep the semicolons. The square brackets are not needed, this is just to make it easy to see the sections.
This page has more information: Link, including how to set the text colour for any sections.
use the columns like a calendar (daily, weekly, monthly etc) and colour code activities to track your progress on larger goals.
different goals in different tabs etc
EDIT: here are some templates that show what i mean https://www.goskills.com/Project-Management/Resources/Project-management-template-Google-Sheets
maybe one will work for you?
I would definitely add it. Add any and all things related to Machine Learning, research, etc on your resume and make sure it's worded in a way that will stand out to someone in that field.
If that one phrase is the only thing under the description for this internship, google "Machine Learning research internship" to find ones that have better descriptions, and pull out key words, competencies, or tasks that this description should have included. Then go through your current resume and see if you can find anything related to those and try to reword what you currently have in your resume to use these words, competencies, and task.
​
Then think about any classes you took that relate to any of these and write out a description for those classes using key words, competencies, and task
Also, try these tips
https://www.goskills.com/Soft-Skills/Resources/Professional-development-resume
​
Lastly, reach out to the professor who is leading this and introduce yourself, ask questions about the internship, what qualities they are looking for in the intern, and let them know you're applying soon.
​
Good luck
you can check this out
https://www.goskills.com/Microsoft-Office/Resources/Google-Docs-Microsoft-Word-comparison
This doesn't tell you which one to use but I guest wrote a pretty long article on this topic not too long ago. Here's a link if you wanna read/skim it.
Love that link and its anecdote!
OP: you should not think full-fledged database but excel does provide power tools to create relationships amongst tabular data, in memory. See https://www.goskills.com/Excel/Resources/How-to-use-PowerPivot.
Love that link and its anecdote!
OP: you should not think full-fledged database but excel does provide power tools to create relationships amongst tabular data, in memory. See https://www.goskills.com/Excel/Resources/How-to-use-PowerPivot.
I can't find the URL for the one I downloaded 5 years ago and customized to my own needs. I downloaded this one this morning though, and I might give it a try as well as I wouldn't mind finding something even better. In general, for a small outfit with owner controlled bookkeeping, I think Excel is fantastic (and more intuitive for folks like me who live in Excel anyway). I keep giving QB (both online and client) a shot thinking I need to be consistent/modern with the bookkeeper professionals, but that is a false belief, and as I said above, my very good CPA handles these spreadsheets quite easily.
https://www.goskills.com/Excel/Articles/How-to-do-taxes-in-Excel
This isn’t necessarily an automaton, but I’ve really benefited from the use of User Defined Functions (UDFs) in Excel.
UDFs have allowed me to power through some things I do often, very quickly. Here is Microsoft’s post on User-Defined Functions: https://support.office.com/en-us/article/create-custom-functions-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f
A couple other good posts on this: https://www.vertex42.com/blog/excel-formulas/custom-user-defined-functions.html
https://www.goskills.com/Excel/Articles/Excel-user-defined-function-examples
Happy Excelling!