In this course we will learn about some awesome Excel features and how to use them with some examples commonly encountered by every analyst.
Bonus: Conditional Formatting
These tools should be in every analysts toolbox and will save you a lot of time and effort if you know how to use them should the need arise.
Follow along with the course using the provided workbook.
Text to Columns can be used to separate or parse data from a single column into multiple columns and is a key tool to have in your toolbox for data manipulation. In this video we're going to look at an example involving parsing out a comma separated list in a single cell.
Flash fill is a great tool for automatically filling out data when it senses a pattern.
Recording macros can automate your repetitive tasks and can also be a good way to start learning VBA.
Learn how to group sheets together to make the changes across multiple sheets.
Use the Go To command to delete blank rows in your data.
Learn how to remove duplicate rows from your data.
Add totals to your data quickly using auto sum.
Quickly fill blank data with the Go To command and the Ctrl + Enter keyboard shortcut.
Learn how to sum across multiple sheets without individually referencing them.
Get the unique items in a list using advanced filter.
Learn how to use conditional formatting to highlight your data based on certain criteria.
I've worked in Canada, Ireland, Luxembourg and the UK as an actuary for 10 years where I discovered my passion for using Excel to find the easiest solutions to my work problems. In 2016 I started an Excel websites which has since grown a 38k following on Facebook. My interest has shifted to online technology and marketing so in 2017 I started a new career at an online advertising start up.