Optimsxl

22/05/2025

As your Microsoft 365 support professional, I will help you add tools to your Business Management Toolboxes to optimise Office 365 for your Business Decision-Makers.

Tools in Excel include
• Live Dashboards
o Automatic identification of outliers by date, value, or classification
o Automatic flagging of critical changes like missed targets or deadlines
• Live Links to External Data Sources
o Reconciling and matching data from multiple sources
o Highlighting inconsistencies and missing entries
• Live Multi-User Access through the Web
o Protection of workbook layout and formulas
o Data validation of data inputs
• Live Branded Reports and/or Summary Snapshots
o Automation of repetitive tasks
o Automatic tracking of data trends and behavioural patterns

Book a free online consultation today and start working even smarter!
Book now at https://bit.ly/KirstinBookings

12/05/2025

Meet Kirstin, your Microsoft 365 Maestro with over 30 years of experience boosting productivity and optimising workflows.

- She transforms Excel sheets into powerful mini-apps, making data tracking effortless and insightful.
- Your PowerPoint presentations? She’ll turn them into captivating showstoppers that spark conversations.
- Word documents? She elevates them into must-read, reference-worthy materials.

Kirstin ensures you get the most out of Microsoft Teams, Outlook, Sway, OneNote, and more—so you can focus on what matters most: your business.

Book a free online consultation today and start working even smarter!
Book now at https://bit.ly/KirstinBookings

16/04/2025

Do you spend hours trying to make sense of data from different teams, systems, or formats?

I specialise in:

✅ Reconciling and matching data from multiple sources
✅ Highlighting and fixing inconsistencies and missing entries
✅ Spotting outliers and trends that might cost your business

I turn chaotic spreadsheets into clean, reliable datasets — built to scale and save you time.

With automated summaries and dashboards, you’ll never waste another minute manually refreshing reports.

📞 Let’s talk if you need clean, connected, actionable Excel solutions.

25/03/2025

HOT TIPS | MICROSOFT OUTLOOK | EMAIL MESSAGES

In Outlook, use CTRL + N to generate a new blank email message.

HOT TIP #1: Aim for at least seven words in your Subject Line for efficient mail management.

HOT TIP #2: Aim to use the word YOU three times in the opening paragraph.

QUICK PARTS AND AUTO TEXT

On the Ribbon, Insert > use Quick Parts to save and apply paragraphs of similar content to any email message.

On the Ribbon, File > Options > Spelling & AutoText > use AutoText to save and apply paragraphs of similar content to any email message.

MESSAGE OPTIONS

> Custom Reminders - create your own message/text to appear in the Reminder pop-up window for both you and the receiver.

Calendar Extract - Insert a portion of your Calendar so that your recipient can find a mutually suitable free time slot for a meeting with you.

> Voting Buttons - create your own and refer to them in the message for a rapid response.

> Delay Delivery - Set up emails created after-hours so that they are only sent during working hours.

> Direct Replies To - allows for replies to your message to be sent to other relevant parties.

MESSAGE FORMATTING

> Horizontal Lines and Borders - make use of these features to break your message into small chunks of information instead of using underlining.

> Font Formatting - make use of colour and uppercase to draw attention to important keywords and details in your message.

> Hyperlinks - with the words CLICK HERE typed and selected, make use of CTRL + K to create a hyperlink that doesn’t show the ugly long web address.

23/03/2025

Strategic Management eServices is a collaborative partnership that offers a unique blend of
• Microsoft Training and Automation,
• Administrative Support,
• and Virtual Assistance,
which combines tech-savviness, intuitive problem-solving, smart decision-making, and prompt action.

This distinct approach sets us apart in providing services to Small and Medium Enterprises.

With more than 30 years of experience each

Optimsxl is your Microsoft Maestro.
A productivity consultant and support professional who will show you how to turn your Office 365 subscription into optimisation tools and that there is an easier and more exciting way to complete and present your daily tasks utilising all Microsoft products.

DLS The Admin Specialist is your skilled and experienced administration specialist with a solid background in executive assistance.
Advanced business and technical acumen, combined with excellent qualifications, ensure a thorough understanding of effective processes and systems, including the resolution of issues and the implementation of appropriate improvements.

Executive Virtual Assistant brings a wealth of knowledge and broad-based business acumen.
This includes experience in Human Resource and Industrial Relations, Contractual Law and Litigation, Operational Implementation and procedure, Administration, Management Principles, and Finance.

Together, we offer the gold standard in small and medium business management support services.

If you would like to learn more about us individually, we invite you to visit our social media pages.
Contact details are also available therein to you.

20/03/2025

There are Microsoft keyboard shortcuts, which are keys or combinations of keys that provide an alternative way to do something you would typically do with a mouse.

Examples of these are

Place your cursor where you want to start, then

Ctrl + Shift + down arrow = Select a paragraph

Shift + down arrow = Select a line of text

Ctrl + A = Select all text

Ctrl + Down arrow = Move the cursor forward to the beginning of the next paragraph

Ctrl + Left arrow = Move the cursor backward to the beginning of the previous word

Ctrl + Right arrow = Move the cursor forward to the beginning of the next word

Ctrl + End = Move the cursor forward to the end of the document

Ctrl + Home = Move the cursor backward to the beginning of the document

18/03/2025

Microsoft updates are important and happen frequently for a few reasons:

• Security: Updates often include fixes for new security issues. They protect your computer from viruses and hackers.

• Bug Fixes: Updates also repair software bugs, making your computer work better.

• New Features: Sometimes, updates add new features to your software.

However, updates can sometimes cause issues. If this happens, here is what you can do:

• Turn Off Auto-Updates: You can control when updates happen. Turn off automatic updates, but remember to check for them yourself.

• Wait: Do not rush to update. Wait a few days to see if others report problems.

• Backup: Before updating, copy your computer files. If there is a problem, you can restore it.

10/03/2025

How much time are we all losing searching for that one file? You know that one file that holds one powerful paragraph that you wrote, making yourself so proud of how perfect that paragraph illustrated your service or product offering.

Who was it? When was it? Oh, where is that file?

We would not be experiencing this frustration if we had a master template that held all our perfect, powerful paragraphs in one place. It is easier to delete unnecessary paragraphs in the document for that new client’s proposal instead of losing so much time searching across multiple files and folders and drives.

HOT TIP OF THE WEEK: Create a single master template in Microsoft Word, and save it as a template. With a few quick clicks, you will always have those powerful, perfect paragraphs ready to go.

08/03/2025

How often have you found yourself chasing a deadline at the eleventh hour, or worse: chasing someone else at the eleventh hour.

Use Outlook’s Custom Reminders to help YOU, AND YOUR TEAM keep those looming deadlines and make those appointments on time every time.

In your Email Message, in the FOLLOW-UP FLAGS drop-down list, select ADD REMINDER…

You can capture your relevant message and clear message in your Reminder Wizard window in the FLAG TO textbox.

You can ALSO capture a relevant and clear message that will appear in the Reminder Wizard window of your Email Recipients in the FLAG TO textbox under FLAG FOR RECIPIENTS.

Give your Email Recipients enough time to come back to you before your Reminder Wizard reminds you to follow up with them by having different dates and times under the REMINDER details options.

Have a look at this example of setting up Custom Reminders in my post's image.

07/03/2025

HOW TO backup Microsoft Outlook | Backup Outlook for Business

This HOW TO video is a sneak preview of the support that Kirstin Bosworth can deliver in online training and coaching sessions. Stay tuned for details of the e-learning platform offering full courses.

HOW TO backup Microsoft Outlook | Backup Outlook for BusinessStep 1 – Ensure Outlook is closedSTEP 2 – Using Windows Explorer, find MY PC, then the DOCUMENTS...

01/03/2025

LOCKED OUT!
Struggling to open a LOCKED Excel File where you are the only one working on it…

Follow these steps to gain control again!
To release the lock on an Excel file …

CLOSE EXCEL: Ensure that all occurrences of Excel are closed

FIND FOLDER: Start Windows Explorer, and then browse to the folder that contains the Workbook file that you tried to open when you received the error message

HIDDEN FILES IN SHARED DIRECTORY: Edit the Folder properties so that SHOW HIDDEN FILES, FOLDERS, DRIVES is checked and uncheck the box for HIDE PROTECTED OPERATING SYSTEM FILES
and/or HIDDEN FILES IN OWN DIRECTORY: Select TOOLS > FOLDER OPTIONS > on the VIEW tab > ADVANCED SETTINGS > select HIDDEN ITEMS > select FILE NAME EXTENSIONS

DELETE OWNER FILE: The owner file will be in the same folder as the locked Workbook you tried to open. The owner file name uses the following convention: It begins with a tilde (~), followed by a dollar sign ($), followed by the remainder of the Workbook file name. The file name extension is .xlsx (For example, the owner file for MyWork.xlsx will be named ~$Work.xlsx)

RESTART APP: Restart Excel and open the Workbook file

27/02/2025

HOW TO create a signature in Outlook

This HOW TO video is a sneak preview of the support that Kirstin Bosworth can deliver in online training and coaching sessions.

Stay tuned for details of the e-learning platform offering full courses.

HOW TO create a signature in OutlookStep 1 – With an email message open, copy your email signature (already designed, formatted and complete)STEP 2 – On the ...