1098 Microsoft 365 courses

Are you ready to embark on an enlightening journey of wisdom with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Functional Skills IT with Microsoft Excel, IoT & ICT Training. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: IT Administration and Networking Course 2: Microsoft Excel Course Course 3: ICT: Information and Communication Technology Course 4: Start an IT Asset Department Course 5: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 6: Recruitment: IT Basics for IT Recruiters Course 7: Web Application Penetration Testing Course Course 8: Internet of Things Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle illuminate your path to wisdom. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Functional Skills IT with Microsoft Excel, IoT & ICT Training package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Functional Skills IT with Microsoft Excel, IoT & ICT Training community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Establish robust bases across each course nestled within the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Decipher intricate concepts through the articulate content of the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Functional Skills IT with Microsoft Excel, IoT & ICT Training journey and let knowledge guide you towards a brighter future. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Functional Skills IT with Microsoft Excel, IoT & ICT Training Bundle. Career path Armed with the Functional Skills IT with Microsoft Excel, IoT & ICT Training bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, this bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Course Overview This comprehensive Microsoft Office course provides an in-depth understanding of the core Office applications—Word, Excel, PowerPoint, and Access. Designed to develop essential digital skills, it equips learners with the ability to navigate each program with confidence, improving document creation, data management, presentations, and database handling. Covering both foundational and advanced features, the course is ideal for those looking to boost their efficiency in a variety of business and administrative contexts. By the end of the course, learners will have the capability to produce professional documents, organise data in spreadsheets, create impactful presentations, and manage information through databases. This structured training ensures clarity in using Microsoft Office tools to support workplace productivity and enhance employability across multiple sectors. Course Description This course explores the full functionality of Microsoft Word, Excel, PowerPoint, and Access—focusing on both classic and new features of the 2019 versions. Learners will begin with the essentials, such as creating and formatting documents, performing calculations in spreadsheets, and developing effective slide presentations. As the modules progress, learners will delve into more detailed features, including managing lists, inserting graphics, handling data queries, and designing user-friendly reports. The training also includes familiarisation with the interface and workflow improvements in each application, offering structured, sequential guidance. Ideal for office professionals, jobseekers, and administrative staff, the course enhances digital fluency and enables learners to carry out a wide range of clerical and operational tasks using the Microsoft Office suite. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Microsoft Word 2019 Module 09: Microsoft Word 2019 New Features Module 10: Getting Started with Word Module 11: Formatting Text and Paragraphs Module 12: Working More Efficiently Module 13: Managing Lists Module 14: Adding Tables Module 15: Inserting Graphic Objects Module 16: Controlling Page Appearance Module 17: Preparing to Publish a Document Module 18: Workbooks - Microsoft Word 2016 (Beginner) Module 19: Microsoft PowerPoint 2019 Module 20: Microsoft PowerPoint 2019 New Features Module 21: PowerPoint Interface Module 22: Presentation Basics Module 23: Formatting Module 24: Inserting Options Module 25: Working with Objects Module 26: Table Module 27: Charts Module 28: Review and Presentation Module 29: Microsoft Access 2019 Module 30: Microsoft Access 2019 New Features Module 31: Introduction to Access Module 32: Modify Data Module 33: Working with Queries Module 34: Access Forms Module 35: Working with Reports (See full curriculum) Who is this course for? Individuals seeking to improve their office software knowledge for employment. Professionals aiming to upgrade their digital skills in a business setting. Beginners with an interest in learning Microsoft Office applications. Jobseekers and administrative workers looking to strengthen their CVs. Career Path Administrative Assistant Data Entry Officer Office Manager Project Coordinator Personal Assistant Executive Support Roles Customer Service Representative Database Administrator (Entry-Level)

