Excel Pro Tips
How to Make Excel Table Automatically Add New Row
Learn how to make Excel tables automatically add new rows using table features, structured references, and dynamic named ranges.
Read article
Make Table
13 lessons in order
Excel Pro Tips
How to Convert a Table to a Range in Excel (5 Easy Ways)
Learn how to convert a table to a range in Excel using Table Design, context menu, VBA, or by removing filters and formatting.
Read article
Excel Pro Tips
How to Add a Column to a Table in Excel (6 Easy Ways)
Learn step-by-step methods to add a column to a table in Excel using the ribbon, context menu, shortcuts, or Power Query.
Read article
Excel Pro Tips
How to Convert Image to Table in Excel (4 Suitable Ways)
Learn 4 easy methods to convert an image to a table in Excel using built-in tools, OneNote OCR, online OCR, and ChatGPT.
Read article
Excel Pro Tips
How to Use Structured Reference in Excel Formula (6 Examples)
Learn 6 easy methods to use structured references in Excel formulas, including SUM, AVERAGE, IF, VLOOKUP, and more.
Read article
Excel Pro Tips
How to Create a Table in Excel from Existing Data
Learn how to turn existing data into an Excel table using Insert, shortcuts, Power Query, Text to Columns & VBA for structured formatting.
Read article
Excel Pro Tips
How to Rotate a Table in Excel (5 Different Examples)
Learn how to rotate an Excel table using Transpose, formatting tools, and formulas to flip data 90° or 180° for easier viewing and analysis.
Read article
Excel Pro Tips
How to Add a Total Row in Excel Table (5 Simple Ways)
Learn how to add a Total Row in an Excel table using shortcuts, Table Design tools, context menu options, Quick Analysis, or SUM function.
Read article
Excel Pro Tips
How to Change Table Colors in Excel (5 Easy Ways)
Learn how to change table colors in Excel using Table Design options, custom palettes, manual fills, themes, and conditional formatting.
Read article
Excel Pro Tips
How to Create a Table from Another Table in Excel
Learn how to create a new Excel table from another table using filtering, INDEX-MATCH, and VLOOKUP to extract and organize data easily.
Read article
Excel Pro Tips
How to Mirror a Table on Another Sheet in Excel
Learn how to mirror a table on another sheet in Excel using simple formulas, conditional logic, Power Query, and VBA for automatic updates.
Read article
Excel Pro Tips
How to Create a Lookup Table in Excel (5 Different Examples)
Learn how to create a lookup table in Excel using XLOOKUP, VLOOKUP, INDEX-MATCH, LOOKUP, and drop-down lists for fast data use.
Read article
Excel Pro Tips
How to Create a Floating Table in Excel (6 Different Ways)
Learn how to create a floating table in Excel using simple tricks like moving tables, Camera tool, Freeze Panes, Watch Window, and VBA.
Read article