3036 Microsoft courses delivered Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. This Access 2016 Introduction is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro. This course covers all the important features of Access 2016 and demonstrates how to use them. Here you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records. This course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage. What Will I Learn? Understand Databases and Database Terminology Work with Data Create Databases and Objects Work with Queries Work with Reports Work with Forms Requirements Basic computer skills. Knowledge of basic database concepts is helpful but not required. Who is the target audience? Students who want to learn database concepts and build basic databases. Introduction Intro FREE 00:01:00 Getting Started What is a database 00:02:00 Understanding Database terminology 00:05:00 Navigating the Access Interface 00:06:00 What is a flat file database 00:04:00 What is a relational database 00:09:00 Relating Tables 00:06:00 Reviewing the Access Ribbon 00:04:00 Working with Data Working with Tables 00:04:00 Navigating Tables 00:02:00 Editing Data 00:03:00 Adding New Records 00:02:00 Using Subdata Sheets 00:03:00 Creating Databases and Objects Understanding Database and Table Design Principles 00:10:00 Using Table Data Sheet View 00:04:00 Working with Field Data Types 00:04:00 Using Table Design View 00:03:00 Using Calculated Fields 00:04:00 Calculating Numbers 00:03:00 Calculating Dates 00:01:00 Calculating Strings 00:02:00 Using the Lookup Wizard 00:05:00 Editing Lookups 00:04:00 Using Indexes 00:02:00 Working with Queries What are Queries 00:03:00 Creating Simple Queries 00:04:00 Understanding the Dynaset 00:02:00 Entering Criteria- Exact Match and Range Operators 00:04:00 Understanding AND v. OR 00:03:00 Using Wild Cards 00:02:00 Using Key Words 00:03:00 Sorting and Hiding Fields 00:02:00 Creating Multi-Table Queries 00:03:00 Additional Tips 00:03:00 Working with Reports What are Reports 00:03:00 Understanding Report Types 00:03:00 Building Effective Reports 00:02:00 Using AutoReport 00:04:00 Understanding the Report Wizard 00:04:00 Using the Report Design View 00:08:00 Creating Labels 00:02:00 Working with Forms What are Forms 00:04:00 Understanding Form Types 00:02:00 Creating Forms 00:02:00 Navigating Forms 00:02:00 Editing Data in Forms 00:03:00 Understanding the Form Wizard 00:03:00 Using the Form Design View 00:04:00 Working with Controls 00:03:00 Using Form Layout View 00:02:00 Additional Tips (2) 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Introduction 00:00:00 Course Certification

Level 5 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Duration 3 Days 18 CPD hours This course is intended for This course is intended for Solution Architects Overview At the end of this course, you will be able to: Apply the AWS Well-Architected Framework Manage multiple AWS accounts for your organization Connect an on-premises datacenter to AWS cloud Move large data from an on-premises datacenter to AWS Design large datastores for AWS cloud Understand different architectural designs for scalability Protect your infrastructure from DDoS attack Secure your data on AWS with encryption Enhance the performance of your solutions Select the most appropriate AWS deployment mechanism Building on concepts introduced in Architecting on AWS, Advanced Architecting on AWS is intended for individuals who are experienced with designing scalable and elastic applications on the AWS platform. Building on concepts introduced in Architecting on AWS, this course covers how to build complex solutions which incorporate data services, governance, and security on AWS. This course introduces specialized AWS services, including AWS Direct Connect and AWS Storage Gateway to support Hybrid architecture. It also covers designing best practices for building scalable, elastic, secure, and highly available applications on AWS. Module 1: AWS Account Management Multiple accounts Multi-account patterns License management Manage security and costs with multiple accounts AWS Organizations AWS Directory Service Hands-on lab: Multi-VPC connectivity using a VPN Module 2: Advanced Network Architectures Improve VPC network connections Enhance performance for HPC workloads VPN connections over AWS AWS Direct Connect AWS Transit Gateway Amazon Route 53 Exercise: Design a hybrid architecture Module 3: Deployment Management on AWS Application lifecycle management Application deployment using containers AWS Elastic Beanstalk AWS OpsWorks AWS CloudFormation Module 4: Data Optimize Amazon S3 storage Amazon ElastiCache AWS Snowball AWS Storage Gateway AWS DataSync Backup and archival considerations Database migration Designing for big data with Amazon DynamoDB Hands-on lab: Build a failover solution with Amazon Route 53 and Amazon RDS Module 5: Designing for large scale applications AWS Auto Scaling Migrating over-provisioned resources Blue-green deployments on AWS Hands-on lab: Blue-green deployment with AWS Module 6: Building resilient architectures DDoS attack overview AWS Shield AWS WAF Amazon GuardDuty High availability using Microsoft SQL Server and Microsoft SharePoint on AWS High availability using MongoDB on Amazon EC2 AWS Global Accelerator Hands-on lab: CloudFront content delivery and automating AWS WAF rules Module 7: Encryption and data security Encryption primer DIY key management in AWS AWS Marketplace for encryption products AWS Key Management Service (AWS KMS) Cloud Hardware Security Module (HSM) Comparison of key management options Hands-on lab: AWS KMS with envelope encryption

