326 Microsoft Power BI courses delivered Online

At work, are you required to use the Microsoft Office 2016 suite, including Word, Excel, PowerPoint, Access, and Outlook? If so, then why not master both the basic and advanced features of these in order to fully benefit your career. Whether you’re a Microsoft Office 2016 beginner or otherwise, taking our popular Microsoft Office 2016 Complete Course will help you to learn new skills. Packed into logical sections and bite-sized modules taught by experts in their field, the course teaches you everything you need to know to use each of the programmes in the Microsoft Office 2016 suite. Working logically through all programmes, the course shows learners how to take full advantage of the Microsoft Office 2016 suite and improve productivity. On completion of the course, you’ll be able to create, edit and effectively maintain Word documents, workbooks and spreadsheets, presentations, desktop databases and emails. Students will also receive an internationally respected certification. If you wish to show your employer that your Microsoft Office 2016 skills are outstanding, then this course is for you. Why choose this course Earn a free e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? This course is ideal for anyone looking to gain Microsoft Office Specialist (MOS) certification. It is aimed at those who wish to develop their skills using Microsoft Office applications, or those in or seeking any office role, including that of PA, Secretary, Admin Assistant, and Administrator, Office Manager, and so on. No experience or previous qualifications are required, so it is available to all students, of all academic backgrounds. Course Contents Microsoft Word 2016 Microsoft Excel 2016 Microsoft PowerPoint 2016 Microsoft Outlook 2016 Microsoft Access 2016

The Microsoft Office Course is designed to provide you with essential skills in MS Office applications that are integral to virtually every workplace, from multinational companies to local schools. Whether you're looking to enhance your everyday work or boost your resume, this course covers everything from Excel to Word, PowerPoint, and Access. By enrolling in this training, you will develop the necessary expertise to manage data, and create documents, presentations, and databases, all while improving your overall proficiency in Microsoft Office tools.

Learn the Latest Skills | Acknowledged by CPD | MCQ Based Exam & Tutor Support | Interactive Video Training  If you are interested in gaining a position as a highly paid Office Administrator, Secretary, or Personal Assistant, then this lesson from Janets is the perfect opportunity. The course focuses on building practical knowledge so that upon successful completion you are fully prepared for work. Whether you are a complete beginner or have some experience, this course covers everything in a concise manner. Gain the confidence to excel in any office or commercial environment by gaining the necessary knowledge of administration, computer, and management techniques. This cutting-edge online course is taught by industry experts with continuing expert involvement, and it teaches you immediately applicable skills. Our Diploma can provide you with the insight, skills and knowledge you need to succeed in this busy career. What Will You Learn? Understand succession planning. Learn the basic computer software you need to know to perform at your best on a daily basis. How to work to a schedule to achieve the best results.. How to present documents and proofread. Organise effective meetings. How to categorise, sub-categorise and manage your filing system effectively. What classes are included in this package? Earn a digital certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This course is designed for those seeking senior secretarial or administrative jobs in an organization, as well as newcomers seeking their first job in an office setting. Although a good command of the English language is assumed, no prior experience or knowledge is required. Career Path Training offered by the Office Admin, Secretarial and PA could potentially benefit a range of roles, but would particularly enhance careers in: Office Administration Personal Assistant Receptionist Secretary Other administration roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement after the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the Office Admin, Secretarial and PA Diploma, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Office Admin, Secretarial and PA Diploma Microsoft Word Microsoft PowerPoint Microsoft Excel Recommended Reading Mock Exam Final Exam Recommended Materials Assignment

Course overview Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course. In this course, you will develop a comprehensive understanding of the PivotTable and PivotChart and explore how they work. In this Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course, you will learn the steps to create your Pivot table and Pivot chart. We'll show you how to use Pivot tables to summarize large amounts of data. You'll also learn how to use PivotChart to provide visual representation to your summarized data. We will then take you through adding sorts, filters, timelines and slicers to create dynamic dashboards. You will also learn how to use the slicer to slice and dice your data the way you want. Learning outcomes Learn how to summaries data with Pivot Table Be able to add graphical representation to your summarized data with PivotChart Learn how to update the Pivot Table with new data Deepen your understanding of sorting and filtering Be able to import data from various sources with Power Query Gain an excellent understanding of Power Pivot Who is this course for? Professionals who want to learn how to summaries large sums of data into meaningful information using Excel Pivot and Charts can take this course. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst Accountants Financial Analyst Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

PowerPoint for Business in 60 Minutes   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to PowerPoint for Business in 60 Minutes.   Microsoft PowerPoint has been around for nearly 35 years, and I am sure you are familiar with it, and have experienced many PowerPoint presentations – some good; many extremely tedious! Creating a business presentation in PowerPoint presents a number of challenges and there is a danger of “death by PowerPoint”. I recently attended a meeting which was supposed to be a planning discussion but which the person leading the meeting insisted on introducing with a PowerPoint presentation of 60 slides – mostly bullet points! We were hardly in the mood for action planning after that assault on our senses.  PowerPoint is good for presenting business results or for a training course, but you need to plan your slideshow carefully to avoid bullet-point boredom and to keep your audience engaged and interested. And that is the purpose of this course – to teach you PowerPoint techniques which you may not be familiar with, and which will help you improve the impact of your business presentations.   Less is more in a slide show so it is important to use techniques and effects which will help engage your audience and draw their attention to the points that matter.  In “PowerPoint for Business in 60 Minutes”, I cover six key topics that will help you produce more impactful business presentations: The best slide transitions and animations for business presentations The morph transition to make the narration of an agenda, or similar list, or a team photograph extremely slick and professional The Zoom effect to create a summary slide with hyperlinks to zoom into the section that you or your audience choose How to animate charts to highlight the key points you want to bring out How to embed Excel tables with slicers into PowerPoint, and why PowerPoint is not developed enough to make this useful for a business presentation How to turn your PowerPoint presentation into a video. This is the technique I am most often asked how to do.   This is not a full “PowerPoint from scratch” course: it assumes familiarity of Microsoft’s ubiquitous programme. Instead, the course takes only 1 hour of your time to focus on key techniques that can help you improve the impact of the presentations you create.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Identify the most useful slide transitions and animations for business presentations Use the morph transition to draw the audience’s attention Create a “zoom” summary slide to jump to user-selected sections of slides Animate charts to highlight key points Embed a Microsoft Excel table in a PowerPoint slide Create a video with commentary of their PowerPoint presentation     Curriculum Lesson 1: Transitions and Animations Lesson 2: The Morph Transition Lesson 3: Zoom Lesson 4: Animating Charts Lesson 5: Excel Tables and Slicers in PowerPoint (or Not!) Lesson 6: Making a PowerPoint Video     Pre-Course Requirements There are no pre-course requirements     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What slide effect allows you to give the illusion of moving around a larger “page”? The Wipe transition. The Dissolve transition. The Push transition. The Fly-In animation   What does “Zoom” in PowerPoint allow you to do? Zoom creates the illusion of “zooming in” on a particular part of a slide Zoom creates a summary slide with hyperlinks to the individual slides or sections contained in the summary Zoom creates a smooth object animation from one slide to another to animate, for example, an agenda or timeline Zoom is used to highlight areas of a chart or graphic to draw the audience’s attention   What is the main problem with embedding a Microsoft Excel table with slicers into PowerPoint? The slicers do not work, and the table cannot be manipulated, in presentation mode in PowerPoint The table cannot be opened or manipulated in PowerPoint slide view Microsoft Excel and PowerPoint are incompatible with each other The file size created is too large for most business PCs to handle   When seeking to create an MP4 video file from a PowerPoint presentation, why is it advisable to record the commentary separately? PowerPoint’s built-in recording facility is unreliable and frequently crashes It’s much quicker to record the audio separately and then insert it into PowerPoint and save as a video file Separate video editing software needs to be used to improve the video’s look and sound where the audio is recorded directly in PowerPoint It removes the stress of commentating “live” on the presentation while recording it, and allows any mistakes and errors to be cut out  

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who wish to gain a foundational understanding of PowerPoint that is necessary to create and develop engaging multimedia presentations. Overview In this course, you will create and deliver an engaging PowerPoint presentation. You will: Identify the basic features and functions of PowerPoint. Develop a PowerPoint presentation. Perform text formatting. Add and arrange graphical elements. Modify graphical elements. Prepare to deliver your presentation. How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft© PowerPoint© can help you do.Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint to begin creating engaging, dynamic multimedia presentations.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using PowerPoint for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for the Microsoft PowerPoint (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam. Lesson 1: Getting Started with PowerPoint Topic A: Navigate the PowerPoint Environment Topic B: View and Navigate a Presentation Topic C: Create and Save a Basic Presentation Topic D: Navigate in PowerPoint for the Web Topic E: Use PowerPoint Help Lesson 2: Developing a PowerPoint Presentation Topic A: Create Presentations Topic B: Edit Text Topic C: Work with Slides Topic D: Design a Presentation Lesson 3: Formatting Text Topic A: Format Characters Topic B: Format Paragraphs Lesson 4: Adding and Arranging Graphical Elements Topic A: Insert Images Topic B: Insert Shapes Topic C: Create SmartArt Topic D: Insert Stock Media, Icons, and 3D Models Topic E: Size, Group, and Arrange Objects Lesson 5: Modifying Graphical Elements Topic A: Format Images Topic B: Format Shapes Topic C: Customize SmartArt Topic D: Format Icons Topic E: Format 3D Models Topic F: Animate Objects Lesson 6: Preparing to Deliver Your Presentation Topic A: Review Your Presentation Topic B: Apply Transitions Topic C: Print or Export a Presentation Topic D: Deliver Your Presentation Additional course details: Nexus Humans Microsoft PowerPoint for Office 365 (Desktop or Online) - Part 1 ( v1.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 PowerPoint for Office 365 (Desktop or Online) - Part 1 ( v1.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.

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 1 sections • 25 lectures • 02:25:00 total length •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

Dive deep into the realm of Excel with our meticulously designed course on 'Excel Pivot Tables, Pivot Charts, Slicers, and Timelines'. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly. Highlights of the Dynamic Excel Gantt Chart and Timelines : Discover the secrets of finding the key to doing your best work Understand how to reach your most productive level based on scientific research and principles Explore the hidden productivity recipes of professionals and the most successful people in the world Develop a routine for greater productivity both at home and at work Understand the time management strategies for managing your time when dealing with multiple urgent tasks Discover how to achieve higher productivity by making just a few simple changes Learn simple yet highly effective productivity hacks that you can apply in minutes or less Explore science-backed advice for developing a 'Productivity Mindset' and beat procrastination Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who is this Course for? Data analysts aiming to bolster their data visualisation techniques. Professionals in finance, sales, and marketing looking to generate detailed reports. Researchers keen on presenting data in an insightful manner. Students aspiring to enhance their data representation and analysis skills. Project managers wanting to make data-driven decisions 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. Requirements The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Data Analyst: £30,000 - £50,000 Financial Analyst: £35,000 - £55,000 Sales Analyst: £28,000 - £47,000 Market Researcher: £24,000 - £45,000 Data Visualization Specialist: £32,000 - £52,000 Business Intelligence Analyst: £38,000 - £60,000 Course Curriculum Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Assignment Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 00:00:00

Business Intelligence for PMs and BAs Today, managers and workers need to interact differently as they face an always-more competitive environment. More and more, we see a new kind of Business Intelligence rising: the collaborative BI. It includes a combination of collaboration tools, including spanning social media and other 2.0 technologies, with online BI tools.' (Source: The datapine Blog)Business Intelligence (BI) is an emerging concept that refers to technologies, applications and practices for the collection, integration, analysis and presentation of business information. The purpose of Business Intelligence for projects is to support better business decision making for project stakeholders. By understanding and applying Business Intelligence, professionals will be better equipped to meet project KPIs and CSFs that lead to project success. In this presentation, we will: Explore and explain this emerging concept of collaborative business intelligence Discuss how BI can help improve certain aspects of decision making for projects, programs and portfolio management Cover the important trends for the adoption of business intelligence in the project life cycle Demonstrate real examples of tool combinations such as those led by Microsoft® with Power BI and Microsoft® Project

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