Excel Basics playlist includes Excel tutorials for those who're new to Excel and also for anyone who's used Excel for a while but has missed out on some of these techniques. The playlist includes, IF, VLOOKUP, changing the Default Excel theme and some formula tricks.
Aulas do Curso
(37 vídeos)
0 de 37 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
Excel Tutorial for Beginners | How to Use Excel
Excel tutorial for beginners: learn how to use Excel step by step, from cells and ranges to entering and formatting data…
1
Excel Cell Reference: Absolute, Relative or Mixed?
I'll show you when to use absolute, relative and mixed references, and how F4 locks a cell.
?? Download the practice wor…
2
Excel Cell Modes Explained: Ready, Enter, Point, Edit
Ever tried to edit a formula in Conditional Formatting or Data Validation, pressed an arrow key, and Excel added a cell …
3
How to Filter Data in Excel (Beginner’s Guide)
Filter data in Excel: shortcuts, wildcards, date filters and totals that follow the filter.
?? Download the practice wor…
4
Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)
Excel Advanced Filter: AND, OR, between and wildcard criteria, plus unique records.
?? Download the practice workbook: h…
5
Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
Sort data in Excel by value, custom list, cell color and icon, then unsort it.
?? Download the practice file: https://ww…
6
Create SMART Drop Down Lists in Excel (with Data Validation)
Data validation in Excel: drop-down lists that update automatically, plus rules for future dates, number ranges and text…
7
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
Use custom data validation formulas in Excel to allow only valid codes like C2345 or PT4534.
?? Read the full guide with…
8
How to Change a Theme and Make it the Default in Excel
Join 400,000+ professionals in our courses here ?? https://link.xelplus.com/yt-d-all-courses
Learn how to set a custom …
9
Excel Header & Footer (& Quickly Copy to other Sheets)
Add a logo, page numbers and file name to Excel headers and footers, then copy them to all sheets.
?? Get one practical …
10
How to Add Notes in Excel | Shortcut Keys, Customize Background & More
?? Join 500,000+ professionals in our courses here ?? https://link.xelplus.com/yt-d-all-courses
Ideal for anyone seeking…
11
Calculate Percentage in Excel the Right Way | Percentage Difference Formula
Calculate percentage change, increase and decrease in Excel with formulas you'll remember.
?? Download the workbook: htt…
12
Find or Replace Text and Numbers in Excel (surprising features)
Excel Find & Replace does more than text: search all sheets, notes and formats, and swap colors.
?? Download the practic…
13
Easily Change CASE of Text in Excel (3 ways including NO Formulas)
Here are 3 ways I change text case in Excel: formulas, Flash Fill, and fonts that are always in caps.
?? Download my pra…
14
Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!
Lock cells and protect an Excel sheet, and unlock all input cells by color without VBA.
?? Download the practice workboo…
15
Stop Your Excel Printing Nightmares! Fix Margins, Scaling & Fit to Page
Print Excel reports that fit the page, with the right margins, scaling, print areas and page breaks.
?? Free Excel print…
16
Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)
Join 400,000+ professionals in our courses here ?? https://link.xelplus.com/yt-d-all-courses
Struggling with Excel prin…
17
Don’t Use VLOOKUP Until You Watch This! (VLOOKUP vs HLOOKUP Explained)
VLOOKUP vs HLOOKUP explained: how to look up values in a table, when to use each one, and why FALSE is the safer last ar…
18
Excel Formulas and Functions You NEED to KNOW!
Excel formulas and functions for beginners. Learn SUM, AVERAGE, COUNT, COUNTA, MIN, MAX and AVERAGEIFS, plus a trick tha…
19
How to ACE Excel Interview Questions (Based on YOUR feedback & by Position)
Join 400,000+ professionals in our courses here ?? https://link.xelplus.com/yt-d-all-courses
Looking for Excel intervie…
20
How to Add Text to the Beginning of Values in Excel (Includes a Hidden Trick)
Add text to the beginning or end of values in Excel with Flash Fill, a formula or a custom format.
?? Get the practice f…
21
Should You Upgrade to Office 2021? Excel Users MUST Watch...
Join 400,000+ professionals in our courses here ?? https://link.xelplus.com/yt-d-all-courses
Microsoft released Office …
22
What's on My Quick Access Toolbar in Excel? You'll Probably be Surprised!
Join 400,000+ professionals in our courses here ?? https://link.xelplus.com/yt-d-all-courses
In this video I'll share t…
23
Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE
Learn how to combine text and numbers in one Excel cell and keep the number formatting.
?? Download the free practice fi…
24
7 Excel Mistakes You Must Stop Making
7 common Excel mistakes and the better way to fix each: external links, merged cells, hidden rows, hardcoded values and …
25
Most Common Excel Errors #?? and How To Fix Them - Avoid Broken Formulas
Common Excel errors and how to fix them, without just deleting them.
?? Download the practice file: https://www.xelplus.…
26
TEXTSPLIT in Excel: The Formula Version of Text to Columns
Split text in Excel with TEXTSPLIT: multiple delimiters, rows and columns, and sorting inside a cell.
?? Get the free pr…
27
How an Excel Expert Sets Up Their Spreadsheet (6 Settings)
6 Excel settings I change on every new install, from Enter key behavior to keeping leading zeros.
?? Free cheat sheet wi…
28
How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)
Let Excel's Analyze Data build Pivot Tables, charts and insights for you. Just ask a question.
?? Download the practice …
29
How to Find Duplicates in Excel (Fastest 4 Methods)
Find duplicates in Excel 4 ways: highlight them, find duplicate rows, flag them or list them.
?? Download the practice f…
30
How to PROPERLY Convert Excel to PDF
Convert Excel to PDF with built-in features and make it look professional. No online converters.
?? Get one practical Ex…
31
Excel Time-Savers - 5 Hidden Features for Busy People
5 Excel tips and tricks that save time, from Name Box bookmarks to Power Query.
?? Free cheat sheet: the Excel shortcuts…
32
The Only VLOOKUP Guide You’ll Ever Need. (No More Errors)
VLOOKUP in Excel, step by step: exact match, other sheets, closest match and error fixes.
?? Download the practice workb…
33
Stop Deleting Excel Rows Manually. Do THIS Instead.
3 ways to delete blank rows in Excel: Go To Special, a COUNTA filter, and Power Query.
?? Download the practice file: ht…
34
Stop Doing Extra Work in Excel! (8 Hidden Features)
8 simple Excel features most beginners miss. Each one replaces a manual task with a shortcut or a few clicks.
?? Downloa…
35
Make Excel Feel Like an App (4 Secret Navigation Tricks)
Stop scrolling through big Excel files. Here are 4 ways I jump to any sheet in seconds.
?? Download the practice workboo…
36
What Actually IS a Pivot Table?
What is a Pivot Table in Excel? It's a tool that turns rows of raw data into a summary you can change with drag and drop…
