搜尋此網誌

2025年6月24日 星期二

[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.

2025年4月22日 星期二

[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.

2025年3月26日 星期三

Expand Acronyms in MS-Word

 File - Options - Proofing - AutoCorrect Options

  Replace text as you type

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