Summary:
The video begins with an introduction to an Excel tutorial series, covering a wide range of Excel topics. The presenter mentions the sponsor, Udemy, and discusses the importance of pivot tables in data analytics. They then demonstrate how to create a pivot table using a sample dataset, explaining the use of rows, columns, and values. The video also covers customizing the display of data, sorting, and creating calculated fields for more complex calculations.
1. The speaker is starting an Excel tutorial series, covering many aspects of Excel, from basic to more complex topics. [Source: Document(page_content="00:00:00.08: what's going on everybody today we are\n00:00:01.60: starting our excel tutorial series\n00:00:04.21: [Music]\n00:00:09.44: now there are so many things that you\n00:00:11.04: can do in excel so i don't know how long\n00:00:13.04: the series is going to be it could be 15\n00:00:14.72: or even 20 videos but what i do know is\n00:00:17.20: that i'm going to be covering just about\n00:00:18.56: every single thing that i've used since\n00:00:20.16: i became a data analyst and i want to\n00:00:21.76: show you how to do it so it won't just\n00:00:24.00: be the more concrete things you know\n00:00:26.16: like pivot tables charts vlookups things\n00:00:28.64: like that it'll also be some of the more\n00:00:30.32: nuanced things like how to deal with\n00:00:32.08: missing data or how to deal with dirty\n00:00:33.92: data and how to clean that up within\n00:00:35.84: excel and so those are things that you\n00:00:37.68: may not be able to do you know if\n00:00:39.44: somebody wasn't showing you how to do it\n00:00:41.36: and so that's what i'm going to try to\n00:00:42.56: help you because i know that that is\n00:00:44.16: something that you will need to do or\n00:00:45.68: learn how to do in excel now before we\n00:00:48.00: get into it i want to give a huge shout\n00:00:49.28: out to the sponsor of this excel series\n00:00:51.04: and that is udemy i took so many excel\n00:00:53.52: courses on udemy when i was first\n00:00:54.88: starting out as a data analyst and there\n00:00:56.72: was this one course that i kept going\n00:00:58.24: back to over and over again because as i\n00:01:00.64: got into it in my job i realized that\n00:01:02.96: there were so many things that were in\n00:01:04.56: that course that i really needed to know\n00:01:06.96: but i didn't realize i needed to know it\n00:01:08.96: and so i'm going to put the links to\n00:01:10.24: those courses in the description in case\n00:01:11.84: you want to take those again huge shout\n00:01:13.44: out to udemy without further ado let's\n00:01:15.20: jump on my screen and get started with\n00:01:16.48: our very first excel tutorial all right\n00:01:18.08: so i'm going to go ahead and get rid of\n00:01:19.04: myself we are going to be looking at\