Office: Difference between revisions
Line 899: | Line 899: | ||
* [https://www.howtogeek.com/683116/how-to-hide-or-remove-comments-in-google-docs/ How to Hide or Remove Comments in Google Docs] | * [https://www.howtogeek.com/683116/how-to-hide-or-remove-comments-in-google-docs/ How to Hide or Remove Comments in Google Docs] | ||
* [https://www.makeuseof.com/how-to-use-google-docs-assistive-writing-feature/ How to Use Google Docs' New Assistive Writing Feature] | * [https://www.makeuseof.com/how-to-use-google-docs-assistive-writing-feature/ How to Use Google Docs' New Assistive Writing Feature] | ||
* [https://www.howtogeek.com/google-docs-cover-image/ Your Google Doc Can Now Have a Stylish Cover] | |||
== LibreOffice Writer == | == LibreOffice Writer == |
Latest revision as of 17:14, 28 September 2024
Office
ISO download
- Download Office 2019, Office 365 & 2016 ISO Offline Installer. The download file is called ProfessionalRetail.img for Office 2016 Professional and ProPlus2019Retail.img for Office 2019 ProPlus.
- How to Extend Office 2019/2016 & Office 365 Trial to 180 Days?
- MS Office Download Links
- Office 2013 Direct Download Links
- how do i install the .img file for Office 20123
Office home use program (HUP)
- https://www.microsofthup.com/hupus/home.aspx $9.95
- Microsoft drops one-off Office licenses from its Home Use Program
永久免費: cscript
- Tools to manage volume activation of Office
- Office 2021 and Office LTSC for Windows and Mac FAQ
- Office 2021 永久免費使用教學 (Office LTSC) By CrazyCracker 瘋破解
- 2022最新win10和win11安装,5分钟搞定!绕过win11系统限制,永久免费激活系统丨科技源代码
- office全家桶免费激活,一键部署,adobe全家桶发布最新2023版本!
- 免费搭建KMs服务器!通过 VM虚拟机、软路由或者VPS都可以搞定激活!
- Word、Excel、Pointpot 最强安装教程! See the last video about the commands to activate office. That is, the IP/url kms.03k.org below can be replaced by our own server IP/url.
- 视频中关于kms激活office有个误区。正常进入office安装目录后,使用如下方法激活 (Use the command cd C:\Program Files\Microsoft Office\Office16 if you have an Office 2019)
cd C:\Program Files\Microsoft Office\Office16 cscript ospp.vbs /sethst:kms.03k.org cscript ospp.vbs /act
- 视频中提到的两行是激活Windows时使用的 (works)
slmgr /skms kms.03k.org slmgr /ato
- Check status
cscript ospp.vbs /dstatus
- KMS 地址列表
- Activate Office 2019 Permanently Using KMS Activation
Transfer license
Change languages
How to Change the Language in Microsoft Office 2016
Office Location
https://products.office.com/en-us/office-2016-preview. Scheduled 9/22/2015.
Tips & Tricks 147 – Find the Location of Excel.Exe. 1. Start Excel 2. Right click on Windows Task Bar > Start Task Manager > Processes tab. 3. Locate Excel.Exe > Right Click > Open File Location to reach to Excel.Exe.
For office 2016 & 365, the executables (EXCEL, WORD, ...) are located at C:\Program Files\Microsoft Office\root\Office16. The path can be found by right clicking Excel from the start menu, choose 'More' > 'Open file location'. Then right click the Excel and choose 'Properties'. The 'Shortcut' tab will display the Excel location in the "Target" field. For the office computer, the location is C:\Program Files (x86)\Microsoft Office\root\Office 16.
On Windows 10, I did not see Excel (Under 'E' or under 'M') at Startup menu. Under 'Microsoft Office 2016 Tools' in the start menu, I see Database Compare 2016, Office 2016 Language Pref..., Office 2016 Upload Center, Skype for Business Record..., Spreadsheet Compare 2016, Telemetry Dashboard for Office, Telemetry Log for Office 2016. I did see Word 2016, Publisher 2016, OneNote 2016, Outlook 2016 in the startup menu. Anyway, I can type excel.exe in the search box to launch Excel 2016.
Office 365
Office 365 is a subscription plan to current and future versions of Microsoft Office that offers other productivity services enabled over the internet (Cloud services) including Exchange Online - hosted email for business, and additional online storage with OneDrive for Business.
Microsoft 365 vs Office 2021
- What's the difference between Microsoft 365 and Office 2021?
- Microsoft 365 vs. Office 2021: What’s the Difference?
OneDrive
- Can I write an equation? Not in Word for the web.
- Adding equations to Google Slides. The strategy is to use the online Latex editor to create a math equation, download the file (say in SVG) and insert it into OneDrive/Google documentation. After I insert a picture (SVG file) on top of a diagram, I need to right click the diagram and choose 'Fill' and pick the white color (since the background color is not white). It works fine except I cannot edit the equation.
- Office.com -> App Launcher -> OneDrive -> My files.
- Word app on OneDrive cannot find text in comments as Desktop can do (Windows only).
Intelligent Services
Make Office Work Smarter for You
macOS version
macOS will have another extra menu bar sits on atop/outside the office application. This Mac menu is less implemented in Microsoft Office. We can ignore that part depending on the applications. PowerPoint 2016 for Mac review: New interface and features make PowerPoint pleasant
Pages, Numbers, Keynote
Forget Microsoft Office: Your Mac Already Has a Free Productivity Suite
Outlook
Set up Outlook with Office 365
- Videos from office.com
How to Configure Outlook for Mac for Office 365
- https://uit.stanford.edu/service/office365/configure/outlook_mac
- https://itservices.usc.edu/office365/outlookmac2016/
New Outlook, not receiving emails
- Top 9 Ways to Fix Microsoft Outlook Not Receiving Emails on Mac. In my case, if I switch from "Legacy Outlook" to "New Outlook", the problem is gone.
- The new Outlook for Mac.
How to Reduce the Size of Your Outlook Data File
http://www.howtogeek.com/285297/how-to-reduce-the-size-of-your-outlook-data-file/
Different panes
http://biz.colostate.edu/mti/tips/pages/outlookReading.aspx
- Navigation pane
- Reading pane
- Inbox/Message List pane: See microsoft.com on how to change the font size of the message list. Mail -> VIew -> Current View -> View Settings. Click 'Other Settings' -> Row Font or 'Conditional Formatting' -> one rule.
- Preview pane
- Calendar pane: See microsoft.com on how to keep the Calendar in Mail pane. Mouse over (not click) on Calendar located on bottom-left. Click the Pin button to dock it to the right edge of the Outlook window.
Change theme
File -> Options -> General. Select the drop-down list from the 'Color scheme'.
Status/presence icons/symbols
Change view: Messages vs Conversations
Go to View > Conversion.
On the web version, there is no menu bar. The same option is at Filter > Show as. We can also uncheck the option of 'Show Focused Inbox' from Filter.
How to increase the font size in the reading pane
Use ctrl + mouse scroll wheel. This will affect the current email message.
Or use the Magnification bar at the right-bottom corner (on the status bar). There is no way to lock the zoom level for all messages.
Garamond font
https://en.wikipedia.org/wiki/Garamond
How to change all message font size
See this post. The con is the messages have to be converted to plain text (images in the email will not be shown).
Outlook 2010:
- Click File > Options > Trust Center (category) > Trust Center Settings... (button) > E-mail Security (category)
- Under 'Read as Plain Text', check the box next to 'Read all standard mail in plain text' > click OK once to return to Outlook Options.
- Click Mail (category) > Stationary and Fonts... (button).
- Under 'Composing and reading plain text messages', click Font... (button).
- Adjust the font size/settings as desired (how to you want to see new messages?) and click OK when done, then OK to exit the Signatures and Stationary window, and OK again to exit Outlook Options.
Note - You will have to click off of whatever email you had selected while changing the settings, then click back on it to see the changes you've made.
How to send an encrypted email
Appointments, meetings, and events
- Appointment: An appointment is an event scheduled on your Outlook calendar that involves only you. Appointments have a start and end time and are private by default, visible only to you. You can use an appointment to block your own calendar for specific work.
- Meeting: A meeting is an appointment that involves other people. You can invite others to a meeting and reserve resources for it. When you add even a single recipient to an appointment, it turns into a meeting.
- Event: An event is an activity that lasts 24 hours or longer. Events do not occupy blocks of time in your calendar; instead, they appear in banners. Examples of events include a trade show, a life event, a vacation, or a seminar.
The main difference is that appointments are for individual use, while meetings are for group use. Events are usually for you and do not have a specific time like appointments do.
Turn an Outlook message into an appointment or a task
Drag the message from the message list to the Calendar or Tasks shortcut near the bottom of the navigation pane.
Out of Office automatic reply
- How To Automatically Reply To Specific Sender (Email Address) In Outlook?
- Send automatic (out of office) replies in Outlook Office for business Office 365 Small Business Outlook.com
Block Out Daily Lunch Time In Outlook Calendar
How To Block Out /Off Time In Outlook Calendar?
New Meeting Request
Click Calendar first and you will see these two options. New appointment will be saved under my own calendar. New Meeting Request will let you to specify To, When, Where, and Subject.
See
Auto delete emails from meeting request
Calendar with email
- Change how you view your Outlook calendar
- How can I display Calendar Agenda on Mac Outlook 2016? - no solution
How to Show a Google Calendar in Outlook
How to Show a Google Calendar in Outlook
Email Group
How to Create an Email Group and Distribution List in Outlook
Tag emails
How to Tag Your Emails For Maximum Searchability
Recurring emails
How to create a recurring e-mail message in Outlook
What's New
Excel
65536 rows limit and ? columns limit
- Until Office 2007, Excel has a maximum of 65,000 rows. Office 2007 bumped that up to a max of 1 million rows. See https://stackoverflow.com/a/527026
- A technical glitch that saw nearly 16,000 Covid-19 cases go unreported in England. Excel's XLS file format dates back to 1987. It was superseded by XLSX in 2007. Had this been used, it would have handled 16 times the number of cases.
- Excel Row and Column Limit. Why does an Excel spreadsheet end at 1048576 and XFD?
- nr=1,048,576=2^20
- nc=16,384=2^14 (XFD). This is based on a 26 base system, not a 10 base system.
Read-only
Import data
Import Excel data from screenshots
Keyboard shortcuts in Excel
F2: edit the selected cell
(MacOS): Control + Option + two fingers on touchpad to Scroll Zoom in/out.
In-cell carriage returns
Alt + return
Autofit column width
- Select all ("CMD + a" OR "Ctrl + a")
- Menu -> Format -> AutoFit Column Width.
Excel R1C1; Change column letters to numbers
- Windows: Preferences - Authoring - Calculation - Use R1C1 reference style
- macOS Excel: Preferences - Calculations - Use R1C1 reference style
- Change column letters to numbers? in LibreOffice
Plot Excel data
- How to create 3D Column Chart in MS Office Excel 2016. Select a range of data. Insert -> select an icon showing barplot. Pick a style we like and click on it. We need to modify the chart title as we want.
- http://app.rawgraphs.io/
- How to Create a Waterfall Chart in Excel
- How to Create a Waterfall Chart in Google Sheets
Apply a Color Scale Based on Values
- Format -> Conditional formatting
- How to Apply a Color Scale Based on Values in Google Sheets
- Two ways to change background color in Excel based on cell value, How to use conditional formatting in Excel
- How to Manage Conditional Formatting Rules in Microsoft Excel
Reduce the number of decimal places
How to Change the Number of Decimal Places in Excel. On the Home tab, select Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.
Data Bars
Sort data in Excel
- Select a range of columns
- Click Sort & Filter button and select 'Custom sort'. Select the header of 'Column' of "sort by". Click the OK button. Done
Creating a Drop-Down Filter to Extract Data Based on Selection
- Excel Filter Data with Dropdown Arrows. Select any cell (not empty) in a worksheet -> Data (menu) -> Filter (icon). It will apply to every columns in the worksheet. Very simple!
- Searchable Drop Down List in Excel (Very Easy with FILTER Function). Select cells and use Ctrl+t to create it.
Remove password protection
Remove password protection from Excel sheets using R
Excel has detected that filename is a SYLK file but cannot load it
This problem occurs when the file that you’re trying to open has uppercase letters “I” and “D” as the first two characters.
For example, your file contains:
ID, Patient, Name 100, John, Smith 101, Mike, Doe
To fix it, either update ID to lower case “Id”, or you can add an apostrophe at the beginning of the first line of text.
Prevent auto convert to dates in Excel
- Release notes for Office for Mac Oct 10, 2023. Search for 'conversiosn'.
- Excel Options -> Advanced -> uncheck 'Enable AutoComplete for cell values'.
- Microsoft Excel Can Now Stop Turning Everything Into a Date
- 微軟終於允許Excel用戶調整自動轉換功能,可以不再自動將連續字母與數字轉成日期.
Convert digits surrounding the letter “E” to a number in scientific notation
- Control data conversions in Excel for Windows and Mac
- Microsoft is finally fixing an Excel data bug that had scientists fuming
How to insert a line break in Excel cell
- Windows: Ctrl + Enter.
- Mac: Option + Enter
Insert a row
It can insert a row above, but not below. See How to insert a row below in Excel 2016
Creating macros
Save a macro-enabled workbook
Saving and Using an Excel 2010 Macro-Enabled Workbook. Excel adds the .xlsm extension to the filename.
Open two sheets side by side
- How to View Two or More Sheets of the Same Excel Workbook At Once
- View Two Sheets Side-by-Side in the Same Workbook
Hidden worksheets
7 Fun & Weird Things You Can Create With Microsoft Excel
http://www.makeuseof.com/tag/7-fun-weird-things-can-create-microsoft-excel/
VBA
- http://www.makeuseof.com/tag/excel-vba-programming-tutorial/
- Tips And Tricks For Excel from extendoffice.com.
How to resize multiple cells to fit pictures quickly in Excel?
How to resize multiple cells to fit pictures quickly in Excel?. It works when I tested on Office 365 Excel on mac.
On mac, we can open VBA by fn + alt + F11 or Tools > Macro > VBA.
Sub ResizePictureCells() For Each Picture In ActiveSheet.DrawingObjects PictureTop = Picture.Top PictureLeft = Picture.Left PictureHeight = Picture.Height PictureWidth = Picture.Width For N = 2 To 256 If Columns(N).Left > PictureLeft Then PictureColumn = N - 1 Exit For End If Next N For N = 2 To 65536 If Rows(N).Top > PictureTop Then PictureRow = N - 1 Exit For End If Next N Rows(PictureRow).RowHeight = PictureHeight Columns(PictureColumn).ColumnWidth = PictureWidth * (54.29 / 288) Picture.Top = Cells(PictureRow, PictureColumn).Top Picture.Left = Cells(PictureRow, PictureColumn).Left Next Picture End Sub
Another technique is to delete pictures. Strangely, 'delete' key does not work on picture objects. Method 1. Click 'F5' or 'fn + F5' on mac. Click 'Special' > check the Object option > OK. All pictures are selected in active worksheet. Press Delete key to delete all of them. Method 2. VBA
Sub DeleteAllPics() Dim Pic As Object For Each Pic In ActiveSheet.Pictures Pic.Delete Next Pic End Sub
How to Create a Timeline in Excel
How to Create a Timeline in Excel: SmartArt, Templates, and More
Excel print the header row on each page
http://www.guidingtech.com/17822/print-first-row-column-every-excel-page/
- Click page layout tab on the ribbon
- Switch to the tab for Sheet and spot the section for Print titles. It hosts a row and a column option.
- In the 'Rows to repeat at top', enter '$1:$1'.
Done!
How to Print the Gridlines and Row and Column Headings in Excel
http://www.howtogeek.com/220645/how-to-print-the-gridlines-and-row-and-column-headings-in-excel/
How to Insert, Edit, or Remove Page Breaks
How to Insert, Edit, or Remove Page Breaks in Microsoft Excel
How to Create a Heat Map in Excel
How to freeze a row/column or multiple rows/columns in Excel
- How to Freeze Cells in Excel
- http://www.howtogeek.com/166326/how-to-freeze-and-unfreeze-rows-and-columns-in-excel-2013/
For example, to freeze the first 2 rows: Select the 2nd row. View --> Freeze Panes.
A simpler way is to move the cursor to some cell, say R4C3. Then 'Freeze Panes' will freeze rows 1-3 and columns 1-2.
Excel Pivot Tables: How to create better reports
Lock cell
Paste multiple lines into one cell in Excel
3 Quick Methods to Paste Multiple Lines into One Cell in Your Excel Worksheet. The first method (double click the cell works).
Split Cells
How to Split Cells in Microsoft Excel
Split paste text into multiple columns
Use Excel functionality to split the string
Highlight the column containing the data to be converted. Data -> Text to columns. This will call "Convert Text to Columns wizard".
If function
https://support.office.com/en-us/article/IF-function-69AED7C9-4E8A-4755-A9BC-AA8BBFF73BE2
=if(exact(E2, "M"), 1, 0) # Compare E2 cell and "M" string value, return 1 if TRUE.
LAMBDA Function
How to Use the LAMBDA Function in Excel
Create a plan with Excel
How to Create a Marathon Training Plan With Excel
Excel Add-ins
Some favorites for you to try, and some are free
Remove green triangles
Windows: File > Options > Formulas > untick checkbox Enable background error checking.
Mac: Preferences > Error Checking > untick Turn on background error checking
Hide rows or columns
- How to Hide or Unhide Columns in Microsoft Excel
- http://www.howtogeek.com/218582/how-to-hide-cells-rows-and-columns-in-excel/
- How to Unhide All Rows in Excel
Hide sheet tabs
How to Hide and Unhide Sheet Tabs in Google Sheets
Clear format
How to Clear Formatting in Microsoft Excel. On the “Home” tab, in the “Editing” section, click the “Clear” option.
Split Screens, Freeze Frames, Quick Cut and Paste, Format Painter
Office Mobile
Free for devices less than 10.1 inch screen on Windows 10.
- https://blogs.office.com/2015/07/29/office-mobile-apps-for-windows-10-are-here/
- https://en.wikipedia.org/wiki/Microsoft_Office_Mobile
- Caveat Office Mobile只允許使用者儲存為支援Open XML的Office檔案格式,無法儲存成DOC、XLS、PPT格式。
Screenshots from different MS-Excel
- 2016. The quick access toolbar and menu have a green color as the background. The current selected menu item has white background color so its color is consistent with the Ribbon and the worksheets. The top-left has an 'X' icon as Office 2013.
- 2013. The quick access toolbar and menu have a white color as the background. The current selected menu item has green background color.
- 2007. The background color of quick access toolbar, menu and Ribbon is blue by default. There is a big circle Windows icon on the left-most quick access toolbar.
- 2003 No Ribbon. No quick access toolbar and the location is used to show 'Microsoft Excel' and the file name.
- 2002/XP or this one. It looks the same as 2000.
- 2000 Simple.
Use a black color as background for easy reading on screens
On the ribbon go to "Page Layout" and then "Page Color" - select black.
How to Remove the Background From a Picture in Excel
How to Remove the Background From a Picture in Excel
Best Websites to Download Free Excel Templates
- The 5 Best Websites to Download Free Excel Templates
- 24 Google Docs Templates That Will Make Your Life Easier
Calendar Templates
The Best Free Microsoft Office Calendar Templates for the New Year
Google sheets
Jump to the last cell in a column
Jump to the Last Cell with Data in a Column in Google Sheets (Hyperlink). Note that to avoid the circular dependency error error, we have to select the cell not in the column we are interested in. For example, if we want to jump to the last row in column B, we can put the =Hyperlink() in any cell in column A.
In fact, use the keyboard shortcut Ctrl+down arrow will work.
Create an Automatic Outline in Microsoft Excel
How to Create an Automatic Outline in Microsoft Excel
PowerPoint
ChatGPT
How To Plan and Create a PowerPoint Presentation With ChatGPT and MidJourney
TTS/Text to speech
ChatTTS 最强文本转语音!一键本地安装,100%成功!. We can get an idea of how long a speech will be from a text.
Ten simple rules
Ten simple rules for effective presentation slides
Capitalize my title
- https://capitalizemytitle.com/. See Proper Capitalization in PowerPoint
- In English title capitalization, it’s common to capitalize the first letter of all words except for certain short words such as articles (a, an, the), conjunctions (and, but, or, for, nor), and prepositions (in, at, to, of, etc.) when they are not the first or last word in the title.
- Note that some preposition words, such as ‘against’, have many letters. Whether the first letter should be capitalized or not depends on the context.
Table of contents
How to Create a Table of Contents in Microsoft PowerPoint
Tables
Two big menus
- Table Design
- Layout: adjust row hight/column width, insert rows/columns, ...
- 4 Steps for Good-looking Tables in a Presentation
- Export From Excel to PowerPoint: 3 Easy Methods and a Recommendation! (including Charts)
Cell background colors: shading
Add or change the fill color of a table cell
- Select the cells or rows in which you want to add or change the fill color.
- On the Table Design tab, click the arrow next to Shading.
- Click the color you want from Theme Colors or Standard Colors, or click More Fill Colors.
R
R flextable package. 3.4 PowerPoint or Word documents with officer for powerpoint & officer. Note that the elements of the table is still editable. How to read and create Word Documents in R 2020. It is interesting that if we don't use qflextable() we will get a default pptx table design. So maybe the officer package is all we need.
library(officer) ft1 <- qflextable(head(airquality)) ft11 <- ft1 %>% theme_box() ft2 <- qflextable(head(ggplot2::diamonds)) %>% theme_zebra() ppt <- read_pptx() ppt <- add_slide(ppt, layout = "Title and Content", master = "Office Theme") ppt <- ph_with(ppt, value = "Hello world", location = ph_location_type(type = "title")) ppt <- ph_with(ppt, value = ft1, location = ph_location_left()) ppt <- ph_with(ppt, value = ft2, location = ph_location(left = 3, top = 5)) print(ppt, target = "~/Downloads/example_table_powerpoint.pptx") ppt2 <- read_pptx("~/Downloads/example_table_powerpoint.pptx") ppt2 <- add_slide(ppt2, layout = "Title and Content", master = "Office Theme") ppt2 <- ph_with(ppt2, value = head(airquality), location = ph_location_left()) # default pptx table style ppt2 <- ph_with(ppt2, value = ft2, location = ph_location(left = 3, top = 5)) # create a temp file src <- tempfile(fileext = ".png") # create PNG object png(filename = src, width = 4, height = 4, units = 'in', res = 400) # create plot plot(sample(100, 10)) # save PNG file dev.off() # Default image size and location # the image proportions are distorted ppt2 <- add_slide(ppt2, layout = "Title and Content", master = "Office Theme") ppt2 <- ph_with(ppt2, external_img(src), use_loc_size = TRUE, location = ph_location_type(type = "body")) # Specify the image size in pptx # PS. specify width, height AND use_loc_size = FALSE in order for it to work ppt2 <- add_slide(ppt2, layout = "Title and Content", master = "Office Theme") ppt2 <- ph_with(ppt2, external_img(src, width=4, height=4), use_loc_size = FALSE, location = ph_location_type(type = "body")) # Define the location of the image ppt2 <- add_slide(ppt2, layout = "Title and Content", master = "Office Theme") # center the plot my_width=5; my_height=4.8 s_s <- slide_size(ppt2) s_w <- s_s$width # width of slides s_h <- s_s$height # width of slides left <- (s_w/2) - (my_width/2) top <- (s_h/2) - (my_height/2) ppt2 <- ph_with(ppt2, value = "Best plot", location = ph_location_type(type = "title")) ppt2 <- ph_with(ppt2, external_img(src, width = my_width, height = my_height), use_loc_size = FALSE , location = ph_location(left = left, top = top)) print(ppt2, target = "~/Downloads/example_table_powerpoint.pptx")
How to Fill Text Color With an Image in Microsoft PowerPoint
https://www.makeuseof.com/tag/fill-text-color-image-powerpoint/
Shape fill
On macOS, the app specific menu (vs the global menu bar) will change with the object currently highlighted. For example if I highlighted a shape object, the app specific menu will have a Shape Format item shown on the far RHS. But if I highlighted a picture object, the app specific menu will have a Picture Format item shown on the far RHS.
So if we have created a shape object and we can click on the Shape Fill icon to select the color to be filled after we have clicked Shape Format menu.
SmartArt
- Create a SmartArt graphic from scratch
- SmartArt in PowerPoint – A Complete Guide (With Pictures!)
- Free SmartArt Google Slides and PowerPoint Templates
- Infographics from Microsoft
How to Convert PowerPoint Slides to Flashcards for Better Study Results
https://www.makeuseof.com/tag/convert-powerpoint-slides-flashcards/
Hide the taskbar in PowerPoint presentation mode
- Display the presentation in Slide show mode > Right click > Screen > Show task bar should be unchecked. See The taskbar is always shown when in Presentation Mode in PowerPoint
- Open Powerpoint > Slide Show tab > Set Up Slide Show > Make sure that Presented by a speaker (full screen) is selected
- Choose File | Options in Backstage view to bring up the PowerPoint Options dialog box > Select the Advanced tab in the sidebar, and scroll down to the Slide Show section > Remove the check mark next to Show popup toolbar
- In PowerPoint, go to Slide Show tab, in Set Up group, click Set up Slide Show, make sure your Show type is configured correctly (do not select Browsed by an individual window)
Powerpoint Presenter View
- Keyboard shortcuts on macOS,
- Presenter view: Option + Return
- Play a show from the current slide: Command + Return
- Presenter view on Windows
- F5 to enter slide show. Click "..." icon shown on the right most at the bottom-left corner. This will bring up a menu and we can choose 'Show Presenter View'.
- Alt + F5
- https://youtu.be/XKRcTw2ATek The screen has to be extended instead of duplicated.
- LibreOffice Impress also support presenter screen. Presenter can use the keyboard shortcut Ctrl+2 to view notes on RHS of your own screen and Ctrl+3 to get an overview of all slides and Ctrl+1 to switch back to the normal view (just see the next slide in PC's screen).
- LibreOffice Impress screenshots (no need to install anything extra at least on Ubuntu 16.04 and actually no need to remember the keyboard shortcuts)
- Presenter View in PowerPoint
- How to Add and Print PowerPoint With Speaker Notes
- Presenter View in Google Slides. Just click in the text box beneath the main slide area to type your notes, or go to Tools > Voice type speaker notes, click the mic button and start dictating. Your notes will be viewable by only when you select “presenter view” from the Present drop-down menu.
- Webex (not work): Options for sharing PowerPoint slides in Webex (including Presenter View). Unlike Teams or Zoom that offer ways to use PowerPoint’s Presenter View Preview mode to share your slides with the attendees while you see your notes, this is not possible in Webex.
- Teams (work): Share - Window - PowerPoint. At this time, the other users can see my PP even my screen hasn't switch to PP automatically. After I manually switch to PP, I can see a red color border around my PP. I can click Slide Show - Presenter View or Opt + Enter keys. Audience will see the normal slide show screen while I am still in the presenter's view. If I click "End Slide Show", it will automatically disconnect the sharing. If we accidentally click "Use Slide Show", we can still double click a slide and bring back the "Presenter View". Note: pressing the "ESC" key will end sharing.
Teleprompter 讀稿機
- Teleprompter (iOS)
- 7 Best Teleprompter Apps in 2023, 10 of the Best Teleprompter Apps for Android
- PowerPoint as Your Teleprompter - Expanding your digital toolbox (video)
- Record videos of yourself FAST! Best teleprompter app tutorial (video)
How to Black (or White) Out a PowerPoint Presentation
https://www.howtogeek.com/365699/how-to-black-or-white-out-a-powerpoint-presentation/
How to Prevent PowerPoint from Automatically Resizing Text
https://www.howtogeek.com/393935/how-to-prevent-powerpoint-from-resizing-text/
How to Dim the Appearance of Text in PowerPoint
- How to Dim the Appearance of Text in PowerPoint
- Dim Text in PowerPoint Presentations
- How to dim text in PPT 2013 (Video)
- Animate bullet points one at a time in PowerPoint for Mac
- Search 'animate bullet list'
- 5 Ways to Highlight Text in a Microsoft PowerPoint Animation
How to Animate Single Words or Letters
How to Animate Single Words or Letters in Microsoft PowerPoint
Aligning Objects Between PowerPoint Slides
- Align and arrange objects from Microsoft
- How to Arrange and Align Elements in PowerPoint
- Aligning Objects Between PowerPoint Slides (the Smart Way)
- How to Align in PowerPoint Ruler, gridlines & guides.
Use Guides to Position Items in Google Slides
How to Use Guides to Position Items in Google Slides
How to Blur an Image in PowerPoint
https://www.howtogeek.com/437476/how-to-blur-an-image-in-powerpoint/
How to Insert an Image Inside of Text in PowerPoint
https://www.howtogeek.com/660010/how-to-insert-an-image-inside-of-text-in-powerpoint/
How to Make an Image Transparent in Microsoft PowerPoint
How to Make an Image Transparent in Microsoft PowerPoint, How to Make an Image Transparent in Google Slides
Add Image Placeholders in Google Slides
How to Add Image Placeholders in Google Slides
Insert a right curly bracket
- Insert and Format Shapes and Lines in Word 2019 - Office 365
- My note on Office 365
- Insert (Office menu, not the menu bar in OS) -> Shape -> Pick the right curly brace shape
- Select the curly brace object. Click the 'Shape Format' menu. Click the 'outline' icon (right next to the 'shape fill'). Then pick a color and change/increase the weight
Insert an arrow
- All about Arrows in PowerPoint (Beginners Series). Many tricks
- Right click "Format shape"
How to Create Brackets
- PowerPoint Brackets.
- Solution 1: just pick the pre-made shape Office provided
- Solution 2: group 3 straight lines
- How to Create Brackets in PowerPoint
- Insert shapes -> rectangle.
- Shape fill -> none. Shape outline -> Weight (increase it).
- Right click the bottom right point -> Edit Points.
- Right click the bottom right point -> Open Path (the point will be shifted a little bit)
- Right click the bottom right point -> Delete Point.
- Adjust the size rectangle as you like.
How to Create a Timeline in Microsoft PowerPoint
https://www.howtogeek.com/677677/how-to-create-a-timeline-in-microsoft-powerpoint/
Designer Tool
How To Use The PowerPoint Designer Tool – 10+ PowerPoint Design Ideas For Presentations
Slide master and Design Template, logo watermark
- (videos) How to add a logo watermark in PowerPoint on all slides, How to place a logo on each PowerPoint slide, How to use PowerPoint Slide Master
- How to Copy a PowerPoint Design Template to Another Presentation
- How to Use Slide Master in Microsoft PowerPoint to Create Impressive Presentations
- Save Time in Microsoft PowerPoint by Making Your Own Theme
- How to Edit a Header and Footer in PowerPoint. Method 1 is "Insert". Method 2 is "Slide master".
- Why can't I select and change the text in the footer?
How to Record Your Screen With Microsoft PowerPoint
- https://www.makeuseof.com/tag/record-screen-microsoft-powerpoint/
- How to Use the PowerPoint Screen Recorder to Engage Your Audience
- How to make your own StatQuest!!! (Video)
How to Make a Poster Using Microsoft PowerPoint
https://www.howtogeek.com/680538/how-to-make-a-poster-using-microsoft-powerpoint/
How to Make a Flowchart in PowerPoint
https://www.howtogeek.com/399626/how-to-make-a-flowchart-in-powerpoint/
Remove background
- How to Remove the Background from a Picture in Microsoft PowerPoint,
- How to Remove a Background or Watermark in PowerPoint
Track Changes in a Microsoft PowerPoint Presentation
How to Track Changes in a Microsoft PowerPoint Presentation
How to Reveal One Line at a Time
How to Reveal One Line at a Time in Microsoft PowerPoint
Progress bar
How to Create a Progress Bar in Microsoft Powerpoint
Sections
Organize your PowerPoint slides into sections
Insert code with syntax highlight
- Copy + paste
- Visual Studio Code, Eclipse
- Notepad ++
- Online syntax highlighter (you could choose to include line numbers): https://hilite.me, https://codebeautify.org/code-highliter
We are in an edit mode when we click on the paste object. PowerPoint will show spelling errors on words. But if we switch to the Slide Show mode, the spelling errors will be gone.
PDF and PowerPoint
5 Ways to Add a PDF Into a PowerPoint Presentation
Google Slides
- 3 Chrome extensions for better presentations
- How to Use Google Slides Animations and Timed Transitions
- How to Use Google Slides Animated Transitions
- The Full Guide on How to Animate Words in Google Slides
- Animate Bullet Points in Google Presentaiton (Video)
- 5 ways to make the most of Google Slides animation features
Link Excel to PowerPoint
How to Link Excel Data to Your PowerPoint Presentation
Create videos
See Video -> PowerPoint.
- How to Turn Your Slideshow Presentations Into Videos
- How to Make a Microsoft PowerPoint Presentation Into a Video
Embed videos
How to Make Google Slides Play Automatically.
Webex and presenter's note
How to properly present PowerPoint slides in Webex Meetings. However I don't have PPT Notes option on my mac's Webex; I only see Notes.
Add Section and Slide Zooms
How to Add Section and Slide Zooms in Microsoft PowerPoint
Zoom in/out in presentation
- 3 Ways to Zoom in on an Object
- Zoom in on a PowerPoint Slide. Hold the Ctrl key + Mouse spinning wheel. Note: this works well on Windows but I haven't found a solution on Mac.
Tips
- 10 PowerPoint Tips for Preparing a Professional Presentation
- 7 Things I Wish I’d Known Before I Made My First PowerPoint Presentation
- Slide master
- Remove image background
- Cropping images
- Presenter view
- Designer
- Animation pane
- Keyboard shortcuts
Insert a live web/html page
- LiveWeb
- Web Viewer add-in
Word
Hide ribbon
Show / hide ribbon arrow in Word v16.20 for Mac is gone. Click an item on the ribbon (example Home) and every on the ribbon will collapse.
4 L shaped lines/crop marks
- Show Crop Marks each page in Word
- How do You get the "L" Shaped Formatting Icons Back in Microsoft Word?
Read to you
- Word -> Review -> Read Aloud -> Samantha. The other voices are too funny.
- 5 Ways to Make Your Computer Read Documents to You
- How to Use the Read Aloud Feature in Microsoft Word
Double space
How to Double Space a Word Document
How to Remove Empty Lines
How to Remove Empty Lines from a Word Document
Add line number
- How to Add Line Numbers in Microsoft Word
- Add or remove line numbers
- Line numbers in word file differs between windows and Mac OS
Convert text to table
Convert text to a table or a table to text
On mac,
- copy the text from Terminal for example, and paste the text to Word
- select the text
- on Word app menu bar (not the global menu), click "Insert" -> arrow next to "Table" icon and then pick Convert text to table....
- Under seperate text at, pick the right one (eg Tabs or Comma). Under AutoFit behavior, choose "Autofit to contents".
Fill text in a shape
Text in Shape in Microsoft Word (video)
Hide spelling and grammar errors in Word
How to Hide Spelling and Grammar Errors in a Specific Word Document
Spelling
- How to turn on spell check in Word | Grammar/Spell check not working in Ms Word (2022)
- Select a paragraph -> Review -> Language -> Uncheck "Do no check spelling or grammar"
- Preferences/Options -> Proofing -> Uncheck the last two options (Hide spelling errors in this document only, ...) (Seems work on Windows only)
Markup
A: To get rid of the tracked changes permanently, you have to accept them and turn off the tracking.
How to Add and Remove Comments in Word
How to Add and Remove Comments in Word
How to merge comments and changes from multiple documents
How to merge comments and changes from multiple documents in Word?
- Open a Word document, and click Review > Compare > Combine.
- Select the original document and revised document in the Combine Documents dialog,
- Click the More button to expand more options
- In the Combine Documents dialog box, (1) check the Comments option in the Comparison settings section, (2) check the Original document option in the Show changes section, and (3) click the OK button.
- A Microsoft Word dialog pops up, please click Continue with Merge button.
And now you will see the original document has been combined with the first one of the checked document.
Rotate a page in Word files
3 Microsoft Word Formatting Tricks You Should Really Know
Avoid change simple quote ' to smart quote ’ (autoformatting) in Word
Uncheck two options in Options -> Proofing -> Autoformatting.
- https://www.simple-talk.com/blogs/2011/11/09/how-to-stop-office-2010-changing-and-to-smart-quotes/
- How To Change Straight Quotes To Curly Quotes In Word? contains a VBA code.
Copy format & paste text
- How to Quickly and Easily Copy Formatting in Word
- How to Copy Formatting in Word (3 Easy Ways with Shortcuts)
- Control the formatting when you paste text
8 MS Word Templates That Help You Brainstorm & Mind Map Your Ideas Quickly
http://www.makeuseof.com/tag/8-ms-word-templates-brainstorm-mind-map-ideas-quickly/
How to use Word to create holiday cards and other projects
https://www.pcworld.com/article/3146255/software/use-word-to-create-holiday-cards-and-projects.html
Change the Style of Hyperlinks
How to Change the Style of Hyperlinks in Microsoft Word
Avoid broken hyperlinks from web address containing space
Find all comments
- Method 1 (better): Review tab in the Tracking panel. Click on Review menu and then the Reviewing button. The default option "Reviewing Pane Vertical" will show all comments on left side panel. See How to Turn On or Off Reviewing Pane in Microsoft Word.
- Method 2: Click on Review menu. Pick up List (default is contextual which means Microsoft Word comments are next to the document's content) by clicking a little down arrow right next to Show comments.
- Method 3: Advanced find. "Go To" tab. Go to what: "Comment". "Any reviewer". Next.
Track changes and comments
How to make sure all the changes have been accepted or rejected and all comments have been removed?
- Track changes in Word
- How to Compare Two Documents in Microsoft Word, View and compare documents side by side
- Word: Track Changes and Comments (video)
How to view comments/ edits by someone?
- Review -> Markup Options -> Reviewers -> Select a name.
- Also check View -> Sidebar -> Reviewing (if the sidebar was closed).
How to diff microsoft word documents
- https://stackoverflow.com/a/41698997. It works.
pandoc -f docx -t markdown -o outfile.md infile.docx
- How to Use Microsoft Word's Compare Feature. Review -> Compare.
How to Organize Tables Across Pages
How to Organize Tables Across Pages in Word
References and footnotes
Annotate on images/Draw
- Use the "Draw" tool on the menu. See a demo How to ANNOTATE a WORD Document (highlight, circle, number, draw, etc.)
- How to DRAW in MS WORD | Microsoft Word Tutorial
- How to Easily HIGHLIGHT TEXT Over IMAGES in Microsoft WORD
How to Make a Dot Grid Paper Template in Microsoft Word
How to Make a Dot Grid Paper Template in Microsoft Word
Dictate and transcribe
How to Use Microsoft Word for Voice Transcriptions
Organize a document, outline view, heading
- How to Insert a Section Break in Microsoft Word
- Collapse or expand parts of a document
- How to Use Outline View in Microsoft Word
- Printing only the headings in the Outline
- Navigation pane. View -> Check 'Navigation Pane'. Microsoft Word: Creating Document Structure with Headings
Google Docs
- How to Hide or Remove Comments in Google Docs
- How to Use Google Docs' New Assistive Writing Feature
- Your Google Doc Can Now Have a Stylish Cover
LibreOffice Writer
Remove table borders from editting. View → Table Boundaries.
Word to PDF
Adobe Acrobat (Adobe Reader cannot). File -> Create -> PDF from File ... This method requires an internet connection. If I am offline, I'll receive a message saying that 'You need to be connected to the internet and signed in to Acrobat to use this feature. Please check and retry'.
Teams
- Start an instant meeting in Teams
- How to Create and Manage Teams in Microsoft Teams
- How to Create a Teams Meeting in Outlook
- How to Set Up a Meeting in Microsoft Teams
- start a meeting in Microsoft Teams without anyone initially present and then invite people to join by sharing a link.
- Navigate to the Calendar Tab:
- Click on the Meet now button at the top right of the Calendar view.
- Once you are in the meeting, click on the People/Participants button in the meeting controls. Click on the Share invite/Copy join info button (it looks like a chain link icon).
- Zoom in and out in Microsoft Teams
- Zoom in "interface", CMD + '='. To reset, CMD + 0
- Zoom in "shared content", Shift + Option + '+'. To reset, Option + Shift + “0”
- Dynamic view/Gallery view (of attendees)/Participants bar
Flow Charts
- https://support.office.com/en-us/article/Create-a-flow-chart-30f87402-ba3d-48c8-8e9f-a66bcee7e5aa
- https://support.office.com/en-us/article/Create-a-flow-chart-af4e3f4c-3854-486a-88ff-eb35692663dc
- How to Create a Flowchart in Word
To create a flow chart in Word,
- View > Gridlines
- Insert > Shape/Line or Text Box
Note that though I can create flowcharts in Word or PowerPoint, I can not export the flowchart to a png file from Word or PowerPoint on my Mac. So I end up using LightShot to take a screenshot.
But Word highlights words with mis-spelling:( The fix that, click 'Review' > Spelling and Grammar. Click 'Ignore' for every words it finds.
Powerpoint
How to Make a Flowchart in PowerPoint
Word
How to Create Flowcharts in Microsoft Word (The Easy Way)
draw.io
- It has an online and offline (open source) versions.
- For offline uses, it has a docker version too.
- The default file extension is an XML. We can export the graph to PNG, SVG among others formats.
- It includes several templates to use.
- Manual & tutorials
- The connector can be created directly from the shape itself through the blue triangle; see Tutorial 1: Creating a Diagram
- To create a text within an object, just double click it. To create a text outside objects, double click somewhere and start to enter the text. After that, just move the text to the location we want.
- It supports layers. Click View > Layers. The Layers panel/menu will be shown up.
- The default one is a 'Background'.
- If we add a new layer, the new layer will be shown on top of the 'Background' in Layers panel. It also uses light blue color to highlight the currently working layer.
- Small triangle next to each layer in the Layers menu allows users to move a layer to 'Back' or 'Front' relative to its neighbor layer. Of course, the top layer cannot go 'Front' and the bottom layer (eg Background) cannot go 'Back'.
- Use the checkbox to hide/show layers.
- Even in the same layer, we can move an object to back or front.
- There are different categories of shapes to use.
- The default one is 'General'.
- Misc category includes lists, tables, linked text, curly bracket, et al
- Flowchart category.
- Arrows category
- Android, iOS, ...