**Course Title: **Microsoft Excel 365: Mastering Excel Formulas

**Course Duration:** 3 Hours

**Course Overview:**
This course is designed to equip participants with a comprehensive understanding of the top Excel formulas essential for data analysis and manipulation. Starting from fundamental functions like SUM and AVERAGE, participants will progress through intermediate functions such as IF and COUNT, and advance to complex formulas including XLOOKUP and CONCATENATE. Additionally, participants will explore bonus formulas to handle errors, calculate dates, manipulate text, and more. By the end of the course, participants will have the skills to efficiently use Excel formulas to streamline their data tasks and improve productivity.

**Course Outline:**

**Module 1: Foundations of Excel Formulas (30 minutes)**
- Introduction to Excel formulas
- Understanding cell references (relative, absolute, mixed)
- Basic arithmetic operators (+, -, *, /)

**Module 2: Essential Formulas for Data Summarization (60 minutes)**

1. SUM: Summing up numerical data
2. AVERAGE: Calculating the average of numerical data
3. MAX and MIN: Finding the maximum and minimum values in a range
4. COUNT and COUNTA: Counting cells with data and non-empty cells respectively
5. CONCATENATE: Joining text strings together

**Module 3: Logical and Conditional Formulas (45 minutes)**

1. IF: Implementing conditional logic
2. COUNTIF and COUNTIFS: Counting cells based on a single criterion and multiple criteria respectively
3. SUMIF and SUMIFS: Summing cells based on a single criterion and multiple criteria respectively
4. AVERAGEIF and AVERAGEIFS: Calculating average based on a single criterion and multiple criteria respectively
5. IFERROR: Handling errors gracefully in formulas

**Module 4: Advanced Formulas for Data Analysis (45 minutes)**

1. XLOOKUP: Advanced lookup function for searching in columns or rows
2. UNIQUE: Extracting unique values from a range
3. DAYS: Calculating the difference in days between two dates
4. NETWORKDAYS: Counting the number of workdays between two dates
5. LEFT, RIGHT, and MID: Extracting substrings from text
6. TRIM: Removing extra spaces from text

**Module 5: Practical Applications and Exercises (45 minutes)**

- Practical examples demonstrating the application of learned formulas
- Hands-on exercises to reinforce understanding
- Q&A session to address participant queries

**Module 6: Integrating Formulas for Basic Data Analysis (15 minutes)**

- Understanding formula nesting: Using formulas within other formulas
- Combining formulas: Creating complex calculations by combining multiple functions
- Case study: Applying multiple formulas to analyze a dataset
- Hands-on exercise: Building a basic data analysis model using integrated formulas
- Tips for efficient formula usage and troubleshooting common errors

**Conclusion and Recap (15 minutes)**

- Review of key concepts and formulas covered in the course
- Recap of practical applications and case studies
- Final Q&A session and feedback collection

**Break**

The Course will also include a 15 minute break half way through 

**Bonus:**

Participants will receive either a PDF or Printed Manual to work alongside this course that they are able to take home with them 


Microsoft Excel 365: Mastering Excel Formulas

Melissa Richards

Superb course - well pitched and really interesting. Learnt a lot about formulas and will be looking to attend pivot tables next

catherine Burns-Sweeney

Amiee was brilliant at explaining and giving examples, she also takes the time to oversee you if you are not sure, I learnt a lot from this course, however I need more training and put into practice, Highly recommend :)

Master some of the best Excel formulas in 3 hrs: Learn SUM, IF, XLOOKUP & more to enhance data tasks & boost productivity.

Question 1

Do you have any previous experience using this software? If yes what? 

Question 2

Is there anything specific you wish to learn from this session?

Question 3

Anything else you'd like to learn?

Unlock the potential of Microsoft Excel with our Excel Level 1 course, designed to empower you with the essential skills and knowledge needed to excel in the world of spreadsheets. Whether you're a complete beginner or looking to reinforce your foundational Excel skills, this course is tailored to your needs.

**Course Duration:**  3 Hours


**COURSE OUTLINE**

- **Course Overview:** Excel Level 1 is the first step in your journey to Excel mastery.
- **Course Objectives:** Develop a strong understanding of Excel's fundamentals, including navigating the interface, creating formulas, and formatting workbooks.

**Lesson One: Getting to know Excel**

- Master the basics of Excel and its interface.
- Microsoft 365 Excel: Introduction to the latest Excel features.
- What are Spreadsheets, Worksheets, and Workbooks?
- What are Columns, Rows, Cells, and Ranges?
- The Excel Interface: Explore the essential components, including the Ribbon Interface and Quick Access Toolbar.
- Worksheet Referencing Elements: Learn how to navigate and reference cells within worksheets.
- Navigating in Excel: Discover various navigation options, including keyboard shortcuts.
- The Ribbon: Uncover the functionality of the Ribbon.
- The Backstage View: Explore file management and Excel 365 file formats.

**Lesson Two: Formulas and Functions**

- Harness the power of Excel formulas and functions.
- Elements of an Excel Formula: Understand mathematical operators and order of operations.
- Types of References: Learn about relative, absolute, and mixed references.
- Excel Formulas: Utilize the Formula Bar, AutoFill, and Flash Fill.
- About Functions: Explore built-in functions using AutoComplete and the Insert Function Dialog Box.
- Practice using Formulas and Functions for data manipulation.
- Selecting Cells: Master essential commands, shortcuts, and data manipulation techniques.
- Inserting Rows and Columns: Customize your worksheets.

**Lesson Three: Formatting a Workbook**

- Enhance the visual appeal of your Excel workbooks.
- What is a Font?: Learn about fonts and the Font Group.
- The Format Cells Dialog Box: Explore advanced formatting options.
- Alignment Options: Control text alignment and indentation.
- Merge & Centre Options: Improve data presentation.
- Renaming Worksheet Tabs and Changing Tab Colour: Organize and customize your worksheets.

