Who it's for: Beginners, as well as experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to organize and analyze data.
What you'll learn: We start with the basics, showing you Excel’s interface and the best ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Next, we cover Charts and Sparklines, along with some tips on presenting data in Excel. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with an overview of XLOOKUP, a vital function for modern-day Excel users. After that, we explore complex Database functions, provide you with an introduction to Macros, and demonstrate how to save time by automating common Excel tasks.
- Introduction (0:38)
- What is Excel? (1:24)
- Excel Interface Overview (6:26)
- Search and Help (2:42)
- Navigating and Selecting Cells (4:16)
- Entering, Replacing, and Deleting Data (9:50)
- Adjusting Cells (4:33)
- Calculations, Formulas, and Functions (13:02)
- Basic Functions (7:08)
- AutoFill (4:26)
- Relative and Absolute Cell Reference (6:07)
- Saving and Sharing Workbooks (3:57)
- Comments (2:28)
- Inserting Rows and Columns (2:54)
- Cut, Copy, and Paste (4:01)
- Formatting Data with Cell Styles (5:53)
- Managing Worksheets (4:36)
- Hiding Row and Columns (1:52)
- Creating Custom Views (3:27)
- Reviewing Worksheets (3:14)
- Printing Worksheets (4:42)
- Conclusion (0:07)