Excel Pivot Table
How to Change Pivot Table Data Source in Excel
Learn how to change pivot table data source in Excel using Analyze tab, VBA, tables, and how to refresh manually or automatically.
Read article
Blog
1285 articles
Excel Pivot Table
How to Create a Pivot Table from Multiple Excel Tables
Learn how to create a pivot table from multiple Excel tables using Power Query, appending queries, and creating relationships step-by-step.
Read article
Excel Pro Tips
How to Make Excel Go to Next Line Automatically
Learn how to make Excel go to the next line automatically using Wrap Text, manual breaks with Alt+Enter, and Find & Replace with Ctrl+J.
Read article
Excel Pro Tips
How To Find Text in Range and Return Cell Reference in Excel
Learn how to find specific text in a range and return its cell reference in Excel using CELL, INDEX, MATCH, and ADDRESS functions.
Read article
Excel Pro Tips
How to Convert Number to Date YYYYMMDD in Excel
Learn how to convert numbers to date format YYYYMMDD in Excel using formulas, Text to Columns, and custom number formatting techniques.
Read article
Excel Pro Tips
How To Merge Two Excel Sheets Based on One Column
Learn how to merge two Excel sheets based on one column using VLOOKUP, XLOOKUP, INDEX MATCH, and Power Query for seamless data integration.
Read article
Excel Pro Tips
How to Separate First, Middle & Last Names Using Excel Formula
Learn how to separate first, middle, and last names in Excel using formulas, Text to Columns, Flash Fill, and Find and Replace techniques.
Read article
Google Sheets Intermediate Tutorials
How to Protect Sheet from View in Google Spreadsheet
Learn how to protect a Google Sheets tab from view by using sheet protection, hiding, limited sharing, and separate files for more security.
Read article
Charts in Google Sheets
How to Add Data Labels in Google Sheets (with Easy Steps)
Learn how to add and customize data labels in Google Sheets charts, fix issues like misalignment, and update them with changing data.
Read article
Google Sheets Intermediate Tutorials
How to Print Selected Cells in Google Sheets (3 Suitable Methods)
Learn how to print selected cells in Google Sheets by choosing print areas, copying to new sheets, using filters, and best printing tips.
Read article
Google Sheets Intermediate Tutorials
How to Copy Conditional Formatting in Google Sheets
Learn how to copy conditional formatting in Google Sheets using Paint Format, Paste Special, and extending formatting to new ranges easily.
Read article
Google Sheets Basics
How to Do Spell Check in Google Sheets: Step-by-Step Guide
Learn how to do spell check in Google Sheets using keyboard shortcuts, menu options, and understand its spell check features easily.
Read article