3399 Courses delivered Online

Give a compliment to your career and take it to the next level. This Finance for Non Finance Managers 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 Finance for Non Finance Managers bundle will help you stay ahead of the pack. Throughout the Finance for Non Finance Managers 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 Finance for Non Finance Managers course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Finance for Non Finance Managers Bundle Consists of the following Premium courses: Course 01: Professional Personal Finance Course Course 02: Improve your Financial Intelligence Course 03: Financial Modeling Course for a Non-Finance Background Course 04: Debt Management - Online Course Course 05: Capital Budgeting & Investment Decision Rules Course 06: Making Budget & Forecast Course 07: Financial Analysis Course 08: Investment Banking & Valuation Course 09: Level 3 Tax Accounting Course 10: Essentials of UK VAT Course 11: Pension UK Enrol now in Finance for Non Finance Managers to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Finance for Non Finance Managersexpertise and essential knowledge, which will assist you in reaching your goal. Module 01: Introduction to Human Resources Module 02: Personal Finance Module 03: Personal Expenses and Income Module 04: Savings Module 05: How to Manage Your Personal Finance Using Free Budgeting Software CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Finance for Non Finance Managers bundle. Requirements This Finance for Non Finance Managers 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. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Professional Personal Finance Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Free Level 4 QLS Endorsed Certificate | CPD Accredited | 120 CPD Points | Advanced Learning Materials | Lifetime Access

Level 4 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

Level 4 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

Getting Started The CMI Level 3 Diploma in Principles of Management and Leadership is designed for practising or aspiring junior-level managers and supervisors responsible for first-level management. The CMI Level 3 Principles of Management and Leadership course enhances the skills of junior managers and supervisors in effective decision-making, communication and motivating the employees to attain maximum productivity and achieve clearly defined outcomes. You'll develop various management and supervisory techniques, enabling you to manage workplace problems with maximum competence. The CMI Level 3 Diploma has a more comprehensive structure, providing you with complete professionalism to become an efficient junior manager or supervisor. You'll have a wide range of units to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits For Learners: Support and monitor goals Provide instructions around objectives Give direction and guidance Support day-to-day operations Effective project planning Providing an overview of the roles and responsibilities required for managers and developing the skills required to succeed Foundation Chartered Manager offers professional recognition and access to the tools to facilitate continuing professional development (CPD) against our Professional Standard For Organisations: Making sure teams can meet organisational objectives Provides extensive knowledge and skills required to be a manager as part of an organisation The capability to apply learning in the context of another organisation or industry sector Key Highlights Are you a practising or aspiring manager and want to supervise or manage a team to achieve clearly defined outcomes? Then, the CMI Level 3 qualification in Principles of Management and Leadership offered by the School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 3 Principles of Management and Leadership can open many career pathways including, but not limited to: Team Leader, with an estimated average salary of £31,051 per annum Supervisor, with an estimated average salary of £34,000 per annum Shift Manager, with an estimated average salary of £36,216 per annum Project Officer, with an estimated average salary of £37,451 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 12 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Get Foundation Chartered Manager status upon course completion Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 2000 to 2500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for practising or aspiring junior-level managers and supervisors. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 18 years of age and over Possess the ability to complete the Level 3 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression There are numerous progression opportunities will be available on successful completion of a Level 3 qualification in Principles of Management and Leadership, Progression to other qualifications at the same level (e.g. from Level 3 Award to Level 3 Certificate Etc.) Progression to other qualifications at the next level (e.g. from Level 3 Certificate to Level 4 or 5 Certificate) Why gain a CMI Qualification? The CMI Level 3 Diploma in Principles of Management and Leadership is aimed at practising or aspiring managers who will supervise or manage a team to achieve clearly defined outcomes. Our CMI Level 3 Diploma in Principles of Management and Leadership will provide you with the key skills and competencies required to be a manager in an organisation. Upon completing the Diploma course in Principles of Management and Leadership, you will be awarded Foundation Chartered Manager Status. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 5 in Management and Leadership, with the goal of becoming a Chartered Manager. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 3 Diploma in Principles of Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must complete any combination to a minimum of 370 TUT hours, 37 credits to achieve this qualification. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Principles of management and leadership Reference No : CMI 301 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand how organisations operate. 2. Understand the management role 3. Understand the application of management and leadership approaches. UNIT2- Developing the Knowledge, Skills and Abilities of Individuals and Teams Reference No : CMI 307 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Know the purpose of developing the knowledge, skills and abilities of individuals and teams. 2. Know different types of development opportunities available to support individuals and teams. 3. Be able to identify and select development opportunities for individuals and teams. UNIT3- Managing a Team to Achieve Results Reference No : CMI 302 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role and purpose of teams 2. Be able to recognise the characteristics of a high performing team. 3. Know how to lead, communicate with and motivate a high performing team. UNIT4- Managing Individuals to be Effective in their Role Reference No : CMI 303 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand an individual's work role and responsibilities 2. Know how to set objectives with individuals. 3. Know how to support individuals to perform well UNIT5- Principles of Communication in the Workplace Reference No : CMI 304 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Know the channels and types of communication used in the workplace. 2. Understand the communication cycle. 3. Be able to plan communication for a target audience. UNIT6- Managing Budgets and Resources Reference No : CMI 314 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the importance of managing resources in own area of responsibility. 2. Understand the use of budgets in an organisation. 3. Understand how to manage costs within a budget. UNIT7- Managing Data and Information Reference No : CMI 318 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for collecting data and information. 2. Know how to manage data and information. 3. Know how to interpret data and information and communicate findings. UNIT8- Managing Meetings Reference No : CMI 319 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purposes and types of meetings. 2. Understand how to prepare for meetings. 3. Understand how to facilitate and chair meetings. UNIT9- Managing Own Personal and Professional Development Reference No : CMI 321 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the benefits of personal and professional development. 2. Know how to identify opportunities for personal and professional development. 3. Know how to create and monitor a personal and professional development plan. UNIT10- Building Stakeholder Relationships Using Effective Communication Reference No : CMI 305 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Know the purpose of building stakeholder relationships 2. Understand different channels and types of communication used to build relationships with stakeholders. 3. Know how to respond to barriers when communicating with stakeholders. UNIT11- Managing Daily Activities to Achieve Results Reference No : CMI 312 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose of daily work activities in the context of an organisation. 2. Understand how to prioritise and set objectives for daily work activities. 3. Know how to organise and allocate work. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Highlights of the Course Course Type: Online Learning Duration: 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about finance and cash management Understand the core competencies and principles of finance and cash management Explore the various areas of finance and cash management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert financial manager or business manager Finance and Cash Management Training Program Course Master the skills you need to propel your career forward in finance and cash management. This course will equip you with the essential knowledge and skillset that will make you a confident financial manager or business manager and take your career to the next level. This comprehensive finance and cash management course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this finance and cash management course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective finance and cash management practice and equip you with the essential skills, confidence and competence to assist you in the finance and cash management industry. You'll gain a solid understanding of the core competencies required to drive a successful career in finance and cash management. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for financial manager or business manager or for people who are aspiring to specialise in finance and cash management. Enrol in this finance and cash management course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive finance and cash management course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this finance and cash management can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This finance and cash management course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This finance and cash management course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This finance and cash management course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Fundamentals and Understanding Concepts Introduction And Basis Of Projections 00:05:00 Making Future Plans And Potential Revenue Generating Activities 00:06:00 Operational Plans That Need To Be Looked At 00:06:00 Cost Management Practices At Hotel And ABC System 00:07:00 Other Matters Before Practical Exercise 00:05:00 Financial Model and Working On Financial Model Room Revenue Budget Template 00:05:00 F&B Revenue Budgeting Template 00:10:00 Banquet And Other Operating Departments 00:10:00 Headcount Budget 00:11:00 Payroll And Other Cost Budgeting 00:12:00 Other hotel operational Expenses 00:10:00 Cash Budgeting Exercise 00:11:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

***24 Hour Limited Time Flash Sale*** Accountancy at QLS Level 5 Diploma Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Accountancy at QLS Level 5 Diploma Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Accountancy at QLS Level 5 Diploma bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Accountancy at QLS Level 5 Diploma Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Accountancy at QLS Level 5 Diploma Career Bundle: Course 01: Accountancy at QLS Level 5 Diploma Course 02: Managerial Accounting Training Course 03: Applied Accounting Course: Mastering Financial Management Course 04: Payroll: Payroll Management Course 05: Xero Accounting - Complete Training Course 06: Sage 50 Accounts Course 07: Making Budget & Forecast Course 08: Cost Control Process and Management Course 09: Anti-Money Laundering (AML) Course 10: Corporate Finance: Working Capital Management Course 11: Level 4 Diploma Accounting and Business Finance Course 12: Financial Modelling for Decision Making and Business plan Course 13: Financial Accounting Course 14: Tax Accounting Diploma Course 15: Commercial Law Course 16: Introduction to VAT Online Training Course 17: Microsoft Excel Training: Depriciation Accounting Course 18: Concept of Charity Accounting Course 19: Understanding Financial Statements and Analysis Course 20: Finance Assistant Training: Level 1 & 2 Certification Course 21: Negotiation Skills Certificate Course 22: Document Control Course 23: Advanced Diploma in Microsoft Excel Course 24: Online Time Management Training Course 25: Risk Assessment & Management With Level 7 in Strategic Learning & Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Accountancy at QLS Level 5 Diploma today and take the first step towards achieving your goals and dreams. Why buy this Level 7 in Strategic Learning & Development? Free CPD Accredited Certificate upon completion of Level 7 in Strategic Learning & Development Get a free student ID card with Level 7 in Strategic Learning & Development Lifetime access to the Accountancy at QLS Level 5 Diploma course materials Get instant access to this Accountancy at QLS Level 5 Diploma course Learn Accountancy at QLS Level 5 Diploma from anywhere in the world 24/7 tutor support with the Accountancy at QLS Level 5 Diploma course. Start your learning journey straightaway with our Accountancy at QLS Level 5 Diploma Training! Accountancy at QLS Level 5 Diploma premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Accountancy at QLS Level 5 Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Accountancy at QLS Level 5 Diploma course. After passing the Accountancy at QLS Level 5 Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Accountancy at QLS Level 5 Diploma course is ideal for: Students seeking mastery in Level 7 in Strategic Learning & Development Professionals seeking to enhance Accountancy at QLS Level 5 Diploma skills Individuals looking for a Level 7 in Strategic Learning & Development-related career. Anyone passionate about Level 7 in Strategic Learning & Development Requirements This Accountancy at QLS Level 5 Diploma doesn't require prior experience and is suitable for diverse learners. Career path This Accountancy at QLS Level 5 Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

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

Microsoft Excel® in Depth (Virtual) 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

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