Excel Skills that Save Hours, Not Just Minutes
These are some of the most unique and helpful (free) courses with a certificate to learn Microsoft Excel. Not only that, but these courses will also help you get smarter than your colleagues.
EXCEL BLOG / INTRODUCTION TO EXCEL / EXCEL FORMULAS LIST / GETTING STARTED WITH VBA / HOW TO USE POWER BI / HOW TO USE GOOGLE SHEETS / EXCEL KEYBOARD SHORTCUTS
Latest Tutorial: Extract Data for Last N Days (Latest Days) using Power Query
- Insert a Timestamp in Excel
- Check Mark Symbol in Excel
- Benefits of Microsoft Excel
- Quick Access Toolbar
- Formula Bar in Excel
- Add Barcode in Excel
- Insert Checkbox in Excel
- Dynamic Drop-Down List in Excel
- Quick Analysis Tool in Excel
- Clear Cache in Excel
- COUNTIF OR
- Time Difference in Excel
- Get Quarter from Date Formula
- Excel Concatenate with Line Break
- Count Between Two Numbers
- COUNT IF GREATER THAN 0
- Useful Excel Macro Examples
- VBA MsgBox
- VBA IF
- VBA User Defined Function
- Personal Macro Workbook
- Data Source for Pivot Table
- Refresh a Pivot Table
- Grand Total in a Pivot Table
- Filter a Pivot Table in Excel
- Delete a Pivot Table in Excel
- Merge Cells
- AutoSum
- Apply Filter
- Print Preview
- Add New Sheet
- Sales Report in Excel
- Inventory Management Template
- Merge [Combine] Multiple Excel Files
- Add Watermark in Excel
- Add Page Number in Excel
- Excel Accounting Number Format
- Background Color to a Cell
- Make Paragraph in a Cell in Excel
- Print Titles in Excel
- Apply Multiple Filters to Columns
- Print a Graph Paper in Excel
- Filter by Color in Excel
- Rename a Table in Excel
- Add Years to Date in Excel
- Count Years Between Dates in Excel
- Count Blank Cells in Excel
- Count Cells that are Not Blank
- Percentage Variance in Excel
- Record a Macro in Excel
- VBA Option Explicit
- Run a Macro in Excel
- VBA Immediate Window
- VBA With
- Create Pivot Chart in Excel
- Move a Pivot Table
- Count Unique Values in a Pivot Table
- Pivot Table Formatting
- Sort a Pivot Table in Excel
- Add Row(s)
- Auto Fit
- Delete Row(s)
- Save As
- Show Formulas
- Concatenate a Range of Cells
- EXCEL SKILLS
- Excel Tips and Tricks
- Write (Type) Vertically in Excel
- Add Border in Excel
- Freeze Panes in Excel
- Quickly Swap Two Cells in Excel
- Change Border Color in Excel
- Find Merged Cells in Excel
- Grey Out Cells in Excel
- Remove Dashes in Excel
- Use AutoCorrect in Excel
- Lock Cells in Excel
- Sum Only Visible Cells in Excel
- Count Unique Values in Excel
- Check IF Zero Then Blank in Excel
- Months Between Two Dates in Excel
- Compare Two Cells in Excel
- VBA Variables
- VBA Combine Workbooks
- VBA Sort Range
- VBA Wait and Sleep
- VBA Dim Statement
- Refresh All Pivot Tables
- Automatically Update a Pivot Table
- Group Dates in a Pivot Table
- Add Running Total in a Pivot Table
- Ranks in Pivot Table in Excel
- Subscript
- Superscript
- Undo and Redo
- Check Mark
- Copy and Paste
- Describe Your Excel Skills in Your CV
- Types of Charts in Excel
- Make First Row Header in Excel
- Save an Excel File on Mac
- Scroll Lock ON-OFF
- Merge Cells in Excel
- Add Serial Numbers in Excel
- Create a Custom List in Excel
- Find a Name Range in Excel
- Make Read Only in Excel
- Turn OFF the AutoSave
- Merge Cells without Losing Data
- Sum Values Based on Year
- IF a Cell Value Starts With
- XLOOKUP Return All Matches
- XLOOKUP with Multiple Criteria
- Wildcard Characters in Excel
- Top VBA Functions
- VBA ERROR Handling
- VBA Constants
- VBA Interview Questions
- Excel Macro-Enabled Workbook
- Formulas in a Pivot Table
- Pivot Table Keyboard Shortcuts
- Pivot Table using Multiple Files
- Pivot Table Timeline
- Single Slicer with Multiple Pivot
- Cut and Paste
- Edit Cell
- Format Painter
- Freeze Pane
- Paste Values
- Conditional Formatting in Excel
- Excel Functions