Description MS office 2016 is an effective and popular app in this modern time. It is almost impossible to think a single moment without MS Office. Publishing text, writing email, letter, application, and creating content, it creates a great influence at this present age. Having a good command of it, people can enrich his career. Do you want to learn how it works? Take a visit to our MS Office 2016 New Features course. This course designs in such a way that will assist students to learn about the key issues of Microsoft Office 2016 along with its new changes. The new version adds some feature in PowerPoint, Outlook, Access, and Microsoft Word such as Tell Me, ink equating, version history, new chart types, themes, and individual review feature. At the end of the course, students can know how to deal with these new features appropriately. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Office 2016 New Features is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Office 2016 New Features is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Overview of Common Changes Using the Tell Me Feature 00:04:00 Using Smart Lookup 00:04:00 Applying the New Colorful Theme 00:02:00 Working with Version History 00:03:00 Working with New Chart Types 00:04:00 Using Ink Equations 00:03:00 New Features in Word Using Co-Authoring 00:05:00 New Features in Excel Using the One-Click Forecast 00:03:00 Searching in the PivotTable Field List 00:01:00 Using Multi-Select with a PivotTable Slicer 00:01:00 Using Maps 00:01:00 Using Get and Transform Power Queries 00:03:00 Publishing and Sharing in Power BI 00:02:00 Using Power View 00:02:00 Working with PowerPivot Improvements 00:02:00 New Features in PowerPoint Using Preset Styles for Shapes 00:04:00 Creating a Screen Recording 00:05:00 New Features in Outlook Working with Groups 00:09:00 Working with Clutter 00:05:00 Searching with Keywords and People Suggestions 00:02:00 Working with Email Attachments 00:03:00 New Features in Access Exploring the New Environment 00:01:00 Exploring New Templates 00:02:00 Exporting Linked Information to Excel 00:01:00 Integrating with SharePoint 2016 00:01:00 Conclusion Course Recap 00:01:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Data Analysis and Data Tools bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Data Analysis and Data Tools related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Data Analysis and Data Tools bundle will help you build a solid foundation to become a proficient worker in the sector. This Data Analysis and Data Tools Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Basic Data Analysis Course 2: Excel Data Analysis Course 3: 2021 Python Programming From A-Z: Beginner To Expert Course 4: Python Data Science with Numpy, Pandas and Matplotlib Course 5: 2021 Data Science & Machine Learning with R from A-Z Course 6: Mastering SQL Programming Course 7: Statistics & Probability for Data Science & Machine Learning Course 8: Quick Data Science Approach from Scratch Course 9: R Programming for Data Science Course 10: Learn Python, JavaScript, and Microsoft SQL for Data science Course 11: Google Data Studio: Data Analytics Course 12: Introduction to Excel Data Tools and Data Management Course 13: Data Center Training Essentials: General Introduction Course 14: Web Scraping and Mapping Dam Levels in Python and Leaflet Course 15: Microsoft Power BI - Master Power BI in 90 Minutes! Course 16: PowerBI Formulas Course 17: Business Intelligence and Data Mining Course 18: Financial Ratio Analysis for Business Decisions Course 19: Research Methods in Business Course 20: Cyber Security Incident Handling and Incident Response Course 21: Microsoft Azure 2017 Course 22: AZ-104: Microsoft Azure Administrator Course 23: Microsoft Azure Cloud Concepts Course 24: Advanced Excel Analytics Course 25: Microsoft Access Tables and Queries 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1:Career Development Plan Fundamentals Course 2:CV Writing and Job Searching Course 3:Interview Skills: Ace the Interview Course 4:Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Learning Outcome This tailor-made Data Analysis and Data Tools bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Data Analysis and Data Tools Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Data Analysis and Data Tools bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Data Analysis and Data Tools Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Microsoft OneNote is a free-form note-taking application helps to take digital notes and keep them organized. It also allows you to add images, diagrams, audios, videos, and so on. OneNote can access from both the desktop or mobile devices. The Office 365 OneNote Online course is intended for beginners to demonstrate the basics of OneNote Online in Office 365, including how to create a notebook and add content efficiently. This course teaches you everything from essential notes to drawings, links and embedded files and data. OneNote notebook contains pages and sections, related to a multi-subject notebook. You'll also learn to navigate and create notebooks, edit, share and print notes quite comfortably. What Will I Learn? Work with OneNote Create a New Notebook Add and Format Content Use Search Requirements Basic Computer Skills Introduction Introduction FREE 00:03:00 Working with OneNote Overview of OneNote 00:05:00 Creating a New Notebook 00:05:00 Navigating in OneNote 00:05:00 Adding Sections and Pages to a Notebook 00:05:00 Adding Content 00:08:00 Formatting Content 00:05:00 Using Tags 00:05:00 Using Search 00:04:00 Sharing & Printing a Notebook 00:06:00 Using Immersive Reader 00:05:00 Conclusion Course Recap 00:03:00 Course Certification

