1375 Microsoft Office courses

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

PowerPoint for Business in 60 Minutes   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to PowerPoint for Business in 60 Minutes.   Microsoft PowerPoint has been around for nearly 35 years, and I am sure you are familiar with it, and have experienced many PowerPoint presentations – some good; many extremely tedious! Creating a business presentation in PowerPoint presents a number of challenges and there is a danger of “death by PowerPoint”. I recently attended a meeting which was supposed to be a planning discussion but which the person leading the meeting insisted on introducing with a PowerPoint presentation of 60 slides – mostly bullet points! We were hardly in the mood for action planning after that assault on our senses.  PowerPoint is good for presenting business results or for a training course, but you need to plan your slideshow carefully to avoid bullet-point boredom and to keep your audience engaged and interested. And that is the purpose of this course – to teach you PowerPoint techniques which you may not be familiar with, and which will help you improve the impact of your business presentations.   Less is more in a slide show so it is important to use techniques and effects which will help engage your audience and draw their attention to the points that matter.  In “PowerPoint for Business in 60 Minutes”, I cover six key topics that will help you produce more impactful business presentations: The best slide transitions and animations for business presentations The morph transition to make the narration of an agenda, or similar list, or a team photograph extremely slick and professional The Zoom effect to create a summary slide with hyperlinks to zoom into the section that you or your audience choose How to animate charts to highlight the key points you want to bring out How to embed Excel tables with slicers into PowerPoint, and why PowerPoint is not developed enough to make this useful for a business presentation How to turn your PowerPoint presentation into a video. This is the technique I am most often asked how to do.   This is not a full “PowerPoint from scratch” course: it assumes familiarity of Microsoft’s ubiquitous programme. Instead, the course takes only 1 hour of your time to focus on key techniques that can help you improve the impact of the presentations you create.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Identify the most useful slide transitions and animations for business presentations Use the morph transition to draw the audience’s attention Create a “zoom” summary slide to jump to user-selected sections of slides Animate charts to highlight key points Embed a Microsoft Excel table in a PowerPoint slide Create a video with commentary of their PowerPoint presentation     Curriculum Lesson 1: Transitions and Animations Lesson 2: The Morph Transition Lesson 3: Zoom Lesson 4: Animating Charts Lesson 5: Excel Tables and Slicers in PowerPoint (or Not!) Lesson 6: Making a PowerPoint Video     Pre-Course Requirements There are no pre-course requirements     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What slide effect allows you to give the illusion of moving around a larger “page”? The Wipe transition. The Dissolve transition. The Push transition. The Fly-In animation   What does “Zoom” in PowerPoint allow you to do? Zoom creates the illusion of “zooming in” on a particular part of a slide Zoom creates a summary slide with hyperlinks to the individual slides or sections contained in the summary Zoom creates a smooth object animation from one slide to another to animate, for example, an agenda or timeline Zoom is used to highlight areas of a chart or graphic to draw the audience’s attention   What is the main problem with embedding a Microsoft Excel table with slicers into PowerPoint? The slicers do not work, and the table cannot be manipulated, in presentation mode in PowerPoint The table cannot be opened or manipulated in PowerPoint slide view Microsoft Excel and PowerPoint are incompatible with each other The file size created is too large for most business PCs to handle   When seeking to create an MP4 video file from a PowerPoint presentation, why is it advisable to record the commentary separately? PowerPoint’s built-in recording facility is unreliable and frequently crashes It’s much quicker to record the audio separately and then insert it into PowerPoint and save as a video file Separate video editing software needs to be used to improve the video’s look and sound where the audio is recorded directly in PowerPoint It removes the stress of commentating “live” on the presentation while recording it, and allows any mistakes and errors to be cut out  

As the most-used spreadsheet program in the world, learning how to use the Microsoft Excel will give you an advantage. This Microsoft Excel 2010 Essentials course is created to help you in learning the basics and importance of this program. In this course, you will learn the necessary skills, knowledge and information about how to plan and organise your data using the tools in this program. Learn the basics and common functions of Microsoft Excel that will help you finish your tasks faster. You will learn writing the right formula and functions that can save you time and become more productive in your work. Course Highlights Accredited Microsoft Excel 2010 for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Excel 2010 for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 10 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Excel 2010 for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Excel 2010 for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Accredited Microsoft Excel 2010 for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Accredited Microsoft Excel 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Excel 2010 for Beginners 00:20:00 Final Exam Final Exam- Accredited Microsoft Excel 2010 for Beginners 00:20:00

In this course, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. Each section in the course contains an exercise for practice and quiz. The course is created using Excel 2019/365 for Windows.

Description: This Microsoft Outlook 2016 Advanced is intended for them who have basic skills with Microsoft Outlook 2016 and want to learn higher level skills or want to learn the topics covered in this course in the 2016 interface. It helps to get up to speed on the various Outlook 2016 features and become familiar with its more advanced options. Learn how to configure advanced message options, use advanced message management options, manage activities using tasks, edit electronic business card, managing outlook data files, among other topics. If you are interested to take this course, don't delay to join us now. Learning Outcomes: Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Outlook 2016 Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Outlook 2016 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Configuring Advanced Message Options Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Advanced Message Management Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Advanced Calendar and Task Management Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Advanced Contact Management Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Sharing Workspaces with Others Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Managing Outlook Data Files Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Managing E-mail Security Configure E-mail Message Security Settings 00:30:00 Activities Activities - Microsoft Outlook 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Outlook 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Outlook 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Executive Secretary & PA Training Course Online For confident candidates with outgoing personalities and a relentless attention to detail, the field of Secretary & PA Diploma services is wide open. Professional personal assistants (PAs) are the ultimate multitaskers, hired to manage the personal affairs and activities of those they support. Some secretaries and PAs work for large corporations, while others are hired by a single executive, entrepreneur, or influential figure. Regardless of which path you take, becoming a trusted and respected PA or Secretary opens the door to a world of incredible career opportunities. Personal qualities and character, as well as hard skills, are important for success as a PA or secretary. It's simply a matter of learning the roles of PAs and secretaries in order to prepare for a rewarding career in the field. This Executive Secretary & PA Training could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. Learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the course. Why choose this Executive Secretary & PA Training Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Executive Secretary & PA Training Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Executive Secretary & PA Training Course.. Other Benefits of This Executive Secretary & PA Training Course FREE PDF Certificates Lifetime Access Free Retake Exam Expert Tutor Support Main Course: Executive Secretary & PA Training Course Free Courses Course 01: Level 2 Certificate in Law and Legal Work Course 02: Level 4 Diploma In Paralegal Studies [ Note: Free PDF certificate will provide as soon as completing the Executive Secretary & PA Training Course] Executive Secretary & PA Training Course Online Our Executive Secretary & PA Training course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our Executive Secretary & PA Training course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Learning Outcomes After completing this Executive Secretary & PA Training course, learner will be able to: Understand personal assistant fundamentals Understand business telephone approaches Understand information regarding shipping and mail services Understand travel arrangements Understand outline setting up conferences and meetings Understand management of time Understand systems for record keeping and filing Understand business writing techniques Understand communication skills Understand customer service Understand basics of microsoft office skills Assessment Method of Executive Secretary & PA Training Course After completing Executive Secretary & PA Training Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Executive Secretary & PA Training Course After completing the Executive Secretary & PA Training course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Executive Secretary & PA Training Course Online This Executive Secretary & PA Training course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements Executive Secretary & PA Training Course Online To enrol in this Executive Secretary & PA Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Executive Secretary & PA Training Course. Be energetic and self-motivated to complete our Executive Secretary & PA Training Course. Basic computer Skill is required to complete our Executive Secretary & PA Training Course. If you want to enrol in our Executive Secretary & PA Training Course, you must be at least 15 years old. Career path Executive Secretary & PA Training Course Online After completing this Executive Secretary & PA Training course, you may able to pursue a formal position in professional Executive PA services such as: Personal Executive Assistant Receptionist Office Assistant Support Secretary Office Manager Personal Concierge Executive Assistant