**Lesson Four: Printing and Exporting as PDF**

- Learn to prepare and share your Excel documents effectively.
- The Print Options in Backstage View: Configure your printing settings.
- Page Setup Dialog Box and Print Preview Option: Control page orientation, print areas, and preview your work.
- Export As PDF and Save As: Share your documents in different formats.


**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Microsoft Excel 365 - Level 1

Excellent enviroment, made to feel welcome and full support, training also not rushed.

Master Excel with our Level 1 course—gain essential skills to excel in spreadsheets and unlock your potential!

Do you have any previous experience using this software?  If so,  please elaborate?

Is there something specific you are hoping to learn on this course?  

One-to-one computer training offers an ideal solution for individuals interested in a variety of computer topics, or seeking highly focused instruction. This personalized approach allows for an in-depth exploration of specific topics or challenges that matter most to the learner. Whether it's troubleshooting issues with your computer setup, understanding software applications, or fine-tuning your computer for optimal performance, one-to-one training ensures that your unique needs and questions are addressed directly. 

One-to-one computer training conducted in the comfort of your home or office offers an ideal solution for individuals facing a variety of computer issues or ...

One-to-One Computer Help (We come to you)

What is the issue you are facing?

Please give the brand/ make of the device you are having issues with (no worries if you do not know).

Is there a day/ time that suits you best (please offer a variety of times/ dates)

Question 4

Anything else you would like to add?

One-to-one computer training conducted in the comfort of your home or office offers an ideal solution for individuals facing a variety of computer issues or seeking highly focused instruction. This personalized approach allows for an in-depth exploration of specific topics or challenges that matter most to the learner. Whether it's troubleshooting issues with your computer setup, understanding software applications, enhancing cybersecurity practices, or fine-tuning your computer for optimal performance, one-to-one training ensures that your unique needs and questions are addressed directly. The convenience of at-home or in-office training makes it even more accessible, providing a tailored and supportive learning environment that empowers individuals to gain the knowledge and skills they need to overcome challenges and achieve their computer-related goals.

One-to-One Computer Help (You come to Us)

**Microsoft Outlook 365 Beginner Level 1 - Course Outline**


Unlock the full potential of Microsoft Outlook 365 with our Beginner Level 1 course. This comprehensive outline is designed to provide you with a solid foundation, ensuring you navigate through emails, calendars, contacts, tasks, and more with confidence.

**Course Duration:** 3 Hours


**COURSE OUTLINE**


- **Course Overview: ** Outlook Level 1 is your entry point into mastering the essential features of Microsoft Outlook 365.
- **Course Objectives: ** Acquire a robust understanding of Outlook's key functionalities, from handling emails and managing calendars to organizing contacts, tasks, and notes.

**Lesson One: Navigating Outlook**

- Explore the basics of Outlook navigation.
- Emails and Email Addresses: Understanding the essentials.
- Layout Exploration: Ribbon bar, backstage view, and more.
- Items and Folders: An in-depth look at organization.
- Ribbon Bar Sections: Delving into each section's functionalities.

**Lesson Two: Mail Management**

- Dive into the world of emails and mail folders.
- Mail Workspace: Understanding the mail environment.
- Read/Unread Emails: Navigating through messages.
- Message Icons: Decoding visual cues.
- Composing Emails: Crafting your messages effectively.
- Managing Contacts: Adding from the address book or typing manually.
- Addressing Fields: To/cc/bcc essentials.
- Email Formatting: Enhancing the visual appeal.
- Email Responses: Receiving, replying, and forwarding.
- Printing Emails: Putting messages on paper.
- Folder Organization: Moving messages and the deleted items folder.
- Attachments and Signatures: Streamlining your emails.
- Recall/Resend: Mastering email control.

**Lesson Three: Calendar Mastery**

- Take command of your schedule with Outlook's calendar features.
- Calendar Entry Types: Adding events and recurring occurrences.
- Categorizing Appointments: Organizing your calendar efficiently.
- Meeting Management: Updating, canceling, and using the room finder tool.

**Lesson Four: People and Contacts**

- Effectively manage your contacts within Outlook.
- Contacts Overview: Navigating through your address book.
- Adding and Importing Contacts: Building your contact list.
- Contact Forwarding and Deletion: Managing your contact database.
- Organizing Contacts: Customizing your view.

**Lesson Five: Task Management**

- Streamline your tasks and to-dos.
- Task Basics: Understanding the task management system.
- Adding Tasks: Creating to-dos effectively.
- Recurring Tasks: Setting up repetitive actions.
- Task Options: Customizing your task settings.
- Assigning and Completing Tasks: Collaborating and marking tasks as complete.
- Task Organization: Moving and managing your task list.

**Lesson Six: Notes, Quick Steps, and Beyond**

- Utilize additional Outlook features for enhanced productivity.
- Creating Notes: Jotting down important information.
- Categorizing Notes: Organizing your notes effectively.
- Quick Steps Overview: A brief introduction to this time-saving tool.

Unlock the full potential of Microsoft Outlook 365 with our Beginner Level 1 course, tailored to empower you with the skills needed for efficient communication, organization, and productivity.


**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Master Outlook 365 with our Beginner Level 1 course. Gain a solid foundation to confidently navigate emails, calendars, contacts, tasks, and more.

Microsoft Outlook 365 - Level 1

**Microsoft Word Beginner Level 1 - Course Outline**

Dive into the world of document creation and editing with our Microsoft Word Beginner Level 1 course. This comprehensive outline is crafted to guide you through the navigation, creation, editing, and printing processes in Microsoft Word, ensuring you develop essential skills for effective document management.

**Course Duration:** 3 Hours

**COURSE OUTLINE**

