• Login
  • Courses
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • VBA Code Generator
  • Contact

Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

Excel Concatenate Strings: Formula Examples

Excel concatenate strings

These Excel concatenate strings formula examples: Help you join multiple strings. Cover solutions for both of the following groups of Excel versions: Excel versions with the CONCAT function (newer Excel versions, including Excel 365). Excel versions without the CONCAT function (older Excel versions). Excel Concatenate Strings Formula Template Excel Concatenate … [Read more...]

Excel Power Query from Workbook (Single Data Source): Example

Excel Power Query from workbook (single data source)

This Excel Power Query from workbook (single data source) example helps you: Import a single data source from a workbook with Power Query (Get & Transform); and Load the imported data to an Excel Table in a new worksheet. Excel Power Query from Workbook (Single Data Source) Process (1) Go to Ribbon > Data > Get Data > From File > From Excel … [Read more...]

Excel Concatenate Multiple Cells with Comma: Formula Examples

Excel Concatenate Multiple Cells with Comma

These Excel concatenate multiple cells with comma formula examples: Help you join the contents of multiple cells using a comma (,) as a delimiter. Cover solutions for both of the following groups of Excel versions: Excel versions with the TEXTJOIN function (Excel 2019 and later, including Excel 365). Excel versions without the TEXTJOIN function (versions before Excel … [Read more...]

Python pandas Read Excel Worksheet: Code Snippet Example

Python pandas Read Excel Worksheet

This Python pandas read Excel worksheet code snippet example helps you read an Excel worksheet to a DataFrame with Python pandas. Python pandas Read Excel Worksheet Code Snippet Template For these purposes: WorkbookPath is (in the context of this Python pandas read Excel worksheet code snippet example) a string specifying the Excel workbook where the worksheet you … [Read more...]

Excel VBA Create Table from Cell Range: VBA Code Snippet Example

Excel VBA Create Table from Cell Range

This Excel VBA create Table from cell range code snippet example helps you: Create an Excel Table; From a cell range. Excel VBA Create Table from Cell Range Code Snippet Template For these purposes: ExcelTableObjectVariable is the name of the object variable representing the newly created Excel Table. WorksheetObjectReference is a reference to the Worksheet … [Read more...]

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • …
  • 23
  • Next Page »

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA. Here are some of my most popular Excel Training Resources:

  1. Free Excel VBA Email Course
  2. Excel Macro Tutorial for Beginners
  3. Excel Power Query (Get and Transform) Tutorial for Beginners
  4. Excel Keyboard Shortcut Cheat Sheet
  5. Excel Resources
Terms and Conditions

Privacy Policy

Limit of Liability and Disclaimer of Warranty

Affiliate Disclosure

Copyright © 2015–2023 PDS Intelligence Pte. Ltd. All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.