7413 Courses in London delivered On Demand

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Master Microsoft Excel with this comprehensive online certification bundle. Learn advanced formulas, data analysis, automation, and visualizations for professional success.

Course Overview Take your spreadsheet skills to the next level and become a Pivot Table pro, with this step-by-step instructor-guided training course. The Excel Pivot Tables Crash Course course will equip you with the practical skills to analyse large sets of information quickly and efficiently using Excel Pivot Tables. It will teach you how to perform a diverse range of tasks such as creating reports, using Pivot Table data for market analytics, identifying trends, and calculating profit. This course is open to learners of all levels. It is ideal for financial and market analysts, administrative assistants, project managers, and anyone whose role involves working with spreadsheet data. Gain in-demand analytical skills and learn up-to-date best practices by learning from the experts. This best selling Excel Pivot Tables Crash Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Excel Pivot Tables Crash Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Excel Pivot Tables Crash Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Excel Pivot Tables Crash Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Excel Pivot Tables Crash Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Excel Pivot Tables Crash Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Excel Pivot Tables Crash Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

A special focus will be put on advanced MS Excel tips and tricks for career advancement in this course.

🚀 Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! 🚀 Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets!   🔥 Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities.   💡 What Sets Our Masterclass Apart: ✅ Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. ✅ Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. ✅ Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. ✅ Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. ✅ Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come.   📚 Course Highlights: 👉 Essential Excel Functions: From basic formulas to advanced functions, we cover it all. 👉 Data Visualization: Transform your data into impactful charts and graphs. 👉 Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. 👉 Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. 👉 Advanced Formulas: Impress your colleagues with advanced calculations. 👉 Automation with Macros: Streamline your tasks with Excel automation. 👉 Error Handling: Learn how to troubleshoot and avoid common mistakes.   🎓 Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity.   🌟 Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. 👉 Limited seats available. Secure your spot now! 👈 Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00

Highlights of the Course Course Type: Online Learning Duration: 1 Hour 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 Microsoft Office Excel Understand the core competencies and principles of Microsoft Office Excel Explore the various areas of Microsoft Office Excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Dynamic Arrays in Excel Program Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Excel 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 Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. 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 office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this Excel 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 Excel 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 Microsoft Office Excel 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 Excel 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 Excel 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 Excel 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 Dynamic Arrays in Excel Dynamic Arrays in Excel 00:03:00 XLOOKUP 00:09:00 FILTER and UNIQUE 00:19:00 SORT and SORTBY 00:12:00 SEQUENCE and RANDARRAY 00:13: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

In this course, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. Each section in the course contains an exercise for practice and quiz. The course is created using Excel 2019/365 for Windows.

Description: The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references. Who is the course for? Professionals who want to learn about the Microsoft Excel 2013 advanced features. People who have an interest in knowing all the functions of Microsoft Excel 2013. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel Advanced course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 11 Hours 11 Minutes 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 retail analytics and management Understand the core competencies and principles of retail analytics and management Explore the various areas of retail analytics and management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert retail manager Retail Analytics In Microsoft Excel Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive retail analytics in Microsoft excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this retail analytics in Microsoft excel 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 Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. 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 office admin or for people who are aspiring to specialize in Microsoft excel. Enroll in this retail analytics in Microsoft excel course today and take the next step towards your personal and professional goals. Earn industry-recognized 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 retail analytics in Microsoft excel 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 Microsoft excel 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 retail analytics in Microsoft excel 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 retail analytics in Microsoft excel 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 retail analytics in Microsoft excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Introduction Introduction 00:03:00 Part 1: Forecasting Basics of Forecasting 00:05:00 Creating Linear Model with Trendlines 00:08:00 1.1 Getting Data Ready For Regression Model Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 1.2 Forecasting Using Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 1.3 Handling Special Events Like Holiday Sales Forecasting in presence of special events 00:02:00 Excel: Running Linear Regression using Solver 00:08:00 Excel: Including the impact of Special Events 00:22:00 1.4 Identifying Seasonality & Trend for Forecasting Models to identify Trend & Seasonality 00:06:00 Excel: Additive model to identify Trend & Seasonality 00:09:00 Excel: Multiplicative model to identify Trend & Seasonality 00:06:00 Market Basket Analysis Market Basket and Lift - Introduction 00:08:00 Named Ranges - Excel 00:10:00 Indirect Function - Excel 00:05:00 2-way lift calculation in Excel 00:11:00 2-way lift calculation - Dynamic 00:07:00 2-way lift data table creation 00:07:00 3-way lift calculation 00:19:00 Store Layout optimization using Lift values 00:15:00 RFM (Recency, Frequency, Monetary) Analysis RFM (recency, frequency, monetary) Analysis 00:08:00 RFM Analysis in Excel- Part 1 00:16:00 RFM Analysis in Excel- Part 2 00:12:00 Part 2: Pricing Part 2: Pricing Steps of setting a Pricing policy 00:03:00 Different Pricing Objectives 00:07:00 2.1 Estimating Demand Estimating Demand 00:07:00 Forms of Demand Curve 00:02:00 Excel: Estimating Linear Demand Curve 00:08:00 Excel: Estimating Power Demand curve with Elasticity 00:05:00 Excel: Estimating Power Demand Curve with points 00:03:00 Subjective Demand curve 00:01:00 Excel: Estimating Subjective Demand Curve 00:02:00 2.3 Evaluating Pricing Strategies Price Bundling 00:07:00 Types of Bundling 00:08:00 The Bundling Problem 00:04:00 Excel: Solving Bundling problem Part 1 00:14:00 Excel: Solving Bundling problem Part 2 00:08:00 Non-Linear Pricing Strategies 00:03:00 Excel: Solving Bundling problem (Price Reversal) 00:08:00 3.1 Lifetime Customer Value Lifetime Customer Value - Key concepts 00:09:00 Lifetime Customer Value - Excel model 00:11:00 3.2 Variations And Sensitivity Analysis Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Appendix 1: Excel Crash Course Basics 00:08:00 Worksheet Basics 00:16:00 Entering values and Formulas 00:07:00 Data Handling Basics - Cut, Copy and Paste 00:14:00 Saving and Printing - Basics 00:09:00 Basic Formula Operations 00:13:00 Mathematical Formulas 00:19:00 Textual Formulas 00:17:00 Logical Formulas 00:11:00 Date-Time Formulas 00:07:00 Lookup Formulas ( V Lookup, Hlookup, Index-Match ) 00:08:00 Data Tools 00:19:00 Formatting data and tables 00:18:00 Pivot Tables 00:08:00 Advance Excel- Solver, Data tables 00:15:00 Assessment Assessment - Retail Analytics In Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Essential Formulas and Functions Mathematical Functions 00:06:00 Textual Functions 00:07:00 Logical Functions 00:11:00 Date-time (Temporal) Functions 00:07:00 Lookup Formulas Lookup Functions 00:08:00 Data Tools Data Tools 00:19:00 Formatting data and tables Formatting data and tables 00:18:00 Pivot Tables Pivot Tables 00:08:00 Charts Charts-Part 1 00:10:00 Charts-Part 2 00:12:00 Named Ranges Named Ranges 00:10:00 Indirect Functions 00:05:00 Excel Shortcuts Excel Shortcuts 00:12:00 Analytics in Excel Analytics in Excel 00:15:00 Macros Macros 00:10:00 Excel Uses Cases: Engaging Visualizations Infographics 1: Cool charts 00:14:00 Infographics 2: Cool charts 00:06:00 Waterfall chart 00:12:00 Excel Uses Cases: Modeling Customer Lifetime value Concept of Net Present Value and Customer Value 00:09:00 Finding Net Present Value in Excel 00:11:00 Sensitivity Analysis in Excel 00:07:00 Variations in finding customer value 00:07:00 Assessment Assessment - Microsoft Excel For Business 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00