Excel Tutorials
150 videos • 8,008 views • by Career Solutions
1
Excel Tips - SUM and AutoSum
Career Solutions
Download
2
Excel Tips - UPPER, LOWER, and PROPER Functions
Career Solutions
Download
3
Excel Tips - Make Filtering Easy with Slicer Buttons
Career Solutions
Download
4
Excel Tips - Don't Use Formulas! Use Ctrl + E Instead
Career Solutions
Download
5
Excel Tips - Import Website Data
Career Solutions
Download
6
Excel Tips - Freeze Columns and Rows / Freeze Panes
Career Solutions
Download
7
Excel Tips - Best Way to Create Dropdowns that Dynamically Update
Career Solutions
Download
8
Excel Tips - TRIM Function - Removes Unwanted Extra Spaces / Fixes Common Formula Error
Career Solutions
Download
9
Excel Tips - Quick Answers with the Status Bar and Customization
Career Solutions
Download
10
Excel Tips - Create Dynamic Row Sequences that Automatically Update
Career Solutions
Download
11
Excel Tips - TRANSPOSE Function - Switch or Rotate Columns and Rows
Career Solutions
Download
12
Excel Tips - Multiple Dependent or Cascading Dropdowns (Simple Method)
Career Solutions
Download
13
Excel Tips - IFERROR and Nested IFERROR to Help Clean Up Your Data
Career Solutions
Download
14
Excel Tips - 25 of the Best Keyboard Shortcuts for Excel
Career Solutions
Download
15
Excel Tips - FILTER Function Basics and Multiple Criteria with Column Select
Career Solutions
Download
16
Excel Tips - Creating and Designing Pivot Tables
Career Solutions
Download
17
Excel Tips - SUMIFS Function | Add with Multiple Variables | Dropdowns
Career Solutions
Download
18
Excel Tips - Using the Format Painter to Clean Up Data
Career Solutions
Download
19
Excel Tips - VLOOKUP Tutorial | Limitations | Multiple Spreadsheet Example
Career Solutions
Download
20
Excel Tips - VLOOKUP Function with Multiple Columns | Multiple Values
Career Solutions
Download
21
Excel Tips - Combine Data in Columns without Losing Data | Multiple Examples Included
Career Solutions
Download
22
Excel Tips - Count Cells with Text | Count Cells with Text Excluding Empty Strings
Career Solutions
Download
23
Excel Tips - COUNTIF and COUNTIFS Explained | Basic and Advanced Examples
Career Solutions
Download
24
Excel Tips - Create Email Hyperlinks that Dynamically Include Recipient, CC Line, Subject and Body
Career Solutions
Download
25
Excel Tips - Text to Columns | Split Up Data Strings from One Column into Multiple Columns
Career Solutions
Download
26
Excel Tips - Import Data from Pictures into Excel
Career Solutions
Download
27
Excel Tips - Find and Replace Explained with Various Examples | Replace Data, Wildcard and Formats
Career Solutions
Download
28
Excel Tips - Combine Emails | Create Group Email Hyperlink
Career Solutions
Download
29
Excel Tips - Move or Copy Spreadsheet Tabs | Existing Workbook or Separate Workbook
Career Solutions
Download
30
Excel Tips - Create Checkboxes to Format Cells and Insert Current Date and Time
Career Solutions
Download
31
Excel Tips - Create Searchable Dropdown Lists | No VBA or Formulas Required | Latest Excel Versions
Career Solutions
Download
32
Excel Tips - How to Protect Your Worksheet | How to Protect Certain Cells
Career Solutions
Download
33
Excel Tips - Add or Remove Columns and Rows | Helpful Tips and Tricks Included
Career Solutions
Download
34
Excel Tips - XLOOKUP Basics | Returning an Array of Data
Career Solutions
Download
35
Excel Tips - XLOOKUP and Nested XLOOKUP Explained
Career Solutions
Download
36
Excel Tips - Creating Heat Maps
Career Solutions
Download
37
Excel Tips - Repeat Actions Shortcuts
Career Solutions
Download
38
Excel Tips - Dynamically Updating Circle Charts | Progress Charts
Career Solutions
Download
39
Excel Tips - Insert Pictures into Cells | The Best Way
Career Solutions
Download
40
Excel Tips - Delete Blank Rows | The Best Way
Career Solutions
Download
41
Excel Tips - Basic Math Functions | Add | Subtract | Multiply | Divide | Bonus Tips Included
Career Solutions
Download
42
Excel Tips - Flash Fill | The Best Excel Feature | Use Instead of Formulas
Career Solutions
Download
43
Excel Tips - Waffle Chart Basics
Career Solutions
Download
44
Excel Tips - Track Any Changes Made to Your Workbook | No VBA
Career Solutions
Download
45
Excel Tips - Hide or Remove All Unused Rows and Columns in Excel
Career Solutions
Download
46
Excel Tips - Autofit Column Width to Cell Contents
Career Solutions
Download
47
Excel Tips - Split Columns into Tables | Lists
Career Solutions
Download
48
Excel Tips - Autofit Row Height to Cell Contents | Auto Text Wrap | Easy Method
Career Solutions
Download
49
Excel Tips - Text Search Box | Dynamic Filtering | One or Multiple Columns
Career Solutions
Download
50
Excel Tips - Remove Formulas AND Keep Your Data
Career Solutions
Download
51
Excel Tips - Split Cells Diagonally
Career Solutions
Download
52
Excel Tips - Move Rows and Columns
Career Solutions
Download
53
Excel Tips - ROUNDUP Function | How to Round Up in Excel
Career Solutions
Download
54
Excel Tips - How to Insert QR Codes | Free
Career Solutions
Download
55
Excel Tips - Adding Trendlines | One or Multiple Chart Elements | Selecting a Specific Series
Career Solutions
Download
56
Excel Tips - Calculating Age from Date of Birth | DATEDIF Function
Career Solutions
Download
57
Excel Tips - Calculating Months, Years, or Days Remaining on a Loan | DATEDIF Function
Career Solutions
Download
58
Excel Tips - Adding a Target Line to Your Charts
Career Solutions
Download
59
Excel Tips - Quick Formatting Tips | Keyboard Shortcut
Career Solutions
Download
60
Calculating Percent Change Formula | Excel Example Included
Career Solutions
Download
61
Excel Tips - Creating and Understanding Pareto Charts | 80/20 Rule
Career Solutions
Download
62
Excel Tips - Generate Barcodes | Free | Link to Barcode Font Included
Career Solutions
Download
63
Excel Tips - TOCOL Function | Combine Multiple Columns | Nested Functions
Career Solutions
Download
64
Excel Tips - VSTACK Function | Combine Data | One or Multiple Tabs or Worksheets
Career Solutions
Download
65
How to Link Excel to PowerPoint | Tables and Charts
Career Solutions
Download
66
Excel Tips - NETWORKDAYS Function | Calculate Working Days Between Two Dates
Career Solutions
Download
67
Excel Tips - Tips for Entering Dates and Times | Auto-Updating Functions and Static Options
Career Solutions
Download
68
Excel Tips - Add Multiple Text Lines Within Cells | Enter Key in Cells | Bullet Points
Career Solutions
Download
69
Excel Tips - Create Random Groups Using WRAPROWS | Excel 365 | Excel for Web
Career Solutions
Download
70
Excel Tips - Split Data Into Different Columns | Split Names
Career Solutions
Download
71
Excel Tips - Adding an Average Line to Charts
Career Solutions
Download
72
Excel Tips - Slicer Button Formatting | Color | Size | Number of Columns
Career Solutions
Download
73
Excel Tips - SUM and AutoSum Tips for Addition | Keyboard Shortcuts
Career Solutions
Download
74
Excel Tips - Early Access to New Features | 365 Insider Program
Career Solutions
Download
75
Excel Tips - New Checkbox Feature | Formatting Cells | Add Current Date and Time
Career Solutions
Download
76
Excel Tips - FILTER Function Using Cell Range Instead of Multiple OR Statements
Career Solutions
Download
77
Excel Tips - Count Number of Times Text Appears | COUNTIF Function | Count Times Name Appears
Career Solutions
Download
78
Excel Tips - Reveal Formulas in Your Workbook
Career Solutions
Download
79
Excel Tips - Compare Columns to Find Matches | Exact Matches | Any Match in Other Column
Career Solutions
Download
80
Excel Tips - Find and Remove Duplicate Values | UNIQUE Function
Career Solutions
Download
81
Excel Tips - Creating Pivot Tables
Career Solutions
Download
82
Excel Tips - Best Way to Create Dynamic Dropdown Lists | No Spaces | Alphabetized | Excel 365
Career Solutions
Download
83
Excel Tips - Highlight Dates Coming Soon or Past Due | Project Due Dates
Career Solutions
Download
84
Excel Tips - Randomize Your Data | RAND Function | Easy
Career Solutions
Download
85
Excel Tips - Pull In Data From Another Report
Career Solutions
Download
86
Excel Tips - Apply Conditional Formatting When You Select a Checkbox
Career Solutions
Download
87
Excel Tips - Sorting Data in Excel | Sorting by Multiple Columns
Career Solutions
Download
88
Excel Tips - Best Way to Create Row Numbers | Include Text
Career Solutions
Download
89
Excel Tips - Freeze Columns and Rows | Freeze Panes
Career Solutions
Download
90
How to Convert PDF to Excel | Excel 365
Career Solutions
Download
91
Excel Tips - Automatically Highlight Active Row | Based on Cell Selection
Career Solutions
Download
92
Excel Tips - Automatically Highlight Active Row and Column | Based on Cell Selection
Career Solutions
Download
93
Excel Tips - Combine Multiple Tabs or Worksheets into One | Power Query
Career Solutions
Download
94
Excel Tips - Format Entire Row Based on Cell Criteria
Career Solutions
Download
95
Excel Tips - Find and Fill All Blank Cells
Career Solutions
Download
96
Excel Tips - Use Timeline Filters to Make Date Filtering Simple
Career Solutions
Download
97
Excel Tips - IF Function with Nested VLOOKUP
Career Solutions
Download
98
Excel Tips - Building Interactive Dashboards
Career Solutions
Download
99
Excel Tips - Progress Bars That Dynamically Update | Easy
Career Solutions
Download
100
Excel Tips - Find and Unhide All Rows and Columns
Career Solutions
Download
101
Excel Tips - Unhide Columns | Ctrl + Shift + 0 Not Working | Windows 11
Career Solutions
Download
102
Excel Tips - Remove Blank Rows | 3 Methods Included
Career Solutions
Download
103
Excel Tips - IF Function Explained | Multiple Examples | AND/OR Statements | Nested IF Function
Career Solutions
Download
104
Excel Tips - Calculating Time Difference | Hours Worked
Career Solutions
Download
105
Excel Tips - Creating a Pie Chart in Excel | Formatting Tips and Tricks
Career Solutions
Download
106
Excel Tips - Restore Previous Save Files or Versions | Microsoft Applications
Career Solutions
Download
107
Excel Tips - Combine First and Last Names | Two Methods Shared
Career Solutions
Download
108
Excel Tips - 10 Important Functions and Formulas
Career Solutions
Download
109
Excel Tips - INDEX And MATCH Functions | Simple and Complex Examples
Career Solutions
Download
110
Excel Tips - Text Search Box | Dynamic Filtering | One or Multiple Columns
Career Solutions
Download
111
Excel Tips - Autofit Row Height to Cell Contents | Auto Text Wrap | Apply to Specified Range Example
Career Solutions
Download
112
Excel Tips - Create Email Hyperlinks that Dynamically Include Recipient, CC Line, Subject and Body
Career Solutions
Download
113
Excel Tips - Create Unlimited Folders Quickly | Choose Folder Names
Career Solutions
Download
114
Excel Tips - Calculating Percent of Total | Quick Analysis Shortcut
Career Solutions
Download
115
Excel Tips - Calculating Average | 3 Easy Methods
Career Solutions
Download
116
Excel Tips - Display Image When Hovering Over A Cell
Career Solutions
Download
117
Excel Tips - TEXTSPLIT Function to Separate Strings with Multiple Delimiters into Columns and Rows
Career Solutions
Download
118
Excel Tips - Autofit Column Width | Apply to Specified Range Example
Career Solutions
Download
119
Excel Tips - Filling in Dates | Different Fill Types
Career Solutions
Download
120
Excel Tips - For Autofitting Columns and Rows | Multiple Methods
Career Solutions
Download
121
Excel Tips - SUBTOTAL Function Details and How it Can Help
Career Solutions
Download
122
Excel Tips - Create Custom Tabs and Groups
Career Solutions
Download
123
Excel Tips – Search Box with Conditional Formatting
Career Solutions
Download
124
Excel Tips - Date Sorting | Multiple Methods Included
Career Solutions
Download
125
Excel Tips - Create Calendars | No Formulas Needed
Career Solutions
Download
126
Excel Tips - Fast Chart Options | Quick Analysis Tool
Career Solutions
Download
127
Excel Tips - Removes Extra Spaces | TRIM Function
Career Solutions
Download
128
Excel Tips - FILTER Function Basics and Multiple Criteria with Column Select
Career Solutions
Download
129
Excel Tips - Find and Remove Duplicate Data and Utilize the UNIQUE Function for Unique Lists
Career Solutions
Download
130
Excel Tips - Inserts Watermarks into Your Spreadsheet
Career Solutions
Download
131
Excel Tips - Create Group Email Link
Career Solutions
Download
132
Excel Tips - Track Any Changes Made to Your Workbook | No VBA
Career Solutions
Download
133
Excel Tips - 5 Ways to Clean Your Spreadsheets
Career Solutions
Download
134
Excel Tips - Combine Workbooks | Easy Method
Career Solutions
Download
135
Excel Tips - Compare Columns | Match and Exact Match
Career Solutions
Download
136
Excel Tips - Move Formulas Without Changing Cell References
Career Solutions
Download
137
Excel Tips - Removing Multiple Filters | Pro Tip
Career Solutions
Download
138
Excel Tips - Inserting Clickable Documents
Career Solutions
Download
139
Excel Tips - Dynamic Row Sequences | Basic and Advanced
Career Solutions
Download
140
Excel Tips - Get Data from Photo or Image
Career Solutions
Download
141
Excel Tips - Create Dynamic Calendars
Career Solutions
Download
142
Excel Tips - Split Cells
Career Solutions
Download
143
Excel Tips Custom Date Filter Dropdowns Using FILTER Function
Career Solutions
Download
144
Excel Tips - Compare Tabs Side by Side from Same Workbook
Career Solutions
Download
145
Excel Tips XLOOKUP Multiple Criteria
Career Solutions
Download
146
[Private video]
Download
147
Excel Tips - Addition with SUM and AUTOSUM
Career Solutions
Download
148
Excel Tips - Separate Data Text in a Single Cell
Career Solutions
Download
149
Excel Tips - Separate Data In Rows Into Columns
Career Solutions
Download
150
Excel Tips - Cleaning Data Quickly | Shortcuts Included
Career Solutions
Download