Our tailored solutions will help streamline your processes and automate workflow. Our goal is to listen to your requirements and create templates or automated and time efficient solutions to collect and analyse data and produce multiple reports and documents.Learn More
Increase productivity and efficiency in the workplace by unlocking the power of Office 365 applications. We help drive your business forward by providing flexible options for effective staff training which can be tailored to your exact needs.Learn More
This course is intended to help all users get started with Teams, use messages and channels, communicate in different ways, and customise Teams settings. On completion of this course, delegates will be able to create and join Teams, add team members, join in conversations and chats, work in Channels and join and create a meeting.Learn More
Word 2013 / 365 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.Learn More
In this course you will create more complex documents that include lists, tables, charts, graphics, and newsletter layouts. You will also merge data into documents to personalise correspondence and address envelopes and labels.Learn More
Office 2010-365. Our Microsoft PowerPoint Introduction course is suitable for complete beginners to Microsoft PowerPoint or used as a refresher.Learn More
2013 / 365 This course has been designed for users who already have an understanding of PowerPoint but would like to improve their skills.Learn More
This Microsoft Word 2013 / Office 365 Advanced training course is for anyone who works with lengthy documents, collaborate with others, or create forms. This course will show you how to use Word efficiently to accomplish these tasks.Learn More
Word 2013 / Office 365 A half-day training course where you can learn the very useful features of how to mail merge and how to use graphics, icons and photographs to create eye-catching documents.Learn More
2013 Office 365 In this course, you will explore the advanced features provided with the Outlook interface, such as advanced message, calendar, and contacts management. You will also spend a lot of time on Tasks and learn ways to organize your list of things To-Do in a way that will make you more productive.Learn More
2013 / Office 365 This half-day course is designed for all users of Microsoft Word and shows how to set up electronic forms and also looks at the basics of recording macros.Learn More
2013 / Office 365 This one-day course starts at the beginning and designed for first-time users of Microsoft Excel. It introduces entering and editing cells and simple statistical functions and it also covers setting up a layout and how to create charts quickly.Learn More
2013 / Office 365 If you have used Microsoft Excel for a while but have never really looked at what it can offer you then this one-day course covers features of Microsoft Excel beyond the basics that many self-taught users are familiar with including charts and sparklines, functions, filtering, and cell referencing.Learn More
2013 / Office 365 If you have been using Excel for some time now and want to take it further and develop more functionality in Excel then this one-day course covers features for experienced users of Microsoft Excel, and is an ideal follow-on from the Beyond the Basics course. We look at worksheet revision, advanced formatting and functions, using external data, data validation, pivot tables, scenarios, and what-if analysis.Learn More
Overview: This half day course is designed for those who require a greater knowledge of the more advanced features of Excel. This is a 'power-user' half day course packed full of tips and tricks and where you will learn advanced functions. You will learn about how pivot tables are used to analyse data and best practice on how to effectively set out raw data to create pivot tables.Learn More
Microsoft Office Solutions Expert (Owner)
“I set up SME Office Support in 2014 to help sole traders and SMEs harness the power of Microsoft Office applications, work SMARTER and reach their business goals.”
Software Developer - VBA and C# .Net.
"Whether it's a full end to end systems or small report generators my goal is to automate the process and make IT work so the user doesn’t have to"
"I believe most businesses need digital support and experienced office management. I've developed skills and knowledge to quickly untangle a maze of systems and I enjoy the challenge."
Kandi has been with the owner since the start in 2014. The Yorkshire Terrier in her makes her a loving part of the business although feisty at times. The Border Terrier part of her makes her high energy with a great personality. She's loyal and fearless which means her job as security is perfect.
Our client, Rachel Hayward, is a professional bid writer, business consultant and lead consultant for Ask the Chameleon, an awards and tender writing company. Rachel’s background includes organisational development and an exceptional HR career. Due to her extensive private and public sector bid and tender writing experience, she has successfully secured £12m in funding for Ask the Chameleon clients.Rachel believes strongly in the power of networking connections and has been nominated for a whole host of awards for her business. Ask the Chameleon has won the Small Business 100 Award and the Federation of Small Business - East Midlands Micro-Business of the Year 2019.
SME Office Support met Rachel at a networking meeting in Derby. During our conversation, she discovered that we offered bespoke automated solutions using MS Office applications. Rachel needed help creating, managing and tracking invoices quickly and efficiently. She also wanted an instant way to view how her business was performing financially.We had a 1-2-1 and discussed how we could help improve Rachel’s current finance system. Through this fact-finding exercise, we gained a better understanding of her business goals and current processes, as well as discussing key areas for improvement and her wish list.Rachel explained that time was essential; she needed to be able to continue to grow her business and to deliver a high standard of service to both existing and new clients.
Rachel recognised the current system she’d created to manage her business finances and invoices was inefficient, disjointed and time consuming. As her business was growing, she had neither the time nor skills to be able to improve the invoice process to the level she required. Her current finance and reporting system for sales, invoices and budgets was created using separate Excel and Word files.
Following our initial meeting, SME Office Support signed a Confidentiality Agreement. This enabled Rachel to be able to confidently send through her working files in Excel and Word, which she had been using to manage her business finances.
The consultation and following documents were key to helping SME Office Support gain a solid understanding of the business requirements, so that a bespoke, automated solution could be designed and developed. From this information, an Outline Specification document was created, summarising the key elements of a customised solution for Rachel’s specific business needs.
Once the system specification was agreed with Rachel, a Booking Form with T&Cs, along with a quotation including project timescales, were both signed to enable the work to commence. The project was designed using Excel with Visual Basics for Applications (VBA).
Interim deliverables were sent to Rachel to review and test throughout the system build, which included the following key features:
The following improvements were made to Rachel’s finance system: