791 Numbers courses delivered On Demand

Learn how to build and test APIs and web services, which form the foundation of most software engineer work with the help of this carefully structured beginner's level course. You will be learning all of this in Python, one of the world's most popular and widely used programming languages.

Learn how to get control - and great results - in a sales management role. Includes Creating a Solid Foundation, Setting Up Your Team, Sales Processes & Techniques, Sales Forecasting, Targets & KPIs.

Learn to build a complete Internet of Things solution with Arduino, a SQL Database, and a web server

Are you ready to unravel the mysteries of numbers? Dive into our compelling Financial Modelling at QLS Level 3 course and be at the heart of smart business decisions. Financial models don't just predict the future; they shape it. Our introduction lets you grasp this powerful tool's essence, preparing you for the exhilarating journey ahead. As you immerse deeper, you'll befriend a restaurant. Not just any restaurant, but one that becomes your canvas to paint financial concepts on. From the hustle of acquiring customers to the nitty-gritty of costs, the case study becomes your guide, blending theory with tangible examples. Learning Outcomes Understand the core principles and applications of financial modelling. Develop financial models anchored in real-world scenarios, using the case study approach. Gain proficiency in customer acquisition, revenue, and cost modelling. Master the intricacies of the three financial statement models. Acquire the skills to identify and rectify errors in financial models. Why choose this Financial Modelling at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Financial Modelling at QLS Level 3 course for? Aspiring financial analysts keen to bolster their modelling expertise. Business owners aiming to gain insights into their company's financial health. Finance students looking to apply theoretical knowledge in practical scenarios. Investment bankers and consultants seeking to refine their financial modelling skills. Professionals in corporate finance aiming to understand business financials better. Career path Financial Analyst: £30,000 - £55,000 Investment Banker: £50,000 - £100,000+ Business Valuation Consultant: £40,000 - £70,000 Corporate Finance Manager: £60,000 - £90,000 Equity Research Analyst: £35,000 - £65,000 Financial Consultant: £40,000 - £75,000 Prerequisites This Financial Modelling at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Financial Modelling at QLS Level 3 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Introduction to the course 00:02:00 Introducton to the Business Priocess 00:03:00 What is Financial Modelling 00:08:00 Starting Point of a Financial Model 00:04:00 First Steps before Starting to create Financial Model and Linking Business Model 00:07:00 Section 02: Case Study: Restaurant - Basic Model for Selecting Initial Idea Starting with End in Mind-Comparative P&L 00:13:00 Customer Acquisition Model 00:16:00 Revenue and Cost Models 00:22:00 Adding Product and Modelling Labour and Other Costs 00:21:00 Modelling Capital Investments and ROI Calc 00:10:00 Case Study: Restaurant - Basic Model for Selecting Initial Idea 00:00:00 Section 03: Business Plan and 3 Financial Statement Models Detailed Customer Acquisition Model and Revenue Model 00:17:00 Cost of Sale Model 00:08:00 Modelling Labour Cost 00:07:00 Modelling Other Operating Expenses 00:14:00 Modelling Balance Sheet 00:14:00 Fixing the Error in Financial Model and Brief of RR 00:07:00 Financial Model for Business plan for New Business 00:00:00 Assignment Assignment - Financial Modelling at QLS Level 3 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Course Overview The demand for iOS apps is increasing every day. If you want to build your career as an app developer or programmer, learning iOS app development will be a smart choice for you. Learn how to create iOS apps using Swift 5 from this Build your first iOS 14 apps using swift 5 course and take your first step to be a pro developer. This course will help you understand Swift coding and solve your problems with app development. In this Build your first iOS 14 apps using swift 5 course, you will learn about the functions of Swift programming, variables and types, operations, collections, flow control, classes and inheritance. You will be able to create your first iOS app using swift 5 and enhance your skill to start your career as an iOS app developer.  This course will help you understand the app development process step by step with easily understandable bite-sized lessons.  Learning Outcomes Get a clear understanding of the fundamentals of iOS and Swift development Learn iOS development programming from scratch Be able to operate Swift 5 Learn the functions of Swift 5 Learn what you should consider before making an iOS app Gain the skills to be an efficient app developer Who is this course for? This course is designed for you to learn how to design iOS applications using swift 5. Anyone interested in app development can learn effective app development skills from this course 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 Build your first iOS 14 apps using swift 5 is a useful qualification to possess and would be beneficial for any related profession or industry such as: Ios Developers Programmers Designers Unit 01: Introduction Module 01: Setup 00:02:00 Module 01: A Quick Reminder 00:01:00 Unit 02: Variables and Types in Swift Programming Module 01: Variables Strings and Constants in Swift 00:08:00 Module 02: Solution - Variables Strings and Constants in Swift 00:01:00 Module 03: Variables and Numbers in Swift 00:07:00 Module 04: Solution - Variables and Numbers in Swift 00:01:00 Module 05: Type conversions in Swift - Danger Will Robinson 00:05:00 Module 06: Solution - Type conversions in Swift - Danger Will Robinson 00:02:00 Module 07: Tuple Types in Swift 00:05:00 Module 08: Solution - Tuple Types in Swift 00:02:00 Unit 03: Optionals in Swift and the Null Problem Module 01: Optionals Nulls and Variables in Swift 00:05:00 Module 02: Solution - Optionals Nulls and Variables in Swift 00:01:00 Unit 04: Operators in Swift Module 01: Operators in Swift - Assignment Arithmetic and Concatenation 00:04:00 Module 02: Solution - Operators in Swift - Assignment Arithmetic and Concatenation 00:01:00 Module 03: Operators in Swift - Unary Compound Logic and Comparison 00:04:00 Unit 05: Collections in Swift Module 01: Collections in Swift - Arrays 00:05:00 Module 02: Solution - Collections in Swift - Arrays 00:02:00 Module 03: Collections in Swift - Sets 00:06:00 Module 04: Collections in Swift - Dictionaries 00:05:00 Module 05: Solution - Collections in Swift - Dictionaries 00:03:00 Unit 06: Flow Control in Swift Module 01: Controlling Flow in Swift - for in loops 00:08:00 Module 02: Solution - Controlling Flow in Swift - for in loops 00:03:00 Module 03: Controlling Flow in Swift - While loops 00:04:00 Module 04: Solution - Controlling Flow in Swift - While loops 00:02:00 Unit 07: Conditional Statements in Swift Module 01: Conditional Statements in Swift - If Else 00:04:00 Module 02: Solution - Conditional Statements in Swift - If Else 00:02:00 Module 03: Conditional Statements in Swift - Switch Case 00:04:00 Module 04: Solution - Conditional Statements in Swift - Switch Case 00:02:00 Unit 08: Control Transfer in Swift Module 01: Control Transfer in Swift - continue break fallthrough return throw 00:06:00 Unit 09: Functions in Swift Module 01: Functions in Swift 00:10:00 Module 02: Solution - Functions in Swift 00:03:00 Module 03: Nested Functions in Swift 00:04:00 Module 04: Solution - Nested Functions in Swift 00:03:00 Unit 10: Enumerations in Swift Module 01: Enumerations in Swift 00:05:00 Module 02: Solution - Enumerations in Swift 00:01:00 Unit 11: Classes and Inheritance in Swift Module 01: Classes in Swift 00:05:00 Module 02: Solution 1 - Classes in Swift 00:02:00 Module 03: Solution 2 - Classes in Swift 00:02:00 Module 04: Inheritance in Swift 00:07:00 Module 05: Solution - Inheritance in Swift 00:04:00 Unit 12: Your First iOS App Module 01: Your First iOS App and Familiarisation 00:05:00 Module 02: The Key iOS Project Files 00:06:00 Module 03: How to Implement a Button in the User Interface 00:05:00 Module 04: How to Connect a Button to Code in Xcode 00:05:00 Module 05: Writing Code to Change a Views Appearance and a TASK 00:02:00 Module 06: Solution to the Task and If Else View Colors 00:07:00 Unit 13: Temperature Conversion App - iOS Layouts Positioning and Buttons Module 01: A Preview of the App We Will Build 00:01:00 Module 02: Create the App and Its User Interface 00:02:00 Module 03: iOS Layouts and Positioning 00:10:00 Module 04: Connecting UI Elements to Code 00:05:00 Module 05: Converting Temperature via Button Click 00:06:00 Module 06: Adding a Bit of Excellence to the UI and a Task for You 00:06:00 Module 07: Task Solution - Adding a Conversions Counter Label 00:07:00 Unit 14: Gods App - Navigation Table Views and Data Passing Module 01: What we are Building 00:02:00 Module 02: Creating the GreekGod Data Model 00:06:00 Module 03: Navigation Controllers in iOS 00:06:00 Module 04: Creating Fake Gods 00:04:00 Module 05: How to Set Up a Table View and Its Controller 00:11:00 Module 06: Task Solution - How to Fix the Table View 00:04:00 Module 07: How to Navigate from Table View to New View in iOS 00:04:00 Module 08: Create a View Controller for the Detail View 00:03:00 Module 09: Passing Data from Table View to View Controller 00:04:00 Module 10: Setting up a Detail View Controller with Passed Data 00:11:00 Module 11: Using Images and ImageViews in Swift - And a Task 00:04:00 Module 12: Solution to the Task 00:04:00 Unit 15: Will I Burn App - Accessing APIs and Device Hardware - GPS Module 01: Preview of the App We Will Make 00:02:00 Module 02: Structures Instead of Classes 00:05:00 Module 03: How to Request Permissions and Capabilities in iOS 00:04:00 Module 04: Requesting User Permissions in iOS - Part 2 00:09:00 Module 05: Requesting User Permissions in iOS - Part 3 00:07:00 Module 06: Creating a SWEET User Interface 00:09:00 Module 07: Task - Connect the UI to Code 00:01:00 Module 08: Connecting User Interface to Code 00:02:00 Module 09: Action Sheet Alerts in iOS 00:05:00 Module 10: Update a Label and Thoughts on Storage 00:03:00 Module 11: User Defaults Storage in iOS 00:05:00 Module 12: Getting and Setting User Defaults in iOS 00:04:00 Module 13: Getting a Location in Latitude and Longitude in iOS Apps 00:04:00 Module 14: Selecting an API Provider for Your Apps 00:07:00 Module 15: Generating an API Key and Exploring the Docs 00:04:00 Module 16: Create an API Access Class in Swift 00:04:00 Module 17: Using Third Party Libraries in iOS - AlamoFire 00:06:00 Module 18: How to Use AlamoFire in iOS 00:08:00 Module 19: How to Extract JSON Data from an API Call 00:06:00 Module 20: Performing Background Calculations in iOS 00:06:00 Module 21: Performing Background Calculations in iOS - Part 2 00:07:00 Module 22: Activity Indicators in iOS and Swift 00:07:00 Module 23: Local Notifications in iOS 00:06:00 Module 24: Solution to the Task - UI Smoothing 00:05:00 Unit 16: Whatsapp Clone Using Google Firebase Module 01: Preview of What We're Building 00:03:00 Module 02: Should you Choose Firebase or Firestore 00:10:00 Module 03: Create a Firebase Application 00:03:00 Module 04: Installing Firebase in your iOS App 00:09:00 Module 05: Firebase Authentication Options 00:05:00 Module 06: Designing the Auth Screen 00:10:00 Module 07: Connecting UI to Code 00:04:00 Module 08: Showing the Auth Screen 00:11:00 Module 09: Validating User Input for Firebase Authentication 00:08:00 Module 10: Register a User in Firebase 00:05:00 Module 11: Logging in via Firebase 00:06:00 Module 12: Set Activity Indicator to Show Network Processing 00:07:00 Module 13: How to Reset a Firebase User Password 00:11:00 Module 14: How to Prevent Dismissal of a View Controller 00:02:00 Module 15: Setting up a Table View and Cell Manually 00:11:00 Module 16: Connecting a TableView and ViewController Manually 00:05:00 Module 17: Implementing TableView Functions in the ViewController 00:06:00 Module 18: Listening to Firebase Data Streams on iOS 00:09:00 Module 19: Demo with Dummy Data 00:03:00 Module 20: Using a TextField Delegate in iOS 00:03:00 Module 21: Sending Data from iOS to Firebase Database 00:05:00 Module 22: Well Done and a Couple HARD TASKS with NO SOLUTION 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The Medical and Pharmacy Maths course has been designed to help you understand Pharmacy and Medical Math concepts and learn to calculate drug dosages cautiously and accurately. We've created this course with multiple, interactive video contents that cover everything from basic math skills to reading and interpreting labels and physicians' orders, introducing important calculation and conversion concepts. You'll learn how to avoid medication flaws brought about by calculation error and get introduced to numbers of problems that you may face in the real world scenario. Moreover, understand various measurement systems, the Math behind IV infusion, reconstituting liquid medications, and how to calculate medications based on a patient's age or body weight. In short, this comprehensive is ideal if you want to gain calculation skills and develop the competencies required by pharmacy technicians. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Medical and Pharmacy Maths 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 Medical and Pharmacy Maths 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 1 lecture Medical Math and Pharmacy Calculations Mastery - 01 00:01:00 Conversions Medical Math and Pharmacy Calculations Mastery - 02 00:04:00 Medical Math and Pharmacy Calculations Mastery - 03 00:09:00 Medical Math and Pharmacy Calculations Mastery - 04 00:13:00 Conversions Using Ratio - Proportion or Dimensional Analysis Medical Math and Pharmacy Calculations Mastery - 05 00:05:00 Medical Math and Pharmacy Calculations Mastery - 06 00:07:00 Medical Math and Pharmacy Calculations Mastery - 07 00:14:00 Medical Math and Pharmacy Calculations Mastery - 08 00:04:00 Medical Math and Pharmacy Calculations Mastery - 09 00:08:00 Pharmacy Math Medical Math and Pharmacy Calculations Mastery - 10 00:07:00 11- Quantity To Be Dispensed 00:03:00 12 - Single Dose, Single Day, Total Volume 00:12:00 Business Math 13 - Business Math Terminologies 00:08:00 14 - Business Math Mark-up Discount 00:16:00 15 - Retail Business Math Mark-up Amount & Mark-up Percentage 00:08:00 16 - Retail Business Math Discount Amount & Discount Percentage 00:15:00 17 - Pharmacy Business Math Purchase Price, Discount, and Discount Percentage 00:03:00 18 - Pharmacy Business Math Percentage Markup Rate 00:02:00 19 - Pharmacy Business Math Gross Profit Net Profit 00:03:00 Understanding Percentages, Strengths & Concentration 20 - Percentages, Strengths & Concentration 00:15:00 21 - % wv, % ww, % vv 00:06:00 Hospital and Compounding Math: Alligation & Dilution 22 - Review of Percentages, Strengths & Concentration 00:02:00 23 - Alligation & Dilution 00:04:00 24 - Application of Percentage, Alligation & Dilution 00:03:00 25 - Practice Problems 00:17:00 26 - More Practice Problems 00:02:00 Hospital Math: Flow Rate & Drip Rate 27 - Flow Rate vs Drip Rate 00:12:00 28 - Finding the R 00:07:00 29 - Finding the T 00:06:00 30 - Finding the V 00:03:00 Dosage Calculation 31 - Dosage Calculation Based on Weight & Age 00:05:00 32 - Dosage Calculation Based on Body Surface Area (BSA) 00:06:00 33 - BSA Practice Problems 00:03:00 34 - Therapeutic Dose versus Lethal Dose 00:02:00 35 - Therapeutic Range Minimum and Maximum Dose 00:08:00 36 - Dosage Calculation Based on Weight mgkgday & mgkgdose 00:07:00 37 - Pediatric Daily Rate 00:06:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Solidworks Drawing Tools Training: Test Preparation Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Solidworks Drawing Tools Training: Test Preparation Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Solidworks Drawing Tools Training: Test Preparation Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Solidworks Drawing Tools Training: Test Preparation Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Solidworks Drawing Tools Training: Test Preparation? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Solidworks Drawing Tools Training: Test Preparation there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Solidworks Drawing Tools Training: Test Preparation course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Solidworks Drawing Tools Training: Test Preparation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Solidworks Drawing Tools Training: Test Preparation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Solidworks Drawing Tools Training: Test Preparation is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction About the course 00:02:00 DRAWING BASICS Setting up drawing sheet 00:01:00 Orthographic views and edit sheet 00:04:00 Projected view and view properties 00:02:00 Smart dimension and Model Item 00:05:00 Saving options 00:01:00 DRAWING TECHNIQUES 1 Relative to model view 00:03:00 Section view 00:04:00 Auxiliary view 00:03:00 Detail view 00:02:00 Broken-out section view 00:02:00 Break view 00:02:00 Alternate position view 00:02:00 View focus 00:02:00 DRAWING TECHNIQUES 2 Bill of Materials (BOM) creation 00:03:00 Missing item in BOM 00:02:00 Custom properties in BOM 00:02:00 Equations in BOM 00:03:00 BOM properties and Item numbers 00:02:00 Hide/Show component 00:02:00 Linked notes 00:02:00 Measuring tool 00:02:00 Isometric section view 00:01:00 SAMPLE EXAM QUESTIONS QUESTION 1 00:03:00 QUESTION 2 00:01:00 QUESTION 3 00:02:00 QUESTION 4 00:02:00 QUESTION 5 00:01:00 QUESTION 6 00:02:00 OFFICIAL EXAM EXAMPLE QUESTION 1 00:03:00 QUESTION 2 00:02:00 QUESTION 3 00:02:00 QUESTION 4 00:03:00 QUESTION 5 00:01:00 QUESTION 6 00:02:00 Assignment Assignment - Solidworks Drawing Tools Training: Test Preparation 00:00:00

Learn to create captivating AI-generated art using DALL-E, Midjourney, and other AI art software. This course covers the fundamentals of AI art creation and provides hands-on training on how to generate stunning visuals. Develop your creativity and artistic skills in a fun and engaging way.

This course is designed for project managers and planners who need to plan and manage projects without resources in Oracle Primavera P6 PPM. You will learn how to navigate the user interface, create project plans, define activities, and manage project timelines without relying on resource constraints.

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification