Power Spreadsheets is about Microsoft Excel and covers a variety of topics.
This archive lists most of the blog posts published in Power Spreadsheets until today.
Table of Contents
Tips & Tricks
- 350 + Excel Keyboard Shortcuts And Hotkeys: Free PDF Cheat Sheet.
- Excel Keyboard Shortcuts: How To Quickly Get Or Create Any Keyboard Shortcut You Need.
- Convert PDF To Excel: 3 Easy Methods You Can Use Right Now.
Formulas and Functions
Text
- Excel LEFT, RIGHT, MID, LEN, FIND And SEARCH Functions: Learn How To Use Them With A 9-Step Example.
Concatenate
- Excel Concatenate Strings: Click here to open.
- Excel Concatenate Number and String: Click here to open.
- Excel Concatenate Date: Click here to open.
- Excel Concatenate with Space: Click here to open.
- Excel Concatenate New Line: Click here to open.
- Excel Concatenate Double Quote: Click here to open.
- Excel Concatenate Multiple Cells with Comma: Click here to open.
Lookup and Reference
Excel VLookup
- Excel VLOOKUP Compare 2 Columns and Find Matches in 4 Easy Steps: Click here to open.
- Excel VLookup Sum Multiple Row Values (in Same Column) in 4 Easy Steps: Click here to open.
- Excel VLOOKUP Multiple Columns in 5 Easy Steps: Click here to open.
- Excel VLOOKUP Sum Multiple Columns (Values) in 6 Easy Steps: Click here to open.
- Excel VLookup Sum Multiple Column Values (with XLOOKUP) in 4 Easy Steps: Click here to open.
- Excel VLookup Sum Multiple Rows and Columns in 3 Easy Steps: Click here to open.
- Excel VLookup Multiple Criteria with INDEX MATCH in 4 Easy Steps.
- Excel VLookup Multiple Criteria with the FILTER Function in 2 Easy Steps.
- Excel VLookup Return Multiple Values with the FILTER Function in 2 Easy Steps: Click here to open.
- Excel VLookup Return Multiple Values in One Cell Separated by a Comma in 4 Easy Steps: Click here to open.
- Excel VLOOKUP Multiple Sheets in 10 Easy Steps: Click here to open.
- Excel VLOOKUP Sheet in Multiple Different Workbooks in 10 Easy Steps: Click here to open.
Excel XLookup
- Excel XLOOKUP Tutorial: Click here to open.
- Excel XLOOKUP in Table: Click here to open.
- Excel Nested XLOOKUP (Dynamic Lookup Value): Click here to open.
- Excel XLOOKUP If Not Found Return Blank: Click here to open.
- Excel IF XLOOKUP (for Error Handling): Click here to open.
- Excel XLOOKUP If Blank Return Blank: Click here to open.
- Excel XLOOKUP Wildcard: Click here to open.
- Excel XLOOKUP Between 2 Values: Click here to open.
- Excel XLookup Return All Matches: Click here to open.
Excel Measurement System Conversion
- Excel Convert Cm to Inches: Click here to open.
- Excel Convert Celsius to Fahrenheit: Click here to open.
Pivot Tables
Power Query
- Excel Power Query (Get & Transform) Tutorial for Beginners: Import, Edit, Load and Consolidate Data with this Step-By-Step Guide.
- Excel Power Query from Workbook (Single Data Source): Click here to open.
Data Analysis
VBA & Macros
Basic Setup + General VBA Constructs And Structures
- Excel Macro Tutorial for Beginners: Create Macros In 7 Easy Steps.
- Excel VBA Tutorial For Beginners: 16 Essential Terms You Must Know To Learn VBA Programming.
- How To Enable Macros In Excel: Step-By-Step Guide To Dealing With 3 Common Scenarios.
- The Excel Visual Basic (VBA) Editor: The Complete And Easy Guide To The VBE.
- Excel VBA Sub Procedures: The Complete Tutorial.
- Excel VBA Function Procedures: Easily Create And Execute User-Defined Functions (UDFs).
- Excel VBA Object Model And Object References: The Essential Guide.
- Excel VBA Sheets and Worksheets: Step-by-Step Guide and 16 Examples to Refer to Sheets or Worksheets in Macros.
- Excel VBA Range Object: 18 Useful Ways Of Referring To Cell Ranges.
- Excel VBA Object Properties: How To Work With, And Get, Available Properties.
- VBA Methods: The Complete Guide To Working With Methods In Excel.
- Define Variables In VBA: How To Declare Variables And Assign Them Expressions.
- Excel VBA Data Types: The Complete Guide To 15 Important Data Types.
- Excel VBA Events: Tutorial And List With 115 Application, Workbook, Worksheet And Chart Events.
- R1C1-Style Notation And The FormulaR1C1 Property In Excel VBA: Tutorial And Examples.
- VBA Worksheet Functions: 5 Ways To Easily Use Excel Functions In VBA.
- VBA Loops Explained: Complete Tutorial On 6 Essential Excel VBA Loops.
- Excel VBA Array: The Complete Tutorial for Beginners.
Excel VBA Select Case
- Excel VBA Select Case Tutorial: Click here to open.
- Excel VBA Select Case Or: Click here to open.
- Excel VBA Select Case And Operator: Click here to open.
- Excel VBA Select Case Multiple Test Expressions: Click here to open.
- Excel VBA Select Case Like Wildcard: Click here to open.
- Excel VBA Select Case Inside For… Next Loop: Click here to open.
- Excel VBA Select Case Range of Cells: Click here to open.
Practical VBA Applications And Macro Examples
- Excel VBA Activate Workbook: Step-by-Step Examples to Activate Workbooks with Macros.
- Excel VBA Create New Workbook: 16 Easy-To-Follow Macro Examples.
- Excel VBA Open Workbook: Easily Open Excel Files In VBA With These 2 Methods And Macros.
- Excel VBA Save Workbook: Easily Save Excel Files With These 3 Macro Examples.
- Excel VBA Close Workbook: 8 Ready-To-Use Macro Code Examples To Close Workbooks.
- Excel VBA Delete Sheet: Step-by-Step Guide and 6 Examples to Delete Sheets with Macros.
- Excel VBA Print: 2 Macro Code Examples To Quickly Setup, Print Or Print Preview Your Work.
- Excel VBA Save As PDF: Step-By-Step Guide And 10 Code Examples To Export Excel To PDF.
- Excel VBA Last Row and Last Column: Step-by-Step Guide and 20 Examples to Find the Last Row or Column with Macros.
- Excel VBA Value and Value2: Step-by-Step Guide and 8 Examples to Set or Get a Cell’s or Cell Range’s Value with Macros.
- Excel VBA Copy Paste: The Complete Tutorial For Copying And Pasting Cells With Macros (And 8 Examples).
- Excel VBA Clear Cell: Step-by-Step Guide and 5 Examples to Clear Cells with Macros.
- Excel VBA Create Named Range: Step-by-Step Guide and 4 Examples to Defined Named Ranges with Macros.
- Excel VBA Merge Cells: Step-by-Step Guide and 6 Code Examples to Merge or Unmerge Cells with Macros.
- Excel VBA Column Width: Step-by-Step Guide and 8 Code Examples to Set or AutoFit the Column Width with Macros.
- Excel VBA Insert Row: Step-by-Step Guide and 9 Code Examples to Insert Rows with Macros.
- Excel VBA Hide Or Unhide Columns And Rows: 16 Macro Code Examples You Can Use Right Now.
- Excel VBA Delete Column: 8 Easy-To-Use Macro Code Examples To Delete Columns Subject To Different Criteria.
- Excel VBA Check if Cell is Empty: Step-by-Step Guide and 4 Examples to Check if Cell Range is Empty with Macros.
- Excel VBA Delete Row: Step-by-Step Guide and 12 Code Examples to Delete Rows with Macros.
- Excel VBA Delete Blank Or Empty Rows: 5 Easy-To-Use Macro Examples.
- How To Convert PDF To Excel Using VBA: Tutorial + 4 Code Examples.
- Excel VBA Font: Step-by-Step Guide and 15 Examples to Change or Set a Cell Range’s Font Characteristics with Macros.
- Excel VBA Date Format: 25 Macro Examples To Easily Set Date Formats.
- Excel VBA AutoFilter: 19 Step-by-Step Examples to Filter Data with Macros.
- Excel VBA Find: 20 Step by Step Examples to Search and Find with Macros.
- Excel VBA VLookup: Step-by-Step Guide and 5 Code Examples to Use the VLookup Function in Macros.
- Excel VBA Replace or Substitute: Step-by-Step Guide and 7 Examples to Replace Characters or Strings with Macros.
- Excel VBA Convert String to Number: Step-by-Step Guide and 7 Examples to Convert String to Byte, Integer, Long, Single, Double, Currency or Decimal.
- Excel VBA Create Bar Chart: Step-by-Step Guide and 4 Examples to Create Clustered or Stacked Bar Charts with Macros.
- Excel VBA Create Pivot Table: Step-by-Step Guide and 4 Examples to Create Pivot Tables with Macros.
- Excel VBA MsgBox: Step-by-Step Guide and 19 Examples to Create a Message Box with Macros.
- Excel VBA InputBox: Step-by-Step Guide and 9 Examples to Create an Input Box with Macros.
- Create Excel UserForms For Data Entry In 6 Easy Steps: Tutorial And Practical Example.
- Custom Excel Ribbon In 7 Easy Steps: The Introductory Tutorial.
Excel VBA Font Color
- Excel VBA Font Color HEX in 5 Easy Steps.
- Excel VBA Change Font Color Based on Cell Value in 4 Easy Steps: Click here to open.
- Excel VBA Change Font Color for Part of Text in 8 Easy Steps.
- Excel VBA Text Box Font Color in 2 Easy Steps.
- Excel VBA UserForm Text Box Font Color in 2 Easy Steps: Click here to open.
- Excel VBA Chart Data Label Font Color in 4 Easy Steps: Click here to open.
- Excel VBA UserForm Label Font Color in 2 Easy Steps: Click here to open.
Excel VBA Protect or Unprotect Sheet
- Excel VBA Protect Sheet Without Password in 2 Easy Steps: Click here to open.
- Excel VBA Unprotect Sheet Without Password in 2 Easy Steps: Click here to open.
- Excel VBA Protect Sheet with Password in 2 Easy Steps: Click here to open.
- Excel VBA Protect Sheet Allow Filter in 2 Easy Steps: Click here to open.
- Excel VBA Protect Sheet Allow Select Locked Cells in 4 Easy Steps: Click here to open.
Excel VBA Tables
- Excel VBA Create Table from Cell Range: Click here to open.
Python
- Python pandas Read Excel Worksheet: Click here to open.
Resources
- 500+ Excel Resources: The Epic Power Spreadsheets Resources List.
- VBA Code Generator and Coding Tools.
Do you want more Excel tutorials and resources?
Enter your email address below to receive FREE updates about new tutorials that will help you improve your Excel skills.