24 тысяч подписчиков
178 видео
Excel Error Fixing: How to Resolve
Excel error pop ups opening file: find broken links and fix!
Mastering custom formatting: Introduction to formatting positive, negative or zero numbers and text
Naming data in excel and how to use in formulas and lists (a beginners guide to named ranges)
Swap values in cells with excel REPLACE function
FORMULAS and OPERATORS: Learn the basics of Excel formulas and functions (Beginners tutorial)
How to enable the Developer tab, for macros, checkboxes, add-ins and more
How to Fix "Cannot Group Selection" Error in Pivot Table (Excel tutorial)
Excel shortcut keys: excel quick formatting shortcut
Use Power Query conditional column to filter by multiple columns and criteria
Beginners guide to Relative, Absolute and Mixed Cell References in Excel (and the shortcut)
PIVOT TABLE calculations: Add calculated field (Part 1: add calculated rows or columns)
Excel for beginners: LARGE and SMALL functions - finding and sorting values by position
Excel for beginners: WORKDAY function - how to find next workday or whether a date is a workday
Excel: Randomly generate names from a list using RANDARRAY and INDEX.
Time-saving Excel Table shortcuts: Add, format, select and manipulate rows and columns
How to Generate Random Numbers in MS Excel (RAND, RANDBETWEEN and RANDARRAY)
Beginners guide to Pivot Tables: learn the basics and overcome common issues (+follow along file)
Functions to join text together: CONCAT and TEXTJOIN (Excel tutorial for beginners)
Excel for Beginners: RESIZING rows and columns - viewing your data in excel
Dynamic array functions: excel filter function, the basics (Advanced filter with multiple criteria)
Excel date picker: insert an excel date picker calendar in a cell
EOMONTH function: Finding the last day of the month in excel
Excel shortcut keys: excel number formatting
Excel shortcut keys: Add the same data into multiple cells with one easy shortcut
TEXTJOIN function: How to Display Split Array Data in One Cell | Excel Tutorial
Dynamic Arrays: Sequence function to generate a sequence in excel (excel 2019 onward)
Extract last names into a single column using TEXTAFTER
Quick Tip: How to Add a Custom Tab in Excel for Enhanced User Experience | Boost Your Productivity!
Cell FORMATTING: Learn how to add borders, colours and patterns in 4 minutes (Excel for beginners)
Quickly inputting date and time into your Excel spreadsheet
Excel for beginners: Combining the FIND and MID functions - basic tutorial
Google Sheets Date Picker: The Best Excel Alternative for a Drop-Down Calendar
How to Pre-Select Cells in Excel to Enter Data Quickly (Productivity Hack)
How to Insert Images in Excel Cells Using the IMAGE Function
Spill ranges in Excel: using # to spill formulas in dynamic arrays (Office 365)
Extract unique values from a list in excel with the UNIQUE function
Excel shortcut keys: F4 excel shortcut (and its two uses) in less than 60 seconds
Split data in power query: split data from rows to columns using power query
Excel for beginners: Changing sentence case in Excel using UPPER, LOWER and PROPER functions
Advanced drop down lists with dynamic array formulas UNIQUE & FILTER (Excel 365 beginners tutorial)
Excel for Beginners: COPY and PASTE - the basics of using the clipboard in Mircosoft excel
Issues with PIVOT TABLES - fixing common errors in 6 minutes (Microsoft Excel for beginners)
PIVOT TABLE calculations: Remove calculated field (Part 2: remove calculated rows or columns)
Mastering Excel's TEXTSPLIT function: Separating data into columns & rows, with optional parameters
FILTER function. How to use it with multiple criteria - dynamic lookup
Excel date picker: insert an excel date picker calendar into a workbook (excel 64 bit version)
Sparklines in excel: What are SPARKLINES and how do I use them?
How to Save Time in Word with a cut and paste trick!
Excel Image to Text: Extract Data from Images into Tables [Beginner's Tutorial]
