[Word] Calculate the sum of numbers in a table column

 To calculate the sum of numbers in a table column in Microsoft Word, follow these steps:

1. Place the Cursor: Click in the cell where you want the sum to appear (typically at the bottom of the column or in a cell where you want the total).
2. Insert a Formula: 
• Go to the Layout tab under Table Tools (this tab appears when your cursor is inside the table).
• Click Formula in the Data group. If you don’t see the Layout tab, ensure you’re in the table and the cursor is active.
3. Enter the Formula: In the Formula dialog box, Word may automatically suggest =SUM(ABOVE) to sum the numbers in the column above the selected cell. If not, type =SUM(ABOVE) in the formula field.

[Word] Automatic Numbering Your Figures

Prepare your figures:

1. Select figure
2. Go to the Reference tab.
3. Insert Caption - Label: Figure

Cross-reference it by

1. Reference type: Figure
2. Insert reference to: Only label and number 

[PowerPoint] Compare Two Versions of PPTX File

Microsoft PowerPoint's Built-in Compare Feature

Microsoft PowerPoint has a "Compare" feature that can help you identify differences.

1. Open one of the two PPTX files you want to compare. It doesn't matter which one, but typically you'd open your "original" or "base" version.
2. Go to the "Review" tab on the PowerPoint ribbon.
3. In the "Compare" group, click on "Compare".
4. A dialog box will open. Navigate to and select the second PPTX file you want to compare to the currently open one.
5. Click "Merge".

What happens next:

• PowerPoint will merge the selected presentation with the one you had open and display the merged file in "Review mode."
• A "Revisions" pane will appear on the right side of your screen. This pane lists all the changes made to the presentation, categorized into "Slide changes" (changes on the current slide) and "Presentation changes" (changes affecting the whole presentation, like added/deleted slides).
• You'll also see annotations on the slides themselves highlighting specific changes (e.g., text edits, object movements, image changes).
• You can then review each change, click on the highlighted areas, and choose to accept or reject them individually.
• Once you've finished reviewing, click "End Review" on the Review tab and save your changes.

[Excel] Drawing Histograms with =FREQUENCY()

How to Create a Histogram in Excel with Two Sets of Data

1. Suppose the grade of students are stored in A1:A70.
2. Bin array (B1:B11) stores 9, 19, 29, ..., 99, 109.
• Grades <= 9 falls into the first bin.
• 10 <= grade <= 19 falls into the second bin.
• The last bin is for 100 <= grade <= 109.  
3. Create an array C1:C11 which is =B1-9.  This will be the x-axis for the bar chart.
4. In D1, Enter the formula =FREQUENCY(A1:A70, B1:B11).
5. You will get 12 cells.  The additional bin is for 109 < grade.  The value is certainly 0. You don't include this in the bar chart.
6. Draw a bar chart with C1:D11.

Expand Acronyms in MS-Word

 File - Options - Proofing - AutoCorrect Options

  Replace text as you type

  (e.g., replace "sip" with "Session Initiation Protocol")