This is the Excel for Analytics – Portfolio Project Series Video 1 – Quick Excel Tips where I’ll show you how to download the source file for the project series and then we’ll jump into a few quick tips to make your life easier when working in Excel.
First things first, how to get the source Excel file – here are your two options:
1) Recommended – Head over to https://www.tmbanalytics.com/excel-for-analytics and drop your name and email in the form and the email will show up right to your inbox in case you need to download again. Going this route will give you exclusive access to TMB Analytics insider discounts on future courses.
2) Head over to Github and download the file from https://github.com/mattbrattin/Excel-for-Analytics
Either way works, it is entirely up to you.
If you’re interested in checking out my Free Analytics Career Foundations course you can sign up at www.tmbanalytics.com/freetraining
In this first video of the Excel for Analytics – Portfolio Project Series we will cover:
0:00 – Importance of Excel skills overview
1:56 – Video series overview
3:07 – Downloading the source file instructions
3:58 – No mouse philosophy + Hand positioning for Excel
7:50 – Navigating from tab to tab using Excel keyboard shortcuts
8:54 – Quick navigation around a data set in Excel using keyboard shortcuts
11:56 – Quickly selecting data in an Excel data set using keyboard shortcuts
14:04 – Using the Alt menu to execute Excel keyboard shortcuts