Excel isn’t just about cells and charts—it’s where numbers tell stories. This Excel Data Analysis (Microsoft Office) Course is designed for those who want to make sense of spreadsheets without staring blankly at endless rows. Whether you’re handling budgets, forecasts, or good old-fashioned reports, you’ll explore Excel’s powerful tools that help turn raw data into clear insights. VLOOKUPs, pivot tables, conditional formatting—yes, the good stuff is all here, and it’s less scary than it sounds. No fluff, just focused learning. This course cuts straight to what matters: using Excel as a decision-making companion. From sorting data like a spreadsheet whisperer to creating charts that even your boss might understand, the content is structured to be logical, easy to follow, and surprisingly enjoyable. Whether you’re in finance, admin, marketing, or somewhere in between, this is for anyone who’s had a spreadsheet say, “figure me out,” and needed the right nudge in the right direction. Learning Outcomes: Trace formulas and use Excel's Scenario Manager and Goal Seek Use Solver and Data Tables to analyse data Utilise Data Analysis Tools to draw insights from data sets Create forecasts with Excel's Forecast Sheet Understand popular formulas like Sumif, Countif, and If Apply advanced formula techniques like And, Or, and Nested If. Course Curriculum: Excel Data Analysis for Beginner Tracing Formulas Using the Scenario Manager Goal Seek Solver Data Tables Data Analysis Tools Forecast Sheet Sumif, Countif, Averageif, Sumifs, and Countifs formulas If, And, Or, and Nested If formulas How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Analyst - £30,000 to £45,000 Financial Analyst - £35,000 to £55,000 Marketing Analyst - £25,000 to £40,000 Business Intelligence Analyst - £35,000 to £60,000 Sales Analyst - £25,000 to £40,000 Project Coordinator - £25,000 to £35,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Microsoft Excel 2021 has quietly slipped in a bundle of new functions that can turn even the most mundane spreadsheets into efficient data-processing machines. This course introduces the latest features like XLOOKUP, LET, FILTER, SEQUENCE, and TEXTSPLIT, which not only simplify formulas but make spreadsheets smarter and tidier. Whether you’re an analyst trying to avoid circular references or someone who’s simply tired of tangled VLOOKUPs, this course brings clarity to your cells—no pun intended. Tailored for Excel users who know the ropes but want to keep up with what's new, this course ensures you don’t fall behind the curve. You’ll explore function upgrades that tidy up old formulas, save time, and help you work cleaner and quicker. With a thoughtful structure and a lightly witty tone, the course content walks you through updates that genuinely make a difference—without drowning you in geek speak. Excel’s had a makeover, and it's about time your formulas caught up. Learning Outcomes: Understand the purpose and benefits of new Excel functions. Apply the RANDARRAY function to generate random data. Use the UNIQUE function to extract unique values from a data range. Create custom number sequences with the SEQUENCE function. Sort data effectively with the SORT and SORTBY functions. Filter data easily with the FILTER function. Unlock the full potential of Microsoft Excel with our new course, "The Theory of Constraints and Throughput Accounting." In just a few modules, you'll learn how to utilise the latest functions in Excel to quickly sort, filter, and analyse data. By the end of the course, you'll be equipped with the knowledge to efficiently organise even the most complex datasets. But this course isn't just about learning new functions - it's about applying them to real-world scenarios. With practical examples and exercises throughout the course, you'll learn how to use these functions in meaningful ways. The benefits of this course are clear: increased productivity, better data analysis, and more efficient workflow. Don't miss out on this opportunity to take your Excel skills to the next level - enroll in "The Theory of Constraints and Throughput Accounting" today. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Upon completing the Functional Maths Training Course, you can venture into diverse job opportunities across various industries, encompassing positions and pay scales that include: Data Analyst - £31,000 per year (average salary) Financial Analyst - £34,000 per year (average salary) Business Intelligence Analyst - £39,000 per year (average salary) Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Course Overview Video 00:03:00 Building Your Virtual Lab Enviorment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and Lab - Create Virtual Install of Server 2016 Full GUI Using VirtualBox 00:12:00 Video and Lab - Creating a Virtual Install of Server 2016 Core Using VirtualBox 00:11:00 Video and Lab - Creating a Virtual Install Of Windows 10 Pro Using Virtualbox 00:16:00 Video - Taking A Snapshot Of Your Current Configuration 00:04:00 Building a Microsoft Server 2016 Domain Video and Lab - Preparing Your Network For Active Directory 00:08:00 Video and Lab - Prepare Server 2016 for Promotion to a Domain Controller 00:10:00 Video and Lab - Promote Server 2016 to a Domain Controller 00:09:00 Video and Lab - Join Server 2016 Core to Windows 2016 Domain 00:08:00 Video and Lab - Promote Server Core to a Domain Controller 00:14:00 Video and Lab - Join a Windows 10 Workstation to a Microsoft Domain 00:15:00 Windows Deployement Service (WDS) Video - Install WDS on a Windows Server 00:16:00 Video - Deploy a Windows 10 Client Using WDS 00:09:00 Operations Master Roles (FSMO) Video and Lab -Transferring FSMO Roles in Active Directory 00:10:00 Video And Lab - Transfer FSMO Roles Using PowerShell 00:07:00 Video and Lab - Seizing the FSMO Roles Using the NTDSUTIL 00:17:00 Disaster Recovery Video and Lab - Mitigating the Loss of Your Forest Root 00:16:00 Video - NDSUTIL - Resetting the Directory Services Recovery Mode Password 00:03:00 Video - How to Backup and Restore the Windows Registry 00:05:00 Video - Install And Use Windows Server Backup 00:03:00 Video And Lab - Reset a Lost Administrator Password 00:13:00 Monitoring Server 2016 Video and Lab - Monitoring Server Performance 00:13:00 Video - Create a Heads-Up Display Using BgInfo 00:08:00 Video - Overview of the Event Viewer in Windows Server 00:13:00 Server 2016 Advanced Administration Video - Rearm the 180-day Evaluation Period for Windows Server 00:03:00 00:03:00 Video - Enable Remote Desktop Using PowerShell 00:06:00 Video - Upgrade Server 2016 Standard to Server 2016 DataCenter 00:03:00 Video - Disable The Complex Password Policy in Windows Server 00:03:00 Video - Manually Enabling Remote Management 00:05:00 00:02:00 Video - Working with Task View in Server 2016 00:03:00 Video - Create a shared folder Using Windows Server 00:04:00 00:00 Video - Windows Server 2016 Windows Updates Settings 00:04:00 IIS Video - Installing IIS Using PowerShell 00:02:00 Video and Lab - Create a New Website Using Windows Server 00:19:00 Video - How to turn on website authentication in IIS Windows Server 00:05:00 Video - Create a New Virtual Directory In IIS 00:05:00 Video - Change the Default Document Used in IIS 00:04:00 Video - Improve Website Performance Using Dynamic Compression in IIS 00:04:00 Video - Create a New Host Record in DNS For ISS Website 00:04:00 Certificates Services Video and Lab - Create a Self-Signed Certificate in IIS 00:12:00 Video and Lab - Configure Group Policy to Trust a Self-Signed Certificate 00:08:00 Video and Lab - Create Self Signed Certificate and Bind in IIS 00:05:00 Video and Lab - Install and configure Certificate Services 00:09:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Movie - Course Overview 00:06:00 Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and Lab - Creating Virtual Install of Server 2012r2 00:08:00 Video and lab -Create a Virtual Install Of Windows 10 VirtualBox 00:16:00 Video - Taking A Snapshot Of Your Current Configuration 00:04:00 Installing and Configuring Active Directory Video and Lab - Preparing Your Network For Active Directory 00:08:00 Video and Lab - Preparing Server 2012 r2 for Promotion to a Domain Controller 00:10:00 Video and Lab - Join Server 2012 R2 Core to an Existing Domain 00:06:00 Video and Lab - Join a Windows 10 Workstation to a Microsoft Domain 00:15:00 Video and Lab - Promote Server Core to a Domain Controller 00:14:00 Video and Lab- Creating a Server 2012 r2 RODC 00:11:00 Domain Naming System (DNS) Video - Create a Secondary Or Backup DNS Server 00:07:00 Create a DNS Reverse Lookup Zone 00:08:00 Video and Lab - Create a GlobalNames zone * (Requires ADDS being present) 00:11:00 Video - Create a New DNS Host Record 00:02:00 Video - Create a Host Record For a New Website In Microsoft DNS 00:04:00 Video - Creating a DNS MX record 00:04:00 Dynamic Host Configuration Protocol (DHCP) Video and Lab - Install and Configure DHCP on Server 2012 00:11:00 Video - Install the DHCP Role Using PowerShell 00:09:00 Video - How to Authorize/Unauthorize a DHCP Server 00:03:00 Video - How To Edit The Default Gateway Settings In DHCP 00:03:00 Video - Edit DNS Server List In DHCP 00:04:00 Video and Lab - Configuring a DHCP SuperScope 00:04:00 Video and Lab - Manage DHCP Failover in Server 2012 R2 00:08:00 Video - Edit a DHCP Scope 00:03:00 Backup And Restore The DHCP Database 00:03:00 Group Policy Video - Creating a Group Policy Object 00:07:00 Video and Lab - Fine-Grained Password Policy in Windows Server 2012 00:10:00 Video and Lab - Configure Folder Redirection in Window Server 2012 R2 00:11:00 Video and Lab - Creating a Mapped Drive Using Group Policy 00:04:00 Video and Lab - Managing User Desktops Using Group Policy 00:06:00 Video - Prevent Automatic Logoff Due To Inactivity 00:03:00 Video - How To Edit Group Policy Objects To Affect a User 00:03:00 Video - How To Edit a Group Policy Object To Affect a Computer 00:04:00 Video - Backup And Restore Group Policy Objects In Active Directory 00:03:00 Video - Force Screensaver and Timeouts Using Group Policy 00:07:00 Video- Change Users Desktop Background Using Group Policy 00:09:00 Disk Management Video - How To Shrink Or Extend a Volume in Windows Server 2012 00:04:00 Video - How To Format a Volume With ReFS in Windows Server 2019 00:04:00 Video - How To Format a Volume With FAT32 in Windows Server 2019 00:02:00 Print Services TCP/IP Printing Overview 00:08:00 Installing Print Services on Server 2012 R2 00:14:00 Video and Lab - Installing a Network Printer Onto a Windows Client 00:03:00 Video and Lab - Adding a Printer to the Network Using TCP/IP 00:10:00 Video - Printer Pooling 00:06:00 Active Directory Maintenance Video and Lab - Creating a Custom Microsoft Management Console (MMC) 00:06:00 Video and Lab - Creating and Managing Objects in Active Directory 00:14:00 Video and Lab - Performing a Full Backup and Recovery of Server 2012 R2 00:06:00 Video - Rearm the 180-Day Evaluation Period for Wondows Server 00:03:00 Video - Rearm the 30-day Evaluation for Windows 10 00:03:00 Video and Lab - Disable the Internet Explorer Enhanced Security 00:03:00 Video and Lab - Performing an Offline Defragmentation of the Directory Database 00:04:00 Video - Creating a Mapped Drive in Server 2012r2 00:04:00 Video - Create a Heads-Up Display Using BgInfo 00:08:00 Troubleshooting Video - Allow PING Packets through for Server 2012, 2016 and 2019 00:05:00 Video and Lab - Troubleshooting Internet Connectivity 00:16:00 Video - NSLookup 00:05:00 Video - Windows Reliability Monitor (RELI) 00:04:00 Overview of Windows Sysinternal Tools 00:08:00 Video - Overview of Sysinternal's Process Explorer 00:15:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Server 2019 Understand the core competencies and principles of Microsoft Server 2019 Explore the various areas of Microsoft Server 2019 Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert Windows Server 2019 administrator Microsoft Windows Server 2019 - Hands-on Training Part I Course Master the skills you need to propel your career forward in Microsoft Server 2019. This course will equip you with the essential knowledge and skillset that will make you a confident Windows Server 2019 administrator and take your career to the next level. This comprehensive Microsoft windows server course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Windows Server course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This Microsoft Windows Server 2019 - Hands-on Training Part I course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.  This comprehensive course will teach you the theory of effective Microsoft Server 2019 practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Server 2019 industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Server 2019. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for Windows Server 2019 administrator or for people who are aspiring to specialise in Microsoft Server 2019.This Microsoft Windows Server 2019 - Hands-on Training Part I course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this Microsoft Windows Server course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Windows Server course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Server 2019 can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Windows Server course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Windows Server course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Windows Server course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Course Overview Video 00:07:00 Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and lab - Create a Virtual Install of Server 2019 Full GUI 00:12:00 Video and lab -Create a Virtual Install of Server 2019 Core Using VirtualBox 00:13:00 Video and Lab - Creating a Virtual Install Of Windows 10 Pro Using Virtualbox 00:16:00 Video - Taking A Snapshot Of Your Current Configuration 00:04:00 Building a Windows Server 2019 Domain Using Powershell Video and Lab - Preparing Your Network For Active Directory 00:08:00 Step 1: Rename Your Server Using Powershell 00:03:00 Step 2: Assign a Static IP address Using PowerShell 00:04:00 Step 3: Install the Active Directory Domain Services Role Using Powershell 00:03:00 Step 4: Promote Server 2019 as a Domain Controller Using PowerShell 00:05:00 Step 5: Promote Server Core to a Domain Controller 00:14:00 Step 6: Add a Windows 10 Client to the Domain 00:15:00 Active Directory Administration video - Create a User in Active Directory 00:04:00 Video - Limit Computers a User Can Log Onto 00:02:00 Video - Limit logon hours for a user in Windows Active Directory 00:02:00 Video - Reset a User's Password in Windows Active Directory 00:02:00 Video - Unlock or Enable An Account in Active Directory 00:02:00 Server 2019 Administration Video and Lab - Reset a Lost Administrator Password in Windows Server 00:13:00 Video - Create a shared folder Using Windows Server 00:04:00 Video - Create a Shared Folder Using Server Manager 00:06:00 Video - Rearm the 180-Day Evaluation Period For Windows Server 00:03:00 Video - Rearm the 30-day Evaluation for Windows 10 00:03:00 Video - Windows Server 2019 Updates Settings 00:04:00 video - Enable Remote Desktop for Server 2019 00:02:00 Video - Enable Remote Desktop Using PowerShell 00:06:00 Video - NTDSUTIL: Resetting the Directory Services Recovery Mode Password 00:03:00 Video - Create a Heads-Up Display Using BgInfo 00:08:00 Video - Manually Enabling Remote Management 00:05:00 Group Policy Video - Prevent Automatic Logoff Due To Inactivity 00:03:00 Video - How To Create And Link a Group Policy To An OU 00:04:00 Video - How To Edit Group Policy Objects To Affect a User 00:03:00 Video - How To Edit a Group Policy Object To Affect a Computer 00:04:00 Video - Backup And Restore Group Policy Objects In Active Directory 00:03:00 Video - Force Screensaver and Timeouts Using Group Policy 00:07:00 Video- Change Users Desktop Background Using Group Policy 00:09:00 Domain Naming System (DNS) Video - Installing the DNS Role Using Server Manager 00:05:00 Video - Create a Secondary Or Backup DNS Server 00:07:00 00:08:00 Video - Create a DNS Reverse Lookup Zone in Server 2019 00:02:00 Video - Create a New DNS Host Record 00:02:00 Video - Create a Host Record For a New Website In Microsoft DNS 00:04:00 Video - Creating a New MX Record For a Microsoft Exchange Server In DNS 00:04:00 DHCP Video - Install the DHCP Role Using PowerShell 00:09:00 Video - Installing the DHCP Server Role Using Server Manager 00:03:00 Video - How to Authorize/Unauthorize a DHCP Server 00:03:00 Video - How To Edit The Default Gateway Settings In DHCP 00:03:00 Video - How To Edit DNS Server List In DHCP 00:04:00 Video - Edit a DHCP Scope 00:03:00 video - How To Backup And Restore The DHCP Database 00:03:00 Video - Use Filters In DHCP To Deny Clients DHCP Services 00:02:00 Video - Create Predefined Options In DHCP 00:06:00 Video - Use DHCP User Classes to Assign Alternate DHCP Options 00:05:00 Disk Management Video - Adding Additional Virtual Hard Disks 00:06:00 Video - How to Shrink Or Extend a Volume In Windows Server 2019 00:04:00 Video - How To Format a Volume With ReFS in Windows Server 2019 00:04:00 Video - How To Format a Volume With FAT32 in Windows Server 2019 00:02:00 Firewall Administration Video -Turn The Windows Firewall On And Off 00:01:00 Video - Using Netsh To Manage the Windows Firewall 00:05:00 Video - Using Powershell to Gather Firewall Information 00:04:00 Troubleshooting Video - Allow PING between Windows Server and Windows 10 00:05:00 Video and Lab - Troubleshooting Internet Connectivity 00:16:00 Video - NSLookup 00:05:00 Video - Windows Reliability Monitor 00:04:00 Overview of Windows Sysinternal Tools 00:08:00 Video - Overview of Sysinternal's Process Explorer 00:15:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Course Overview Video 00:05:00 Building Your Virtual Lab Environment Downloading ISO and OVA Fles for VirtualBox 00:08:00 Create Virtual Install of Server 2016 Full GUI Using VirtualBox 00:12:00 Video and Lab - Creating a Virtual Install of Server 2016 Core Using VirtualBox 00:11:00 Video and Lab - Creating a Virtual Install Of Windows 10 Pro Using Virtualbox 00:16:00 Take a Snapshot of Your Current Configuration 00:04:00 Building a Microsoft Server 2016 Domain Preparing Your Network for Active Directory 00:09:00 Prepare Server 2016 for Promotion to a Domain Controller 00:09:00 Video and Lab - Promote Server 2016 to a Domain Controller 00:09:00 Join Server 2016 Core to Windows 2016 Domain 00:08:00 Promote Server Core to a Domain Controller 00:14:00 Add a Windows 10 Workstation to a Microsoft Domain 00:15:00 Create a Server 2016 Replica Domain Controller 00:13:00 Domain Naming System (DNS) Installing the DNS Role Using Server Manager 00:05:00 Create a Secondary or Backup DNS Server 00:07:00 Create a Secondary or Backup DNS Server Using Server Core 00:08:00 Create a DNS Reverse lookup Zone in Server 2016 00:02:00 Create a New DNS Host Record 00:01:00 Create a New MX record in DNS 00:04:00 Dynamic Host Configuration Protocol (DHCP) Install and Configure DHCP Using PowerShell 00:08:00 Authorize a Windows 2016 DHCP Server 00:03:00 Server and Scope Options in Windows Server 2016 00:03:00 How to Edit the Default Gateway Settings in DHCP 00:02:00 How to Edit DNS Server List in DHCP 00:03:00 Use Filters in DHCP to Deny Clients DHCP Services 00:02:00 Use DHCP User Classes to assign alternate scope options 00:05:00 Edit a DHCP Scope 00:02:00 How to Backup and Restore the DHCP Database 00:03:00 Create Predefined Options in DHCP 00:06:00 Speed Learning Active Directory Administration Create a User in Active Directory 00:01:00 Create an Administrator User in Server 2016 00:04:00 Create a Distribution Group in Active Directory 00:02:00 Create and Use a Security Group 00:03:00 Create an Organizational Unit 00:02:00 Unlock a User account 00:01:00 Move an Object to a New Organizational Unit in Active Directory 00:02:00 Change the Domain Administrator Password 00:01:00 Fix Access Denied When deleting Active Directory objects 00:01:00 Speed Learning Group Policy Prevent Automatic Logoff Due to Inactivity 00:03:00 Create and Link a Group Policy Object to an OU 00:04:00 Edit Group Policy Objects to Affect a User 00:03:00 Edit a Group Policy Object to Affect a Computer 00:03:00 Backup and Restore Group Policy Objects 00:03:00 Force Screensaver and Timeouts Using Group Policy 00:06:00 Change Users Desktop Background Using Group Policy 00:09:00 Speed Learning Server 2016 Administration Overview of the New Start Menu for Server 2016 00:02:00 Working with Task View in Server 2016 00:02:00 Enable Remote Desktop Using PowerShell 00:10:00 Rearm the 180-day Evaluation Period for Wndows Server 00:02:00 Rearm the 30-day Evaluation Period for Windows 10 00:03:00 Create a Heads-up Display Using BgInfo 00:08:00 Change the Date, Time and Numbers Format in Server 2016. 00:02:00 Rename Windows Server 2016 Using PowerShell 00:02:00 Manage Files and Shares Setup Work Folders in a Windows Domain 00:15:00 Configure a Distributed File System Using Windows Server 00:16:00 Create a Shared Folder on a Windows Server 00:04:00 Create a Shared Folder Using Server Manager 00:06:00 Speed Learning Managing Printers Add a Network Printer in Windows Server 2016 00:04:00 Install and Use the Print Management role in Windows Server 2016 00:04:00 Deploy Printers Using Group Policy in Windows Server 2016 00:03:00 Speed Learning Server 2016 Firewall Turn the Firewall on or off in Windows 2016 Server 00:01:00 Allow an Inbound Port Through a Windows Firewall 00:02:00 Enable PING for Server 2016 and Windows 10 00:04:00 Using Netsh to Manage the Windows Firewall 00:04:00 Using Powershell to Gather Firewall Information 00:04:00 Disk Management Adding Additional Hard Disks Using VirtualBox 00:06:00 Shrink or Extend a Volume in Windows Server 00:04:00 Format a Volume with ReFS in Windows Server 00:03:00 Format a Volume With FAT32 in Windows Server 00:02:00 Troubleshooting NSLookup 00:05:00 Troubleshooting Internet Connectivity 00:16:00 Overview of Windows Sysinternal Tools 00:08:00 Overview of Sysinternal's Process Explorer 00:17:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Server 2019 Understand the core competencies and principles of Microsoft Server 2019 Explore the various areas of Microsoft Server 2019 Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert Windows Server 2019 administrator Microsoft Windows Server 2019 - Hands-on Training Part II Course Master the skills you need to propel your career forward in Microsoft Server 2019. This course will equip you with the essential knowledge and skillset that will make you a confident Windows Server 2019 administrator and take your career to the next level. This comprehensive Microsoft windows server course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft windows server course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This Microsoft Windows Server 2019 - Hands-on Training Part II course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.  This comprehensive course will teach you the theory of effective Microsoft Server 2019 practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Server 2019 industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Server 2019. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for Windows Server 2019 administrator or for people who are aspiring to specialise in Microsoft Server 2019.This Microsoft Windows Server 2019 - Hands-on Training Part II course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this Microsoft windows server course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft windows server course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Server 2019 can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft windows servercourse has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft windows server course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft windows server course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and Lab - Create Virtual Install of Server 2019 Full GUI 00:12:00 Video and Lab - Creating a Virtual Install of Server 2019 Core Using VirtualBox 00:13:00 Video and Lab - Creating a Virtual Install Of Windows 10 Pro Using Virtualbox 00:16:00 Video - Take a Snapshot Of Your Current Configuration 00:04:00 Building a Windows Server 2019 Domain Using PowerShell Video an Lab - Preparing Your Network for Active Directory 00:08:00 Step 1: Rename Your Server Using Powershell 00:03:00 Step 2: Assign a Static IP address Using PowerShell 00:04:00 Step 3: Install the Active Directory Domain Services Role Using Powershell 00:03:00 Step 4: Promote Server 2019 as a Domain Controller Using PowerShell 00:05:00 Step 5: Promote Server Core to a Domain Controller 00:14:00 Step 6: Add a Windows 10 Client to the Domain 00:15:00 Windows Deployment Services Video - Install WDS on a Windows Server 00:16:00 Video - Deploy a Windows 10 Client Using WDS 00:09:00 Operations Master Roles (FSMO) Video and Lab - Transferring FSMO Roles in Active Directory 00:10:00 Video And Lab - Transfer FSMO Roles Using PowerShell 00:07:00 Video and Lab - Seizing the FSMO Roles Using the NTDSUTIL 00:17:00 Disaster Recovery Video and Lab - Mitigating the Loss of Your Forest Root 00:16:00 Video- Resetting the Directory Services Recovery Mode Password 00:03:00 Video - How to Backup and Restore the Windows Registry 00:05:00 Video - Install And Use Windows Server Backup 00:03:00 Video And Lab - Reset a Lost Administrator Password 00:13:00 Monitoring Server 2019 Video and Lab - Monitoring Server Performance 00:13:00 Video - Create a Heads-Up Display Using BgInfo 00:08:00 Video - Overview of the Event Viewer in Windows Server 00:13:00 Server 2019 Advanced Administration Video - Rearm the 180-day Evaluation Period for Windows Server 00:03:00 Video - Create a shared folder Using Windows Server 00:04:00 Video - Disable The Complex Password Policy in Windows Server 00:03:00 Video and lab - Configuring NIC Teaming on Windows Servers 00:10:00 Video and Lab - Network Load Balancing for Windows Servers 00:08:00 Video - NDSUTIL - Resetting the Directory Services Recovery Mode Password 00:03:00 IIS Video and Lab - Create a Website Using IIS on Server 2019 00:19:00 Video - How to turn on website authentication in IIS Windows Server 00:05:00 Video - Improve Website Performance Using Dynamic Compression in IIS 00:04:00 Video - Create a New Virtual Directory In IIS 00:05:00 Video - Change the Default Document Used in IIS 00:04:00 Certificates Services Video and Lab - Create a Self-Signed Certificate in IIS 00:12:00 Video and Lab - Configure Group Policy to Trust a Self-Signed Certificate 00:08:00 Video and Lab - Create Self Signed Certificate and Bind in IIS 00:05:00 Video and Lab - Install and configure Certificate Services 00:09:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. 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 Data Analysis in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 31 lectures • 04:46:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00