Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included
Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Tailored in company 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 PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS 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
Broiler Cleaning Certificate Taking the stove cleaning course is a chance to begin your own proficient broiler cleaning business, obliging business and private clients. This is a chance for you to begin your own fruitful business equipped with the information and abilities you need to furnish your customers with the best quality outcomes and administration consistently. Prologue to the Oven Cleaning Certificate The stove cleaning authentication is a perceived certificate to help you kick off your vocation as an expert broiler more clean. This course contains fourteen modules flooding with significant data that requires roughly ten hours to finish. You will learn fundamental stove cleaning methods, the lawful necessities encompassing compelling broiler cleaning thus substantially more. You will be equipped with all you require to maintain your own fruitful business pushing ahead. During your online examinations you will have the help of a coach, who is available to direct you. You can concentrate from anyplace utilizing any gadget and study at your own speed, not set to any timetable, empowering you to work all day and study in your extra time. On finish and breezing through the different decision assessment, you will get your affirmation, which is industry perceived and can be downloaded and printed whenever the timing is ideal. What You Will Learn The course involves fourteen data stuffed modules, which will show you the accompanying: Comprehend what work you will do as an expert broiler cleaner alongside the fundamental hardware you should create the best outcomes. Realize why preparing in broiler cleaning is an advantage and where to track down the best positions where you will utilize your insight, the distinction between working for yourself or for another person and how to get long haul business contracts for stove cleaning. Understand what kinds of stove cleaning occupations are accessible. Get a decent comprehension of broiler cleaning hardware. Know the items and devices you will require, the motivation behind every one and how to guarantee you meet the exacting wellbeing and security guidelines. Think about substance wellbeing and what guidelines you need to stick to. Realize what documentation you should uphold industry cleaning items, who is liable for wellbeing and security consistence thus substantially more. Find out about the functioning conditions you can anticipate from what amount of time it will require to finish a task, why security garments is so significant and different valuing structures you should exploit. Comprehend the different stove cleaning strategies and anticipated norms. Understand what instruments you ought to use for various surfaces and what methods to use to profound clean stoves adequately. Expertise to clean Rayburn and AGA cookers. Expertise to distinguish these two regular cookers, what items you should utilize and what are the most well-known working temperatures of these two machines. Learn all you require to think about business broiler cleaning based on what's required to dry steam cleaning to the hardware you will require. Get a decent comprehension of harmless to the ecosystem stove cleaning - "green cleaning." Learn about amazing normal de-greasers and the advantages of steam cleaning instead of utilizing synthetic arrangements. Figure out how to run a stove cleaning administration adequately to make progress. Realize what it involves to run an assistance adequately, help to support your client care levels and the number of broilers you can hope to clean consistently. Expertise to begin your own broiler tidying business from introductory beginning up expenses to showcasing and building up your online presence. Find out about business protection, charge and the hardware you will require when beginning your own broiler cleaning business. Comprehend what is involved when recruiting staff to work for you, including your duties as a business and when you ought to compose a wellbeing and security strategy, in addition to quite a lot more. Advantages of the Oven Cleaning Certificate This perceived certificate can give you such countless advantages during and after your internet preparing, these include: An industry perceived accreditation. You will figure out how to convey the best support of your customers. You will have the information you need to begin your own effective stove cleaning business. You study online at your own speed with no set timetable. You can concentrate from any gadget associated with the web. Online help all through your examination to control you the correct way. Course Modules/Lessons Module 1: Oven Cleaning an Introduction Module 2 : Why Train in Oven Cleaning? Module 3 : The Different Types of Oven Cleaning Jobs Available Module 4 : Oven Cleaning Equipment Module 5 : Chemical Safety, Compliance and Legal Requirements Module 6 : Working Conditions Module 7 : Oven Cleaning Techniques and Standards Expected Module 8 : Cleaning AGA and Rayburn Cookers Module 9 : Commercial Oven Cleaning Module 10 : Green Oven Cleaning Module 11 : Running an Oven Cleaning Service Module 12 : Starting Your Own Oven Cleaning Service Module 13 : Business Insurance, Equipment & Tax Module 14 : Hiring People to Work for You
Legitimate Secretary Certification Level 3 Working in the legitimate area doesn't expect you to be an attorney. Legitimate secretaries offer fundamental help to specialists, helping them to deal with their case load, sort out their journals and put together their workplaces. This work regularly incorporates contact with customers. The legitimate secretary authentication program involves 15 hours of study, which will give you the instruments, abilities and information important, to go after a secretarial job in a lawful firm or update your colleagues' current abilities. Upon effective consummation of the course, you will be granted an industry-perceived declaration. Potential businesses can confirm your declaration on our site. What's Covered in the Course? The lawful secretary declaration gives you fundamental data and exhortation, to guarantee that you are profitable in this part inside any lawful firm. A portion of the perspectives that you can hope to realize when taking the course online include: The part of the legitimate secretary: what you will be required to perform and the overall responsibilities; The act of essential lawful editing and report composing abilities; The significance of customer privacy; Information on the English overall set of laws; The different court frameworks and designs; A comprehension of legitimate guide and who is qualified for this advantage; Common prosecution; Improved word handling and sound (tuning in) abilities; A functioning information on wills and probate law, land and conveyancing work on, empowering you to be more included and give your group the most ideal help; Family law, criminal law, organization and business law and permitting laws; Offers, legal surveys and case expressed; A glossary of lawful terms; Counsel on the best way to discover lawful secretary positions and get ready for a meeting. What are the Benefits of the Course? The course is on the web, directed at your own speed and separated into simple to-oversee modules, utilizing any gadget connected to the web; Understudies have lifetime admittance to the modules, should they need to revive their insight sometime in the future; The capacity to quick track your profession and build up the abilities you need, to get your favored work or upgrade the abilities of existing representatives; Work all day, while you complete your examinations and increment your capabilities; Secure an industry-perceived certificate; No passageway prerequisites; Online help all through your investigation experience; Reasonable cost.
This course is a guide for those keen on filling in as any sort of executive in an office setting. This incorporates individual collaborator (PA) and secretarial positions. It's likewise ideal for the individuals who right now stand firm on authoritative situations and need to extend their abilities to acquire new tips and deceives. In every module, the course will assess a particular ability that is fundamental in each authoritative position. We will go overbroad abilities, like client correspondence and trust in the working environment, just as more explicit abilities, for example, business composing and helpful PC applications. Members in this course will get important data that is straightforwardly appropriate to any managerial position. Regardless of whether they be as a PA or a secretary, occupations in an organization manage numerous parts of a business. Representatives in these positions need to manage ranking staff and clients, just as different organizations. To do so successfully, they need to have a wide exhibit of abilities that address every one of these territories. This course offers a more profound glance at these important capacities and leaves understudies ready to do their organization occupations effortlessly, expertise and certainty. What You Will Learn: Valuable skills that will help in any administrative position How to use Microsoft Outlook and Excel How to communicate with senior staff How to communicate with customers and clients in a professional manner How to manage your time and keep organised in your job Benefits of Taking This Course: Gain significant abilities that are alluring to managers Gain tips and deceives that are valuable in the work environment and can help you do your work all the more viably Find out about all that a PA or secretarial occupation involves Figure out how to direct business on the web, on the phone and face to face Improve your trust in the working environment to empower you to improve as a representative Video Review Executive Assistant Tools & Tips for Organisational Perfection Course Modules/Lessons Module 01: Introduction and Calendar Management Module 02: Writing Letters, Faxes and Emails in a Business Setting Module 03: Telephone Skills and Building Your Self-confidence Module 04: Making Travel Arrangements and Invoicing Module 05: Time Management and Efficient Filing Module 06: Customer Care and Dealing with Complaints Module 07: Planning Ahead, Presenting and Proofreading Module 08: Typing and Word Processing Module 09: A Quick Look at Microsoft Outlook and Excel Module 10: Organising Meetings and Effective Communication Estimated course learning time: 9 hours
Introduction Secretaries are an integral part of any team. What once started as a simple role of keeping secrets and relaying messages has over time progressed into a career in and of itself. Secretaries are the ones who are responsible for keeping the team organised, informed and working towards the set goals determined by upper management. But there is definitely far more to this simple role than meets the eye. People who take the time to understand what it means to be an effective secretary often benefit from a deeper understanding about the job, develop a better sense of professionalism, and get to perfect their office skills, among many other benefits. Being a secretary is more than paperwork, it comes with many responsibilities and opportunities for growing professionals. This course will give you all the information you need to become an effective secretary. What You Will Learn: About the different types of secretaries and related professions About the role of an effective secretary and their responsibilities About the certifications, qualities and skills needed to become and effective secretary About the various challenges and perks of working as a secretary for both men and women The Benefits of Taking This Course: Understand how to develop your skills which will help in various office settings Understand how different industries use secretaries with different skill sets Gain knowledge that can help you become an integral part of any office team Gain a deeper understanding of business, business protocols and the day to day business interactions with clients Course Modules: Module 01: Types of Secretarial Positions Module 02: The Role and Responsibilities of a Secretary Module 03: Certifications, Skills and Qualities of an Effective Secretary Module 04: The perks and Challenges of Working in a Secretarial Position
Becoming an Executive PA Learning about becoming an executive PA is essential information for anybody who is either looking to land a dream job in the well-remunerated and dynamic world of executive PAs or wanting to improve their current skill set and become the best possible executive PA. This course covers everything you need to know about becoming an executive PA, including a detailed description of the work environment, which educational requirements there are and the personal traits you need to develop to increase your chances of landing your dream executive PA job. We also include a detailed description of every role fulfilled by executive PAs in all types of industries and organisations, as well as how to adequately prepare yourself for these roles and improve your current skill set. From each task you are required to perform to expert tips on how to perform them efficiently and effectively, this is the ultimate guide to becoming the best possible executive PA! What You Will Learn: The subjects, courses and qualifications you need to become an Executive PA All about the structure of the position, the work environment and the nature of the industry The personal traits required by the job and how to develop them All about the roles to fulfil and tasks required and expert advice on how to perform these tasks efficiently and effectively The Benefits of Taking This Course: Understand the skills needed to help you become a great PA Learn what it takes to achieve job security in a solid position Help your employability in the industry Improve your knowledge and skill set
Making Lively and Effective Meetings Certification Understanding the keys to enthusiastic and successful gatherings is crucial for anyone in any association, paying little heed to the nature and the size. This course gives a thorough knowledge into each part of guaranteeing that gatherings are vivacious and powerful, including how to plan for a gathering, the sorts of meeting to pick and how to make them overly compelling and never exhausting! From the approaches to utilize time, to viable gathering correspondence procedures you can apply as a gathering facilitator or member, this course covers each perspective that anybody in any organization or association has to know. You Will Learn Instructions to completely plan for a gathering The distinctive gathering types and how to realize which is best for your necessities Step by step instructions to guarantee that gatherings are exuberant and invigorating for all participants Instructions to adequately impart previously, during and after the gathering Instructions to keep the gathering centered and exceptionally gainful Advantages of Taking This Course You will actually want to put together and facilitate the best gatherings at your association You will comprehend the keys to capitalizing on each gathering and never squander one more moment You will actually want to recommend new and imaginative approaches to make your gatherings exuberant, invigorating and innovative You will actually want to allocate errands to participants and get the absolute best out of them in each gathering You will actually want to save time, increment profitability and transform gatherings into amazing key devices
Minute Taking Certification Minute taking is a key administrative role which significantly increases the effectiveness of meetings. Without quality minutes, organisations can fail to harness drive and motivation and teams can lose focus. Minutes act like a compass to guide the team by recording past decisions and tracking current discussions and actions. Without the specific skills needed to record information and output it in appropriate and effective ways, staff can become fearful of the process and refrain from taking the opportunity to practise critical skills. This course supports individuals to understand the role and learn the skills needed to effectively take minutes and support meetings, teams, groups, conferences and committees to enhance collaboration and efficiency. Minute taking is not just about writing notes. To be a good minute taker requires an in-depth understanding of how to prepare for the meeting, the responsibilities during the meeting and processes to follow once the meeting is over. There are also key skills in listening and communication which can rapidly enhance effectiveness and enjoyment of the role. Taking this course will prepare individuals to capture and output the correct level of detail and quality to meet internal and external compliance requirements. This course has been developed with experimental activities, detailed guidance and the opportunity to learn and practise the key skills and qualities mandatory for effective minute taking. The exercises, quizzes and worksheets assess progress as you go through the course, gradually building learning to a level of confident proficiency and expertise. What you will learn Lessons you will learn in this course include: Understanding the basics of minute writing The qualities of a minute taker The benefits of taking minutes Recording of minutes Minutes layout Minutes standards Technology in minute taking Common dos and don'ts when writing minutes Benefits of the course The benefits of taking this course include: Understanding meeting minutes templates and when to use them Know how to write different kinds of minutes suited to the occasion Developing your listening skills to extract important information Comprehend the style and tone of language and legal requirements Learn how to effectively edit and proofread minutes to ensure accuracy Taking this course will help individuals conquer fears and enhance skills. Organisational effectiveness can be dramatically improved by getting this key ability established in individuals and within teams. Anybody can learn how to take accurate minutes and quickly see the benefit this brings to the entire organisation. Course Modules/Lessons Module 1: Minute Taking Basics Module 2: Standards for Minute Taking Module 3: Pre-Meeting Preparation Module 4: During And After The Meeting Module 5: Personal Development
3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access