Search Results

Bespoke Microsoft training, data management, sales analysis and Excel consultancy from Gemma Coles. Trusted by the NHS, UK Government and pharmaceutical organisations. Get in touch. Gemma also offers Consultancy Services Gemma is dedicated to empowering individuals and businesses through her consultancy services. With a passion for helping others, she offers a diverse range of tailored solutions designed to meet the unique needs of each client. Whether you are looking for strategic guidance or practical support, Gemma is here to help you thrive. Let her expertise guide you towards success! Training & Coaching Microsoft is a powerful business suite, and Gemma is here to help you master it with tailored training and coaching. Whether you're an individual looking for 1:1 support or a business seeking group training, Gemma will create bespoke sessions designed to match your exact needs. From beginners to advanced users, training is practical, hands-on, and focused on building confidence and skills that you can apply immediately in your work. from £300 per session Data Management Effective data management is key to making informed business decisions. Using my advanced Excel expertise, I can help clean, organize, and refine data from CRM systems and other sources, ensuring accuracy and consistency. By removing duplicates, correcting errors, and structuring data effectively, I will transform raw information into a reliable, easy-to-use format that supports smarter analysis and better business insights. Analysis & Insights Turning raw data into valuable insights is key to making informed business decisions. Whether you need a one-off sales analysis report for presentations, funding discussions, or strategy sessions, or ongoing market analysis, Gemma can provide clear, data-driven reports tailored to your needs. Using Excel and PowerPoint, Gemma will transform your data into meaningful insights that help drive strategy and growth. Sales Strategy and Segmentation A strong sales strategy starts with understanding your data. Using advanced Excel skills, Gemma can analyse your sales, product, and market data to uncover key trends, identify customer segments, and highlight opportunities for growth. Through detailed sales segmentation, she can break down your customer base by demographics, buying behaviour, and profitability, helping you tailor marketing efforts, optimise pricing, and improve customer engagement. Whether it’s targeting the right audience, refining your product mix, or identifying underperforming areas, Gemma provides clear, data-driven insights to shape a smarter, more effective and efficient business strategy. Bespoke Template Creation "Gemma will create a custom Excel tool designed specifically for your business needs. Whether you’re looking to streamline sales planning, production, or logistics, the result will be a more efficient and simplified process tailored to your operations. Cost of Goods Analysis Gemma will build a strong and reliable pricing database that accurately calculates costs per unit, gram, or widget—factoring in all fixed, variable, direct, and indirect costs. Using my advanced Excel expertise, I’ll create a dynamic pricing tool that effortlessly adjusts to different scenarios, helping your business make informed decisions with ease. Testimonials "Gemma has has completed several projects for my department in the last month relating to data cleansing and master data. Her work has been exceptional, going above and beyond, treating these projects as if they were her own. She has suggested ways to improve data accuracy and provided outcomes that have meant we have the cleanest data sets ever in the organisation. As she completed the work, where there were questions over the validity of origin of records, she sought clarification be coming up with suggestions and action for our internal teams moving forwards. We would utilise Gemma as our first port of call whenever looking for excel, modelling, forecasting or master data projects. Her tenacity and responsiveness is second to none." Name: Tim A Working with us Smart Skills Academy is committed to operating as a responsible, ethical business. Our full governance documentation is available below: Modern Slavery & Human Trafficking Policy Anti-Racism Policy Our Commitment to Carbon Reduction Terms & Conditions Privacy Policy Refund Policy.

Excel Shortcuts — 40 essential Microsoft Excel keyboard shortcuts with step-by-step instructions, a quick reference guide, and a free video tutorial. Download free from Smart Skills Academy. Excel Shortcuts This guide is all about working smarter, not harder. Inside, you’ll find 50 essential Excel shortcuts designed to help you save time, boost productivity, and feel in control of your spreadsheets—whether you’re a complete beginner or looking to polish up your skills. Each shortcut has been carefully selected to make your day-to-day Excel tasks quicker and simpler. You’ll find: A clear explanation of each shortcut Step-by-step instructions Practical tips on when and why to use them You will be provided with; A Word document as a quick reference guide A video tutorial walking you through each shortcut in real time The Excel document I use throughout the walkthroughs. Let’s take the stress out of spreadsheets and help you feel smart, capable, and in control. This resource is FREE £0 Download Now More Questions? Return to Course Options

Master Microsoft Excel with 101 step-by-step video tutorials, 101 practice documents and 12 hours of content. Practical training from a Microsoft-certified trainer. Certificate included. Microsoft Excel Associate "If you need to master Excel, you absolutely must talk to Gemma. I was heading into a new job where Excel for reporting was non-negotiable. I felt nervous, but Gemma made the whole experience wonderfully easy and fun. I now feel totally confident using Excel in my new role, and I can't thank her enough!" — Hannah, Business Development Manager If Excel makes you anxious, slows you down, or leaves you quietly Googling how to do things you feel you should already know — this course is for you. Microsoft Excel is the most in-demand workplace skill in the UK, and yet most people are using a fraction of what it can do. This course changes that. Not with dry theory or overwhelming technical manuals, but with 101 short, focused video tutorials that show you exactly what to do, step by step, in real time. Every single lesson comes with a downloadable practice document and a walkthrough instruction sheet — so you're never just watching, you're doing. By the time you finish, you won't just understand Excel. You'll be the person in the room who actually knows how to use it. What's included: 101 step-by-step screen share video tutorials 101 downloadable practice documents — yours to keep 101 walkthrough instruction sheets for every lesson 12 hours of content covering everything from essential formulas to charts, formatting, and real-world data tasks Lifetime access — learn at your pace, revisit anything, any time A certificate of completion to add to your CV or LinkedIn profile View the syllabus Buy Now For £150 More Questions? Are these skills important? Excel Associate - The Outcomes After this course, you will: Stop second-guessing yourself every time someone sends you a spreadsheet Build and format Excel files from scratch with confidence Use formulas and functions that actually save you time — without needing to memorise them Produce professional charts and reports that look like you know exactly what you're doing Feel genuinely confident using Excel in front of colleagues, in job interviews, and in your day-to-day role Have a Microsoft-aligned certificate that proves your skill level to employers This course is ideal for anyone returning to work, moving into an admin or support role, freelancers managing their own data, or any professional who's tired of feeling behind every time Excel comes up. Preview the Course: View sample documents here.... Walkthrough Document Excel Workbook Tutorial Video Lab Preview a detailed step-by-step Excel tutorial showing how to Insert and configure a total rows on a table. Liked the Preview? Start the full course now! 48% of UK office workers have never received any formal Microsoft Excel training Acuity Ttaining 2/3 of all office workers use Excel at least once per hour Acuity Ttaining 750M people worldwide, use Microsoft Excel, which makes it the most widely used data tool on the planet. Microsoft 82% of middle-skill jobs and 65% of high-skill jobs has Microsoft Excel listed as a required skill. National Skills Coalition 12-20% Employees with advanced Excel skills earn on average 12–20% more than those without. Burning Glass / Harvard Business Scgool Why Excel skills matter

Master Microsoft Word with 55 step-by-step video tutorials, 55 practice documents and 6.5 hours of content. Practical training from a Microsoft-certified trainer. Certificate included. Microsoft Word Associate "Gemma makes learning enjoyable and straightforward. She’s highly knowledgeable, yet explains things in a way that’s clear, simple, and engaging. Her interactive style keeps all the sessions fun and memorable. Smart Skills Academy has been a fantastic experience all round!" — Xinqi, System & Process Improvement and implementation If Word makes you feel like you're constantly guessing — fiddling with formatting that won't behave, creating documents that never quite look professional, or avoiding features you know exist but have never figured out — this course is for you. Microsoft Word is the most widely used document creation tool in the world, and yet most people are only scratching the surface of what it can do. This course changes that. Not with dense manuals or overwhelming theory, but with 55 short, focused video tutorials that show you exactly what to do, step by step, in real time. Every single lesson comes with a downloadable practice document and a walkthrough instruction sheet — so you're always doing, not just watching. By the time you finish, you won't just be able to use Word. You'll be the person who actually knows how to use it properly. What's included: 55 step-by-step screen share video tutorials 55 downloadable practice documents — yours to keep 55 walkthrough instruction sheets for every lesson 6.5 hours of content covering everything from formatting and layout to tables, images, styles, and collaboration tools Lifetime access — learn at your pace, revisit anything, any time A certificate of completion to add to your CV or LinkedIn profile View the syllabus Buy Now For £120 More Questions? Word Associate - The Outcomes After this course, you will: Stop wrestling with formatting that refuses to do what you want Create clean, professional documents from scratch with confidence Use styles, templates, and layout tools that save you hours of manual tweaking Handle tables, images, and columns without the usual frustration Produce reports, letters, and documents that look like they were designed rather than just typed Feel genuinely confident opening Word for any task, however unfamiliar it looks This course is ideal for anyone who regularly creates documents at work or at home and wants to stop second-guessing every step. Whether you're returning to work, starting a new role, running your own business, or simply tired of producing documents that never look quite right — this is where that changes. Preview the course; View sample documents here.... Walkthrough Document Word Workbook Tutorial Video Lab Preview a detailed step-by-step Word tutorial showing how to Insert and configure a total rows on a table. Liked the Preview? Start the full course now! 40% of a professionals working week is spent creating or editing documents McKinsey Global Institute 1.2 Billion people worldwide use Microsoft Word each year! Techbloat 80% of job postings requiring Microsoft Office skills specifically mention Word proficiency Burning Glass / Harvard Business Scgool Why Word skills matter