- **Course Overview:** Word Level 1 is your stepping stone to mastering the fundamental features of Microsoft Word for creating, editing, and formatting documents.
- **Course Objectives:** Acquire foundational skills in Word, from navigating the interface to efficient document creation and management.

**Lesson One: Navigation of Word**

- Explore the essentials of Word navigation.
- Opening Word: Creating a new page or utilizing templates.
- Layout of Word: Navigate the Ribbon, Backstage View, and other key features.

**Lesson Two: Creating a Word Document**

- Master the art of document creation.
- Creating a Blank Document: Start your writing journey.
- Default Formatting: Understand and customize default settings.
- Save Options: Ensure your work is securely stored.
- Preview and Print Options: Prepare your document for sharing.

**Lesson Three: Views in Word**

- Explore different document views and zoom options.
- Using Each View Feature: Navigate through Print Layout, Draft, and more.
- Zoom Options: Adjust your view for precision.

**Lesson Four: Editing a Word Document**

- Hone your document editing skills.
- Scroll Bars and Keyboard Navigation: Efficiently navigate through your document.
- Text Editing Options: Master basic text manipulation techniques.
- Copy, Paste, Cut Options: Streamline your editing process.
- Undo/Redo Commands: Safeguard your work.
- Formatting Options: Enhance the visual appeal.
- Format Painter: Apply formatting effortlessly.
- Margins, Headers, and Footers: Customize document layout.
- Find & Replace: Locate and modify text efficiently.
- Page Breaks: Control the flow of your document.

**Lesson Five: Adding Items to a Word Document**

- Enhance your documents with tables, charts, and images.
- Adding a Table: Organize data effectively.
- Adding a Chart: Visualize information.
- Adding Pictures: Incorporate images seamlessly.

**Lesson Six: Printing a Word Document**

- Prepare and share your documents effectively.
- Preview and Print Options: Configure printing settings.
- Saving as PDF: Share your document in different formats.
- Sharing Document: Collaborate and distribute your work.

**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Unlock the full potential of Microsoft Word with our Beginner Level 1 course, tailored to empower you with the skills needed for efficient document creation, editing, and sharing.

Explore document creation with our Microsoft Word Beginner Level 1 course. Learn to navigate, create, edit, and print in Word, developing key management skills.

Microsoft Word 365 - Level 1 

**Microsoft PowerPoint Beginner Level 1 - Course Outline**

Unlock the creativity and presentation prowess of Microsoft PowerPoint with our Beginner Level 1 course. This comprehensive outline is structured to equip you with fundamental skills, guiding you through the creation, formatting, and delivery of captivating presentations.

**Course Duration:** 3 Hours

**COURSE OUTLINE**

- **Course Overview:** PowerPoint Level 1 is your gateway to mastering the essential features of Microsoft PowerPoint for effective and engaging presentations.
- **Course Objectives:** Develop a strong foundation in PowerPoint, from navigating the interface to creating, formatting, and presenting dynamic slideshows.

**Lesson One: Navigating PowerPoint**
- Explore the basics of PowerPoint navigation.
- What is PowerPoint?: An introduction to the presentation software.
- Opening PowerPoint: Creating a new presentation or utilizing templates.
- Ribbon Bar and Backstage View: Navigate through the essential features.

**Lesson Two: Creating a PowerPoint**
- Dive into the process of building compelling presentations.
- Adding Slides: Constructing the structure of your presentation.
- Different Slide Layouts: Exploring various formatting options.
- Replacing Text: Customizing content for your audience.
- Changing Layouts: Adapting the structure as needed.
- Adding Shapes and Pictures: Enhancing visual appeal.

**Lesson Three: Formatting a PowerPoint**
- Elevate the visual impact of your presentation.
- Basic Formatting: Adjust font size, color, and other essential elements.
- Design Tab: Explore themes and the designer tool for polished presentations.
- Basic Transitions: Enhance slide-to-slide flow.
- Basic Animations: Bring your content to life.

**Lesson Four: Presenting a PowerPoint**
- Master the art of delivering impactful presentations.
- Starting a Slide Show: From the beginning or a specific slide.
- Presenter's View: Navigate through the presenter's perspective.
- Presentation Options: Utilize features like laser pointer, drawing tools, subtitles, and more.
- Notes During Presentation: Enhance your delivery with speaker notes.

**Lesson Five: Printing a PowerPoint**
- Prepare and share your presentation materials effectively.
- Printing Selected Slides: Tailor your handouts or print specific slides.
- Print Styles: Choose between full-page or tiled print options.


**TAKE HOME**

Take home your own level 1 manual in either Print or PDF to help further your skills!

Unlock the full potential of Microsoft PowerPoint with our Beginner Level 1 course, tailored to empower you with the skills needed for creating and delivering impactful presentations

 Master PowerPoint with our Beginner Level 1 course. Learn fundamental skills for creating, formatting, and delivering captivating presentations effectively.

Microsoft PowerPoint 365 - Level 1

**1. Introduction to Basic Computer Operations (30 Minutes)**

- Using a Mouse (Explanation of the mouse, its parts, and its functions, Types of Clicks, using the Scroll Wheel)
- Using a Keyboard (Basic keyboard layout, Key Functions, Shift, Caps Lock, Special Characters, Delete vs Backspace)
- Understanding how to get around Windows
- Adjusting System Settings (volume, changing the date, etc)
- Using the calculator
- Using the Snipping Tool
- The concept of Cut & Paste
- Maximise, minimise and restore

**2. Introduction to Microsoft Office Applications (80 Minutes)**

20 minutes per application

- EXCEL (Navigating the Interface, Creating your first Spreadsheet, the concept of cells, selecting cells, moving cells, using autofill, Creating simple formulas, Formatting a spreadsheet, Saving and opening a file, clearing contents vs clearing formats, Printing)
- OUTLOOK (Navigating the Interface, Creating an email, attaching a document, marking emails as read or unread, using the flag, sorting emails, searching for an email, deleting and recovering emails, Creating an appointment, Different calendar views, Sending a meeting invitation, Creating tasks, Using Notes, Printing)
- WORD (Navigating the Interface, Creating your first Document, Typing Text, Basic text formatting, Basic paragraph formatting, Inserting images and resizing/moving them, using Bullets & numbered lists, Saving a file, Closing a file, Opening a file, Printing)
- POWERPOINT (Navigate the interface, Create a Presentation, Adding slides, using the slide layouts, entering data, formatting data, inserting pictures & shapes, Using Animations and Transitions, Running a slide show, Printing)

**3. Understanding Files and Folders**

- Difference between files and folders
- Navigating the File System
- Storage Locations

**4. Browsing the Internet**

- What is the internet?
- Purpose and Benefits
- What is a Web Browser
- Opening a Web Browser
- Understanding the Browser Interface
- Entering a URL
- What is a search engine
- Performing a search
- Understanding search results
- Basic Internet safety (recognizing secure sites, avoiding suspicious links)
- Using multiple Tabs
- Bookmarking

Master basic computer operations and MS Office: Navigate Windows, use tools, and create documents, spreadsheets, and presentations effectively.

Basic Computer Skills

Do you have any experience using computers, if so what? 

Is there anything specific you with to learn on this course?

**1. Introduction to RoboForm**

- Overview: What is RoboForm and what are its key features?
- Benefits of Using RoboForm: Emphasize security, convenience, and efficiency in managing passwords.

**2. Setting Up RoboForm**

- Downloading and Installing: Guide on how to download and install RoboForm on a PC.
- Creating a RoboForm Account: Steps to create a new user account.
- Initial Setup: Configuring basic settings for first-time use.

**3. Generating and Managing Passwords**

- Using the Password Generator: How to create strong, secure passwords.
- Saving Passwords: Demonstrate how to save newly created passwords in RoboForm.
- Organizing Passwords: Tips on organizing passwords into folders for easy access.

**4. Filling Forms and Logging In**

- AutoFill Feature: How RoboForm fills forms and logs into websites automatically.
- Customizing Form Entries: Editing and adding new personal data into RoboForm for various forms (e.g., addresses, payment information).

**5. Using Bookmarks**

- Saving & Using Bookmarks
- Bookmarks Menu & Options

**6. Safenotes**

- How to create new safenotes
- Viewing Safenotes

**7. Identities**

- How to create an Identity
- Using Identities

**8. RoboForm on Different Platforms**

- Installing RoboForm on Multiple Devices: Instructions on setting up RoboForm on additional computers and mobile devices.
- Syncing Passwords Across Devices: How to ensure your passwords are synced and up-to-date across all devices.

**9. Sharing Passwords Safely**

- Using RoboForm’s Sharing Feature: Steps to safely share login information with family or colleagues.
- Managing Shared Access: How to manage permissions and revoke access when necessary.

**10. Two-Factor Authentication (2FA)**




Excellent password manager that generates very secure passwords for you to use, and allows you to save them and automatically log in to your websites.

Secure Password Management with RoboForm

Do you have any previous experience using RoboForm? or a similar password protection program?

Is there anything specific you wish to learn from this course?

**Create Charts**
- Charts
- Chart Types
- Chart Insertion methods
- Resizing and Moving the Chart
- Adding Additional Data
- Switching between Rows and Columns

**Modify and Format Charts**
- Modifying vs Formatting
- Chart Elements
- Minimize extraneous chart elements
- The Chart contextual tabs
- Formatting the Chart with a Style
- Adding a Legend to the Chart

**Adding Sparklines**
- Sparkline Types
- Inserting and Editing Sparklines
- The Sparkline Tab

**Create a Trendline**
- Trendlines
- Types of Trendlines
- Adding a Trendline
- The format trendline Task Panel

**Create Advanced Charts**
- Combination Charts
- Dual Axis Charts
- Creating Custom Chart Templates

**Incorporate SmartArt**
- About SmartArt
- The Choose a SmartArt Graphic Dialog Box
- About the Text Pane

Discover Excel charting: Learn chart creation, formatting, adding sparklines, trendlines, advanced charts, and SmartArt in this detailed course.

Excel 365 Charts

**Create a PivotTable**
- PivotTables
- Start with Questions, end with Structure
- The Create PivotTable Dialog Box
- The PivotTable Fields Task Pane
- Summarise Data in a PivotTable
- The "Show Value As" Functionality of a Pivot Table
- Format a PivotTable
- External Data
- PowerPivot
- PowerPivot Functions

**Filter Data Using Slicers**
- Slicers
- The Insert Slicers Dialog Box

**Analyse Data with PivotCharts**
- PivotCharts
- Create PivotCharts
- Applying a Style to a PivotChart


Learn to create PivotTables, use slicers for data filtering, and analyze data with PivotCharts, including styling and PowerPivot functions.

Excel 365 Pivot Tables

**3-Hour Training Course Outline: Using Excel 365 as a Database**

Unlock the power of Excel 365 as a database with our comprehensive training course. This course is designed to equip you with the knowledge and skills necessary to utilize Excel as an effective database solution.

**Course Duration:** 3 Hours

**Course Overview:**
Master the capabilities of Excel 365 as a database and learn how to leverage its features for efficient data management.

**Course Objectives:**
- Gain an understanding of Excel's potential as a database tool.
- Learn essential data entry, organization, and manipulation techniques.
- Explore advanced features such as pivot tables, data cleansing, and paste special functionalities.

**Course Outline:**

1. **Introduction to Excel as a Database (15 minutes)**
   - Overview of Excel 365: Features and benefits for database functions.
   - Excel vs. Traditional Databases: Knowing when to use Excel and its limitations.

2. **Data Entry and Organization (30 minutes)**
   - Structuring Data: Setting up tables and named ranges.
   - Data Validation: Maintaining data integrity with validation rules.

3. **Data Sorting and Filtering (30 minutes)**
   - Basic Sorting: Alphabetical, numerical, and custom sorting.
   - Advanced Filtering: Techniques for filtering by text, numbers, dates, and color.

4. **Outlines, Grouping, and Subtotals (30 minutes)**
   - Creating Outlines: Grouping data for collapsible outlines.
   - Adding Subtotals: Automatically calculating subtotals in grouped data.

5. **Enhancing Spreadsheet Functionality (30 minutes)**
   - Printing Titles and Headers: Setting up repeated rows/columns.
   - Freeze Panes: Keeping header information visible while scrolling.
   - Conditional Formatting: Highlighting important data with formatting rules.

6. **Introduction to Pivot Tables (30 minutes)**
   - Basics of Pivot Tables: Creating and manipulating pivot tables.
   - Pivot Table Analysis: Summarizing and analysing data efficiently.

7. **Data Cleansing Techniques (30 minutes)**
   - Removing Duplicates: Identifying and removing duplicate entries.
   - Text to Columns: Converting concatenated data into structured format.
   - Error Checking: Tools and formulas for data review.

8. **Advanced Paste Special Features (15 minutes)**
   - Paste Special Overview: Utilizing various paste special options.
   - Practical Applications: Demonstrations of paste special in data management.

**Conclusion and Q&A (10 minutes)**
   - Course Wrap-Up: Summary of key points and best practices.
   - Q&A Session: Addressing remaining questions and providing clarifications.

**Prerequisites:**

To ensure successful participation and comprehension of the "Using Excel 365 as a Database" course, participants are expected to have the following prerequisites:

1. **Basic Understanding of Excel:** Participants should have a foundational understanding of Excel, including familiarity with basic functionalities such as entering data, formatting cells, and navigating through worksheets.

2. **Proficiency in Data Entry and Formulas:** A working knowledge of data entry techniques and Excel formulas is essential. Participants should be comfortable with entering and organizing data, as well as performing basic calculations using Excel formulas.

3. **Understanding of Spreadsheet Concepts:** Familiarity with spreadsheet concepts such as rows, columns, cells, and ranges is necessary. Participants should understand how to navigate and manipulate data within a spreadsheet environment.

4. **Basic Knowledge of Database Concepts:** While not mandatory, a basic understanding of database concepts such as tables, records, fields, and data validation will be beneficial. This knowledge will help participants grasp the concepts of using Excel as a database more effectively.

5. **Access to Excel 365:** Participants must have access to Excel 365 or a compatible version installed on their laptops for hands-on practice during the training sessions.

By ensuring you meet these prerequisites, you will be better equipped to engage with the course material and maximize your learning outcomes during the training sessions.

Unlock the full potential of Excel 365 as a database with our comprehensive training course, designed to empower you with the skills needed for efficient data management and analysis.

Unlock Excel 365's database potential! Learn data entry, sorting, pivot tables & more in our 3-hour course. Prerequisites: basic Excel & database understanding.

Using Excel 365 as a Database

**3-Hour Training Course Outline: Mastering What-If Analysis in Excel 365**

Uncover the power of What-If Analysis in Excel 365 with our comprehensive training course. This outline is meticulously crafted to equip you with the skills necessary to leverage Goal Seek, Scenarios, and Data Tables for robust decision-making and scenario analysis.

**Course Duration:** 3 Hours

**Course Overview:**
Delve into the realm of What-If Analysis and learn how to harness its potential for informed decision-making and strategic planning.

**Course Objectives:**
- Understand the importance of What-If Analysis in various fields.
- Master the usage of Goal Seek, Scenarios, and Data Tables for comprehensive scenario analysis.
- Apply What-If Analysis tools to real-world scenarios for effective decision-making.

**Course Outline:**

1. **Introduction to What-If Analysis (20 minutes)**
   - Overview: Definition and significance of What-If Analysis.
   - Types of Tools: Introduction to Goal Seek, Scenarios, and Data Tables.
   - Real-World Applications: Examples from finance, marketing, and operations management.

2. **Using Goal Seek (40 minutes)**
   - Understanding Goal Seek: When and how to use it effectively.
   - Setting Up Analysis: Step-by-step instructions with practical examples.
   - Troubleshooting: Resolving common issues encountered during Goal Seek analysis.

3. **Creating and Managing Scenarios (50 minutes)**
   - Introduction to Scenarios: Utility in modeling multiple outcomes.
   - Setting Up Scenarios: Creating and saving scenarios in Excel.
   - Advanced Techniques: Merging, editing, and deleting scenarios.
   - Hands-On Exercise: Participants create and analyze scenarios.

4. **Building Data Tables (40 minutes)**
   - Explaining Data Tables: One-variable and two-variable data tables.
   - Creating Data Tables: Step-by-step guide with practical application.
   - Analysis and Interpretation: Using data tables for decision-making.

5. **Integrating What-If Analysis Tools (30 minutes)**
   - Combining Tools: Utilizing Goal Seek, Scenarios, and Data Tables together.
   - Case Study: Participants solve complex business cases integrating all tools.

6. **Review and Q&A (20 minutes)**
   - Recap of Key Concepts: Summarizing workshop content.
   - Q&A Session: Addressing participant queries.
   - Feedback and Closing Remarks: Collecting feedback and concluding the session.

**Prerequisites:**
To ensure successful participation and comprehension of the "Mastering What-If Analysis in Excel 365" course, participants are expected to have the following prerequisites:

1. **Basic Understanding of Excel:** Participants should have a foundational understanding of Excel, including familiarity with basic functionalities such as entering data, formatting cells, and navigating through worksheets.

2. **Proficiency in Excel Formulas:** A solid grasp of Excel formulas and functions is essential. Participants should be comfortable creating and using formulas to perform calculations and manipulate data within Excel.

