3043 Microsoft courses in Wetherby delivered Online

Overview This comprehensive course on MS Access Databases Forms and Reports Level 3 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Databases Forms and Reports Level 3 comes with accredited certification from CPD, 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 MS Access Databases Forms and Reports Level 3. It is available to all students, of all academic backgrounds. Requirements Our MS Access Databases Forms and Reports Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 16 lectures • 02:49:00 total length •Creating a form with Autoform: 00:14:00 •Using the Form Wizard: 00:09:00 •Changing a form with design view: 00:26:00 •Adding form controls: 00:21:00 •Subforms: 00:15:00 •Creating reports with Autoreport: 00:03:00 •Using the Report Wizard to create a report: 00:07:00 •Changing a report in design view: 00:11:00 •Adding calculations: 00:09:00 •Grouping, sorting and adding totals to reports: 00:16:00 •Using the Label Wizard: 00:04:00 •Form and table properties: 00:06:00 •Exporting a report to Excel: 00:03:00 •Using the Switchboard Manager to create a nice menu: 00:17:00 •Finalizing the application: 00:08:00 •Assignment - MS Access Databases Forms and Reports Level 3: 00:00:00

Get ready for an exceptional online learning experience with the IT Administration, Networking, Cyber Security Awareness & GDPR bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The IT Administration, Networking, Cyber Security Awareness & GDPR is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, theIT Administration & Networking package has something for everyone. As part of the IT Administration & Networking package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the IT Administration & Networking bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following IT Administration, Networking, Cyber Security Awareness & GDPR CPD Accredited Courses: Course 01: IT Administration and Networking Course 02: Encryption Course 03: Advance Windows 10 Troubleshooting for IT HelpDesk Course 04: Building Your Own Computer Course 05: Cyber Security Awareness Training Course 06: Secure Programming of Web Applications Course 07: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 08: CompTIA A+ (220-1001) Course 09: Data Center Training Essentials: General Introduction Course 10: Information Management Course 11: Bash Scripting, Linux and Shell Programming Course 12: Learn Ethical Hacking From A-Z: Beginner To Expert Course 13: Computer Networks Security from Scratch to Advanced Course 14: GDPR UK Training Course 15: Cisco ASA Firewall Training Course Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online IT Administration, Networking, Cyber Security Awareness & GDPR bundle, you will gain the following: CPD QS Accredited Proficiency with this IT Administration & Networking bundle After successfully completing the IT Administration & Networking bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this IT Administration & Networking bundle The online test with immediate results You can study and complete the IT Administration & Networking bundle at your own pace. Study for the IT Administration & Networking bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this IT Administration, Networking, Cyber Security Awareness & GDPR bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This IT Administration & Networking bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the IT Administration, Networking, Cyber Security Awareness & GDPR, a rich anthology of 30 diverse courses. Our experts handpick each course in the IT Administration & Networking bundle to ensure a wide spectrum of learning opportunities. This IT Administration & Networking bundle will take you on a unique and enriching educational journey. The IT Administration, Networking, Cyber Security Awareness & GDPR bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the IT Administration & Networking bundle offers you the flexibility and convenience to learn at your own pace. Make the IT Administration & Networking package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT Administration, Networking, Cyber Security Awareness & GDPR bundle is perfect for: Starting in IT & Network Admin: Ideal for those new to IT seeking a foundation in network administration. IT Upskilling Professionals: Great for existing IT professionals looking to broaden their skills across various sectors. Managing IT Infrastructure: Useful for employees tasked with managing their organization's IT systems. Cybersecurity for IT Graduates: Excellent for recent IT graduates wanting practical cybersecurity knowledge. IT Compliance for Managers: Great for managers overseeing IT teams who need familiarity with IT compliance. Requirements You are cordially invited to enrol in this IT Administration, Networking, Cyber Security Awareness & GDPR bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Upon IT Administration, Networking, Cyber Security Awareness & GDPR course completion, you can expect to: Network administrator (SMB) Cyber security analyst GDPR compliance officer IT project manager System administrator Chief Information Security Officer (CISO) Freelance IT security consultant Certificates 20 CPD Quality Standard PDF Certificates. Digital certificate - Included

Duration 2 Days 12 CPD hours Overview Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files Create views and customize data in visualizations. Manage, sort, and group data. Save and share data sources and workbooks. Filter data in views. Customize visualizations with annotations, highlights, and advanced features. Create and enhance dashboards in Tableau. Create and enhance stories in Tableau As technology progresses and becomes more interwoven with our businesses and lives, more and more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets?. Lesson 1: Tableau Fundamentals Topic A: Overview of Tableau Topic B: Navigate and Configure Tableau Lesson 2: Connecting to and Preparing Data Topic A: Connect to Data Topic B: Build a Data Model Topic C: Save Workbook Files Topic D: Prepare Data for Analysis Lesson 3: Exploring Data Topic A: Create Views Topic B: Customize Data in Visualizations Lesson 4: Managing, Sorting, and Grouping Data Topic A: Adjust Fields Topic B: Sort Data Topic C: Group Data Lesson 5: Saving, Publishing, and Sharing Data Topic A: Save Data Sources Topic B: Publish Data Sources and Visualizations Topic C: Share Workbooks for Collaboration Lesson 6: Filtering Data Topic A: Configure Worksheet Filters Topic B: Apply Advanced Filter Options Topic C: Create Interactive Filters Lesson 7: Customizing Visualizations Topic A: Format and Annotate Views Topic B: Emphasize Data in Visualizations Topic C: Create Animated Workbooks Topic D: Best Practices for Visual Design Lesson 8: Creating Dashboards in Tableau Topic A: Create Dashboards Topic B: Enhance Dashboards with Actions Topic C: Create Mobile Dashboards Lesson 9: Creating Stories in Tableau Topic A: Create Stories Topic B: Enhance Stories with Tooltips

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about productivity and growth Understand the core competencies and principles of productivity and growth Explore the various areas of productivity and growth Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert life coach 10 Daily Goals to set for Humans to Enjoy a Happy and Productive Life! Course Master the skills you need to propel your career forward in productivity and growth. This course will equip you with the essential knowledge and skillset that will make you a confident life coach and take your career to the next level. This comprehensive happy and productive life course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this happy and productive life course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This 10 daily goals to set for humans to enjoy a happy and productive life! course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.  This comprehensive course will teach you the theory of effective productivity and growth practice and equip you with the essential skills, confidence and competence to assist you in the productivity and growth industry. You'll gain a solid understanding of the core competencies required to drive a successful career in productivity and growth. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for life coach or for people who are aspiring to specialise in productivity and growth.This 10 daily goals to set for humans to enjoy a happy and productive life! course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this happy and productive life course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive happy and productive life course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this productivity and growth can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This happy and productive life course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This happy and productive life course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This happy and productive life course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Add Daily Goal Setting to Your Life and Remove Stress of Long Term Goals. Welcome to 10 Daily goals for Humans 00:02:00 The Entire Value of This Course in The First Video by Showing my Workflow. 00:05:00 The Old Way of Setting Goals in Time Versus The New Way Setting Goals for Today 00:04:00 Example Of a Daily Goal Versus a Long Term Goal in My Workflow 00:08:00 The Benefits of Daily Goal Setting Explained. Time Spent Working And Enjoying Long Term Goals Versus Daily 00:03:00 I Can Still Set Long Term Goals as Long as They Fall Within a Daily Goal 00:05:00 Problems Solved with Setting Goals Each Day Instead of Making Long Term Goals. Daily Goal Setting Eliminates Setting Goals Where I Do Not Control The Outcome 00:06:00 When You Control The Outcome of a Daily Goal, Jealousy Does Not Appear 00:07:00 Anything That Blocks Progress on a Daily Goal I Work to Eliminate 00:06:00 Days of Failing to Accomplish The Goal Become Okay Because of so Much Success 00:07:00 The Data Saved me From Telling a Story of My Failure After Having a Baby 00:06:00 Tracking Daily Goals Is Essential for Learning and Consistency. Microsoft Excel Works for Me to Track My Professional Progress 00:05:00 MyFitnessPal Works For me to Track my Diet, Exercise, And Weight 00:10:00 Mint Works For Me to Track My Finances 00:05:00 I Participate in a Support Group Each Day to Track My Sanity 00:08:00 Prayer And Inspirational Books Help Me Track My Mood at Morning And at Night 00:07:00 Everyone Helps Me Track my Service and Purpose For Living 00:03:00 What Are My Daily Goals and How Do I Practice Them What Are My 10 Daily Goals. Saying Them Out Loud Helps Me Practice Them 00:03:00 Stay Sane by Not Creating More Pain and Suffering For Myself and Others 00:07:00 Make a Positive Contribution to My Family Members and Friends 00:07:00 Eat a Balanced Healthy Diet And Feel I Can Eat Whatever I Want to 00:07:00 Exercise 00:03:00 Do The Right Amount of Something Productive 00:05:00 Have Some Fun 00:05:00 Stay Curious 00:10:00 Help Someone 00:08:00 Clean Up And Fix Up 00:08:00 Practice Saying Thank You and Staying Grateful 00:07:00 Building A Life Defined by Accomplishing Daily Goals. How Do I Do It Nothing I Get Involved in is More Important Than My Daily Goals 00:05:00 Sometimes it Comes Down to a Walk at The Doctor's Office 00:05:00 Laziness is My Friend And I Design My Life Around Accepting How Lazy I Am 00:05:00 Habits Are My Friend Because a Few Good Habits Accomplish Most all The Goals 00:05:00 Anything That Gets in The Way of Daily Goals I Consistently Fix 00:04:00 Accepting The Things I Cannot Change and Changing The Things I Can 00:05:00 Daily Goal Setting Looks Easy. What Makes It Difficult and How to Fix It This Seems Too Easy to Be Really Work The Mind Loves Complexities 00:05:00 Any Sickness That Exists Will Trample on Daily Goals 00:06:00 Being Above or Below Accomplishing Daily Goals And Humility 00:06:00 Too Busy to Have 10 Things to Do Every Day 00:05:00 If You See You Cannot Live Right on Your Own, The Only Solution is To Get Help 00:05:00 Congratulations on Completing the Course! What Next Thank You For Finishing This Course.What Did it Motivate You To Do 00:02:00 A Year Later, How Does My Life Look After Doing These Goals 00:08:00 What if I Fail The Goals 00:06:00 Practicing Unconditional Love For Others 00:11:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Overview This comprehensive course on MS Access Tables and Queries for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Tables and Queries for Beginner comes with accredited certification from CPD, 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 MS Access Tables and Queries for Beginner. It is available to all students, of all academic backgrounds. Requirements Our MS Access Tables and Queries for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 20 lectures • 03:32:00 total length •Module 01: Tour of the screen: 00:11:00 •Module 02: Using Design view to create and edit tables: 00:45:00 •Module 03: Using the lookup wizard: 00:09:00 •Module 04: Importing data from Other Data Sources into Access: 00:18:00 •Module 05: Linking Tables from Other Data Sources into Access: 00:10:00 •Module 06: Exporting data from Access to other data types: 00:03:00 •Module 07: Creating and Managing Table Relationships: 00:10:00 •Module 08: Database Tools: 00:05:00 •Module 09: Sort and Filter a Table: 00:06:00 •Module 10: Basic Queries: 00:22:00 •Module 11: Prompting the user for the criteria: 00:05:00 •Module 12: Creating Calculated Fields in a Query: 00:10:00 •Module 13: Creating Totals Queries: 00:08:00 •Module 14: Multiple table Queries: 00:12:00 •Module 15: Viewing the SQL code for an Access Query: 00:06:00 •Module 16: Using the Query Wizards: 00:09:00 •Module 17: Creating Subqueries: 00:03:00 •Module 18: Creating Make Table, Append, Update and Delete Queries: 00:19:00 •Module 19: Displaying a certain number of records: 00:01:00 •Assignment - MS Access Tables and Queries for Beginner: 00:00:00

Welcome to the world of machine learning, Java, and Python programming! This exciting bundle offers a comprehensive learning experience with a variety of courses that will equip you with the knowledge and skills needed to excel in these fields. Within this bundle, you will find a total of eight courses, including three QLS-endorsed courses and five relevant CPD QS-accredited courses. The three QLS-endorsed courses in this bundle are the Machine Learning with Python course, the Introduction to Java course, and the Diploma in Python Programming. These courses have been carefully curated and designed to provide you with a solid foundation in machine learning and programming using both Java and Python. Upon completion of these courses, you will receive hardcopy certificates to showcase your achievement. In addition to the QLS-endorsed courses, this bundle also includes five CPD QS-accredited courses. These courses are highly relevant to the field and will further enhance your understanding and expertise. They include Azure Machine Learning, Complete Python Machine Learning & Data Science Fundamentals, Machine Learning Model Using AWS SageMaker Canvas, Statistics & Probability for Data Science & Machine Learning, and 2021 Data Science & Machine Learning with R from A-Z. Key Features of the Machine Learning, Java and Python Programming Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Machine Learning, Java and Python Programming bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Machine Learning with Python QLS Course 02: Introduction to Java QLS Course 03: Diploma in Python Programming 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Azure Machine Learning Course 02: Complete Python Machine Learning & Data Science Fundamentals Course 03: Machine Learning Model Using AWS SageMaker Canvas Course 04: Statistics & Probability for Data Science & Machine Learning Course 05: 2021 Data Science & Machine Learning with R from A-Z In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Machine Learning, Java and Python Programming courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain a comprehensive understanding of machine learning principles and algorithms. Develop proficiency in programming with Python and Java, and apply these skills to real-world projects. Explore the fundamentals of data science and statistical analysis. Learn how to leverage cloud-based platforms, such as Azure and AWS, for machine learning tasks. Build and deploy machine learning models using various frameworks and tools. Acquire practical knowledge in data preprocessing, feature selection, and model evaluation techniques. Gain expertise in using R for data science and machine learning applications. This bundle combines the power of machine learning, Java programming, and Python programming to provide you with a comprehensive skill set in these high-demand fields. With a total of eight courses, including three QLS-endorsed and five CPD QS-accredited courses, this bundle covers all the essential topics and techniques needed to succeed. Whether you are a beginner looking to enter the world of machine learning and programming or an experienced professional seeking to expand your knowledge and skills, this bundle has something for everyone. From understanding the fundamentals to applying advanced algorithms, you will gain a deep understanding of machine learning principles and the ability to develop robust applications using Java and Python. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in starting a career in machine learning, Java programming, or Python programming. Professionals seeking to enhance their skills and stay updated with the latest trends in these fields. Students pursuing degrees in computer science, data science, or related disciplines. Anyone looking to broaden their knowledge and explore the exciting field of machine learning and programming. Career path Machine Learning Engineer: £45,000 - £90,000 per year Data Scientist: £40,000 - £80,000 per year Java Developer: £30,000 - £70,000 per year Python Developer: £35,000 - £75,000 per year Cloud Solutions Architect: £50,000 - £100,000 per year Statistical Analyst: £35,000 - £65,000 per year Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Learning Objectives Introduction , Linking Workbooks and Worksheets , Working with Range Names , Sorting, Filtering, and Subtotaling , Analyzing and Organizing with Tables , Using Conditional Formatting , Displaying Data Graphically , Understanding PivotTables, PivotCharts, and Slicers , Working with Advanced PivotTables and PowerPivot Features , Conclusion   Pre-Requisites Excel 365 Introduction course or equivalent knowledge or experience.   Description In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. Section 01 Lesson 01: Linking Workbooks and Worksheets 00:06:00 Lesson 02: Linking Workbooks with 3D References 00:05:00 Lesson 03: Understanding the Consolidate Feature 00:06:00 Section 02 Lesson 01: What are Range Names 00:04:00 Lesson 02: Creating Range Names Using the Name Box and Define Name 00:06:00 Lesson 03: Creating Range Names Using Create from Selection 00:03:00 Section 03 Lesson 01: Understanding the Differences Between Sorting and Filtering 00:03:00 Lesson 02: Sorting Lists 00:06:00 Lesson 03: Filtering Lists 00:08:00 Lesson 04: Creating Subtotals 00:06:00 Section 04 Lesson 01: Creating Tables and Understanding the Benefits 00:07:00 Lesson 02: Understanding the Elements of a Table 00:06:00 Lesson 03: Formatting a Table 00:08:00 Lesson 04: Sorting and Filtering Tables 00:03:00 Lesson 05: Filtering with Slicers 00:04:00 Lesson 06: Calculating with Tables 00:04:00 Lesson 07: Removing Erroneous Table Data 00:03:00 Lesson 08: Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 Lesson 01: What is Conditional Formatting 00:04:00 Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules 00:07:00 Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales 00:06:00 Lesson 04: Using Custom Fonts and Colors 00:04:00 Lesson 05: Using Custom Conditional Formatting 00:06:00 Lesson 06: Modifying or Removing Conditional Formatting 00:05:00 Section 06 Lesson 01: What are Charts 00:05:00 Lesson 02: Creating Charts 00:06:00 Lesson 03: Understanding Chart Elements 00:05:00 Lesson 04: Modifying Chart Elements 00:09:00 Lesson 05: Changing and Moving Charts 00:04:00 Lesson 06: Filtering a Chart 00:04:00 Lesson 07: Formatting Charts 00:07:00 Lesson 08: Adjusting Numbering 00:06:00 Lesson 09: Creating Dual Axis Charts 00:05:00 Lesson 10: Forecasting with Trendlines 00:05:00 Lesson 11: Creating a Chart Template 00:04:00 Lesson 12: Displaying Trends with Sparklines 00:07:00 Section 07 Lesson 01: What is a PivotTable 00:06:00 Lesson 02: Creating a PivotTable 00:07:00 Lesson 03: Working with the PivotTable Fields Pane 00:09:00 Lesson 04: Basic Data Organization and Analysis with PivotTables 00:06:00 Lesson 05: Formatting PivotTables 00:06:00 Lesson 06: Creating a PivotChart 00:04:00 Lesson 07: Modifying and Formatting a PivotChart 00:04:00 Lesson 08: Adding Slicers and Timeline Slicers 00:03:00 Lesson 09: Formatting Slicers 00:04:00 Lesson 10: Using the Ideas Feature 00:03:00 Section 08 Lesson 01: Using the PivotTable and PivotChart Wizard 00:02:00 Lesson 02: Adding a Calculated Field 00:05:00 Lesson 03: Adding a Calculated Item 00:04:00 Lesson 04: Applying Conditional Formatting to a PivotTable 00:02:00 Lesson 05: Creating Filter Pages for a PivotTable_1 00:03:00 Lesson 06: Enabling the PowerPivot Add: In 00:06:00 Final Exam Final Exam - Excel 365 Intermediate 00:20:00

Welcome to a project-based intermediate course. This course is designed to learn how to create new and exciting projects using various python modules. In each section, we will build a project and with each project, you will learn how to create an online multiplayer game, AOL-style chat room, and more!