Prepare young people for the workplace with practical Microsoft Excel, Word and PowerPoint training. Self-paced, certificate-included courses from Smart Skills Academy. Preparing the Next Generation Smart Skills Academy is the perfect companion to your academic journey, offering young people the opportunity to build essential digital skills that often go untaught in traditional classrooms. Whether you're crafting essays, creating presentations, or preparing for university and the workplace, our practical, step-by-step video tutorials will help you master Microsoft Office tools like Excel, Word, and PowerPoint with confidence. The course is completely self-paced, easy to follow, and fits seamlessly around your studies and extracurricular commitments. We will be here to hold your hand, while your confidence grows, every step of the way 92% of employers value basic digital skills World Skills UK 55% of 17-24 year olds cannot perform all 20 'Essential Digital Skills'. The Essential Digital Skills Framework, commissioned by LLoyds Banking Group, 2023. 69% of UK leaders believe their organisation is facing a digital skills gap. Microsoft and Goldsmiths, University of London 1/3 of employees believe their lack of IT skills prevent them from doing their job effectively. STL Skills Survey 18% Only of 17-24 year olds feel confident in their digital abilities World Skills UK Why these skills are so important Why Microsoft Office Skills Matter for Today’s Youth Bridging the Digital Skills Gap Despite being digital natives, many young people lack essential digital competencies. A report by FutureDotNow reveals that 55% of 18–24-year-olds in the UK cannot perform all 20 essential digital tasks required for work. Microsoft Office proficiency is among the most in-demand skills across various industries. A study highlighted that Microsoft Office ranks as the third most required skill in high-growth, high-salary positions. Enhancing Academic and Career Prospects Mastery of Microsoft Office tools directly correlates with improved academic performance and career readiness: Word: Develops writing and editing skills crucial for assignments and professional documentation. Excel: Enhances analytical and problem-solving abilities through data management and visualization. PowerPoint: Builds communication skills via the creation of compelling presentations. These competencies are not only vital for academic success but also highly valued in the workplace. Addressing Employer Expectations Employers increasingly seek candidates with advanced Microsoft Office skills. In the business services sector, there’s a notable shortage of applicants proficient in these tools. Furthermore, 69% of UK business leaders report facing a digital skills gap within their organizations, emphasizing the need for early and effective digital skills training. AI skills that will set you apart. AI is already changing the way people work — and by the time today's students enter the workplace, it will be an expectation, not an advantage. Yet most schools and colleges aren't teaching it. That means the young people who take the initiative to learn AI skills now will walk into interviews and first roles with something most of their peers simply don't have. Microsoft Copilot is built directly into the Office tools already used in most workplaces and universities. Knowing how to use it effectively — to draft documents, analyse data, build presentations, and write prompts that get real results — is the kind of practical, demonstrable skill that stands out on a CV and impresses in an interview. How Smart Skills Academy helps: My AI Essentials course is designed for complete beginners. There's no technical background required — just a curiosity to learn and the willingness to try. In just two hours, you'll go from "I've heard of AI" to confidently using it inside Word, Excel, and PowerPoint in ways that will save you time and make your work stand out from day one. Quick Links AI Essentials Excel Excel Tests Excel Shortcuts Word Word Tests Word Shortcuts Powerpoint PowerPoint Tests PowerPoint Shortcuts More Questions? Click here to read Frequently Asked Questions. Looking for Coaching? Gemma does offer 1:2:1 training, group coaching and bespoke training sessions. Click here for more info. Certificate of Achievement Once you have completed your course you have the opportunity to sit a multiple choice exam. If you gain the required 70% pass rate you will be sent a certificate of accomplishment - a valuable addition to your CV or personal statement. Microsoft Excel Associate Unlock the full potential of Microsoft Excel with our beginner friendly course. More Info

Test your Microsoft Word knowledge with multiple choice questions and practical timed tests aligned to the official Microsoft Word syllabus. Just £25 from Smart Skills Academy. Microsoft Word Tests This course includes a multiple choice workbook with 55 questions that will test your knowledge against the Microsoft Word Syllabus, a unique feature of this test is that there are hundreds of preloaded questions that will be selected at random meaning unlimited question combinations for you to work through. There are also 2 x 50 minute practical test that mimics the official Microsoft Word exam. View the syllabus A sample of the multiple choice test. Buy Now For £25 More Questions?

We can’t find the page you’re looking for This page doesn’t exist. Go to Home and keep exploring. Go to Home