827 Microsoft 365 courses delivered On Demand

All in One Bundle Special Discount Offer Are you looking to enhance your Office Skills for Admin, Secretarial, PA (Executive PA)? If yes, then you have come to the right place. Our comprehensive courses on Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) will assist you in producing the best possible outcome by learning the Office Skills for Admin, Secretarial, PA (Executive PA). Course 01: This Microsoft Office Bundle Microsoft Excel 2019 Microsoft Word 2019 Microsoft PowerPoint 2019 Microsoft Access 2019 Course 02: Admin, Secretarial, PA The Office Skills for Admin, Secretarial, PA (Executive PA) bundle is for those who want to be successful. In the Office Skills for Admin, Secretarial, PA (Executive PA) bundle, you will learn the essential knowledge needed to become well versed in Office Skills for Admin, Secretarial, PA (Executive PA). Our Office Skills for Admin, Secretarial, PA (Executive PA) bundle starts with the basics of Office Skills for Admin, Secretarial, PA (Executive PA) and gradually progresses towards advanced topics. Therefore, each lesson of this Microsoft Excel- Office Skills for Admin, Secretarial, PA (Executive PA) is intuitive and easy to understand. Why would you choose the course from Compliance Central: Lifetime access to courses materials Full tutor support is available from Monday to Friday Learn at your own pace from the comfort of your home Accessible, informative learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the bundle Study in your own time through your computer, tablet or mobile device Curriculum Breakdown of the Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) Microsoft Excel 2019 Microsoft Excel 2019 New Features Getting Started with Microsoft Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Word 2019 Microsoft Word 2019 New Features Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentation Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Access Modify Data Working with Queries Access Forms Working with Reports CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Office Skills for Admin, Secretarial, PA (Executive PA). Requirements To enrol in this Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Office Skills for Admin, Secretarial, PA (Executive PA) bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Microsoft Office Skills for Admin, Secretarial, PA (Executive PA). Certificates 2 CPD Accredited PDF Certificate Digital certificate - Included 2 CPD Accredited PDF Certificate for Free CDP Accerdited Hardcopy Certificate Hard copy certificate - £10.79 Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before ***Best Deal of the Market. Offer Ends Today*** In today's fast-paced business world, administrative roles require diverse skills to thrive and succeed. Our Complete Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) course equips you with the essential knowledge and abilities needed to excel in the field. Whether you're an entry-level professional seeking to kickstart your career or an experienced administrator looking to upskill, this course is your pathway to success. The Complete Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) now comes to you accompanied by a 7 Premium Courses Bundle. Enrol now in this Microsoft Office Complete bundle & get access to the following Office Skills: Admin, Secretarial & PA (Executive PA) with Microsoft Office courses: Course 01: Microsoft Office Skills (Word, Powerpoint, Microsoft Excel) - CPD Certified Course 02: Admin, Secretarial & PA at QLS Level 7 Course 03: Legal Secretary Course 04: UK Employment Law Course 05: Organisational Skills Course for Administrator Course 06: GDPR Course 07: Communication Skills Our Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme & accredited by CPDQS (with 250 CPD points) to make your skill development & career progression more accessible than ever! This Complete Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) course can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Student Testimonials - What Our Students Say! ''Comprehensive course on Microsoft Office and administrative skills. Highly recommended!'' Reviewed by Walker ''Great Course and great Customer service. Very Informative'' Reviewed by Bab ''Excellent content. Very well explained. Certainly recommended.'' Reviewed by Denis Jackson Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA Why Choose Our Office Skills: Admin, Secretarial & PA (Executive PA) Course: Get instant access to this Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) course. Learn Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) essentials from anywhere in the world Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) Course is affordable and simple to understand Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) Course is entirely online, interactive lesson with voiceover audio Lifetime access to the Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) materials Microsoft Office Skills with Admin, Secretarial & PA (Executive PA) comes with 24/7 tutor support. CPD 220 CPD hours / points Accredited by CPD Quality Standards Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 (Promo Videos) 13:54 1: Introduction Video Preview 01:10 2: Introduction Preview 02:58 3: Excel Overview Preview 05:20 4: Start Excel Spreadsheet Preview 04:26 Module 01 - Introduction to Personal Assistant 10:33 5: Introduction to Personal Assistant Preview 10:33 Module 02 - Introduction to Office Administration 07:17 6: Introduction to Office Administration 07:17 Module 03 - Skills of an Effective Administrator 09:19 7: Skills of an Effective Administrator 09:19 Module 04 - Introduction to Reception and Receptionist 14:09 8: Introduction to Reception and Receptionist 14:09 Module 05 - Business Telephone Skills 11:04 9: Business Telephone Skills 11:04 Module 06 - Representing Your Boss and Company 23:02 10: Representing Your Boss and Company 23:02 Module 07 - Business Etiquette 11:26 11: Business Etiquette 11:26 Module 08 - Mail Services and Shipping 17:15 12: Mail Services and Shipping 17:15 Module 09 - Travel Arrangements 14:20 13: Travel Arrangements 14:20 Module 10 - Organising Meeting and Conferences 17:24 14: Organising Meeting and Conferences 17:24 Module 11 - Diary Management and Note taking 14:56 15: Diary Management and Note taking 14:56 Module 12 - Time Management 23:16 16: Time Management 23:16 Module 13 - Record Keeping and Filing Systems 17:30 17: Record Keeping and Filing Systems 17:30 Module 14 - Business Writing Skills 28:36 18: Business Writing Skills 28:36 Module 15 - Organisational Skills 17:06 19: Organisational Skills 17:06 Module 16 - Communication Skills 16:21 20: Communication Skills 16:21 Module 17 - Customer Service 09:54 21: Customer Service 09:54 Module 18 - Effective Planning and Scheduling 33:19 22: Effective Planning and Scheduling 33:19 Module 19 - Invoicing/Petty Cash 18:39 23: Invoicing/Petty Cash 17:39 24: Final Words 01:00 Assessment (Optional) 02:00 25: Assignment on- Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 02:00 Order Your Certificate 02:00 26: Order Your CPD Certificate 01:00 27: Order Your QLS Endorsed Certificate 01:00 Free Course No 01: Legal Secretary 4:00:14 28: Module 01: Understanding the Concept of Paralegal 14:11 29: Module 02: Key Legal Terminology 10:47 30: Module 03: Effective Communication Skills for Paralegals 22:43 31: Module 04: The Legal Workplace & Professionals 28:06 32: Module 05: Law & Legal Systems 22:59 33: Module 06: Contract & Business Law 34:56 34: Module 07: Property Law 11:50 35: Module 08: Wills, Probate, Estate Law 07:59 36: Module 09: Criminal Law 16:32 37: Module 10: Common Paralegal Legal Matters 23:34 38: Module 11: Human Rights 09:56 39: Module 12: Conflict and Conflict Resolution 13:16 40: Module 13: Professional Conduct and Ethics of Paralegals 15:03 41: Module 14: Mandatory Knowledge Fields and Survival Tips for Paralegals 08:22 Free Course No 02: GDPR 1:04:50 42: Module 01: GDPR Basics 10:32 43: Module 02: GDPR Explained 09:51 44: Module 03: Lawful Basis for Preparation 14:13 45: Module 04: Rights and Breaches 14:04 46: Module 05: Responsibilities and Obligations 16:10 Free Course No 03: UK Employment Law 3:23:15 47: Module 01: Basic of Employment Law 16:18 48: Module 02: Legal Recruitment Process 26:45 49: Module 03: Employment Contracts 14:06 50: Module 04: Employee Handbook 13:03 51: Module 05: Disciplinary Procedure 13:56 52: Module 06: National Minimum Wage & National Living Wage 21:58 53: Module 07: Parental Right, Sick Pay & Pension Scheme 31:14 54: Module 08: Discrimination in the Workplace 27:43 55: Module 09: Health & Safety at Work 10:21 56: Module 10: Dismissal, Grievances and Employment Tribunals 20:52 57: Module 11: Workplace Monitoring & Data Protection 06:59 Free Course No 04: Organisational Skills Course for Administrator 43:28 58: Module 01: Remove the Clutter 05:41 59: Module 02: Prioritise 04:16 60: Module 03: Scheduling Your Time 04:21 61: Module 04: To Do Lists 03:35 62: Module 05: Paper and Paperless Storage 04:26 63: Module 06: Organisation in Your Work Area 04:05 64: Module 07: Tools to Fight Procrastination 04:22 65: Module 08: Organizing Your Inbox 04:21 66: Module 09: Avoid the Causes of Disorganization 04:18 67: Module 10: Discipline is the Key to Stay Organized 04:03 Who is this course for? Microsoft Office Skills (Excel, Word, Access) Anyone interested in learning more about the topic is advised to take this Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course. This Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course is open to everybody. Requirements Microsoft Office Skills (Excel, Word, Access) Anyone interested in learning more about the topic is advised to take this Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course. This Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA course is open to everybody. Our Microsoft Office Skills (Excel, Word, Access) with Admin, Secretarial & PA Course is suitable for anyone interested in: Microsoft Office Specialist (MOS) Microsoft Office Specialist (MOS) Expert Microsoft Office Specialist (MOS) Master Microsoft Specialist certification in Office 365 MS Office User Touch Typing Worker Career path Microsoft Office Skills (Excel, Word, Access) The Microsoft Office Skills (Excel, Word, Access) course teaches you essential skills to help you be more productive in your career. Our Course is suitable for the following: Office Administrator Data Analyst HR Admin Microsoft Office Specialist Receptionist Audio Typist Certificates CPD Accredited Digital Certificate Digital certificate - Included Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - £139 Please note that International students have to pay an additional £10 as a shipment fee.

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet 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 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists 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 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data 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 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Microsoft Office Foundation with Minute Taking Masterclass Unlock your potential in office management with the Microsoft Office 7 courses bundle Foundation with Minute Taking Masterclass. Sharpen your Microsoft Office skills with this bundle and become a minute-taking pro. Equip yourself with the Microsoft Office expertise every employer values. Learning Outcomes: Navigate the Excel Interface 2023 using Microsoft Office features. Apply formatting to modern documents through Microsoft Office tools. Develop presentations using Microsoft Office Power Point. Operate Microsoft Access & Database proficiently. Prepare for minute-taking using Microsoft Office utilities. Record meeting decisions and actions effectively. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Microsoft Office Foundation with Minute Taking Masterclass: Excel Interface 2023: Master the intricacies of Excel 2023 to elevate your Microsoft Office proficiency. Formatting Text of a Modern Document: Learn advanced text formatting techniques using Microsoft Office features. Setting up and Managing Presentations: Set up and manage compelling presentations leveraging Microsoft Office tools. Microsoft Access & Database: Gain hands-on experience in Microsoft Access & Database as part of your Microsoft Office skillset. Preparation for Minute Taking: Prepare for efficient minute-taking through the utilisation of Microsoft Office features. Minute Meeting, Decision and Action: Execute accurate minute meeting documentation, decision-making, and action-planning.

A course by Sekhar Metla IT Industry Expert RequirementsNo programming experience needed. You will learn everything you need to knowNo software is required in advance of the course (all software used in the course is free)No pre-knowledge is required - you will learn from basic Audience Beginner JavaScript, Python and MSSQL developers curious about data science development Anyone who wants to generate new income streams Anyone who wants to build websites Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Audience Beginner JavaScript, Python and MSSQL developers curious about data science development Anyone who wants to generate new income streams Anyone who wants to build websites Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer

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.

Data doesn’t speak for itself — it needs someone who can ask the right questions and write the right code. This course offers a focused introduction to three of the most widely used tools in data science: Python, JavaScript, and Microsoft SQL. You’ll explore how each language plays its part in working with data, from handling large datasets to performing analysis and visualisation. All delivered online, with no whiteboards, lab coats or cold meeting rooms involved. Whether you're curious about coding or keen to brush up on logic and structure, the course walks you through the essentials with clarity and purpose. You’ll look into the building blocks of each language, how they interact with data, and how they can be used to create meaningful insights. Designed for learners who prefer clear content over convoluted lectures, it's a straight-talking guide to getting started in data science — without trying to be clever for the sake of it. 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.

🚀 Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! 🚀 Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets!   🔥 Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities.   💡 What Sets Our Masterclass Apart: ✅ Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. ✅ Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. ✅ Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. ✅ Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. ✅ Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come.   📚 Course Highlights: 👉 Essential Excel Functions: From basic formulas to advanced functions, we cover it all. 👉 Data Visualization: Transform your data into impactful charts and graphs. 👉 Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. 👉 Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. 👉 Advanced Formulas: Impress your colleagues with advanced calculations. 👉 Automation with Macros: Streamline your tasks with Excel automation. 👉 Error Handling: Learn how to troubleshoot and avoid common mistakes.   🎓 Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity.   🌟 Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. 👉 Limited seats available. Secure your spot now! 👈 Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00

🚀 Elevate Your Marketing Game with 'Digital Advertising with Microsoft: A Comprehensive Guide' 🚀 Are you ready to revolutionize your digital advertising strategy and unlock the full potential of Microsoft's powerful advertising platforms? Look no further! Introducing our groundbreaking online course: 'Digital Advertising with Microsoft.' 🌐 Why Microsoft? 🌐 Microsoft is more than just a tech giant - it's a game-changer in the digital advertising landscape. With platforms like Microsoft Advertising and LinkedIn, you have access to a vast audience of engaged users ready to connect with your brand. Whether you're a seasoned marketer or a budding entrepreneur, this course is your ticket to mastering the art and science of digital advertising with Microsoft.   🚀 What You'll Gain from this Course 🚀 ✅ Comprehensive Insights: Dive deep into the intricacies of Microsoft Advertising and understand how to leverage its unique features for maximum impact. ✅ Strategic Campaign Planning: Learn the art of crafting targeted, high-converting campaigns that resonate with your audience and drive results. ✅ Optimization Techniques: Discover insider tips and tricks to optimize your ad performance, ensuring you get the most bang for your advertising buck. ✅ Mastering LinkedIn Advertising: Unleash the power of LinkedIn advertising with strategies tailored to the platform's professional audience. ✅ Data-Driven Decision-Making: Harness the potential of data analytics to make informed decisions, continuously refining your campaigns for success. ✅ Exclusive Industry Insights: Stay ahead of the curve with the latest trends, updates, and best practices in the ever-evolving world of digital advertising.   🔥 Bonuses to Supercharge Your Learning Experience 🔥 🎁 Interactive Quizzes and Assignments: Reinforce your knowledge with hands-on activities that solidify your understanding. 📈 Real-world Case Studies: Gain inspiration from successful campaigns and apply those insights to your unique business challenges. 🤝 Community Support: Connect with like-minded professionals, share experiences, and get personalized advice from our expert instructors. 🔒 Lifetime Access: Enjoy unlimited access to course materials, updates, and a dedicated community to support your ongoing success.   💡 Ready to Transform Your Digital Advertising Game? 💡   Enroll now in 'Digital Advertising with Microsoft: A Comprehensive Guide' and take the first step towards becoming a digital advertising maestro. Don't miss out on this opportunity to boost your brand's visibility, drive conversions, and elevate your marketing ROI. 🌟 Join the digital advertising revolution with Microsoft - because your success is just a click away! 🌟 Course Curriculum Digital Advertising with Microsoft: A Comprehensive Guide Microsoft Ads dashboard 00:00 Campaign home overview 00:00 How to edit campaign name and change campaign budget 00:00 Ad Campaigns 00:00 Ad Bids & Optimization 00:00 Spy on Your Competitors 00:00 Set Your Budget & Automate Extensions 00:00 Ad Extension Overview & How Tos #1 00:00 How To Add Different Types of Extensions 00:00 Microsoft Ad Editor 00:00 Reports 00:00