1109 Microsoft Office courses in Cardiff delivered On Demand

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.

[vc_row][vc_column][vc_column_text] Description: Improve your competency in Microsoft Office with this Microsoft Excel Complete Course - Beginners, Intermediate, Advanced. Microsoft Excel is the most widely used spreadsheet program in the world. It allows businesses to conduct data analysis, record expenditures and carry out simple to complex maths calculations. Want to master Excel? This complete training course will help you gain the practical skills and knowledge you need to perform everyday data-based tasks faster and more efficiently. This course is designed to help you familiarise with the major functionalities of Excel, with step-by-step guidance. You will start with simple tasks like viewing excel data, working with the interface, using quick analysis and more. At an intermediate skill level, you will learn about macros, forms, slicers, timelines etc. Finally, at an advanced level, you will learn how to create charts, pivot tables, solve formula errors and manage your data more effectively. This online course is the ultimate online guide for learning MS Excel. Certify your skills in this leading office software and gain maximum career progression! Who is the course for? Professionals who want to learn how to use Microsoft Office Excel. People who have a need to analyze and organise large amounts of data. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Microsoft Excel Complete Course - Beginners, Intermediate, Advanced is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Management consultant Investment Banking Analyst Marketing Engineering Researchering [/vc_column_text][/vc_column][/vc_row] Microsoft Excel - Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Excel for Newbies - Activities 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel - Intermediate Level 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Excel Complete Course - Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course condenses Microsoft Word, PowerPoint, and Outlook into a powerful 90-minute learning experience. Learn the core functionalities to create professional documents, captivating presentations, and manage your email efficiently. Ideal for busy professionals or anyone new to Microsoft Office. Boost your productivity and become a Microsoft whiz in just 90 minutes! Enroll now and conquer your workday!

Level 3 Diploma | FREE QLS Endorsed Certificate | 11 CPD Courses & PDF Certificates | 145 CPD Points | Lifetime Access

Description: Regardless of whether you are a business writer, an advertiser, or somebody who utilizes the software for general report creation and handling, the skills incorporated into this course will enable you to maximize your use of many powerful Word features to create compelling, visually attractive, and useful documents. This online course will allow you to learn advanced Word techniques, covering all that you need to help you get started. It shows you how to open reports and control the words on the page, so they look as you mean, whatever your purpose.In this course you will learn the necessary skills, knowledge and information of Microsoft Word 2007.  Who is this course for? New users, beginners, and intermediates users can benefit from this course. This course would be ideal for individuals who wish to develop their skills of using Microsoft Office Excel application. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path:  Microsoft Word 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. PA. Secretary. Administrator. Office Manager. Microsoft Word 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Adding Pictures 01:00:00 Module Four - Adding Smart Art 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Advanced Table Tasks 01:00:00 Module Seven - Inserting Special Objects 01:00:00 Module Eight - Adding In-Document References 01:00:00 Module Nine - Advanced Research Tasks 01:00:00 Module Ten - Reviewing a Document 01:00:00 Module Eleven - Customizing Word 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Word 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Word 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Word 2007 Advanced Level 00:20:00

Description: Microsoft SharePoint, a web-based co-working platform, helps the business organisations to share documents and ideas. This document management platform allows the users to work effectively and collaboratively with other members. Through the Microsoft SharePoint 2016 For Users, you will learn how to navigate and use Microsoft SharePoint and how to manage the documents or how to find out the desired contents, documents, etc. The Microsoft SharePoint 2016 For Users teaches you to use the application using lists and how to use the communication and collaboration features, or how to use the application with Microsoft word program, etc. The course provides all the necessary information that a user may need to operate or navigate the program through different devices. Learning Outcomes: Accessing and navigating through SharePoint sites Adding documents and searching in SharePoint sites Filter, group and sort lists, while also adding item to lists, modifying them and configuring views Collaborating with others by sharing and updating profiles, sharing and following content, and creating blog posts Using SharePoint across other Microsoft Office programs like Outlook Integrate SharePoint with OneDrive and using it on mobile devices 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 SharePoint 2016 For Users 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 SharePoint 2016 For Users 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. Opening and Navigating SharePoint Team Sites Access SharePoint Sites 00:15:00 Navigate SharePoint Sites 00:15:00 Working with SharePoint Content Adding Documents 00:15:00 Searching SharePoint 00:15:00 Using Lists Add Items to Lists 00:15:00 Modifying List Items 00:15:00 Configure List Views 00:15:00 Filter, Group, and Sort List Data 00:15:00 Using Collaboration and Communication Features Update and Share Your Profile 00:15:00 Share and Follow SharePoint Content 00:15:00 Create a Blog Post 00:30:00 Using SharePoint with Microsoft Office Open and Save SharePoint Documents with Microsoft Office 00:15:00 Use Document Versions in Microsoft Office 00:30:00 Access SharePoint Using Outlook 2016 00:15:00 Accessing SharePoint Using Alternate Methods Synchronize OneDrive with SharePoint 00:15:00 Use SharePoint with a Mobile Device 00:15:00 Activities Activities - Microsoft SharePoint 2016 For Users 00:00:00 Mock Exam Mock Exam- Microsoft SharePoint 2016 For Users 00:20:00 Final Exam Final Exam- Microsoft SharePoint 2016 For Users 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  Office 365 OneNote is created so you can access your OneNote notebooks from the same website where they are stored, and make some fundamental changes without using a computer where your desktop Office applications are installed. This will be useful to those people who are always on the go and always need to have access to their files from anywhere. In this course, you will learn the necessary skills, knowledge and information about the OneNote online which is part of the Office 365 suite of apps. Students will learn how to create notebooks, add content, share and print OneNote Online notebooks. Who is the course for? This course would be ideal for Microsoft Office users, students and office workers. This course is designed for anyone who wants to learn about one note 365 essentials. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft One Note 365 Essentials will be very beneficial and helpful, especially to the following professionals: Event planner Project manager Real estate agent Travel agent Teacher Lawyer Microsoft One Note 365 Essentials Module One - Getting Started 00:30:00 Module Two - Welcome to Office 365 Web Apps 01:00:00 Module Three - Working with Notebooks 01:00:00 Module Four - Working with Pages and Sections 01:00:00 Module Five - Editing in the Browser 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Your Text 01:00:00 Module Eight - Paragraph Formatting, Styles and Tags 01:00:00 Module Nine - The Insert Tools (I) 01:00:00 Module Ten - The Insert Tools (II) 01:00:00 Module Eleven - The View Tab 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note 365 Essentials 00:00:00 Mock Exam Mock Exam- Microsoft One Note 365 Essentials 00:20:00 Final Exam Final Exam- Microsoft One Note 365 Essentials 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

🚀 Unlock Seamless Teamwork with 'Efficient Collaboration: Mastering Office 365' 🚀 Are you ready to revolutionize the way your team works together? Say goodbye to productivity bottlenecks and hello to streamlined collaboration with our comprehensive online course: 'Efficient Collaboration: Mastering Office 365.'   🌐 Why Office 365? In today's fast-paced business environment, effective collaboration is non-negotiable. Microsoft Office 365 stands as the ultimate toolkit, empowering teams to communicate, share, and achieve together seamlessly. From Word and Excel to Teams and SharePoint, this suite offers unparalleled potential for enhanced productivity.   🔥 What Will You Learn? 📈 Maximize Productivity: Discover the hidden gems within each Office 365 app to boost your team's efficiency and output. 🤝 Streamline Communication: Unleash the full power of Microsoft Teams, fostering real-time collaboration and communication across your organization. 🌐 Master Cloud Collaboration: Dive into SharePoint and OneDrive to facilitate secure and efficient document sharing, ensuring your team is always on the same page. 🔄 Automation Techniques: Learn how to automate repetitive tasks with Power Automate, saving time and reducing errors. 📱 Mobile Collaboration: Extend your collaboration capabilities to mobile devices, allowing your team to work from anywhere.   🎓 Why Choose Our Course? ✅ Expert Instructors: Taught by seasoned Office 365 professionals with hands-on industry experience. ✅ Interactive Learning: Engage in practical exercises and real-world scenarios to reinforce your understanding. ✅ Lifetime Access: Enjoy access to course materials and updates for a lifetime, ensuring your skills remain cutting-edge. ✅ Community Support: Join a vibrant community of learners, exchanging insights and overcoming challenges together.   🌟 Who Is This Course For? Business Owners Project Managers Office Administrators Team Leaders Anyone looking to supercharge their collaboration skills   💡 Enroll Today and Transform Your Team's Collaboration! Don't let outdated collaboration methods hinder your team's potential. Join 'Efficient Collaboration: Mastering Office 365' today and unlock the full power of Office 365. Take the first step towards a more connected, productive, and successful future! Course Curriculum Basic Overview 00:00 Licensing Issues for Business 00:00 Home Vs Business Pricing 00:00 Reasons To Consider the Home Version 00:00 Differing Levels of Business Pricing - Enterprise 00:00 Purchase and Set Up 00:00 Using Office Applications Online 00:00 Using Office Applications Offline 00:00 Do You Need to Be Internet Connected 00:00 Using One Drive - Admin 00:00 Using One Drive Basic Functions 00:00 Skype For Business Installation 00:00 Skype for Business Webinars 00:00 Skype for Business Vs Skype for Desktop 00:00 Microsoft Outlook With Exchange 00:00 Outlook.com Vs Microsoft Exchange 00:00 Managing Tasks With Planner 00:00 The Teams Application 00:00 Invoicing and Management Applications 00:00 Conclusion 00:00 Advanced Overview 00:00 Other 365 Options 00:00 Admin Panel - Part One 00:00 Admin Panel - Part Two 00:00 Document Sharing and Collaboration 00:00 Document Sharing and Collaboration With Delve 00:00 Intranet with Sharepoint 00:00 Intranet with Sharepoint - External App Updates Part Two 00:00 PPT Alternative Onscreen Presentatoins with Sway 00:00 PPT Alternative Onscreen Presentations With Sway - Part Two 00:00 Zapier Like Integrations with Flow - Part One 00:00 Zapier Like Integrations with Flow - Part Two 00:00 Slack Like Conversations With Yammer - Part One 00:00 Slack Like Conversations with Yammer - Part Two - External 00:00 Adding On Applications with Dynamics 365 00:00 Adding on Applications with Dynamics 365 - Part 2 00:00 Create Surveys - Quizzes and Polls with Forms - Part One 00:00 Create Surveys - Quizzes and Polls with Forms 00:00 Using Microsoft To Do 00:00 Conclusion 00:00

Description:  You will learn the necessary skills, knowledge and information about Microsoft SharePoint 365 through this course. In this course you will learn how to sign on to the Microsoft Office 365 portal, and see where the SharePoint content will be stored. You will learn the Home Page of the portal, where to sign into Team Site and the Office 365 web apps, including outlook. Through share point essentials you will look at the Team Site and how to navigate around and view the SharePoint Site. SharePoint online is the Office 365 answer to collaboration. SharePoint online will let you manage documents and information in one place that customers and colleagues can access from virtually anywhere. Who is the course for? Professionals who want to learn about the basic features of Microsoft SharePoint 365 People who have an interest in knowing the essentials in Microsoft SharePoint 365 Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a 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/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft SharePoint 365 Essentials course would be beneficial for any type of professions or careers such as: Administrative Assistant Administrator Office Manager Personal Assistant Secretary. Microsoft SharePoint 365 Essentials Module One - Getting Started 00:30:00 Module Two - Basic SharePoint Concepts 01:00:00 Module Three - Working with My Site 01:00:00 Module Four - Working with SharePoint Content 01:00:00 Module Five - Working with Libraries 01:00:00 Module Six - Working with Lists 01:00:00 Module Seven - Working with Other Types of Lists 01:00:00 Module Eight - Working with Calendars 01:00:00 Module Nine - Working with Sites and Pages 01:00:00 Module Ten - Working with Views 01:00:00 Module Eleven - Using Workflows 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft SharePoint 365 Essentials 00:00:00 Mock Exam Mock Exam- Microsoft SharePoint 365 Essentials 00:20:00 Final Exam Final Exam- Microsoft SharePoint 365 Essentials 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00