2692 Office Skills & Productivity courses in Edinburgh delivered On Demand

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you ready to embark on an enlightening journey of wisdom with the Business Etiquette, Communication & Writing Skills bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Business Etiquette, Communication & Writing Skills. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Email Writing Training Course 2: Diploma in Effective Writing Skills Course 3: Proofreading & Copyediting Course 4: Report Writing Course 5: Business English Perfection Course Course 6: Document Control Course 7: Touch Typing Essentials Course 8: Effective Communication Skills Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Business Etiquette, Communication & Writing Skills bundle illuminate your path to wisdom. The Business Etiquette, Communication & Writing Skills bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Business Etiquette, Communication & Writing Skills package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Business Etiquette, Communication & Writing Skills bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Business Etiquette, Communication & Writing Skills community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Business Etiquette, Communication & Writing Skills Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Business Etiquette, Communication & Writing Skills bundle. Establish robust bases across each course nestled within the Business Etiquette, Communication & Writing Skills bundle. Decipher intricate concepts through the articulate content of the Business Etiquette, Communication & Writing Skills bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Business Etiquette, Communication & Writing Skills bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Business Etiquette, Communication & Writing Skills bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Business Etiquette, Communication & Writing Skills bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Business Etiquette, Communication & Writing Skills bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Business Etiquette, Communication & Writing Skills bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Business Etiquette, Communication & Writing Skills journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Business Etiquette, Communication & Writing Skills Bundle. Career path Armed with the Business Etiquette, Communication & Writing Skills bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Business Etiquette, Communication & Writing Skills bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Your enterprise faces a new challenge, an unpredictable risk. The weight of responsibility rests on your shoulders, but there's a beacon of hope. Your foundation in Enterprise Risk Management empowers you to chart the path ahead. This transformative journey begins with our encompassing Enterprise Risk Management (ERM) course bundle. This Enterprise Risk Management (ERM) bundle presents a curated selection of courses designed to fortify your professional armoury. Delve into the intricate frameworks of Enterprise Risk Management and ISO 31000, grasp the core techniques behind Enterprise Risk: Identification and Mitigation, fuel your entrepreneurial spirit with Entrepreneurship Training, and establish a concrete understanding of Business Management. Furthermore, upscale your prowess with the Diploma in Lean Process and Six Sigma, journey through Operations Management: Enterprise Resource Planning and SAP Controlling (CO) - Product Costing S4HANA, and anchor your knowledge in Quality Management and Strategic Training - ISO 9001. Amid the ever-shifting sands of the business world, this Enterprise Risk Management (ERM) bundle's objective is to equip you with the ability to foresee, navigate, and manage enterprise risks, ensuring a thriving and sustainable trajectory for your ventures. Your Gateway to Excellence in Enterprise Risk Management: Course 01: Enterprise Risk Management and ISO 31000 Course 02: Enterprise Risk: Identification and Mitigation Course 03: Entrepreneurship Training Course 04: Business Management Course 05: Diploma in Lean Process and Six Sigma Course 06: Operations Management: Enterprise Resource Planning Course 07: SAP Controlling (CO) - Product Costing S4HANA Course 08: Quality Management and Strategic Training - ISO 9001 Learning Outcomes: Develop a robust understanding of Enterprise Risk Management principles and practices. Equip yourself with skills in risk identification, evaluation, and mitigation techniques. Absorb entrepreneurial concepts and foundational business management strategies. Commandeer Lean Process methodologies and Six Sigma for streamlined efficiency. Decipher the intricacies of Enterprise Resource Planning and SAP Controlling. Ground yourself in the benchmark standards and tactics associated with ISO 9001. Enterprise Risk Management and ISO 31000: Navigate the rich tapestry of risk management paradigms and ISO benchmarks. Enterprise Risk: Identification and Mitigation: Learn the art of discerning and addressing business risks adeptly. Entrepreneurship Training: Embrace the core tenets of initiating, steering, and expanding a business. Business Management: Comprehend the cardinal principles that underpin thriving businesses. Diploma in Lean Process and Six Sigma: Embrace the magic of streamlined processes and evidence-led decision-making. Operations Management: Enterprise Resource Planning: Journey through the labyrinth of resource orchestration and management. SAP Controlling (CO) - Product Costing S4HANA: Decipher the nuances of product valuation in the SAP milieu. Quality Management and Strategic Training - ISO 9001: Anchor yourself in quality-centric methodologies and strategic ISO norms. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Visionaries keen to dive into the domain of Enterprise Risk Management. Aspiring leaders and managers aiming for a dynamic role in business. Entrepreneurs desiring a fortified business insight. Process connoisseurs or analysts seeking a skill refinement. Individuals with an ardour to advance in business and risk management terrains. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Risk Management Analyst - £30K to £50K/year. Business Process Consultant (Lean & Six Sigma) - £35K to £60K/year. Operations Manager - £40K to £70K/year. SAP CO Consultant - £45K to £65K/year. Quality Management Specialist - £32K to £55K/year. Enterprise Risk Manager - £60K to £90K/year. Business Entrepreneur - Salaries are contingent on enterprise magnitude and prosperity. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the Writing bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Writing (Freelance Writing, Fiction, Novel, Screenwriting, Movie Script, Children's Book). Delve into eight immersive CPD Accredited courses, each a standalone course: Certificate in Freelance Writing Creative Writing Course - Fiction Copywriting Level 4 Screenwriting & Scriptwriting Creative Writing Course - Short Stories Creative Writing Course: Writing Storybooks For Children Proofreading & Copyediting Touch Typing Essentials Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Writing (Freelance Writing, Fiction, Novel, Screenwriting, Movie Script, Children's Book) bundle illuminate your path to wisdom. The Writing (Freelance Writing, Fiction, Novel, Screenwriting, Movie Script, Children's Book) bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Writing (Freelance Writing, Fiction, Novel, Screenwriting, Movie Script, Children's Book) package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Writing bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Writing (Freelance Writing, Fiction, Novel, Screenwriting, Movie Script, Children's Book) community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Writing bundle. Establish robust bases across each course nestled within the Writing bundle. Decipher intricate concepts through the articulate content of the Writing bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Writing bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Writing bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Writing bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Writing bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Writing bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Writing journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Writing bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Writing bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the Bid Writing bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Bid Writing, Freelance Writing & Email Writing. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Bid Writing Course 02: Certificate in Freelance Writing Course 03: Business English Perfection Course Course 04: Creative Writing Course 05: Email Writing Training Course 06: Diploma in Effective Writing Skills Course 07: English: Spelling, Punctuation, and Grammar Course 08: Touch Typing Essentials Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Bid Writing, Freelance Writing & Email Writing bundle illuminate your path to wisdom. The Bid Writing, Freelance Writing & Email Writing bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Bid Writing, Freelance Writing & Email Writing package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Bid Writing bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Bid Writing, Freelance Writing & Email Writing community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Bid Writing bundle. Establish robust bases across each course nestled within the Bid Writing bundle. Decipher intricate concepts through the articulate content of the Bid Writing bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Bid Writing bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Bid Writing bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Bid Writing bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Bid Writing bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Bid Writing bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Bid Writing journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Bid Writing bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Bid Writing bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the Dental Nurse & Dental Hygienist bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Dental Nurse & Dental Hygienist. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Dental Assistant Course 2: Dental Hygiene Online Course Course 3: Dental Radiography Course 4: Clinical Observations Skills Course 5: Control and Administration of Medicines Online Training Course Course 6: Diploma in Medical Secretary Course 7: Infection Control Course 8: Personal Hygiene Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Dental Nurse & Dental Hygienist bundle illuminate your path to wisdom. The Dental Nurse & Dental Hygienist bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Dental Nurse & Dental Hygienist package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Dental Nurse & Dental Hygienist bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Dental Nurse & Dental Hygienist community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Dental Nurse & Dental Hygienist Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Dental Nurse & Dental Hygienist bundle. Establish robust bases across each course nestled within the Dental Nurse & Dental Hygienist bundle. Decipher intricate concepts through the articulate content of the Dental Nurse & Dental Hygienist bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Dental Nurse & Dental Hygienist bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Dental Nurse & Dental Hygienist bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Dental Nurse & Dental Hygienist bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Dental Nurse & Dental Hygienist bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Dental Nurse & Dental Hygienist bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Dental Nurse & Dental Hygienist journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Dental Nurse & Dental Hygienist Bundle. Career path Armed with the Dental Nurse & Dental Hygienist bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Dental Nurse & Dental Hygienist bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Are you ready to embark on an enlightening journey of wisdom with the Investment bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Capital Budgeting & Investment Decision. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Capital Budgeting & Investment Decision Rules Course 02: Investment Banking: Venture Capital Fundraising for Startups Course 03: Applied Economics Course 04: Fundamentals of Zero Based Budgeting Course 05: Make Business Plans: Forecasting and Budgeting Course 06: Corporate Finance: Working Capital Management Course 07: Xero Accounting and Bookkeeping Training Course 08: Financial Analysis Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Capital Budgeting & Investment Decision bundle illuminate your path to wisdom. The Capital Budgeting & Investment Decision bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Capital Budgeting & Investment Decision package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Investment bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Capital Budgeting & Investment Decision community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Investment bundle. Establish robust bases across each course nestled within the Investment bundle. Decipher intricate concepts through the articulate content of the Investment bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Investment bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Investment bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Investment bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Investment bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Investment bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Investment journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Investment bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Investment bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     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 is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Overview This Excel spreadsheet for Beginner course will unlock your full potential and will show you how to excel in a career in Excel spreadsheet for Beginner. So upskill now and reach your full potential. Everything you need to get started in Excel spreadsheet for Beginner is available in this course. Learning and progressing are the hallmarks of personal development. This Excel spreadsheet for Beginner will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Excel spreadsheet for Beginner course covers everything you must know to stand against the tough competition in the Excel spreadsheet for Beginner field.  The future is truly yours to seize with this Excel spreadsheet for Beginner. Enrol today and complete the course to achieve a Excel spreadsheet for Beginner certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Excel spreadsheet for Beginner course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Excel spreadsheet for Beginner course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Excel spreadsheet for Beginner course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Excel spreadsheet for Beginner is suitable for anyone aspiring to start a career in Excel spreadsheet for Beginner; even if you are new to this and have no prior knowledge on Excel spreadsheet for Beginner, this course is going to be very easy for you to understand.  And if you are already working in the Excel spreadsheet for Beginner field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Excel spreadsheet for Beginner course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Excel spreadsheet for Beginner course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Excel spreadsheet for Beginner course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Excel spreadsheet for Beginner course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Assignment Assignment - Excel spreadsheet for Beginner 00:00:00