Microsoft Excel Tutorials
45 videos • 11,073 views • by Sharon Smith
For any skill level, these real-life examples illustrate how you can harness the power of Excel in your every day tasks and projects.
1
How to Create a Table of Contents with Hyperlinks in Excel
Sharon Smith
Download
2
Match Names on Two Excel Sheets with VLOOKUP – Create Unique ID in Excel
Sharon Smith
Download
3
Create and Track a Basic Inventory List in Excel - Excel Inventory List Template
Sharon Smith
Download
4
How to Create Fillable Forms in Excel - Employee Engagement Survey Template
Sharon Smith
Download
5
Create A Calendar In Excel - Dynamic Annual Payroll Calendar 2023
Sharon Smith
Download
6
How to Calculate Working Days in Excel & Exclude Weekends & Holidays
Sharon Smith
Download
7
How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP
Sharon Smith
Download
8
Automate Reports in Excel using Office Scripts - Time Saving Tip to Auto Format Reports
Sharon Smith
Download
9
How to Create Pivot Tables in Excel to Analyze Data - Pivot Tables Made Easy for Beginners
Sharon Smith
Download
10
Automate Data Clean-up with Power Query - Auto Format & Combine Multiple Sheets - Save Time
Sharon Smith
Download
11
Create an Organizational Chart with Excel Data - Make Org Chart from Excel Employee Database
Sharon Smith
Download
12
Top Excel Formulas for HR (FREE Download of Useful Excel Formulas)
Sharon Smith
Download
13
Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets
Sharon Smith
Download
14
How to Add or Subtract Time in Excel - Calculate Hours and Minutes for Accurate Timekeeping
Sharon Smith
Download
15
VLOOKUP Excel Tutorial for HR Professionals (How to use VLOOKUP)
Sharon Smith
Download
16
How to Modify a Pivot Table in Excel (View Pivot Table in a Tabular Spreadsheet Format)
Sharon Smith
Download
17
How to Create Charts and Dashboards in Excel (FREE HR Dashboard Template)
Sharon Smith
Download
18
Pivot Table Tips with Employee Benefit Data (Excel Pivot Table Tutorial for HR)
Sharon Smith
Download
19
How To Export Word Form Data Fields To Excel
Sharon Smith
Download
20
How to Create A Multi-Select Drop-Down List in Excel
Sharon Smith
Download
21
How To Lock A Form in Excel - Creating Fillable Forms in Excel
Sharon Smith
Download
22
How To Auto Populate Text From A Drop-Down List Selection in MS Excel - Create Fillable Forms
Sharon Smith
Download
23
How To Switch First and Last Name in Excel Column - Swap Last and First Name in Excel
Sharon Smith
Download
24
Excel Report Formatting and Printing Tips for HR (Formatting Spreadsheets for Printing)
Sharon Smith
Download
25
How to Customize the Quick Access Toolbar and Status Bar in Excel (2 Useful Commands)
Sharon Smith
Download
26
Sort and Filter Data in Excel (Sort and Un-sort in Excel Using HR Reports)
Sharon Smith
Download
27
How to Create A Mail Merge for Email – Send Multiple Customized Invoices Simultaneously
Sharon Smith
Download
28
How To Hide Worksheet Tabs in Excel – Hidden vs Very Hidden
Sharon Smith
Download
29
Performance Review Form Template In Excel
Sharon Smith
Download
30
How To Insert A Submit Form Button In Excel - Submit Form to Email – Create Fillable Forms in Excel
Sharon Smith
Download
31
How To Hide Command Button in Excel When Printing - Print Form Without Submit Button
Sharon Smith
Download
32
How To Convert PDF To Excel - PDF Data Connector in Excel 365
Sharon Smith
Download
33
How to Open a Corrupted Excel File – Open And Repair a Corrupted Workbook
Sharon Smith
Download
34
How To Convert Image To Excel Table With MS Office App - Extract A Table From A Photo With Phone
Sharon Smith
Download
35
How to Randomly Select a Winner for a Prize Giveaway Using Excel
Sharon Smith
Download
36
How to Select Multiple Random Winners for a Prize Giveaway
Sharon Smith
Download
37
Calculate Employee Years of Service & Forecast Service Anniversary in Excel
Sharon Smith
Download
38
How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example
Sharon Smith
Download
39
Simplifying Pivot Tables with Timelines and Slicers - Data Visualization Made Easy
Sharon Smith
Download
40
How to Insert a Dynamic Pivot Chart in PowerPoint - Excel to PowerPoint Integration
Sharon Smith
Download
41
How to Analyze Data Quickly in Excel - Using Excel's Built-in AI Features
Sharon Smith
Download
42
Create Date Countdown in Excel - Countdown Timer of Days Remaining
Sharon Smith
Download
43
How to Create Sheet Tabs from a List - Then Make a Table of Contents with Links
Sharon Smith
Download
44
Add Shortcuts to Ribbon in Excel - Speed Up your Excel Workflow using the Quick Access Toolbar
Sharon Smith
Download
45
How to Create a Progress Circle Chart in Excel - Dynamically Display Percentage of Completion
Sharon Smith
Download