Excel tips and tricks Helping you to master Excel fundamentals with easy to use advice. How to export your Excel 2019 / 365 spreadsheet and save as CSV? How to remove duplicated rows in an Excel 2019/365/2016 spreadsheet? How to export data from Microsoft Access tables to .CSV, xlsx and text formats? How to enable the Power Pivot data analysis Add-in for Excel? Excel Macros for beginners: How to record and write VBA Macros in your Excel 2019 workbooks? How to import data from Excel into an Access database? How to access and open an Excel 97/2003 .xls file in Excel 2016, 2019 and 365? How to automatically highlight alternate rows or columns in Excel 2016? How to make Office 2016 or 2019 or 365 your default Microsoft Office application? Automatically format cells, dates, columns and rows in Excel 2016? How to create checklists in Excel sheets and Word documents? How to combine two or more cells or columns in Excel 2016 / 365 / 2019? How to remove duplicated entries from an Excel 2016 list? How to add a drop-down menu for data validation in Excel 365? How to embed watermarks in Office 2016 / 2019 Excel spreadsheets and PowerPoint presentations? How to embed Word objects into an Excel 2016 / 365 / 2019 workbook? How to remove password protection from Excel 365 / 2016 / 2019 workbooks? How to spell check in Excel 2019 / 365 and 2016 (automatically and manually)? How to split worksheet cells by half in Excel 2016 / 2019? What program will allow me to open an xlsx file on Android, iPhone, MAC and PC?