Description A good command in MS Project 2016 may assist you to make an astonishing career in the field of a manager. Are you looking for such a course that may help you to establish your position by making a good plan? If you want, you may look at the MS Project 2016 Introduction. It can help you to reach your goal. The course designed in such a way that will enable you to know the basic facts about how to develop the plan, examining resources to a task, handling the budget, tracking progress, and scrutinizing workloads. The purpose of the course is to make students efficient to set plan, create and customize a schedule, create resources to work with resource pool, and to make an effective project plan providing them a strong knowledge of how to add tasks, import it from Excel and Outlook, link tasks to create dependencies, and to break down structures to modify the task properties. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Project 2016 Introduction is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Project 2016 Introduction is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started with Microsoft Project Overview of Microsoft Project 00:02:00 The Microsoft Project Ribbon 00:04:00 Working with Task Views 00:04:00 Working with Resource Views 00:02:00 Working with More Views 00:03:00 Working with Tables 00:04:00 Creating a New Project Plan 00:03:00 Configuring the Project Information Window 00:05:00 Using the Manual and Auto Schedule Task Tool 00:03:00 Updating Project Plan Properties 00:02:00 Creating a New Project Calendar 00:02:00 Customizing a Project Calendar 00:05:00 Applying a Custom Calendar to the Project 00:02:00 Working with Tasks Creating New Tasks 00:03:00 Creating Recurring Tasks 00:03:00 Importing Tasks from Excel 00:04:00 Importing Outlook Tasks 00:01:00 Creating a Work Breakdown Structure 00:05:00 Overview of Task Dependencies 00:02:00 Linking Tasks 00:04:00 Using Lag and Lead Time 00:03:00 Working with Task Constraints 00:03:00 Working with Task Deadlines 00:02:00 Creating Task Notes 00:02:00 Adding Tasks to the Timeline 00:02:00 Working with Project Resources Resource Overview 00:03:00 Creating Resources 00:03:00 Importing Resource Information 00:03:00 Connecting to a Resource Pool 00:02:00 Working with Resource Calendars 00:04:00 Assigning Resources to Tasks 00:06:00 Assigning Multiple Resources 00:04:00 Managing Resource Overallocations 00:04:00 Preparing a Project Plan for Finalization Setting a Project Baseline 00:04:00 Managing Gantt Chart Elements 00:03:00 Formatting Gantt Chart Bars 00:03:00 Sharing a Project Plan 00:04:00 Conclusion Course Recap 00:01:00 Resources Resources - MS Project 2016 Introduction 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course is a short and crisp introduction to those who do not have any prior knowledge of scripting or any programming basics. The instructor has tried to explain the concepts in such a simple terminology that even non-technical people will find it very easy to grasp the various Windows PowerShell concepts.

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 Diploma 00:10: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