Training courses
Add to training material - Place where relevant:
info@shufra.org.il
Snipping Tool - Copying text out of pictures: Recording-20240711_112647.webm (sharepoint.com)
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:
https://support.microsoft.com/en-us/office/view-email-messages-by-conversation-in-outlook-0eeec76c-f59b-4834-98e6-05cfdfa9fb07#PickTab=Classic_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_215514.webm (sharepoint.com)
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
https://unitedsynagogue-my.sharepoint.com/:v:/g/personal/mshear_theus_org_uk/EY0TtHLxDGhCgGl-HK61tp0BhEBFJlr1r1r-ua0dGrLzvw?nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D&e=3DBus3
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_144736.webm
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-developers.com/conditional-formatting-automate-excel-spreadsheet/
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_094351.webm (sharepoint.com)
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_135405.webm https://unitedsynagogue-my.sharepoint.com/:v:/g/personal/mshear_theus_org_uk/EWS4q-CzxphAjkCoNTLJyqUBA3FLJXS1Vm7Utk8vuDo6LA?e=5HOhEj&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D
Tip #35 - Microsoft Edge - Toolbar Functionality - Tools,
Outlook, Teams etc. Recording-20240821_105314.webm User defined
image https://unitedsynagogue-my.sharepoint.com/:v:/g/personal/mshear_theus_org_uk/Ef69nidva5RFuNJPEypw-XwB3NUTfikZFh2Rpq7m0juZYA?e=3SOVFE&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbFZpZXciOiJTaGFyZURpYWxvZy1MaW5rIiwicmVmZXJyYWxBcHBQbGF0Zm9ybSI6IldlYiIsInJlZmVycmFsTW9kZSI6InZpZXcifX0%3D
imposition pdf free - Google Search
www.jawspdf.com
howto save word to wiki file format - Google Search - https://www.microsoft.com/en-us/download/details.aspx?id=12298
Contact - Bottom Line Marketing Group (bottomlinemg.com)
http://tubesyz.com/filemaker-cloud-90-second-overview-filemaker-cloud-filemake-pro-15-training/
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.
www.teachingstrends.co.uk
https://takelessons.com/
http://www.gbbo.co.uk/OnlineTraining/?utm_source=google&utm_medium=non-brand-cpc&utm_campaign=control-region&utm_term=%2Bwebsites
Bite
Size, Minutes of Learning Saving You Time Forever (bitesizeltd.com)
How to
https://www.howtogeek.com/735876/how-to-group-and-animate-objects-in-microsoft-powerpoint/
https://www.globaledulink.co.uk/
Training
http://uk.siteslikesearch.com/sites-similar-to/reachtms.co.uk
http://www.training-classes.com/
Bring along Shaye Berger and Shmuel Edel to Work Avenue
http://www.pass4sure.com/
https://www.catglobal.com/CATGlobal8/default.asp
https://www.inst.org/
https://www.learnsocial.com/
https://www.learningpeople.com/uk/courses/it-courses/
https://www.walkme.com
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/learning/me
Ezra Ezekiel and Mr Charles Petrook 43 Elliot Road London
NW4 3DS.
http://www.elearning-cegos.fr/
www.strategyeducation.co.uk
https://www.edx.org/
https://eu.udacity.com/
https://www.coursera.org/
http://www.openculture.com/freeonlinecourses
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.com/promethean-planet-users?kb_language=en_US
http://www.prometheanplanet.com/en-us/index.html
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:
