3343 Microsoft courses

Increase your Excel and Pivot Table skills and knowledge within hours which will get you noticed by top management and prospective employers. Become more productive at using Excel which will save you hours each day and eliminate stress at work. This course helps you learn about Pivot Tables that can be used for data analysis with a proper approach.

Discover Excel 2019 and become confident in using spreadsheets

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course 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 paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

If data is the new oil, then coding is your refinery. Whether you're exploring the depths of machine learning or navigating databases with ease, this course sharpens your edge in the competitive world of data science. With a sharp focus on three industry-leading languages—Python, JavaScript, and Microsoft SQL—you’ll build the solid foundations needed to analyse, automate, and query data confidently. From writing clean scripts to crafting smart SQL queries, you’ll develop the mindset to speak fluently in the language of data. Delivered entirely online, the course keeps your learning agile and accessible. Python lays the groundwork for analysis and automation, JavaScript helps in data visualisation and interaction, and SQL ensures you can command databases without blinking. It's not about ticking boxes—it’s about building fluency in what matters. Whether you're upskilling or aiming for a sharper digital edge, this course speaks directly to future-focused learners ready to code with purpose. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: JavaScript Section 01: Introduction Section 02: Basics Section 03: Operators Section 04: Conditional Statements Section 05: Control Flow Statements Section 06: Functions Section 07: Error Handling Section 08: Client-Side Validations Python Section 09: Introduction Section 10: Basic Section 11: Strings Section 12: Operators Section 13: Data Structures Section 14: Conditional Statements Section 15: control flow statements Section 16: core games Section 17: functions Section 18: args, KW args for Data Science Section 19: project Section 20: Object oriented programming [OOPs] Section 21: Methods Section 22: Class and Objects Section 23: Inheritance and Polymorphism Section 24: Encapsulation and Abstraction Section 25: OOPs Games Section 26: Modules and Packages Section 27: Error Handling Microsoft SQL Section 28: Introduction Section 29: Statements Section 30: Filtering Data Section 31: Functions Section 32: Joins Section 33: Advanced commands Section 34: Structure and Keys Section 35: Queries Section 36: Structure queries Section 37: Constraints Section 38: Backup and Restore Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. 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 £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn Python, JavaScript, and Microsoft SQL for Data science course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn Python, JavaScript, and Microsoft SQL for Data science course is open to all, with no formal entry requirements. Career path Upon successful completion of the Learn Python, JavaScript, and Microsoft SQL for Data science Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Leverage the Power of Microsoft® Project 2013 to Manage Your Projects This video gives insight into creating effective schedules and communicating efficiently to stakeholders using Microsoft® Project 2013. You will gain an understanding of the new features in Project 2013 for managing projects, including how to create a well-formed project schedule and assign resources and costs to tasks. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

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.

Understanding databases and SQL

FourSquare Training specialise in private, corporate Power Automate courses delivered at your premises and tailored to your needs.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for those with a basic understanding of Microsoft© Windows© and who need to know how to use Outlook as an email client to manage their email communications, calendar events, contact information, and other communication tasks. Overview In this course, you will use Outlook to compose and handle your email communications and also manage your calendar, contacts, and tasks.You will:Navigate Outlook to read and respond to email.Use the Address Book and format and spell check new messages.Attach files and insert illustrations to messages.Customize read and response options.Use flags, categories, and folders to organize messages.Create and work with Contacts.Create appointments and schedule meetings in Calendar.Create and work with Tasks and Notes. In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create tasks and notes for yourself, and customize the Outlook interface to suit your working style.This course covers the Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification exam. Getting Started with Outlook Topic A: Navigate the Outlook Interface Topic B: Work with Messages Topic C: Access Outlook Help Topic D: Outlook on the Web Formatting Messages Topic A: Add Message Recipients Topic B: Check Spelling and Grammar Topic C: Format Message Content Working with Attachments and Illustrations Topic A: Attach Files and Items Topic B: Add Illustrations to Messages Topic C: Manage Automatic Message Content Customizing Message Options Topic A: Customize Reading Options Topic B: Track Messages Topic C: Recall and Resend Messages Organizing Messages Topic A: Mark Messages Topic B: Organize Messages Using Folders Managing Contacts Topic A: Create and Edit Contacts Topic B: View and Print Contacts Working with the Calendar Topic A: View the Calendar Topic B: Create Appointments Topic C: Schedule Meetings Topic D: Print the Calendar Working with Tasks and Notes Topic A: Create Tasks Topic B: Create Notes Additional course details: Nexus Humans Microsoft Outlook for Office 365 (Desktop or Online) - Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Outlook for Office 365 (Desktop or Online) - Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for existing Microsoft SharePoint site owners who will create and manage sites, add advanced features, implement and manage records management, and create and administer workflows. Overview Upon successful completion of this course, existing SharePoint site owners will be able to take on administrative responsibility for implementing and managing advanced features based on business requirements. Students will:?Configure site settings.?Integrate external applications and data.?Configure site metadata.?Manage archiving and compliance.?Implement workflows. In this course, students will learn how to create, configure, and manage a SharePoint site so that your team or organization can collaborate effectively, manage the flow of digital information, automate business processes, and meet records management needs. Configuring Site Settings Configure Site Settings to Meet Team Requirements Configure Site Search Organize the Site and Configure Navigation Configure Site Auditing Integrating External Applications and Data Add an RSS Feed to Your Site Enable Email Connectivity for a Library Configuring Site Metadata Create a Custom Content Type Add Site Columns to Content Types Create and Configure Document Sets Managing Archiving and Compliance Manage Site Closure and Deletion Configure In-place Records Management Manage Records Using the Records Center Manage Content with the Content Organizer Configure Information Management Policies Implementing Workflows Plan a Workflow Create and Publish a Workflow Test Workflows Design and Implement Advanced Workflows Additional course details: Nexus Humans Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft SharePoint 2016 - Advanced Site Owner with Workflow Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.