12 Essential Skills for Every Excel User

Опубликовано: 07 Ноябрь 2024
на канале: OneNumber - Tableau Experts

504

Where do you begin with Excel? It's a tool so widely used that everyone assumes you know how to work your way around it! But for those of us just starting out, it can be really intimidating to work out where to begin.

This video will walk you through 12 essential Excel skills that everyone should know, from Beginners to Experts! With these 12 skills, you'll be equipped to get started on your first Excel workbook, or to upgrade the workbook you're working on.

Connect with us:
•Book an hour to work with Ollie: https://onenumber.biz/office-hours
•Upcoming Tableau Classes: https://onenumber.biz/onenumber-table...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley

Resources:
•Example Excel Workbook: https://docs.google.com/spreadsheets/...
•Download the raw data set: https://catalog.data.gov/dataset/elec...

Chapters
0:00 Intro
0:28 Excel Tables
2:48 Filtering and Sorting
4:52 Freezing Rows and Columns
6:38 Field Formatting
7:56 Conditional Formatting
10:44 Aggregation Functions
12:22 IF Function
13:40 COUNTIF Function
14:54 CONCATENATE Function
15:58 Date Functions
17:08 PivotTables
19:52 Creating Charts
20:47 Inserting Slicers