Description Feng Shui Diploma The main principle behind FengShui is that things happening around us influence all of us. The circulation of life force energy, known as Ch'i, determines everyone's life. In other words, if we arrange our life in a particular way, we can surely choose to live the life we want. Certain arrangements and order in life can bring prosperity and happiness in life. As most people believe, FengShui is not merely about organising objects in a certain way. It is to do with the lifestyle. It is about choosing a way of life that is flowing towards positivity. FengShui can be applied to everything in one's life, including home, career and relationship. This diploma course in FengShui will help the learner understand everything about this Chinese art of better living. The course gives details about different types of FengShui and the different methods of arranging objects that would bring in a lot of change in the way life revolves around one. It will help the learner understand thoroughly about maximising one's energy and the ideal place to eat, sleep and work. The course will guide the learner to understand in detail the energy patterns in one's life and how to enhance one's positive energy. Once the learner completes this course, he or she will have ample knowledge about the different spots in one's home that offers good health, wealth, love, wisdom, a good career etc and how these aspects could be used to improve one's life. There are lots of opportunities for those who complete FengShui owing to the growing interest worldwide in this Chinese art. Besides individuals, several small and big business houses consult FengShui experts before venturing into new initiatives. A FengShui practitioner will be able to assist his or her client by suggesting ways to improve their health, wealth, career and relationships. One can find employment in FengShui companies or practice on their own. What you will learn 1: PRINCIPLES OF FENG SHUI 2: THE FIVE ELEMENTS 3: THE LATER HEAVEN SEQUENCE 4: PRINCIPLES 5: THE EIGHT COMPASS POINTS 6: MEDITATION AND THE NINE PALACES 7: HOUSE DIRECTIONS 8: FENG SHUI IN THE OFFICE ENVIRONMENT Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.
Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want In this course, you will learn various safety protocols and essential skills to create a secure and hazard-free work environment. This course will help you become a safety-conscious professional capable of identifying potential dangers and implementing effective safety measures. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Get to know office ergonomics Understand the occupational safety program Learn corrective actions for safety Know the risk factors and causes of MSDs Understand the basic safety practices at the workplace Get acquainted with ergonomics-related injuries Know personal protective equipment Learn the benefits of the ergonomics program Learn the OSHA's standards Understand workplace safety inspection Get introduced to industrial hygiene Know respiratory protection Why Workplace Safety Training Course right for you? This extensive online course is beneficial for those who want to understand occupational safety programs, workplace safety inspections, corrective actions for safety, and personal protective equipment. You will also have a broad knowledge of electrical safety precautions, basic safety practices at the workplace, and OSHA's standards. In addition, this online course will introduce you to OSHA, industrial hygiene, safety and health programs. This interactive course will give you a thorough understanding of respiratory protection, walking and working surfaces, and hazard communications. By the end of the course, you will gain a deep understanding of safety practices at the workplace, occupational safety programs, and workplace safety inspections. Workplace Safety Training Course Details Accredited by 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. 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. Course Curriculum Introduction Introduction What is Ergonomics What is Ergonomics Benefits of Ergonomic Program Benefits of Ergonomic Program Ergonomic Related Injuries Ergonomic Related Injuries Risk Factors and Causes of MSDs Risk Factors and Causes of MSDs Office Ergonomics Office Ergonomics Occupational Safety Program Occupational Safety Program Workplace Safety Inspection Workplace Safety Inspection Corrective Actions for Safety Corrective Actions for Safety Personal Protective Equipment Personal Protective Equipment Precautions for Electrical Safety Precautions for Electrical Safety Basic Safety Practices at Workplace Basic Safety Practices at Workplace OSHAs Standard OSHAs Standard Who should take this course? This extensive workplace safety training course is beneficial for those who want to stay updated on workplace safety best practices and learn OSHA standards. It is ideal for those who want to pursue a career in the field of workplace safety. Entry Requirements There are no academic entry requirements for this workplace safety training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This workplace safety training 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 can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. 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. Certificate can be obtained in PDF version 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
Duration 1 Days 6 CPD hours This course is intended for Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers) This course provides students with an overview of the IBM Cognos Analytics suite of products and their underlying architecture. Students will examine each component as it relates to an Analytics solution & will be shown a range of resources. IBM Cognos Analytics Describe IBM Cognos Analytics Describe IBM Cognos Analytics components Describe IBM Cognos architecture at a high level Describe IBM Cognos security at a high level Consume Content in IBM Cognos Analytics Where do consumers access BI content? Use published reports Drill through to related data Specify run report options Specify properties of an entry Alerts and Watch Items Create Reports in IBM Cognos Analytics Overview of reporting and report authoring Identify package types, uploaded files, and data modules available for reporting Examine IBM Cognos Analytics - Reporting Examine the interface Explore different report types Create a simple, sorted, and formatted report Create a report view Create a subscription Create an Active Report Import and report on personal data Create Dashboards in IBM Cognos Analytics Describe IBM Cognos Dashboarding Identify the IBM Cognos Dashboarding user interface Add report content and tools to create dashboards Widget-to-widget communication Filter data in the dashboard Sort, group and ungroup, and calculate data Create Metadata Models in IBM Cognos Analytics Define IBM Cognos Framework Manager and its purpose Describe the IBM Cognos Framework Manager environment Describe IBM Cognos Cube Designer Get high-level content from Dynamic Cubes course and/or FM course Web-based Modeling Create Data Modules Extend IBM Cognos Analytics Introduction to IBM Cognos Mobile Key features Examine Cognos Mobile architecture Identify supported products Introduction to IBM Cognos BI for Microsoft Office Describe Cognos Analysis for Excel (CAFÂ) Compare IBM Cognos Analytics & IBM Cognos BI New features in IBM Cognos Analytics Changes from IBM Cognos BI to IBM Cognos Analytics Legacy option Examine Event Studio Examine the role of Event Studio in Performance Management List the benefits of Event Studio Examine Metric Studio Identify scorecards, metrics, and metric types Organize metrics with strategies Track initiatives with projects
24 Hour Flash Deal **40-in-1 Mandatory & Statutory Training Mega Bundle** Mandatory & Statutory Training Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Mandatory & Statutory Training package online with Studyhub through our online learning platform. The Mandatory & Statutory Training bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Mandatory & Statutory Training course provides complete 360-degree training on Mandatory & Statutory Training. You'll get not one, not two, not three, but fortyMandatory & Statutory Training courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Mandatory & Statutory Training courses are yours for as long as you want them once you enrol in this course In this exclusive Mandatory & Statutory Training bundle, you really hit the jackpot. Here's what you get: Step by step Mandatory & Statutory Training lessons One to one assistance from Mandatory & Statutory Trainingprofessionals if you need it Innovative exams to test your knowledge after the Mandatory & Statutory Trainingcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all forty Mandatory & Statutory Training courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Mandatory & Statutory Training certificate and transcript on the next working day Easily learn the Mandatory & Statutory Training skills and knowledge you want from the comfort of your home This Mandatory & Statutory Training Bundle consists the following career oriented courses: Course 01: Health and Safety Executive (HSE) Course 02: Fire Safety Course 03: Manual Handling Training Course 04: First Aid at Work Course 05: Equality, Diversity and Discrimination Course 06: Data Protection and Data Security (GDPR) Training Certification Course 07: Diploma in Safeguarding Vulnerable Adults Course 08: Safeguarding Children Course 09: Conflict Resolution Course 10: Money Laundering Awareness and Anti-Bribery Training Course 11: Evacuation Procedures Training Course 12: Risk Assessment & Management Course 13: Cyber Security Awareness Training Course 14: Infection Control Diploma Course 15: COSHH Basics for a Safe Working Environment Course 16: Lone Worker Safety & Protection Course 17: Mental Health Awareness Course Online Course 18: Dementia Awareness Course 19: Inclusive Communities: Disability Awareness and Inclusion Training Course 20: Diversity Training Course 21: Workplace Violence, Harassment and Conflict Resolution Training Course 22: Food Safety & Hygiene Certificate Course 23: Customer Service & Environment Course 24: Time Management Course 25: Stress Management Training Course 26: Effective Communication Skills Diploma Course 27: Team Building Masterclass Course 28: Leadership Skills Training Course 29: Business Contract & Compliance Manager: Ensuring Legal Integrity Diploma Course 30: Substance Misuse Awareness Diploma Course 31: Professional Crisis Management Certificate Course 32: Mental Health and Wellbeing: Self Care Course 33: Effective Remote Working Course 34: Leading and Managing Remote Team Course 35: Child Protection Course 36: Domestic Violence and Abuse Awareness Diploma Course 37: Whistleblowing Training Course Course 38: Foundations of IT Security: Protecting Digital Assets Course 39: Principles of Fraud Prevention: Building a Strong Defence against Fraudulent Activities Course 40: Drugs and Alcohol Awareness Training The Mandatory & Statutory Training course has been prepared by focusing largely on Mandatory & Statutory Training career readiness. It has been designed by our Mandatory & Statutory Training specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Mandatory & Statutory Training Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Mandatory & Statutory Training bundle course has been created with fortypremium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Mandatory & Statutory Training Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Mandatory & Statutory Training Elementary modules, allowing our students to grasp each lesson quickly. The Mandatory & Statutory Training course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Mandatory & Statutory Training training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Mandatory & Statutory Training Requirements To participate in this Mandatory & Statutory Training course, all you need is - A smart device A secure internet connection And a keen interest in Mandatory & Statutory Training Career path You will be able to kickstart your Mandatory & Statutory Training career because this course includes various courses as a bonus. This Mandatory & Statutory Training is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Mandatory & Statutory Training career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free
Give a compliment to your career and take it to the next level. This Manager Management Training bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Manager Management Training bundle will help you stay ahead of the pack. Throughout the Manager Management Training programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Manager Management Training course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Manager Management Training Bundle Consists of the following Premium courses: Course 01: Management for Managers Course 02: Leadership and Management Training Course Course 03: Level 3- Project Management Course 04: Resourcing and Managing Talent Course Course 05: Employment Law Level 3 Course 06: Equality and Diversity Course 07: People Management Skills Level 3 Course 08: Performance Management Course 09: Compliance & Business Risk Management Course 10: Level 2 Microsoft Office Essentials Course 11: Leadership & Management Diploma Enrol now in Manager Management Training to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Manager Management Training expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Manager Management Training bundle. Requirements This Manager Management Training course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors.
Duration 5 Days 30 CPD hours This course is intended for Microsoft Dynamics 365 Finance and Operations Apps Developers Overview By the end of this course, you will learn to develop fully realized solutions by using standardized application coding patterns. In this course, you will learn the tasks needed to fulfill the role of developer in Dynamics 365 Finance and Operations Apps. The Dynamics 365 for Finance and Operations (FO) developer is a key technical resource that implements and extends the application to meet the requirements of the business. Module 1: Overview & Architecturen Explore the ecosystem and main components Explore the technical architecture Explore design and deployment considerations Module 2: Developer Tools Manage implementations by using Lifecycle Services Manage source code by using version control Customize by using Visual Studio Module 3: Solution Design Implement application lifecycle management Module 4: AOT Elements Build extended data types and enumerations Build tables Build forms and optimize form performance Create classes Create other user interface elements Module 5: Code Development & Testing Explore the test framework and use tools Get started with development using X++ Develop object-oriented code Use RSAT tool Module 6: Data Migration Prepare data for migration Module 7: Frameworks Introduction Explore extensions and the extension framework Extend elements SysOperationSandbox framework Summary Module 8: Integration Identify data integration patterns and scenarios Implement data integration concepts and solutions Implement the data management package API Data integrations Integrate with Microsoft Azure Connecting to Power Platform services Consume business events Integrate Finance and Operations apps with Microsoft Dataverse Module 9: Reporting Explore the reporting tools Build reports Build workspaces Manage data sources with external data stores Module 10: Security & Performance Work with performance and monitoring tools Implement role-based security Apply basic performance optimization techniques Additional course details: Nexus Humans MB-500T00 Dynamics 365 - Finance and Operations Apps Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MB-500T00 Dynamics 365 - Finance and Operations Apps Developer course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Branding Your Online Business course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Branding Your Online Business course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Branding Your Online Business and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Branding Your Online Business course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Branding Your Online Business course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Branding Your Online Business will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction to Branding Your Online Business Introduction 00:05:00 Module 01: Is Entrepreneurship for You Is Entrepreneurship for You 00:04:00 Reasons to Become an Entrepreneur 00:04:00 Characteristics of an Entrepreneur 00:04:00 The Mindset of an Entrepreneur 00:04:00 Types of Entrepreneurs 00:04:00 The 8p's Of Entrepreneurship 00:03:00 Module 02: Setting Up Your Home Office Setting Up Your Home Office 00:04:00 Tips for Designing Your Office Space 00:02:00 How to Layout Your Office Space 00:02:00 Tips to Be Super Productive in Your Home Office 00:03:00 Provides privacy 00:03:00 Set Up a Home Office You Love 00:03:00 Module 03: Decide Which Industry and Niche to Fill Decide Which Industry and Niche to Fill 00:04:00 Tips to find the right industry for you 00:03:00 How to Find Your Niche 00:04:00 Strategies for choosing an E-Commerce niche 00:04:00 How to Market an Online Business 00:05:00 Create Multiple Revenue Streams for Your Business 00:04:00 Module 04: Starting Your Business Online with Affiliate Marketing Starting Your Business Online with Affiliate Marketing 00:05:00 What is Affiliate Marketing 00:03:00 Tips on Choosing Products to Market 00:04:00 How to Get Targeted Traffic for Your Products 00:03:00 Research Product Demand 00:03:00 Choosing the Right Products to Sell for Yourself 00:04:00 Module 05: The Importance of Digital Marketing to an Online Business The Importance of Digital Marketing to An Online Business 00:03:00 Choosing the right platform to build your website 00:04:00 Using Social Media Effectively 00:03:00 Building Referrals with Current Customers 00:03:00 The Importance of An Autoresponder to Generate Leads 00:03:00 Using Articles to generate Leads 00:03:00 Module 06: Branding Your Business Branding Your Business 00:03:00 The Importance of Good Customer Service 00:03:00 Define Your Audience 00:04:00 Grow Your Online Presence 00:03:00 Reinvent Your Brand as Your Grow 00:03:00 Embrace Networking On and Offline 00:04:00 Module 07: Conclusion Review of course 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
10 premium courses| 10 PDF certificates for Absolutely Free
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