12579 Manager courses in Downpatrick delivered Online

Through this course, you'll gain a deep understanding of the role of OB and its contemporary trends in today's dynamic business environment. Delve into the rich history of different perspectives of organisational behaviour, from classical theories to contemporary approaches. Learn how classical theories have shaped our understanding of OB and explore cutting-edge contemporary theories that are transforming the way we work. Enroll today and take your first step towards mastering the intricacies of organisational behaviour!" Discover the driving forces behind organisational behaviour and gain insights into contemporary trends that are shaping the modern workplace. From classical theories to cutting-edge approaches, this course will equip you with the knowledge and skills to understand and manage OB in today's dynamic business environment.After the successful completion of the course, you will be able to learn about the following, Understand Organisational Behaviour (OB), its role and Contemporary Trends. Explain different perspectives of organisational behaviour. Explore Classical Theories of Organisational Behaviour. Understand Contemporary Theories of Organisational Work. Through this course, you'll gain a deep understanding of the role of OB and its contemporary trends in today's dynamic business environment. Delve into the rich history of different perspectives of organisational behaviour, from classical theories to contemporary approaches. Learn how classical theories have shaped our understanding of OB and explore cutting-edge contemporary theories that are transforming the way we work. Enroll today and take your first step towards mastering the intricacies of organisational behaviour!" Discover the driving forces behind organisational behaviour and gain insights into contemporary trends that are shaping the modern workplace. From classical theories to cutting-edge approaches, this course will equip you with the knowledge and skills to understand and manage OB in today's dynamic business environment. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Organisational Context and Contemporary Organisational Behaviour Self-paced pre-recorded learning content on this topic. Organisational Context and Contemporary Organisational Behaviour Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Business Managers Human Resources Professionals Organizational Development Practitioners Leadership and Management Consultants Industrial/Organizational Psychologists Business Students Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

>> 48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! << Do you have a brilliant idea for a product but feel lost in the jungle of development? Did you know that in the UK, 20% of new products failwithin the first year? This comprehensive Product Development course equips you with the knowledge and skills to navigate the complex journey from conception to market success. This Diploma in Product Development at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! This Product Development training course empowers you to transform your product idea into a market reality. Master product classification, planning, pricing, branding, marketing, and financial analysis, navigating the journey from concept to launch with confidence. Unleash your entrepreneurial potential and build a successful career in the UK's thriving product development landscape. Learning Outcomes of Product Development Course Classify products based on market focus and consumer needs. Craft impactful product plans that drive successful development. Implement effective pricing strategies for profit maximization. Analyse existing product portfolios and identify growth opportunities. Develop data-driven marketing campaigns for targeted customer engagement. Utilise financial analysis tools to evaluate product viability and ROI. Elevate your career, launch groundbreaking products, and become a master of innovation. Enrol today in our Product Development course and take your product development skills to the next level! Why Choose Our Product Development Course? FREEProduct Development QLS endorsed certificate Get a free student ID card with Product Development Training Get instant access to this Product Development course. Learn Product Development from anywhere in the world The Product Development is affordable and simple to understand The Product Development is an entirely online, interactive lesson with voiceover audio Lifetime access to the Product Development course materials The Product Development comes with 24/7 tutor support Take a step toward a brighter future with our Product Development ourse! *** Course Curriculum *** Here is the curriculum breakdown of the Product Development at QLS Level 4 course: Module 01: Introduction to Product Management Module 02: Product Classification Module 03: Developing the Product Plan Module 04: New Product Development Module 05: Levels of a Product and Product Life Cycle Module 06: Product Pricing Strategy Module 07: Product and Brand Portfolio Analysis Module 08: Channels Management Module 09: Basics of Marketing for Products Module 10: Financial Analysis for Product Management Assessment Process of Product Development You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Product Development at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Product Development at QLS Level 4 This Product Development at QLS Level 4 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements Product Development at QLS Level 4 No prior background or expertise is required in this Product Development course. Career path Product Development at QLS Level 4 The Product Development at QLS Level 4 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Product Manager Brand Manager Marketing Manager Sales Manager Entrepreneur Consultant Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Product Development at QLS Level 4 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Product Development at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

Excellent course to become a great quality manager! Gain insights on Understanding Lean, the Five Principles of Lean, and an Overview of Six Sigma.

2 QLS Endorsed Courses | CPD Certified | Free PDF & Hard Copy QLS Certificates | 180 CPD Points | Lifetime Access

Recent studies have highlighted the paramount importance of Food Hygiene and Safety in the catering industry. With foodborne illnesses posing significant risks to public health, there's an urgent need for professionals with comprehensive knowledge in this domain. Given these findings, our bundle course, "HACCP with Food Hygiene and Safety for Catering at QLS Level 5," emerges as a timely and essential offering. A recent report by the Food Standards Agency revealed that adherence to stringent food safety standards could prevent a substantial proportion of foodborne illnesses. This underscores the critical role of proper hygiene practices and regulatory compliance in the catering sector. With "Food Hygiene and Safety" mentioned over thirty-five times throughout the curriculum, our Food Hygiene and Safety bundle course ensures a deep dive into these crucial aspects. Comprising a mix of QLS-endorsed and CPD QS-accredited courses, our Food Hygiene and Safety bundle provides a holistic learning experience. Participants will explore topics ranging from HACCP principles to food microbiology, immersing themselves in the intricacies of food safety management. Moreover, with modules dedicated to personal development and career growth, learners can enhance their professional skill set while advancing their knowledge of food hygiene standards. Bundle Includes : QLS Endorsed Courses: Course 01: Diploma in HACCP Training at QLS Level 5 Course 02: Advanced Certificate in Food Hygiene and Safety for Catering at QLS Level 2 CPD QS Accredited Courses: Course 03: Food Hygiene and Safety Course 04: How to Improve Your Food Hygiene Rating Course 05: Food Labelling Regulations Course 06: Immunity Boosting Food Course 07: Food and Beverage Manager Course 08: Immunity Boosting Food Course 09: Food Microbiology Course 10: Food and Mood: Improving Mental Health Through Diet and Nutrition 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 11: Career Development Plan Fundamentals Course 12: CV Writing and Job Searching Course 13: Networking Skills for Personal Success Course 14: Ace Your Presentations: Public Speaking Masterclass Course 15: 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.Microsoft Power BI & Microsoft Excel QLS Endorsed Diploma. Learning Outcomes: Gain a comprehensive understanding of HACCP principles and their application in the catering industry. Master advanced techniques in food hygiene and safety, ensuring compliance with industry regulations. Explore food labelling regulations and their implications for consumer health and safety. Acquire knowledge of immunity-boosting foods and their role in promoting public health. Develop skills in food and beverage management, essential for overseeing hygiene protocols in catering establishments. Enhance career prospects through improved networking, presentation, and decision-making skills. This comprehensive Food Hygiene and Safety bundle delves into the intricate world of food hygiene and safety, equipping participants with the knowledge and skills necessary to thrive in the catering industry. Through a series of meticulously curated modules, learners embark on a journey to master the principles of Hazard Analysis and Critical Control Points (HACCP) at QLS Level 5. They delve into the intricacies of risk assessment and mitigation, learning how to identify potential hazards in food production and implement effective control measures. Moreover, participants explore advanced techniques in food hygiene and safety, honing their ability to uphold impeccable standards in catering environments. From understanding the nuances of cross-contamination to implementing robust cleaning and sanitation practices, every aspect of food safety management is meticulously covered. Through real-world case studies and practical examples, learners gain insights into industry best practices, preparing them to navigate the complex landscape of food safety regulations with confidence. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Food Hygiene and Safety course is ideal for: Aspiring catering professionals seeking to enhance their knowledge of food safety regulations. Current food industry workers aiming to upskill and advance their careers. Individuals interested in pursuing roles in food and beverage management. Health and safety officers tasked with ensuring compliance in catering establishments. Students pursuing qualifications in hospitality and catering management. Entrepreneurs planning to venture into the food service industry. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Food Hygiene and Safety courses, you will be able to: Food Safety Officer Quality Assurance Manager Catering Manager Food and Beverage Director Public Health Inspector Food Hygiene Trainer Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 2 QLS Endorsed Certificates Hard copy certificate - Included

Project Accounting and Finance Skills: On-Demand Do you manage both project schedules and budgets, but do not have insight into how actual results relate to the approved budget? Do you desire to have more clarity about the relationship between your project's performance with the accounting and financial systems in your organization? Do you need to understand financial and accounting terminology to bridge the gap between the 'world of finance' and the 'world of project management? Organizations have a need to manage-by-projects, because projects are the means to deliver on strategic goals and objectives. Therefore, the project manager must have an understanding of the financial world of investments to ensure the organization will realize expected business value. This requires a foundation in the principles of accounting and finance to comprehend how the project's contribution provides an organization with a competitive advantage. Learn what you must do to give your organization the assurance it needs that its investment in your project will realize business value. Learn what you must do to give your organization the assurance it needs to know that its investment in your project will realize business value. What You Will Learn At the end of this program, you will be able to: Explain the aspects of classical corporate accounting and finance effects on managing projects Determine how your project fits into the corporate income statement, balance sheet, and cash flow statement Analyze the financial aspects of managing projects Use earned value management as the basis for decision making throughout the project life Recognize the importance of the project manager's financial responsibilities Focus on what PMs do and should be doing, in support of accounting and finance Use financial information within a project environment to meet financial results Track and analyze the project's financial status and forecast with the goal of realizing benefits Generate work performance data to ensure a project's outcome aligns with financial metrics Foundation Concepts Accounting and Finance Terms and Concepts Accounting and Finance Essentials Financial Terms and Concepts Projects as Financial Investments Overview of 'Two Worlds' Project as Investments Accounting and Finance World: Standards, Principles and Practices Accounting and Finance Standards and Principles Accounting and Finance Practices Capital Budgeting Corporate Budgeting Accounting and Finance World: Economic Project Selection Methods Economic Project Selection Methods Economic Project Selection and the Business Case Project Management World Project Management and Financial Controls Project Management and Work Performance Data Project Management and Earned Value Management Project Management and Work Performance Reporting

11 CPD UK & IPHM Accredited Courses Bundle | Recognised Certificate | MCQ based Exam and Tutor Support Included | Lifetime Access | Instant Result | Interactive Video Training Are you looking to begin your HR management career or want to develop more advanced skills in HR management? Then this HR administrator course will set you up with a solid foundation to become a confident HR manager and help you to develop your expertise in HR management. This bundle course has been designed with 11 CPD UK & IPHM accredited courses to provide the ultimate learning experience for our learners to further develop their expertise in their chosen field. Gain the essentials skills and knowledge you need to propel your career forward as a HR manager. This Bundle Package Includes: The following courses of the HR administrator course will set you up with a solid foundation in the HR management industry and give you the essential skills you need to succeed! HR Manager Recruitment Skills For HR Payroll Administrator Training Recruitment, Selection and Onboarding Organisation structure , Bands and Grades Performance Management System - KRAs Manage Conflict in Teams Time and Workload Management Problem Solving and Decision Making Supervisory Skills Delegation Skills For Managers If you're interested in working as a HR manager or want to learn more skills in HR management but unsure of where to start, then this HR administrator course will set you up with a solid foundation to become a confident HR manager and develop more advanced skills. The HR administrator course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a HR manager. The HR administrator courses bundle will help learners to fully enhance their skill set in team leading and active monitoring. By combining these related courses, learners will be equipped with a wide range of desirable skills to fast track their career. This comprehensive HR administrator course is the perfect way to kickstart your career in the field of HR management. This HR administrator course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. This HR administrator course supports learners of all skill levels. Whether you're an intermediate or advanced learner looking to brush up on your skills or a beginner wanting to start a new career or learn something new, our dedicated team of expert tutors are on hand to guide you through your learning every step of the way from enrolment to course completion. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This HR administrator course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Why Choose this HR Administrator Course: 11 Courses Bundle in your desired field Boost your skills in HR management Endorsed by The Quality Licence Scheme Accredited by The CPD UK and International Practitioners of Holistic Medicine (IPHM) MCQ Based Exam & Industry Expert Support Included Dual (CPD UK and IPHM) recognised accredited certificate in 1 course Learn from industry experts Lifetime Access High-quality e-learning study materials Self-paced, no fixed schedules 24/7 customer support through email Available to students anywhere in the world Study in a user-friendly, advanced online learning platform Who is this HR administrator course for? This comprehensive HR administrator bundle course are suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of HR management. Entry Requirement There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. Course Curriculum HR Manager Recruitment Skills for HR Payroll Administrator Training Recruitment, Selection and Onboarding Organisation Structure , Bands and Grades Performance Management System - KRAS Manage Conflict in Teams Time and Workload Management Problem Solving and Decision Making Supervisory Skills Delegation Skills for Managers Recognised Accreditation CPD Certification Service 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. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to obtain the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organization for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65 and will be charged separately for each course. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam, you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. You/your employer can verify your certificate through our website. Certificate can be obtained in PDF version and will be charged separately for each course, at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Description: To maintain your company's reputation, you have to keep your customers satisfied. An experienced and efficient customer service can easily maintain your customers. This Level 2 Certificate in Customer Service Management will teach the aspects managing customer service. In this course, you will learn to identify links between excellence in customer service and your business policies. You will also learn to develop skills and practices that are essential elements of customer service, recognize what are employees and customers are looking for, etc. Finally, you will understand the true meaning of leadership, managing performance, and practices. Learning Outcomes: Recognise means to settle connectivities between excellence in customer service as well as your business and policies Improvise the skills and practices essential for a customer service-focused manager Detect the customers as well as what they are searching for being truly involved Recognise who are your customers and what their interests are Improve plans for generating engaged employees and satisfied customers in the related business units that you manage 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? Level 2 Certificate in Customer Service Management 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 Level 2 Certificate in Customer Service Management 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. Customer Service Management - Updated Version Who We Are and What We Do 00:17:00 Establishing Your Attitude 00:13:00 Identifying and Addressing Customer Needs 00:12:00 Generating Return Business 00:14:00 In-Person Customer Service 00:10:00 Giving Customer Service over the Phone 00:12:00 Providing Electronic Customer Service 00:12:00 Recovering Difficult Customers 00:15:00 Understanding When to Escalate 00:14:00 Customer Service Management - Old Version Course Overview 00:05:00 Six Critical Elements 00:30:00 Understanding Leadership 00:30:00 Five Practices of Leadership 00:45:00 Mock Exam Mock Exam- Level 2 Certificate in Customer Service Management 00:20:00 Final Exam Final Exam- Level 2 Certificate in Customer Service Management 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE