6119 Courses

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Recent statistics indicate a growing demand for skilled professionals in administrative, secretarial, and personal assistant roles, underlining the indispensable nature of these positions across industries. In response to this trend, our comprehensive Admin, Secretarial & PA with Office Management & Minute Taking QLS Endorsed Diploma bundle offers a strategic blend of QLS endorsed courses and CPD QS accredited modules designed to elevate your proficiency and advance your career in the administrative realm. With a holistic approach encompassing technical expertise and personal development, this Admin, Secretarial & PA with Office Management & Minute Taking bundle equips you with the essential tools to excel in diverse administrative environments. In today's dynamic workplace landscape, adaptability and multifaceted competencies are paramount. This Admin, Secretarial & PA with Office Management & Minute Taking bundle empowers you with the knowledge and skills necessary to navigate the complexities of office management, minute taking, and administrative support roles efficiently. Whether you're aspiring to enter the field or aiming to enhance your existing capabilities, this curated collection of courses provides a robust foundation for professional growth and success. Bundle Include includes: QLS Endorsed Courses: Course 01: Advance Certificate in Office Management & Administration at QLS Level 3 Course 02: Diploma in Minute Taking at QLS Level 5 Course 03: Diploma in Admin, Secretarial & PA at QLS Level 5 CPD QS Accredited Courses: Course 04: Online Meeting Management Course 05: UK Employment Law Course 06: HR and Leadership Management Course 07: Report Writing Course 08: Document Control Course 09: Delegation Skills Course 10: Paralegal Training Course 11: Process Improvement: How to Reduce Waste Take your career to the next level with our bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive bundle, endorsed by the prestigious QLS and accredited by CPD.Admin, Secretarial & PA with Office Management & Minute Taking QLS Endorsed Diploma. Learning Outcomes: Upon completion of this Admin, Secretarial & PA with Office Management & Minute Taking bundle, participants will: Demonstrate advanced proficiency in office management and administration techniques. Execute effective minute taking procedures in various organizational settings. Implement administrative best practices in secretarial and personal assistant roles. Apply UK employment law principles to ensure compliance within the workplace. Cultivate leadership and HR management skills essential for effective team coordination. Employ critical thinking and decision-making strategies to enhance problem-solving abilities. Embark on a transformative journey towards professional excellence with our comprehensive Admin, Secretarial & PA with Office Management & Minute Taking course bundle designed to elevate your administrative prowess and career trajectory. Dive into the intricacies of office management and administration, gaining proficiency in essential tasks ranging from scheduling and budgeting to team coordination and facility management. Explore the art of minute taking, mastering techniques to capture vital meeting discussions accurately and succinctly, ensuring effective communication and documentation within your organization. Moreover, immerse yourself in the dynamic landscape of UK employment law, equipping yourself with the knowledge and insights necessary to navigate legal frameworks and safeguard organizational compliance. Harness the power of HR and leadership management, honing your abilities to foster a cohesive and productive work environment while nurturing talent and driving strategic initiatives. From enhancing your report writing skills to implementing efficient document control processes, each module is meticulously crafted to equip you with the tools and techniques needed to thrive in today's competitive administrative arena. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to pursue careers in administrative, secretarial, or personal assistant roles. Professionals seeking to enhance their skill set and advance their career prospects. Graduates looking to augment their theoretical knowledge with practical administrative expertise. Entrepreneurs or small business owners aiming to streamline administrative processes within their organizations. HR professionals interested in bolstering their leadership capabilities and strategic decision-making skills. Anyone keen on refining their networking abilities and maximizing personal success in the professional arena. Requirements You are warmly invited to register for this bundle. Please be aware that there are no formal entry requirements or qualifications necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Administrative Assistant Executive Assistant Office Manager HR Coordinator Legal Secretary Personal Assistant Business Administrator Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificate Hard copy certificate - Included

If you want to enhance your problem-solving and decision-making abilities with ChatGPT's predictive capabilities, streamline your communication, and improve efficiency in professional/personal settings, this course is for you. Acquire the skills to train and fine-tune ChatGPT for specific applications and industries.

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

🚀 Unlock Your Financial Freedom with the Effortless Revenue Method! 🚀 Are you tired of the daily grind and ready to take control of your financial future? Imagine a life where money flows effortlessly into your bank account, allowing you to live on your terms and pursue your passions. Introducing the 'Effortless Revenue Method' - the ultimate online course designed to revolutionize your approach to income generation!   🌟 What You'll Learn: 1️⃣ Passive Income Mastery: Discover proven strategies to create multiple streams of passive income that work for you 24/7. Say goodbye to trading time for money and hello to a lifestyle of financial ease. 2️⃣ Automated Revenue Systems: Learn how to set up automated systems that generate revenue with minimal effort on your part. We'll guide you through the process of creating a sustainable income machine that works while you sleep. 3️⃣ Online Business Acceleration: Whether you're a seasoned entrepreneur or just starting, we'll share insider secrets to catapult your online business to new heights. From digital products to affiliate marketing, we've got you covered. 4️⃣ Smart Investment Strategies: Unlock the power of intelligent investing. Discover how to make your money work for you by understanding the most lucrative investment opportunities in today's market. 5️⃣ Time Management Hacks: Maximize your productivity and efficiency with time-tested techniques. Learn how to focus on what truly matters, allowing you to achieve more with less effort.   🔥 What's Included: ✅ Comprehensive Video Modules: Engaging and easy-to-follow video lessons that break down complex concepts into actionable steps. ✅ Interactive Workbooks: Apply what you've learned with hands-on exercises designed to solidify your understanding and accelerate your results. ✅ Exclusive Community Access: Connect with like-minded individuals, share success stories, and receive ongoing support from our thriving community. ✅ Lifetime Access: Enjoy unlimited access to course updates and new content, ensuring you stay ahead of the curve in the ever-evolving world of online revenue.   💡 Don't miss out on this opportunity to transform your financial reality! Enroll in the Effortless Revenue Method today and pave the way for a future of abundance and prosperity. Course Curriculum

🌟 Unleash Your Potential with the 'Simple Transformation Equation' Online Course! 🌟 Are you ready to embark on a journey of personal and professional growth? Introducing our groundbreaking online course: 'Simple Transformation Equation.' This transformative program is designed to empower you with the essential tools and strategies needed to achieve success and fulfillment in all aspects of your life.   🚀 Why Choose 'Simple Transformation Equation'? ✨ Unlock Your True Potential: Discover the power within you to make positive changes and reach new heights. The Simple Transformation Equation will guide you through a step-by-step process that empowers you to tap into your full potential. 🔍 Clarity in Chaos: Life can be chaotic, but with our proven equation, you'll gain clarity and direction. Say goodbye to confusion and hello to a focused, purpose-driven life. 🤝 Enhance Relationships: Whether it's personal or professional, relationships are key to success. Learn how to build meaningful connections, communicate effectively, and foster collaboration. 💡 Master Personal Development: Elevate your personal development journey with a systematic approach. The Simple Transformation Equation equips you with the mindset and skills needed to overcome obstacles and turn challenges into opportunities. 🌈 Create Your Success Blueprint: Define and achieve your goals with precision. This course provides you with a blueprint for success, helping you set realistic goals and develop a roadmap to reach them.   🎓 What You'll Learn: The Power of Mindset: Understand how your mindset shapes your reality and learn strategies to cultivate a positive and growth-oriented mindset. Goal Setting Mastery: Set meaningful and achievable goals, and acquire the tools to stay focused and motivated throughout your journey. Effective Communication: Enhance your communication skills to build stronger, more meaningful connections in both personal and professional spheres. Time Management Tactics: Learn to maximize your productivity and efficiency by mastering the art of time management. Overcoming Obstacles: Develop resilience and the ability to turn challenges into stepping stones towards your success.   💻 Don't miss out on this opportunity to transform your life! Enroll in the 'Simple Transformation Equation' online course today and take the first step towards a brighter, more fulfilling future. Course Curriculum

🚀 Unleash Your Potential: Join 'Becoming a Person of Action' Online Course! 🚀   Are you tired of feeling stuck, watching opportunities pass you by, and dreaming about a more fulfilled life? It's time to break free from the chains of procrastination and transform into the unstoppable force you were meant to be!   🌟 Introducing 'Becoming a Person of Action' Online Course! 🌟   🚨 Why This Course? This isn't just another self-help program; it's a dynamic blueprint for turning your dreams into reality. Developed by experts in personal development and success, this course is designed to propel you into a life of action, achievement, and fulfillment.   💡 What You'll Learn: ✅ Overcoming Procrastination: Break free from the shackles of procrastination and start taking decisive actions. ✅ Goal Setting Mastery: Learn the art of setting and achieving goals that align with your passions and purpose. ✅ Time Management Tactics: Discover practical strategies to maximize your time and productivity. ✅ Building Unstoppable Habits: Develop habits that propel you forward and create lasting positive change. ✅ Mindset Shifts: Cultivate a mindset of success and resilience to overcome challenges.   🔥 What Sets Us Apart: ✨ Interactive Learning: Engage in immersive exercises, quizzes, and discussions for a hands-on learning experience. ✨ Expert Guidance: Benefit from the wisdom of seasoned mentors with a track record of success. ✨ Community Support: Connect with like-minded individuals, share experiences, and build a network of support. ✨ Lifetime Access: Enjoy unlimited access to course materials, ensuring continuous growth and reinforcement.   🎁 Limited Time Offer: Enroll Now and Receive Exclusive Bonuses! 📚 Action Workbook: A companion workbook to apply course principles to your unique journey. 🎯 Personalized Goal-Setting Session: A one-on-one session with a success coach to set your personalized action plan.   🌈 Your Transformation Awaits - Act Now! Don't let another moment pass you by. Join 'Becoming a Person of Action' and take the first step towards the life you've always envisioned.   🚀 Your dreams are waiting - become the person of action you were destined to be! 🚀 Course Curriculum

Working from home might sound like a dream—until your Wi-Fi cuts out mid-meeting and you’ve forgotten which day it is. This course is here to help you avoid turning into a coffee-fuelled chaos merchant in your pyjamas. Designed for professionals who want to sharpen their approach to remote working, the training covers the essentials of staying productive, communicating clearly, managing time (and emails) like a pro, and avoiding that creeping sense of isolation. You’ll gain structured insights into building healthier work routines, keeping your digital desk tidy, and making sure your presence is felt—even if you're not physically present. Whether you’re navigating your workday from the kitchen table, a corner of the spare room, or an actual desk (impressive), this course offers you the tools to stay efficient, focused, and professional without losing your mind—or your laptop charger. Key Features The Effective Remote Working Training course includes the following offers: CPD Quality Standards Accredited Effective Remote Working Training Course Lifetime Access No Hidden Fees 24/7 Tutor Support Certificate Available with reasonable price Discover a wealth of learning opportunities with our diverse range of online courses including Effective Remote Working Training. From professional development to personal enrichment, we offer courses in a variety of subjects including business, technology, arts, languages, and more. This Effective Remote Working Training course is carefully curated by industry experts and delivered through engaging multimedia content, interactive quizzes, and hands-on projects to ensure an immersive learning experience. Curriculum Introduction to Remote Working Setting Up Remote Office Staying Motivated and Competitive Strategies for Boosting Productivity Virtual Collaboration and Working on Teams Effective Communication Techniques Ensuring Growth As a Remote Employee Etiquette for Video and Audio Calls Why This Online Course is Better for You: Unlike traditional classroom settings, our online Effective Remote Working Training course offers flexibility and convenience tailored to fit your busy lifestyle. With 24/7 access to Effective Remote Working Training course materials and the ability to learn at your own pace, you can study whenever and wherever it's most convenient for you. Plus, our online platform provides a supportive community of fellow learners and dedicated instructors to guide you every step of the way. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our Effective Remote Working Training course is designed for anyone eager to expand their knowledge and skills, regardless of their background or experience level. Whether you're a working professional looking to upskill, a student seeking supplemental education, or an enthusiast pursuing a passion project, our courses are accessible to learners of all ages and abilities. Career path Invest in your future and unlock new career opportunities with our online Effective Remote Working Training course. Gain valuable skills and credentials that are in high demand in today's competitive job market. Whether you're looking to switch careers, climb the corporate ladder, or start your own business, This course provide the expertise and certification you need to succeed. Certificates Digital Certificate Digital certificate - £9 Hard copy Certificate Hard copy certificate - £15 A Hardcopy Certificate (international): £15 + £10 (postal charge) = £25