Skip to content

Instantly share code, notes, and snippets.

@ricklentz

ricklentz/new_analyst_excel_onboarding.txt

Created June 19, 2017 13:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ricklentz/0fe47d33b3bbd292a517aa82716188fc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ricklentz/0fe47d33b3bbd292a517aa82716188fc to your computer and use it in GitHub Desktop.
Download ZIP
Excel onboarding for new analysts
Raw
new_analyst_excel_onboarding.txt
Sort and filter data
https://support.office.com/en-us/article/Sort-and-filter-data-ffb9fcb0-b9cb-48bf-a15c-8bec9fd3a472?ui=en-US&rs=en-US&ad=US
VLOOKUP: When and how to use it
https://support.office.com/en-us/article/VLOOKUP-When-and-how-to-use-it-9a86157a-5542-4148-a536-724823014785?ui=en-US&rs=en-US&ad=US
Use conditional formatting
https://support.office.com/en-us/article/Use-conditional-formatting-03ab07da-1564-4913-b69f-2b1a370c8910?ui=en-US&rs=en-US&ad=US
Take conditional formatting to the next level
https://support.office.com/en-us/article/Video-Take-conditional-formatting-to-the-next-level-542c19e3-3f1d-443b-b48e-3360102a0315?ui=en-US&rs=en-US&ad=US
Create a PivotTable and analyze your data
https://support.office.com/en-us/article/Create-a-PivotTable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760?ui=en-US&rs=en-US&ad=US
@ricklentz
Copy link
Author

ricklentz commented Jun 21, 2017

project: correlate_epsilon; Analysis of information flows, system changes and non-observable events

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment