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)
Excel Pivot Table Slicers: Learn how to add pivot table slicer to filter data in excel
Excel for beginners: Combining the FIND and MID functions - basic tutorial
Conditional Formatting vs Custom Formatting: Which is Best for Inserting Icons into Your Workbook?
Excel for Beginners: SORTING and FORMATTING - the basics
Excel for beginners: Viewing your workbook in different ways to make working easier!
Using Forms in Microsoft Excel (easy data entry and searching). Easy Excel tutorial
Excel for Beginners: LINE charts - the basics
PIVOT TABLE calculations: Remove calculated field (Part 2: remove calculated rows or columns)
Create Unique & Complex Reference Numbers in Excel with Custom Formats or TEXT & LEFT Functions
Excel for beginners: Changing sentence case in Excel using UPPER, LOWER and PROPER functions
Excel for beginners: Basics of the FIND and SEARCH functions
Advanced Filtering Using Functions: Beginners’ Tutorial (DSUM, DCOUNT and other D functions)
Guide to the RIBBON in MS Excel: Where do I find commands? (Quick workbook navigation guide)
Excel for beginners: Learn the basic TIME functions, including NOW, HOUR, MINUTE, SECOND and TIME
Dynamic array functions: excel filter function, the basics (Advanced filter with multiple criteria)
Excel shortcut keys: F4 excel shortcut (and its two uses) in less than 60 seconds
Excel shortcut keys: excel number formatting
Excel for beginners: INDEX and MATCH functions to lookup data from multiple tables
Excel for beginners: Inserting pictures, illustrations and other graphics
Functions to join text together: CONCAT and TEXTJOIN (Excel tutorial for beginners)
Excel for Beginners: RESIZING rows and columns - viewing your data in excel
Excel for beginners: SUBTOTAL function - what does it do and how to use it!
How to Use the LEN Function in Excel (2-Minute Tutorial for Beginners)
Excel shortcut keys: switching between workbooks and quickly switch worksheets in excel
Group data in POWER QUERY: automatically group data in excel
Excel shortcut keys: Add the same data into multiple cells with one easy shortcut
HLOOKUP basics tutorial: all you need to know in only 3 minutes (beginners Microsoft Excel)
Excel date picker: insert an excel date picker calendar in a cell
ABSOLUTE CELL REFERENCE: learn the shortcut! (beginners excel tutorial) *MAC shortcut in description
Advanced drop down lists with dynamic array formulas UNIQUE & FILTER (Excel 365 beginners tutorial)
Quickly inputting date and time into your Excel spreadsheet
Extract last names into a single column using TEXTAFTER