3. **Familiarity with Data Analysis Concepts:** An understanding of basic data analysis concepts such as variables, datasets, and statistical measures will be beneficial. Participants should be able to interpret data and understand its implications for decision-making.

4. **Knowledge of Spreadsheet Modeling:** Familiarity with spreadsheet modeling techniques, including scenario analysis and data tables, will be advantageous. Participants should understand how to create and interpret models to analyze different scenarios and make informed decisions.

5. **Access to Excel 365:** Participants must have access to Excel 365 or a compatible version installed on their laptops for hands-on practice during the training sessions.

By ensuring you can meet these prerequisites, you will be better equipped to engage with the course material and maximize your learning outcomes during the training sessions.

Unlock the full potential of What-If Analysis in Excel 365 with our comprehensive training course, designed to empower you with the skills needed for strategic decision-making and scenario planning.

Unleash Excel 365's What-If Analysis power in our 3-hour course. Learn Goal Seek, Scenarios, and Data Tables for informed decision-making. Prerequisites: Basic 

Mastering What-If Analysis in Excel 365

**Course Title: Mastering Social Media Post Design with Canva**

**Course Overview:**
This course equips participants with the knowledge and skills necessary to create visually appealing and engaging social media posts using Canva. Participants will learn various design principles, tools, and techniques to enhance their social media presence and effectively communicate their messages across different platforms.

**Course Objectives:**

1. Understand the fundamentals of social media post design.

2. Learn how to navigate and utilize Canva's features and tools effectively.

3. Create visually stunning and engaging social media posts tailored to specific platforms and audiences.

4. Explore advanced design techniques, branding strategies, and engagement tactics.

5. Gain hands-on experience through practical exercises, including creating adaptable posts for different social media platforms.


**Course Outline:**

**Session 1: Introduction to Social Media Design Basics (45 minutes)**
- Understanding the importance of visual content in social media marketing.
- Exploring different types of social media posts (e.g., images, infographics, videos).
- Introduction to design principles (e.g., color theory, typography, composition).
- Analyzing successful social media posts for inspiration.

**Session 2: Getting Started with Canva (45 minutes)**
- Overview of Canva's interface and key features.
- Setting up a Canva account and accessing templates.
- Exploring design elements such as layouts, backgrounds, and elements.
- Understanding how to customize templates to suit your brand and message.

**Session 3: Designing Engaging Social Media Posts (45 minutes)**
- Choosing the right dimensions and formats for different social media platforms (e.g., Instagram, Facebook, Twitter).
- Creating visually appealing graphics using Canva's tools and resources.
- Incorporating text effectively to convey messages and capture attention.
- Adding branding elements such as logos and brand colors.
- Optimizing posts for mobile viewing and accessibility.

**Session 4: Advanced Design Techniques (30 minutes)**
- Exploring advanced design features in Canva, such as masking, layering, and effects.
- Incorporating multimedia elements, including videos, GIFs, and animations, into social media posts.
- Utilizing Canva's design grids and alignment tools for precision and consistency.
- Creating custom graphics and illustrations using Canva's drawing tools and photo editing capabilities.

**Session 5: Adapting Posts for Different Social Media Platforms (45 minutes)**
- Understanding the unique requirements and best practices for various social media platforms (e.g., Instagram, Facebook, Twitter, LinkedIn).
- Creating adaptable post templates that can be customized for each platform.
- Optimizing post elements such as dimensions, aspect ratios, and content to maximize engagement on different platforms.
- Hands-on exercise: Participants will create five social media posts using Canva, each tailored for a specific platform.

Learn to design captivating social media posts using Canva. Explore design principles, tools, and hands-on exercises. Bring a laptop with Canva access.

Social Media Post Design with Canva

Google Sheets is a versatile cloud-based spreadsheet application that offers real-time collaboration, allowing multiple users to work on the same document simultaneously. Accessible from any device with an internet connection, it integrates seamlessly with other Google Workspace apps, providing a cohesive workflow. Supporting a wide range of functions and advanced features like data validation and pivot tables, it is suitable for complex data analysis. Its sharing and permission settings enhance security, making it a preferred choice for businesses and individuals looking for a reliable collaborative spreadsheet solution.

**Course Duration:**  3 Hours


**COURSE OUTLINE**

**GETTING STARTED WITH GOOGLE SHEETS**

Creating a Google Sheet Account
- Using Google Sheets
- Google Sheet Account

Navigating the Google Sheets Interface
- The Google Sheets Home Screen
- Spreadsheet Tabs
- Navigation
- Working Together and Sharing

Setting up your first spreadsheet
- Adjusting the Width of the columns and rows
- Combining and Separating Cells
- Changing the format of cells
- Entering Data
- Copying and Pasting Data
- Editing Data
- Inserting Formulas
- Protecting Your Spreadsheet From Loss
- Changing the Name of Your Spreadsheet

Importing Data into Google Sheets
-  Importing Data from a Local File
- Importing Data from Google Drive
- Importing Information from Different Websites
- Importing Data from Outside Sources

**WORKING WITH BASIC FUNCTIONS AND FORMULAS**

Understanding Functions and Formulas
- Functions in Spreadsheets Formulas in Spreadsheets
- Utilizing the Pre-Configured Functions and Formulas
- Handling Errors and Debugging

Using Arithmetic Operators and Mathematical Functions
- Arithmetic Operators
- Mathematical Functions
- Order of Operations
- Using Mathematical Functions with Cell Reference

Utilizing Logical and Comparison Functions
- Logical Functions
- Comparison Operators
- Combining Logical and Comparison Functions
- Error Handling and Logical Functions

Applying Text Functions for Manipulating Text Data
- Basic Text Functions
- Advanced Text Functions
- Formatting Text with Text Functions

**FORMATTING AND CUSTOMIZING YOUR SPREADSHEET**

Formatting Cells and Ranges
- Define Cell and Range
- Font Styles and Alignment
- Background Colors and Borders
- Conditional Formatting

Creating and Formatting Tables
- Creating Tables
- Formatting Tables

Inserting and Formatting Charts and Graphs
- Inserting Charts and Graphs
- Formatting Charts and Graphs

Using Conditional Formatting for Data Visualization

**SORTING, FILTERING, AND MANAGING DATA**

Sorting Data in Google Sheets
- Data Sorting
- Filtering Data
- Data Management
- Data Validation
- Sorting Options and Tips

Filtering Data with Filters and Filter Views
- Using Filters
- Filter Views
- Advanced Filtering Techniques

Using Data Validation to Control Input
- Enabling Data Validation
- Common Use Cases for Data Validation
- Data Validation Tips and Best Practices

Organizing and Managing Sheets and Tabs
- Creating and Renaming Sheets
- Rearranging and Grouping Sheets
- Changing Tab Colors
- Hiding and Unhiding Sheets
- Protecting Sheets and Tabs
- Using Tab Summaries and Table of Contents

Google Sheets is a versatile cloud-based spreadsheet application that offers real-time collaboration, allowing multiple users to work on the same document si...

Google Sheets - Level 1

**CV Writing - Crafting a Standout Resume**

This comprehensive 3-hour training course is designed to equip attendees with the essential skills and knowledge to create a compelling and professional CV. Participants will learn the fundamental components of a CV, effective structuring and formatting techniques, and the importance of tailoring their CV to specific job descriptions. 

**Course Duration:** 3 Hours

**COURSE OUTLINE**

Introduction
- Welcome and Objectives

Understanding CV Basics
- Purpose of a CV
- Essential Components

Structuring Your CV
- Formatting Tips
- Creating Clear Sections

Tailoring Your CV
- Researching Job Descriptions
- Customizing Your CV
- Showcasing Achievements

Writing Effective Content
- Personal Statement
- Highlighting Skills
- Avoiding Common Mistakes

Proofreading and Feedback
- Proofreading Techniques
- Getting Feedback

Interactive Workshop
- Hands-on CV Review
- Recap of Key Points
- Summary of what was covered
- Q&A Session
- Open floor for participants to ask questions


This 3-hour course equips attendees with essential CV writing skills, covering components, structuring, formatting, and tailoring CVs to job descriptions.

CV Writing (Free Course)

The eKit gives you all you need to pass one of the Microsoft Office Specialist exams.  You get one exam (and a free resit if you need it), an online video course covering the exam topics and access to multiple practise tests.  You have access to the tools for 12 months before the eKit expires.

Microsoft Office Specialist (MOS) eKit

Single Video course, Test Preparation, MOS Exam and free retake if needed

Question 0

Please choose from Word Associate, Excel Associate, PowerPoint Associate, Outlook Associate, Excel Expert or Word Expert.

The **Microsoft Office Specialist (MOS)** program is a globally recognized standard for validating expertise in the productivity tools within the Microsoft Office suite, including Word, Excel, PowerPoint, Outlook, Access, and more. Whether you're looking to enhance your career, secure a new job, or simply increase your efficiency in office software, the MOS certification provides you with the tools to achieve your goals.

**Why Choose MOS Certification?**

1. Industry Recognized Certification: MOS is widely recognized in the business world as evidence of advanced skills in Microsoft Office applications, which are crucial in nearly every job role. Having MOS certification on your resume showcases your commitment to enhancing your expertise and sets you apart from your peers in the job market.

2. Boost Employability: In today's competitive job market, employers often seek out individuals who can contribute efficiently from day one. By demonstrating proficiency in Microsoft Office, you position yourself as a valuable asset to any team, enhancing your job prospects and promotional opportunities within your current and future roles.

3. Increase Productivity: Learning to use Microsoft Office applications effectively can drastically reduce the time it takes to accomplish daily tasks. From mastering advanced Excel formulas to automating tasks in Word and managing emails more efficiently in Outlook, MOS certification equips you with skills that streamline workflows and increase productivity.

4. Professional Development: Pursuing MOS certification is an excellent way to continue your professional development, stay updated with the latest software updates, and continuously improve your skills. This ongoing learning process is essential for career growth and professional satisfaction.

5. Flexibility and Comprehensive Learning Resources: The MOS certification program offers flexibility in learning and testing. You can prepare for the exams at your own pace using a wide array of resources including online tutorials, in-person classes, textbooks, and practice tests. This wealth of resources ensures that you can fit your learning around your schedule and learning style.

6. Performance-Based Testing: Unlike traditional exams that rely on multiple-choice questions, MOS exams are performance-based. This means you are tested on real-world tasks and scenarios, which provides a deeper understanding of the software and its practical application in your day-to-day activities.

7. Pathway for Advancement: Starting with core certifications, you can advance to expert and then master levels. Each level deepens your expertise and opens up further opportunities for professional growth and recognition.

8. Suitable for All Ages and Skill Levels: Whether you are a student, a job-seeker, an office professional, or someone looking to return to the workforce, MOS certification is suitable for all ages and skill levels. It provides a structured pathway to mastering office applications that are crucial in both academic and business environments.

9. Global Network of Certified Professionals: As a MOS certified professional, you join a global community of individuals who have demonstrated their abilities in Microsoft Office applications. This network can be a valuable resource for career advice, networking, and sharing tips and best practices.

10. Support from Microsoft: As a Microsoft certification, MOS comes with the support and branding of one of the world’s leading technology companies. This backing is invaluable when presenting your credentials to employers or clients.

**How to Get Started?**

Getting started with the MOS certification is simple. Determine which application you want to master first and assess your current skill level. Choose a learning path that suits your needs, and begin your training using the vast resources available. Once ready, you can take the exam at an authorized testing centre or online under a proctored environment.

In conclusion, the Microsoft Office Specialist program not only enhances your technical skills but also enriches your professional development. Whether your goal is to gain a competitive edge in the job market, increase your workplace productivity, or achieve personal satisfaction in mastering a tool, MOS certification is a stepping stone to success.

Microsoft Office Specialist (MOS) Exam

Choose one 50 minute online exam which is performance-based, testing your ability to complete specific tasks rather than answering multiple-choice questions.

The future belongs to those who create. Whether it’s to inform, persuade, entertain, or inspire, success in the digital age means communicating in visually rich and interactive ways. With a firm grasp on the world’s most powerful creative tools, Adobe Certified Professionals are ready to make their mark.

Adobe Certified Professional is the industry-recognized certification that demonstrates mastery of Adobe Creative Cloud software and must-have knowledge for digital media careers. Each exam is integrated with an Adobe application and designed by experts, allowing for an authentic assessment of job-ready skills.

https://youtu.be/YPpmx_7l1Xc

**CREATIVITY WITH CREDIBILITY**

Adobe Certified Professional is an industry-recognized credential that effectively validates one’s skills in Adobe Creative Cloud applications. 

Complete an Exam and get certified in ONE the following:

- Visual Effects & Motion Graphics using **Adobe After Effects**
Advance your career in the motion graphics industry by earning an industry-recognized certification for Adobe After Effects, the world-class tool for video compositing, motion graphics design, and animation.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/after-effects

- Multiplatform Animation using **Adobe Animate**
Show off your animation skills by earning an industry-recognized certification for Adobe Animate, the powerful vector animation and multimedia authoring software.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/animate

- Web Authoring using **Adobe Dreamweaver**
Become an Adobe Certified Professional in Web Authoring and show your skills on Adobe Dreamweaver, the all-in-one visual development tool for creating, publishing, and managing websites and mobile content. 
https://certiport.pearsonvue.com/fc/aca/od/cc2021/dreamweaver

- Graphic Design & Illustration using **Adobe Illustrator**
Digital media gurus bring their unique vision to life everyday with shapes, colour, and effects through Adobe Illustrator, the industry-standard vector graphics software. Earn an industry-recognized certification for Adobe Illustrator and prove your guru skills. 
https://certiport.pearsonvue.com/fc/aca/od/cc2021/illustrator

- Print & Digital Media Publication using **Adobe InDesign**
Show your understanding and ability to create print and digital media publications using Adobe InDesign, the industry-leading layout and page design application.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/indesign

- Visual Design using **Photoshop**
Adobe Photoshop is now considered a household name. Show your skills on the world’s most widely used digital imaging software by becoming an Adobe Certified Professional in Visual Design.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/photoshop

- Digital Video using **Adobe Premiere Pro**
Prove your video editing skills by earning an industry-recognized certification for Adobe Premiere Pro, the industry-leading non-linear editing software for TV, film, and social sharing.
https://certiport.pearsonvue.com/fc/aca/od/cc2021/premiere-pro

While meaningful to any job seekers and students interested in digital creative careers, these exams are best suited for ages 14 and up. No Bachelor's degree or other prerequisites are necessary, other than what is outlined in the Objective Domains. Each certification is valid for three years from the date of issue.

Ready to prove that you have the skills to work with multiple Adobe software applications? Earn two Adobe Certified Professional certifications and you will receive an Adobe Certified Professional specialty certificate for Visual, Web or Video Design.

Adobe Certified Professional Exam

Single 50 minute Adobe exam completed from home. Choose from Photoshop, Illustrator, InDesign, Premiere Pro, After Effects, Animate & Dreamweaver.

Which Adobe exam (and version) were you after?

Adobe Certified Professional e-Kit

Video Course, Practise Tests, official Adobe exam and a free retake if needed.  Valid for 12 months.

Which Adobe application e-Kit would you like?

Post Course Survey

**Cancellation by the Participant:**

If a registered participant wishes to cancel their attendance in a training course, they must notify us in writing via email or through our registration system.

**Substitution:**

If a registered participant is unable to attend, they may request a substitution with another individual from their organization at no additional cost. Please notify us of such substitutions in advance.

**Cancellation by the Organizer:**

We reserve the right to cancel a training course due to unforeseen circumstances, low enrolment, or other reasons. If we cancel a course, participants will receive a full refund of the course fee.

**Course Rescheduling:**

In the event that we need to reschedule a course, registered participants will have the option to attend the rescheduled date or receive a full refund of the course fee.

**No-shows:**

Participants who do not attend the training course and do not provide a cancellation notice will not be eligible for a refund.
Please make sure to review and understand this cancellation policy before registering for a training course. By registering for our training courses, you acknowledge and agree to the terms outlined in this policy.

Sign up to the Innovate Training newsletter to occasionally receive news, promotions and event information. You can unsubscribe at any time.

Innovate Training

The Team

We’d love to hear from you! Find out how to contact or find us below.

Get in touch

Innovate Training is an Authorised Testing Centre of Microsoft Office and on a mission to empower the community of Bude and its neighbouring towns through enhanced computer skills. We believe that equipping individuals with essential computer skills not only boosts their efficiency but also opens up new avenues for employment and personal growth. Our commitment is to provide accessible, high-quality training, ensuring that everyone can harness the full potential of today's digital world. Join us in your journey to greater opportunities and computer proficiency.  

We will also soon be offering Microsoft Office Certification courses where you can complete the official Microsoft Office exams to prove you skills.  Please let us know if this is of interest.

 Innovate Training

We will add videos, manuals and other relevant products here in due course.

Below is a list of all our upcoming events.  If you cannot make the below dates please get in touch detailing when are able to attend, and how many people are with you.

Innovate Training

Our events

Our events

Our events

Our products

Our products