Excel Tips & Tricks
Loading...
47
subscribers
38,125
video views
Uploaded videos
1-10 of 50-
Split a Cell Diagonally
dough517
12 views
I'll show two ways to diagonally split a cell. One way is a put a diagonal line through a cell and the other is to insert a shape object.
-
Separate First and Last Names
dough517
9 views
How to separate first and last names in a one column to multiple columns. The full name is separated by a comma and in this session two methods can be used: (1) Text to C...
-
Lock Rows and Columns with Freeze Panes or Split
dough517
8 views
Learn to to lock rows or columns with Freeze Panes or Split in Excel 2007
-
Create a Dropdown List
dough517
6 views
How to create a dropdown list using the Data Validation features with three examples (csv list, range & named range).
-
Compare Lists Using a PivotTable
dough517
15 views
An example of how to compare two list using a PivotTable in Excel 2007. See other video on comparing list using Conditional Formatting.
-
Compare Lists Using Conditional Formatting
dough517
20 views
An example of how to compare two list using the conditional formatting feature in Excel 2007. See other video on comparing list using a PivotTable.
-
Create a Stacked Column or Bar Chart
dough517
63 views
How to create a stacked column, 100% stacked column or stacked bar chart
-
Filter Unique Values from a List
dough517
22 views
How to filter out unique values from a list in a column. I'll show three ways to do this: (1) with a PivotTable (2) with the Advanced Filter feature (3) with the Remove Dup...
-
Find Duplicates with a PivotTable
dough517
32 views
How to find duplicate values in one column record or in multiple column records
-
Use a Picture in a Chart
dough517
22 views
How to use a picture in a chart by embedding it in the plot area background or as the data series element.
Advertisement
About Excel Tips & Tricks
more
less
Play all(50)