1041 Microsoft 365 courses delivered Online

Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Microsoft Office 2016 Excel Beginner to Advanced Course Description At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate 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.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Receptionist Office Admin Data entry Officer Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

Description: The 70-662 - Deploying Microsoft Exchange Server 2010 S course prepares you for the exam 70-662 - Deploying Microsoft Exchange Server 2010 S. The purpose of the MCTS: Microsoft Exchange Server 2010 certification is to validate your skills in support for the maintenance and administration of the Exchange servers in an enterprise environment. In the course, you will learn how to use active directory and support infrastructure, use active directory components, and the network-based services. The course also teaches you about the server roles in Exchange Server 2010, and infrastructure requirements for Exchange Server 2010. You will learn about mailbox servers and recipients, securing the server, mailbox database update process, public folder process for MAPI clients, and e-mail address policies. The course will focus the ways of managing client access, POP3 and IMAP4 options, and Outlook client connectivity troubleshooting. Finally, the course will teach you how to manage Message Transports, Exchange Security and how to implement High Availability. 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? 70-662 - Deploying Microsoft Exchange Server 2010 S 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 70-662 - Deploying Microsoft Exchange Server 2010 S 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. Active Directory and Supporting Infrastructure 70-662-Active Directory and Supporting Infrastructure FREE 00:15:00 70-662-Active Directory Components 00:24:00 70-662-Network Based Services 00:21:00 70-662-Server Roles in Exchange Server 2010 00:21:00 70-662-Infrastructure Requirements for Exchange Server 2010 00:21:00 Mailbox Servers and Recipients 70-662-Mailbox Servers and Recipients 00:58:00 70-662-Secure the Server 00:38:00 70-662-Mailbox Database Update Process 00:26:00 70-662-Public Folder Process for MAPI Clients 00:29:00 70-662- E-Mail Address Policies 00:17:00 Managing Client Access 70-662-Managing Client Access 00:46:00 70-662-POP3 and IMAP4 Options 00:35:00 70-662-Outlook Client Connectivity Troubleshooting 00:23:00 Managing Message Transports 70-662-Managing Message Transports 00:49:00 70-662-How S MIME Works 00:39:00 70-662- Back Pressure - System Monitoring 00:15:00 70-662-Edge Transport Server Security 00:36:00 Exchange Security 70-662-Exchange Security 00:36:00 70-662-Management Role Assignment Policies 00:26:00 70-662-Messaging Policy and Compliance 00:34:00 70-662-Message Classifications 00:21:00 70-662-Considerations for Managing the Message Journal Mailbox 00:37:00 70-662-Managed Folders 00:19:00 Implementing High Availability 70-662-Implementing High Availability 00:18:00 70-662-Database Availability Group 00:32:00 70-662-Transport Dumpster 00:27:00 70-662-Backup and Restore Scenarios 00:26:00 70-662-Database Mobility 00:21:00 70-662-Network and Performance Guidelines 00:18:00 Mock Exam Mock Exam- 70-662 - Deploying Microsoft Exchange Server 2010 S 00:20:00 Final Exam Final Exam- 70-662 - Deploying Microsoft Exchange Server 2010 S 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn new skills and develop your professional knowledge with our Advanced Diploma in Microsoft Office and learn from home at a pace that suits you. The Microsoft Office 2019 course has been expertly designed for you to complete through distance e-learning and achieve a professional qualification without leaving your own home! Learn and Explore the New Features of Microsoft Office 2019 in this course. From creating documents and spreadsheets, to presenting information in a slide show and managing projects, this Microsoft Office 2019 course is your step-by-step guide to getting it all done. Get started now, and be on your way to mastering Word, PowerPoint, Excel, and more. Learn the skills you'll need to improve your CV and land the job of your dreams. Complete the Advanced Diploma in Microsoft Office to earn an industry-recognized credential that will help you excel in the workplace. Become confident of your abilities and use them to develop your profile online and in the marketplace.

The comprehensive Basic Microsoft SQL Server Development has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Basic Microsoft SQL Server Development today, and learn from the very best the industry has to offer! This best selling Basic Microsoft SQL Server Development has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic Microsoft SQL Server Development is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic Microsoft SQL Server Development is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The Basic Microsoft SQL Server Development is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic Microsoft SQL Server Development , you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic Microsoft SQL Server Development will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic Microsoft SQL Server Development to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Prepare to use Microsoft Word to its most tremendous potential with this expertly outlined Basic Microsoft Word Essentials (Arabic) course. This course goes through the fundamental functionalities of MS Word and how to get started with it. MS Word is a popular word processing program that can be used for a variety of purposes. It makes creating documents, brochures, and applications a breeze. This comprehensive Basic Microsoft Word Essentials (Arabic) will walk you through the MS Word program, starting with the basics and moving on to the interface. You'll learn how to create essential Word documents, colour pages, incorporate tables, and write in various fonts and sizes. Once you complete, you will get equipped with the fundamental skills to utilise MS Word in modern and effective ways.  Enrol right now and add a new skill to your repertoire for incredible opportunities. This best selling Basic Microsoft Word Essentials (Arabic) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic Microsoft Word Essentials (Arabic) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic Microsoft Word Essentials (Arabic) is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Basic Microsoft Word Essentials (Arabic) is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic Microsoft Word Essentials (Arabic), you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic Microsoft Word Essentials (Arabic) will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic Microsoft Word Essentials (Arabic) to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Advanced Diploma in Microsoft Excel has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced Diploma in Microsoft Excel today, and learn from the very best the industry has to offer! This best selling Advanced Diploma in Microsoft Excel has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Diploma in Microsoft Excel is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced Diploma in Microsoft Excel is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced Diploma in Microsoft Excel is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced Diploma in Microsoft Excel, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced Diploma in Microsoft Excel will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced Diploma in Microsoft Excel to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview The comprehensive Microsoft Server 2019 Installation and Management has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Microsoft Server 2019 Installation and Management today, and learn from the very best the industry has to offer! This best selling Microsoft Server 2019 Installation and Management has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Microsoft Server 2019 Installation and Management is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Microsoft Server 2019 Installation and Management is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Microsoft Server 2019 Installation and Management is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Microsoft Server 2019 Installation and Management, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Microsoft Server 2019 Installation and Management will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Microsoft Server 2019 Installation and Management to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

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.

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00