Excel Tutorial for Beginners: Learn it FAST

Опис:

This video introduces Excel basics, covering what Excel is, how to enter and format data, understanding the ribbon UI, setting up filters and sorting, using formulas for totals and averages, creating charts, and applying conditional formatting. It also includes a sample file and homework problems. 0:00 - Introduction to Excel (Tanvi's tracking troubles) 1:15 - Starting Excel 1:38 - Understanding the Excel Screen (ribbon, formula bar, grid and status bar) 4:09 - Setting up the sales tracker 7:35 - Exploring Excel Ribbons 8:21 - Formatting the data so it looks nice 11:37 - Using filters to understand data (which customers paid by cash?) 13:05 - Formatting currency values 13:57 - Sorting data so highest amount shows on top 15:46 - Writing formulas to add up values 21:01 - Clearing away things in your spreadsheet 21:29 - Calculating average of values with formulas 22:39 - Visually representing data with Excel charts 24:08 - Formatting and adjusting Excel charts 27:27 - Special charting tip: Showing just selected data in the graph 28:26 - Highlighting values that are below 1200 (conditional formatting) 29:57 - Homework problems & closing remarks