TutorialWord Tutorial

How to Restrict Editing to Parts of a Word Document

Restrict Editing to Parts of a Microsoft Word Document This tutorial will explain how to restrict editing to parts of a Word document.  If you'd prefer watch the video tutorial at the bottom of the page.

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Step 1: With your document open, click the ribbon’s Review tab and then click the Restrict…

Read More
Excel TutorialExcel VBA TutorialTutorial

Automatically Refresh a PivotTable When its Data Source is Updated

PivotTables require a refresh if the underlying data is changed or added to.  This tutorial will explain how to automatically refresh your PivotTable using a few lines of VBA code. The solution will work when you change existing data or add new data.  Follow the tutorial and/or watch the video below.

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

For…

Read More
Excel TutorialTutorial

Combine Values & Delimiters Using Excel’s TEXTJOIN Function

How to Use Excel's TEXTJOIN Function =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Excel’s TEXTJOIN function provides a quick way of combining values in different cells, like for example first, middle and surnames as shown below.  This has always been possible in Excel but TEXTJOIN provides a better solution if you need to include…

Read More