Training courses
Add to training material - Place where relevant:
Snipping Tool - Copying text out of pictures: Recording-20240711_
Word:
ascii for “No Entry” sign Alt+128683
Letter "ó" Alt+0243
Cannot FIND Two Chevrons: If you search for <>, the result will be "No results found", so search for < and then for > separately
Cannot find the ASCII Code for the Crosshair Cursor Symbol
Q. I try to delete a new page at the end of the file but however much I try, it doesn't work!
A. Copy a Paragraph Return from elsewhere in the same (or an another) document and then select the last blank part of the document. Now with the selected blank space, paste the copied Paragraph Return and then press the Backspace Button.
Q. How can I use the Find dialogue box to search for Table elements?
A.
How to find / Replace / Insert Cell Marker: See Word code for end-of-cell mark. On replace special character a - Microsoft Community
Outlook:
When the InBox looks empty and the following message displays "Currently displaying all messages newer than 12 months", you can change this by following the instructions: How to see more than 12 months worth of emails on Outlook? However, depending on the number of eMails, see what the IT Helpdesk says: Please do not change the sync date to "All" as this will slow down your Outlook massively due to the sheer size of your inbox. In regards to searching for those emails, I suggest one of the two: Make your search as detailed and as specific as possible. Use the filters (date from to date to), add a specific sender, etc. or Use Outlook on the web for finding these as that is where it will display you loads more results than the Outlook app search feature.
search a string of text by removingthespaces: example: If you search for "automatic" and "replies" will not work as effectively as "automaticreplies"
reducing image sizes, image attachments in emails: Recording-20240716_
How to print Memo Style double sided?
"field chooser" "outlook" "in folder" - Google Search
How to setup and cancel automatic confirmation of Meeting invitations
Tip #41 - Outlook - Creating Meeting Appointments from Emails
This is one of the most useful new features of Outlook I used in 2024. Such a simple way to create meetings from Emails.
I also forgot to mention that it doesn't only work with meeting appointments, if you use tasks you can do exactly the same by dragging the email into your tasks icon to create a new task, secondly it also works with contacts, so if you receive an email you haven't got in your contacts, just drag and drop the email to the people icon and it will create a new contact with all the users info in there.
Any questions let us know.
Recording-20250109_112812.webm
Shortcuts
Q. When I try to paste text with a picture the following warning appears:
See the attached file, which is a screenshot of a computer description automatically generated
A.
Q. How do you set one of the dozen or so Calendars in Outlook to be the default one?
A.
Q. I received an eMail message but it looks completely blank.
A. Restart Outlook and this problem should go blank...
When an eMail is sent from an eMail system - i.e. not by a human being... then the message does not have the option to React - e.g. with a smiley or a "thumbs up".
Excel:
Focus Cell - See: Recording-20241205_
Shortcut How to enter the time into a cell
Excel tip: How I use conditional formatting to automate my
Excel spreadsheets like a pro https://www.xda-
To calculate the percentage difference between two numbers in Excel, you can use the following formula:
=(New Value - Old Value) / Old Value * 100
For example, here's how you can apply it:
- Enter the old value in cell A1 and the new value in cell B1.
- In cell C1, enter the formula: =(B1 - A1) / A1 * 100.
- Press Enter to get the percentage difference.
For example, if the old value is 50 and the new value is 75, the formula will be =(75 - 50) / 50 * 100, which results in a 50% increase.
If you need to calculate the absolute percentage difference (ignoring whether the change is an increase or decrease), you can use the ABS function:
=ABS((New Value - Old Value) / Old Value * 100)
This will give you the percentage difference without considering the direction of the change.Quick Analysis - What is it and How to
Learn a trick or two in Excel: Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond | SpringerLink
Paste multiple items: Clipboard in Windows - Microsoft Support
How to remove yellow tip notes comments from Cells Erasing floating comment on excel - Microsoft Community
Excel - Importing PDF tables: Recording-20240711_
Warning: "Do you want to mak ethis file a trusted document?", with Tick box "Do not ask me again for network files", Yes / No
Share OneDrive files and folders - Microsoft Support
To change text from uppercase to lowercase in Excel, you can use the `LOWER` function. Here’s a step-by-step guide:
### Using the LOWER Function
1. **Identify the Cell with Uppercase Text:**
- Suppose cell A1 contains the text "HELLO".
2. **Use the LOWER Function:**
- In a new cell (e.g., B1), enter the formula:
```excel
=LOWER(A1)
```
- This will convert the text in A1 to lowercase and display "hello" in B1.
3. **Apply to Multiple Cells:**
- If you have a range of cells (e.g., A1:A10) that you want to convert to lowercase, you can apply the formula to each cell in the range:
- In cell B1, enter:
```excel
=LOWER(A1)
```
- Drag the fill handle (a small square at the bottom-right corner of the cell) down from B1 to B10 to apply the formula to the rest of the cells.
### Copying and Pasting as Values
If you want to replace the original uppercase text with the lowercase text, follow these steps:
1. **Convert to Lowercase Using the LOWER Function:**
- Follow the steps above to convert the text using the `LOWER` function.
2. **Copy the Lowercase Text:**
- Select the cells with the lowercase text (e.g., B1:B10).
- Right-click and choose "Copy" (or use `Ctrl+C` / `Cmd+C`).
3. **Paste as Values Over the Original Text:**
- Select the original cells with the uppercase text (e.g., A1:A10).
- Right-click and choose "Paste Special".
- In the "Paste Special" dialog, choose "Values" and click "OK".
This will replace the original uppercase text with the lowercase text.
### Example
Let's say you have the following data in column A:
| A |
|---------|
| HELLO |
| WORLD |
| EXCEL |
| FORMULA |
1. **In column B, use the LOWER function:**
| A | B |
|---------|---------|
| HELLO | =LOWER(A1) |
| WORLD | =LOWER(A2) |
| EXCEL | =LOWER(A3) |
| FORMULA | =LOWER(A4) |
2. **After applying the LOWER function:**
| A | B |
|---------|---------|
| HELLO | hello |
| WORLD | world |
| EXCEL | excel |
| FORMULA | formula |
3. **Copy the lowercase values from column B to column A using "Paste Special" > "Values".**
After these steps, your data will look like this:
| A |
|---------|
| hello |
| world |
| excel |
| formula |
This method ensures that your text is converted from uppercase to lowercase efficiently.
Tip #37 - Excel - Extracting data from a cell: Viva Engage - Conversation (cloud.microsoft)
How to compare or remove horizontally-duplicated values, when a value appears in two Columns on the same Row, using the TRUE/FALSE (or “Match”/“Mismatch”) result in a new - third Column? How to Compare Two Columns in Excel (for matches & differences)
Tip #36 - Excel - Export your calendars to Excel Recording-20240821_
Tip #35 - Microsoft Edge - Toolbar Functionality - Tools,
Outlook, Teams etc. Recording-20240821_
imposition pdf free - Google Search
howto save word to wiki file format - Google Search - https://www.microsoft.com/en-u
Contact - Bottom Line Marketing Group (bottomlinemg.com)
http://tubesyz.com/filemaker-
Will Kintish is the UK's leading authority in Business and Social Networking Skills training.
Kintish helps thousands of people become confident and effective networkers by offering networking tips, techniques and training.
Bite Size, Minutes of Learning Saving You Time Forever (bitesizeltd.com)
How to
https://www.howtogeek.com/
https://www.globaledulink.co.
Training
http://uk.siteslikesearch.com/
http://www.training-classes.co
Bring along Shaye Berger and Shmuel Edel to Work Avenue
https://www.catglobal.com/
https://www.learningpeople.
gMail Training - Example: How to Find in gmail: from:(y.b.daskal@gmail.com) OR to:(y.b.daskal@gmail.com)
https://www.linkedin.com/
Ezra Ezekiel and Mr Charles Petrook 43 Elliot Road London NW4 3DS.
http://www.elearning-cegos.fr/
http://www.openculture.com/
Maximum number of characters - count this text so to know how many letters may be used in the samsung handset before it turns into an eMail message automatically:
ActivInspire Online Training Courses
https://promethean.helpjuice.
http://www.prometheanplanet.
Q. How to fix problems with google drive "ERR_QUIC_PROTOCOL_ERROR" in Edge or in Chrome
A. If nothing helps - even after closing the application and restarting, do this: Switch another Google Drive that is open is your Browser and then click the GoogleAccount Drop-Down-Menu. From there click the Account for which you're trying to open the Google Drive for and bob's your uncle!" If this also doesn't help, delete your Browser Cache. If this doesn't help, see: How to fix the message "drive.google.com uses an unsupported protocol." "ERR_SSL_VERSION_OR_CIPHER_MISMATCH" - Google Search
F7 = Spell Checker: Before you hit the Send Button on your eMail message, please place the text into a MSWord file. Then hit the F7 Button (on top of the numbers 7 & 8 of the keyboard). When finished, place the corrected text into your eMail message and hey presto, your message now makes [more] sense! As an example, here is the message that you sent me about 40 minutes ago, but after it has been corrected by the Spelling Checker of MSWord:
