37199 RES courses delivered Online

Course Objectives At the end of this course you will be able to: Understand the Outlook interface Send and receive email messages Organise email messages Manage their calendar Manage their contacts Work with tasks and notes Customise Outlook ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started With Outlook Navigate the Outlook Interface Perform Basic Email Functions Use Outlook Help Composing Messages Create an Email Message Check Spelling and Grammar Format Message Content Attach Files and Items Enhance an Email Message Manage Automatic Message Content Reading and Responding to Messages Customise Reading Options Work with Attachments Manage Your Message Responses Managing Your Messages Manage Messages Using Tags, Flags, and Commands Organise Messages Using Folders Managing Your Calendar View the Calendar Manage Appointments Manage Meetings Print Your Calendar Managing Your Contacts Create and Update Contacts View and Organise Contacts Working With Tasks and Notes Create and manage Tasks Create and manage Notes Customising the Outlook Environment Customise the Outlook Interface Create and Manage Quick Steps Who is this course for? Who is this course for? This course is intended for the user who needs to learn how to use Microsoft Outlook to compose and send email, schedule appointments and manage contact information. Requirements Requirements General knowledge of the Windows OS

Course Objectives At the end of this course you will be able to: Collaborate on documents Add reference marks and notes Make long documents easier to use Secure a document Work with forms '1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Collaborating on Documents Modify User Information Share a Document Compare Document Changes Review a Document Merge Document Changes Review Tracked Changes Coauthor Documents Adding Reference Marks and Notes Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Simplifying and Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Ancillary Table Manage Outlines Create a Master Document Securing a Document Suppress Information Set Formatting and Editing Restrictions Add a Digital Signature to a Document Restrict Document Access Forms Create Forms Manipulate Forms Who is this course for? Who is this course for? This course is designed for users who would like to create and work with lengthy and well structured documents, collaborate with others on documents, and create forms in Microsoft Word Requirements Requirements Preferably, delegates should have attended the Word Intermediate course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Business Analysis: Market Research Analyst bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Business Analysis: Market Research Analyst related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Business Analysis: Market Research Analyst bundle will help you build a solid foundation to become a proficient worker in the sector. This Business Analysis: Market Research Analyst Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Fundamentals of Business Analysis Course 2: Business Intelligence Analyst Course 3: Business Intelligence and Data Mining Course 4: Research Methods in Business Course 5: Financial Modelling for Decision Making and Business plan Course 6: Investment Course 7: Business Productivity Training Course 8: Business Consultant Course 9: Foundations of Business Strategy Consulting Course 10: Business Performance Management Course 11: Financial Analysis Course 12: Financial Statement Analysis Masterclass Course 13: Stakeholder Management Analyst Course 14: Public Speaking Course 15: Complete Communication Skills Master Class for Life Course 16: Receptionist Skills Course 17: Minute Taking Executive Training Course 18: Time Management Training - Online Course Course 19: Investment Analyst Course 20: Market Research Analyst Course 21: Make Business Plans: Forecasting and Budgeting Course 22: Business Accounting Training Course 23: Basic Business Finance Course 24: Strategic Business Planning Course 25: Business Development Course 26: Business Plan for Entrepreneours Course 27: Branding Fundamentals for New Business Course 28: Business Development & Sales Course 29: Marketing Strategies for Business Course 30: Financial Ratio Analysis for Business Decisions 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Course 8: Boost Your Confidence and Self-Esteem Course 9: Public Speaking Training Course 10: Learn to Fight Procrastination Learning Outcome This tailor-made Business Analysis: Market Research Analyst bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Business Analysis: Market Research Analyst Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Business Analysis: Market Research Analyst bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Business Analysis: Market Research Analyst Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Getting Started ILM Level 2 Diploma in Team Leading course is designed to provide new and aspiring team leaders with a thorough understanding of the leadership role and its wide-ranging responsibilities. As a widely accepted and nationally recognised course, it is an ideal platform to start your journey towards a successful leadership career. This course aims to provide a thorough understanding of core team-leading competencies, such as communication, motivation, and performance management, while also looking into the specific areas of leadership relevant to your workplace context. Through an extensive selection of modules you will have the flexibility to tailor your learning experience to align with your career aspirations and professional development goals. Key Benefits For Learners Take control of your personal development Communicate clearly and confidently Engage and support your team Build positive and productive relationships at work Get a nationally recognised qualification For Organisations Provide team leaders with extensive training to ensure they have the required skills to lead their teams effectively. Equip staff with the competence and knowledge needed to effectively manage people Cultivate strong relationships within and outside the organisation. Encourage staff to engage in continuous learning and development Foster a culture of open communication, active listening, and seamless collaboration which paves way to increased productivity and job satisfaction. Career Pathways The ILM Level 2 Team Leading can open many career pathways including, but not limited to: Team Leader, with an estimated average salary of £27,835 per annum Supervisor, with an estimated average salary of £22,480 per annum Team Coordinator, with an estimated average salary of £25634 per annum About Awarding Body Institute of Leadership & Management (ILM) is a professional body that helps people worldwide improve their leadership capabilities and advance their careers. All ILM qualifications are awarded by The City and Guilds of London Institute, founded in 1878 and incorporated into the Royal Charter. ILM qualifications are regulated and approved by Ofqual, the governing body for qualifications in the UK. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 12 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by ILM-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies ILM Membership - You will receive 12 months of the Institute of Leadership & Management membership, bringing access to a wealth of resources to support your leadership development. ILM Digital credentials - Validate your skills and share achievements anywhere, anytime using Digital Credentials Assessment For each module you study, you will complete a written assignment of 1500-2000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your ILM-approved tutor. Entry Requirements ILM Level 2 Diploma in Team Leading is designed for new aspiring team leaders, which gives an in-depth introduction to the role and responsibilities of a team leader. To be eligible for this course, you must: Be 18 years of age and over Be new to a team leader role or have some experience in team leading or similar job role. Possess the ability to complete the Level 2 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression This qualification will provide progression opportunities to other qualifications such as: ILM Level 3 Diploma in Management ILM Level 4 NVQ Diploma in Management ILM Level 4 Diploma in the Principles of Leadership & Management Why gain a ILM Qualification? This course is designed for team leaders, aiming to support the development of their skills in leading a team, ensuring that the team's work meets organisational objectives, and contributing to planning, problem-solving, and decision-making. The Level 2 course provides an in-depth introduction to critical roles and responsibilities for those new to a leadership position. Each module equips you with essential skills to successfully lead a team, including planning, allocating, and monitoring work. Additionally, you will learn motivation techniques and how to address complex issues such as underperformance. Successful completion of the course could lead you to progression to Level 2 or 3 courses. Through this course you will learn how to develop yourself as a Team Leader, how to improve the performance of your team and how to plan and monitor work. ILM graduates achieve remarkable things: An impressive 70,000 people take ILM qualifications every year, with 93% of employers agreeing that their managers improved after completion. ILM Membership - All ILM learners receive a minimum of 12 months membership of the Institute of Leadership & Management, bringing access to a wealth of resources to support their leadership development ILM Digital credentials - Validate skills and share achievements anywhere, anytime using Digital Credentials Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Resolve Customers' Complaints Reference No : 8620-323 Credit : 4 || TQT : 40 UNIT2- Lead and Manage a Team Reference No : 8620-202 Credit : 5 || TQT : 50 UNIT3- Principles of Team Leading Reference No : 8620-203 Credit : 5 || TQT : 50 UNIT4- Understand Business Reference No : 8620-204 Credit : 4 || TQT : 40 UNIT5- Develop Working Relationships with Colleagues Reference No : 620-205 Credit : 3 || TQT : 30 UNIT6- Manage Team Performance Reference No : 8620-301 Credit : 4 || TQT : 40 UNIT7- Manage Conflict within a Team Reference No : 8620-310 Credit : 5 || TQT : 50 UNIT8- Health and Safety Procedures in the Workplace Reference No : 8620-208 Credit : 2 || TQT : 20 UNIT9- Manage Personal Performance and Development Reference No : 8620-200 Credit : 4 || TQT : 40 UNIT10- Communicate Work-Related Information Reference No : 8620-201 Credit : 4 || TQT : 40 Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

The Level 5 Diploma in Education and Training (L5 DET) is an industry-standard qualification for those teaching in the post-16 sector.

Course Information This one day course is designed to provide you with comprehensive guidance and practical help for when designing and implementing audit programmes. Using the guidance of ISO 19011 with reference to PV, GCP, GMP and GLP audit programmes, you will explore audit programme design, operation, review and improvement. The course will work through why audits are important and understanding the drivers behind a good audit programme. It will discuss how to identify and assess the risks in your organisation, linking them with organisational goals, using these risks as a basis for the design of a risk-based audit programme during facilitated practical workshops. Delegates will have the opportunity to consider and discuss common issues and constraints that may shape their audit programmes. By the end of the course you will have: A clear understanding of the role of audit programmes in managing compliance and of the drivers and risks behind audit programmes An understanding of the roles and responsibilities of management and personnel An appreciation of resourcing implications and auditor attributes A good insight into the practicalities and activities required for design of risk based audit programmes A comparison of your circumstances, challenges, common issues and ways to approach managing audit programmes with other delegates on the course. Tutors Tutors will be comprised of (click the photos for biographies): Louise Handy Director, Handy Consulting Ltd Programme Please note timings may be subject to alteration. Day 1 08:50 Registration 09:00 Welcome and Introduction 09:15 Why do we Need to Audit? Exploring risk and regulation, responsibility and performance. 09:45 Discussion - Programmes, Needs, Commonalities Understanding the needs of delegates' own organisation and comparing common themes and threats. 10:00 Establishing an Audit Programme Design, objectives, risk and resources. This session discusses the consideration when designing audit programmes. 10:30 Break 10:45 Risk Management Considerations, guidance and methods for assessing and controlling risk. 11:00 Workshop 1 - Risks, Prioritisation and Control Looking at specific risks, assessing and evaluating to feed into audit programme management. 12:00 Workshop 1 - Feedback 12:30 Lunch 13:30 Putting it into Practice Resources, practicalities and challenges - the realities of auditing, including selection of auditors, ensuring practice will meet expectations and the reasons to note audit results. 13:45 Workshop 2- Designing Audit Programmes Designing audit programmes using output from risk assessment process. Challenges and flexibility. 15:00 Break 15:15 Workshop 2 - Feedback 15:30 Monitoring, Reviewing and Improving Why or when should existing processes change, understanding the implications of change or inaction and exploring how to improve the audit programme. 16:15 Panel Session This final session will address any outstanding issues raised by delegates. 16:30 Close of Course Extra Information Remote Course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device< Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking You will need a stable internet connection, a microphone and a webcam. CPD Points 7 Points   Development Level Develop

Course Objectives At the end of this course you will be able to: Customise message settings Organise and locate Outlook messages Set Calendar options Manage their Contacts Work with activities using the Journal and Tasks Share their workspaces Manage their Outlook data files ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Configure Advanced Message Options Delay delivery Insert Advanced Characters and Objects Modify Message Settings, Properties, and Options Use Automatic Replies Advanced Message Management Sort Messages Filter Messages Organise Messages Search Messages Manage Junk Mail Manage Your Mailbox Automate Repetitive Tasks Quick steps Rules Auto Archive Advanced Calendar Management Manage Advanced Calendar Options Create Calendar Groups Manage Meeting Responses Advanced Contact Management Edit an Electronic Business Card Manage Advanced Contacts Options Forward Contacts Export Contacts Managing Activities by Using Tasks and Journal Entries Assign and Manage Tasks Record and Modify Journal Entries Sharing Workspaces with Others Delegate Access to Mail Folders Share Your Calendar Share Your Contacts Managing Outlook Data Files Back Up Outlook Items Change Data File Settings Configuring Email Message Security Settings Who is this course for? Who is this course for? This course is designed for experienced Outlook users who need to increase their efficiency in the usage and manipulation of emails, tasks and the calendar. Requirements Requirements Preferably, delegates would have attended the MS Outlook Introduction course.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included