Register on the PowerPoint Presentation today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The PowerPoint Presentation is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The PowerPoint Presentation Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the PowerPoint Presentation, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01- Introduction and Welcome Introduction 00:03:00 Unit 02 - Map Out Your Massage Map Out Your Massage Introduction 00:14:00 Prepare Your Opening Slides 00:09:00 Prepare Your Opening Slides Activity 00:04:00 Prepare Your Core Content Slides 00:15:00 Prepare Your Core Content Slides Activity 00:04:00 Prepare Your Closing Slides 00:06:00 Prepare Your Closing Slides Activity 00:05:00 Unit 03 - Add Variety to Your Visuals Add Variety to Your Visuals Intro 00:06:00 Use Pictures to Add Impact 00:17:00 Use Pictures to Add Impact Activity 00:04:00 Keep Graphics Simple 00:07:00 Keep Graphics Simple Activity 00:03:00 Use Illustrations to Increase Comprehension 00:07:00 Use Illustrations to Increase Comprehension Activity 00:04:00 Use Handouts to Reach Every Learner 00:08:00 Your Turn Activity 00:02:00 Additional Material Game Changing PowerPoints Workbook 00:05:00 Game Changing PowerPoints - Workbook 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Overview This comprehensive course on Outlook Tips and tricks will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Outlook Tips and tricks comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Outlook Tips and tricks. It is available to all students, of all academic backgrounds. Requirements Our Outlook Tips and tricks is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 12 lectures • 00:48:00 total length •1 - Basic sort: 00:02:00 •2 - Handling Attachments: 00:06:00 •3 - Advanced Sort: 00:05:00 •4 - Conditonal Formatting: 00:04:00 •5 - Filter and Advanced Filter: 00:05:00 •6 - Categories: 00:03:00 •7 - Flags and Reminders: 00:05:00 •8 - Rules: 00:08:00 •9 - Managing Junk Email: 00:03:00 •10 - Managing Folders: 00:03:00 •11 - Inbox Maintenance: 00:04:00 •Assignment - Outlook Tips and tricks: 00:00:00

Learn how to be compelling and proficient in your regular work, with an intensive comprehension of how the Microsoft power point can support you regardless of the level of expertise you are at. We have a Microsoft course for you! Microsoft PowerPoint Basic is followed by this Microsoft PowerPoint Intermediate Course. This Microsoft PowerPoint Intermediate course is intended to take your computer skills from basics to all the way to next level, one step at a time, so enrol now. In this course you will learn the necessary skills, knowledge, and information of Microsoft PowerPoint.  Course Highlights Certified Microsoft PowerPoint Intermediate Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft PowerPoint Intermediate Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft PowerPoint Intermediate Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft PowerPoint Intermediate Level is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Microsoft PowerPoint Intermediate Level is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 00:30:00 Module Two - Working with the PowerPoint Environment 01:00:00 Module Three - Working with Sections and Presentation Organization 01:00:00 Module Four - Formatting Presentations 01:00:00 Module Five - Formatting Shapes and Text Boxes 01:00:00 Module Six - Creating a Photo Album 01:00:00 Module Seven - Working with Graphical Elements 01:00:00 Module Eight - Working with Audio and Video Content 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Collaborating on Presentations 01:00:00 Module Eleven - Working with Presentation Info and Other Formats 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Certified Microsoft PowerPoint Intermediate Level 00:00:00 Mock Exam Mock Exam- Certified Microsoft PowerPoint Intermediate Level 00:20:00 Final Exam Final Exam- Certified Microsoft PowerPoint Intermediate Level 00:20:00