From the course: Excel: You Can Do This
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Copying, coloring, and naming tabs - Microsoft Excel Tutorial
From the course: Excel: You Can Do This
Copying, coloring, and naming tabs
(funky music) - We've got data and a spreadsheet, and we've got stuff to do with this data. We can dive in and get ourselves caught up in a fix. No, stop, back up, I'm going to show you some tips, on how to keep yourself organized. (whooshing) We've got three sets of data, a bunch of columns, and the columns aren't lined up. We got Last Name for this first section. We got Favorite Fish in the same column, but Favorite Fish, well it's just crazy. And we got to clean this up. Don't start cleaning this up yet. First tip, I'm going to highlight this tab. Right click it. Move or Copy, I want to copy it. And yeah, it can go before sheet one, Okay. Why did I do that? Because once I start cleaning it up, if I make a mess or delete something and can't get it back, I can always get back to my raw data. So that's what I'm going to do here. I'm going to double click this tab, call it RAW, and then click away from it, then go back to it. Right click, Tab Color, I'm going to color it red…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
Flash Fill: Merge data in different cells1m 51s
-
Linking sheets3m 3s
-
(Locked)
Copying, coloring, and naming tabs3m 3s
-
(Locked)
SUM: Calculating a basic sum2m 12s
-
(Locked)
Freeze panes: See your data while scrolling1m 57s
-
(Locked)
Conditional formatting2m 28s
-
(Locked)
Data validation: Ensure users don't input crazy data2m 23s
-
(Locked)
Create a drop-down list3m 27s
-
(Locked)
Create basic charts from scratch1m 38s
-
(Locked)
Split text in Power Query: Split real-world data fields2m 53s
-
(Locked)
IF statement2m 4s
-
(Locked)
COUNTIFS: Count entries based on conditions1m 40s
-
(Locked)
The #N/A error: What does it mean and what causes it?1m 45s
-
(Locked)
VLOOKUP4m 18s
-