Excel Tips & Tricks
23 videos • 4,227 views • by Sharon Smith
Quicker "How To" videos to demonstrate cool Excel features.
1
How To Switch First and Last Name in Excel Column - Swap Last and First Name in Excel
Sharon Smith
Download
2
How to Extract First Name in Excel (2 Helpful Ways)
Sharon Smith
Download
3
How to Add or Subtract Time in Excel - Calculate Hours and Minutes for Accurate Timekeeping
Sharon Smith
Download
4
How to Hide Confidential Data in Excel - Hiding Social Security Numbers & Credit Card Numbers
Sharon Smith
Download
5
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
Sharon Smith
Download
6
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
Sharon Smith
Download
7
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
Sharon Smith
Download
8
How to Password Protect Excel Spreadsheets (Cybersecurity Tip)
Sharon Smith
Download
9
How to Repeat Header Rows in Excel (Repeat Title Rows on Each Printed Page)
Sharon Smith
Download
10
How to Calculate Percent Difference Between Two Numbers in Excel
Sharon Smith
Download
11
Split Data From One Cell into Multiple Columns (Text to Columns in Excel)
Sharon Smith
Download
12
How to Lock and Protect Cells in Excel (Lock and Unlock cells before you Protect your Spreadsheet)
Sharon Smith
Download
13
How to Change Cell Color In Excel Based on Value (Conditional Formatting in Excel)
Sharon Smith
Download
14
How to Create a Drop-Down List in Excel
Sharon Smith
Download
15
How to Analyze Data Using IF Function in Excel
Sharon Smith
Download
16
Combine Data From Multiple Cells into One Cell (Create ID Number in Excel)
Sharon Smith
Download
17
How To Hide Worksheet Tabs in Excel – Hidden vs Very Hidden
Sharon Smith
Download
18
How to Open a Corrupted Excel File – Open And Repair a Corrupted Workbook
Sharon Smith
Download
19
How To Convert Image To Excel Table With MS Office App - Extract A Table From A Photo With Phone
Sharon Smith
Download
20
How To Convert PDF To Excel - PDF Data Connector in Excel 365
Sharon Smith
Download
21
How To Fix Excel When Formula Shows Instead of Result - VLOOKUP Troubleshooting Tip
Sharon Smith
Download
22
Create Date Countdown in Excel - Countdown Timer of Days Remaining
Sharon Smith
Download
23
Add Shortcuts to Ribbon in Excel - Speed Up your Excel Workflow using the Quick Access Toolbar
Sharon Smith
Download