Course Overview Find the ultimate Python Developer roadmap by taking this 2021 Python Programming From Beginner to Expert course. Through this course, you will gain the fundamental skills to create your Python programs from scratch. In this step-by-step 2021 Python Programming From Beginner to Expert course, you will learn core Python skills from beginners to advanced features. The training begins by outlining the software installation procedure, guiding you through a series of Python basic data types, Python operators, advanced data types, Python functions and loops. You will learn how to handle errors in Python and comprehend the advanced functions in Python. The skills you develop in the program will enable you to create and run your first Python project. Enroll today and take your Python programming skills to the next level! Learning Outcomes Learn how to install Python on various operating systems Gain in-depth knowledge of the basic data types in Python Strengthen your knowledge of Python operators Learn about Python advanced data types Deepen your understanding of Python advanced functions Learn step-by-step how to handle errors Who is this course for? Anyone interested in learning Python programming and exploring the path to become a Python developer can take this 2021 Python Programming From Beginner to Expert course. This course opens the door for tremendous opportunities. 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 The 2021 Python Programming From Beginner to Expert course would be beneficial for any related profession or industry such as: Python Developer Python Programmer Product Manager Data Analyst Module 01: Introduction to Python Programming from A-Z Introduction To Python Section Overview 00:05:00 What is Python Programming? 00:10:00 Who is This Course For? 00:05:00 Python Programming Marketplace 00:06:00 Python Job Opportunities 00:05:00 How To Land a Python Job Without a Degree 00:08:00 Python Programmer Job Roles 00:09:00 Python from A-Z Course Structure 00:04:00 Module 02: Getting Familiar with Python Getting Familiar with Python Section Overview 00:06:00 Installing Python on Windows 00:10:00 Anaconda and Jupyter Notebooks Part 1 00:08:00 Anaconda and Jupyter Notebooks Part 2 00:16:00 Comments 00:05:00 Python Syntax 00:02:00 Line Structure 00:03:00 Line Structure Exercise 00:07:00 Joining Lines 00:05:00 Multiple Statements on a Single Line 00:05:00 Indentation 00:08:00 Module 03: Basic Data Types Basic Data Types Section Overview 00:08:00 String Overview 00:10:00 String Manipulation 00:07:00 String Indexing 00:04:00 String Slicing 00:08:00 Printing 00:10:00 Python Variables 00:08:00 Integers and Floats 00:08:00 Booleans 00:05:00 Mini Project 1 : Letter Counter 00:20:00 Module 04: Python Operators Python Operators Section Overview 00:04:00 Comparison Operators 00:09:00 Arithmetic Operators 00:08:00 Assignment Operators 00:04:00 Logical Operators 00:13:00 Identity Operators 00:05:00 Membership Operators 00:02:00 Bitwise Operators 00:08:00 Module 05: Advanced Data Types Python Advanced Data Types Section Overview 00:11:00 Sets 00:06:00 List Overview 00:05:00 List Slicing and Indexing 00:04:00 Tuples 00:02:00 Dictionaries 00:11:00 When to use each one? 00:05:00 Compound Data Types 00:03:00 Module 06: Control Flow Part 1 Control Flow Part 1 Section Overview 00:15:00 Introduction to Control Flow 00:01:00 Basic Conditional Statements 00:14:00 More Conditional Statements 00:05:00 For Loops 00:10:00 While Loops 00:12:00 Module 07: Control Flow Part 2 Control Flow Part 2 Section Overview 00:02:00 Break Statements 00:08:00 Continue Statements 00:05:00 Zip Function 00:07:00 Enumerate Function 00:04:00 List Comprehension 00:04:00 Module 08: Python Functions Python Functions Section Overview 00:03:00 Introduction to Functions 00:05:00 Python help Function 00:03:00 Defining Functions 00:09:00 Variable Scope 00:08:00 Doc Strings 00:04:00 Module 09: User Input and Error Handling User Input and Error Handling Section Overview 00:02:00 Introduction to Error Handling 00:03:00 User Input 00:04:00 Syntax Errors 00:04:00 Exceptions 00:11:00 Handling Exceptions Part 1 00:08:00 Handling Exceptions Part 2 00:08:00 Module 10: Python Advanced Functions Python Advanced Functions Section Overview 00:05:00 Lambda Functions 00:05:00 Functions args and kwargs 00:10:00 Iterators 00:08:00 Generators and Yield 00:12:00 Map Function 00:14:00 Filter Function 00:08:00 Module 11: Python Scripting and Libraries Python Scripting and Libraries Section Overview 00:05:00 What is a script? 00:01:00 What is an IDE? 00:17:00 What is a text editor? 00:12:00 From Jupyter Notebook to VScode Part 1 00:15:00 From Jupyter Notebook to VScode Part 2 00:05:00 Importing Scripts 00:03:00 Standard Libraries 00:04:00 Third Party Libraries 00:06:00 Module 12: NumPy NumPy Section Overview 00:04:00 Introduction to NumPy 00:04:00 Why use NumPy? 00:04:00 NumPy Arrays 00:10:00 Reshaping, Accessing, and Modifying 00:07:00 Slicing and Copying 00:06:00 Inserting, Appending, and Deleting 00:10:00 Array Logical Indexing 00:04:00 Broadcasting 00:08:00 Module 13: Pandas Introduction to Pandas 00:17:00 Pandas Series 00:17:00 Pandas Series Manipulation 00:17:00 Pandas DataFrame 00:17:00 Pandas DataFrame Manipulation 00:13:00 Dealing with Missing Values 00:10:00 Module 14: Introduction to OOP Functional vs OOP 00:06:00 OOP Key Definitions 00:04:00 Create your First Class 00:12:00 How to Create and Use Objects 00:06:00 How to Modify Attributes 00:12:00 Module 15: Advanced OOP Python Decorators 00:27:00 Property Decorator 00:09:00 Class Method Decorator 00:07:00 Static Methods Decorator 00:10:00 Inheritance 00:21:00 Module 16: Starting a Career in Python Python Career Section Overview 00:06:00 Getting Started with Freelancing 00:09:00 Building A Brand 00:12:00 Personal Branding 00:13:00 Importance of Having Website/Blog 00:04:00 Networking Do's and Don'ts 00:04:00 Top Freelance Websites 00:08:00 Creating A Python Developer Resume 00:06:00 Resources Resources - Python Programming Beginner to Expert Course 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Course Overview Direct messenger communication is more effective than Facebook posts. The faster you can answer the questions of your customers, the better response you'll get. And messenger chatbot makes you available for your customers 24/7. Learn how you can use messenger communication effectively and create your own chatbot from this Facebook Marketing and Building Messenger Chatbots course and boost your Facebook marketing skill today. In this Facebook Marketing and Building Messenger Chatbots course, you will learn how you can create a Facebook Messenger chatbot and turn your messenger inbox into a marketing platform. This course will teach you how you can create your chatbot with personalized text message conversation. You will also understand the settings of able to get an automatic notification for any emergency queries. This will also help you with messenger promotions, ad campaigns and increase sales through the chat platform. Learning Outcomes Understand how Facebook marketing works Be able to create an effective messenger chatbot Learn the functions of messenger chatbot Connect chatbot with webinars, Google sheets and other files Be able to create a highly successful or messenger ad campaign Learn how to set up SMS notifications from Facebook Messenger Develop chatbot drip campaign and attract new customers through Messenger Who is this course for? This course is for anyone who wants to learn about Facebook marketing and promote their business through Facebook. You will learn to build a messenger chatbot and be able to communicate with your customers more effectively. 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 Facebook Marketing and Building Messenger Chatbots is a useful qualification to possess and would be beneficial for any related profession or industry such as: Social Media Marketers Digital Marketers Social Media Influencers Small Business Owners Marketing Professionals Module 01: Introduction to Facebook Messenger Marketing Course Slides 01:40:00 MobileMonkey Support 00:05:00 Welcome to Facebook Messenger Chatbot Masterclass 00:08:00 What is messenger marketing? 00:10:00 Advantages of using Facebook messenger marketing 00:15:00 How is chatbot marketing different than other marketing channels? 00:07:00 Who can use messenger bots to their advantage? 00:05:00 Module 02: Example Use Cases For Facebook Messenger Chatbots Ecommerce chatbot strategies 00:10:00 Webinar/event registrations using chatbots 00:04:00 Lea-gen chatbot strategies 00:09:00 Using chatbots to promote educational resources 00:10:00 Using chatbots to stay in touch with your customers 00:08:00 Calculating LTV and CAC to formulate incentive plans 00:11:00 Ideas for incentive structures to promote through Facebook chatbots 00:09:00 Module 03: Psychological Principles of Persuasion in Effective Bot Design Commitment and Consistency in chatbot design 00:15:00 Increasing customer value with reciprocity 00:14:00 Using social proof to build trust and identity 00:12:00 Likability - your secret weapon to successful bot marketing 00:11:00 Using scarcity to drive your customers to convert faster 00:09:00 Understanding the Fogg Behavior Model and how to use it to your advantage 00:16:00 Module 04: Building Killer Chatbots With MobileMonkey What is MobileMonkey? 00:05:00 Creating a MobileMonkey account and connecting your Facebook page 00:06:00 Viewing active bots and adding users 00:03:00 Create your first chatbot! 00:03:00 Module 05: Learning All About The MobileMonkey Chatbot Builder Widgets, Page Flow and Organisation 00:08:00 Effective Ways of Media relation & Public Relation 01:00:00 Adding Q&A items in MobileMonkey 00:06:00 Understanding unanswered questions 00:04:00 Configuring and editing bot builder settings 00:04:00 All about the text widget 00:07:00 All about the image widget 00:01:00 All about the form widget 00:10:00 All about the quick question widget 00:07:00 All about the gif widget 00:03:00 All about the attachment widget 00:02:00 All about the attribute widget 00:02:00 All about the connection widget 00:03:00 All about the email widget 00:03:00 All about the gallery widget 00:06:00 All about the list widget 00:03:00 All about the navigate widget 00:03:00 All about the typing widget 00:03:00 All about the video widget 00:03:00 Module 06: How to wield the Mobile Monkey Chat Blaster like a Jedi Master What's a chat blast anyway? 00:03:00 A few useful chat blaster use cases 00:06:00 Chat blasting vs. drip campaigns 00:06:00 Planning four chat blast ideas (Part 1) 00:10:00 Planning four chat blast ideas (Part 2) 00:12:00 Organising our chat blast pages in the Mobile Monkey page builder 00:05:00 Building our coupon chat blast 00:11:00 Testing our chat blast before blasting 00:05:00 Launching our first chat blast: Naming, audience, page and purpose 00:09:00 Building a chat blast to drive phone calls 00:14:00 Building our new product line chat blast 00:16:00 Building our competitive advantage/awareness chat blast 00:19:00 Analysing chat blast results 00:02:00 Module 07: Understanding Lead Magnets and Using Lead Magnets To Build Your Contact List Why are lead magnets important? 00:05:00 Installing your chat widget on a WordPress site 00:06:00 Installing your chat widget on a Shopify site 00:01:00 Installing your chat widget through Google Tag Manager 00:05:00 Link to the messenger and adding it to emails and blogs 00:10:00 Adding the checkbox plugin to your web forms 00:03:00 How to use Facebook Comment Guards 00:17:00 Creating Facebook messenger landing pages 00:13:00 Module 08: Facebook Messenger Ad Campaigns Using Your MobileMonkey Chatbots! What are Facebook Messenger Ads? 00:06:00 Messenger ads best practices and sample strategies 00:12:00 Creating a new messenger ad campaign on Facebook 00:09:00 Designing a messenger ad 00:14:00 Completing messenger campaign creation in Facebook ads manager 00:07:00 Drafting our mobile monkey messaging campaign blueprint 00:07:00 Creating and naming all our pages in MobileMonkey 00:04:00 Building our messenger landing page in Mobile Monkey 00:04:00 Finishing all the other Facebook messenger bot pages 00:14:00 Duplicating your ad groups to try different targeting settings 00:08:00 Setting up MobileMonkey Q&A and other loose ends 00:07:00 Module 09: Understanding Audiences in MobileMonkey and Using Them to Your Advantage What are audiences in MobileMonkey 00:08:00 Creating an all contacts and gender-based audience 00:04:00 Timezone and last active based audiences in mobile monkey 00:07:00 Creating an audience based on a custom variable 00:07:00 Module 10: Building Our First MobileMonkey Drip Campaign! What are the drip campaigns and drip campaign best practices? 00:07:00 Practical and useful drip campaign ideas 00:07:00 Building and reviewing our drip pages in MobileMonkey 00:08:00 Creating and launching our first MobileMonkey drip campaign 00:09:00 Module 11: Using the RSS Blaster in MobileMonkey RSS feed step by step and best practices 00:10:00 Module 12: Becoming a MobileMonkey Power User With Advanced Integrations and Connections SECTION 13 Becoming a Mobile Monkey power user with connections Chapter 01 What are connections and when would you use them_1 00:03:00 Creating a connection to Google Sheets 00:14:00 Creating a connection to GoToWebinar 00:10:00 Send new leads to your CRM (Hubspot) 00:08:00 Send an SMS to your sales team when a contact requests a callback 00:10:00 Module 13: Understanding Your MobileMonkey Audience Insights Contacts - searching, exporting and deleting 00:03:00 Audiences in MobileMonkey 00:02:00 Forms - what they are and how to use them 00:02:00 Bot analytics - how to find useful information using Mobile Monkey analytics 00:03:00 Module 14: Staying on Facebook's Good Side: Chatbot Compliance What you need to know about staying compliant with Facebook 00:04:00 Getting approved for subscription messaging 00:09:00 Module 15: Conclusion ... Goodbye for now but stay in touch! Thank you, getting help, final thoughts 00:05:00
Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training 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 Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this 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 specialise in Microsoft excel. Enrol in this Microsoft 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 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 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 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 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 Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with âANDâ & âORâ / IF with Countif 00:08:00 Ex 0504 If with âANDâ & âORâ / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - 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
Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 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 microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training 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 Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this 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 specialise in Microsoft excel. Enrol in this Microsoft 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 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 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 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 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 Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with âANDâ & âORâ / IF with Countif 00:08:00 Ex 0504 If with âANDâ & âORâ / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - 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
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
Digital forensics is becoming very important in cyber security to detect and backtrack Black Hat criminals. It is essential to remove hackers' malicious backdoors/malware and trace them back to avoid possible future incidents.
Master GDPR and data protection with our comprehensive course, learning essential regulations and security measures to safeguard organizational data. Equip yourself to manage personal information effectively, ensuring compliance and building trust.
You will not only learn a few lines of code in this course but will also understand the principles of programming. Learn the fundamentals of JavaScript with the latest JavaScript versions (ES6/ES7/ES8/ES9/ES10/ESNext) and you will be well on your way to being a Grandmaster programmer in any language.
Overview This comprehensive course on Complete iOS 11 and Swift 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete iOS 11 and Swift 4 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 Complete iOS 11 and Swift 4. It is available to all students, of all academic backgrounds. Requirements Our Complete iOS 11 and Swift 4 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 13 sections • 177 lectures • 19:08:00 total length •iOS 11 Course Overview: 00:11:00 •Install Xcode 9: 00:07:00 •Xcode 9 Beta 4 Update: 00:09:00 •App: Hustle - Your first iOS 11 App: 00:22:00 •Variables, operators, and how computers work: 00:17:00 •Strings in Swift: 00:15:00 •Working with numbers in Swift: 00:20:00 •Swift Functions: 00:23:00 •Booleans: 00:21:00 •Constants: 00:10:00 •Array Data Structure in Swift: 00:13:00 •Swift Loops: 00:19:00 •Dictionary Data Structure in Swift: 00:19:00 •Object Oriented Programming in Swift: 00:12:00 •Inheritance: 00:08:00 •Polymorphism: 00:08:00 •Optionals: 00:21:00 •Enumerations: 00:20:00 •Extensions: Part 1: 00:15:00 •Extensions: Part 2: 00:21:00 •Intro to Protocols, Delegates - Numbers Example: 00:13:00 •Intro to Protocols, Delegates Part 2 - Question Generator: 00:18:00 •Protocols, Delegates - Building Color Magic App UI: 00:17:00 •Protocols, Delegates - Using the Delegate Method in Color Magic App: 00:16:00 •Protocols, Delegates - Using Mutating Functions in Types: 00:18:00 •Git and Version Control - The Fun Way!: 00:12:00 •Terminal Basics - Changing Directories: 00:06:00 •Terminal Basics - Creating Directories and Files: 00:05:00 •Terminal Basics - Copying and Renaming Files: 00:09:00 •Terminal Basics - Deleting Files and Directories: 00:06:00 •Git Basics: 00:17:00 •Setting up Github: 00:05:00 •Working with Local and Remote Repositories: 00:11:00 •Handling Git Merge Conflicts: 00:17:00 •App: Swoosh 01 - Creating the Welcome Screen: 00:25:00 •App: Swoosh 02 - Working with Frames: 00:16:00 •App: Swoosh 03 - Intro to Auto Layout: 00:27:00 •App: Swoosh 04 - Working with Stack Views: 00:27:00 •App: Swoosh 05 - Intro to Segues (Changing Screens): 00:10:00 •App: Swoosh 06 - Refactoring in Xcode 9: 00:10:00 •App: Swoosh 07 - Debugging: setValue forUndefinedKey: 00:04:00 •App: Swoosh 08 - Programmatic Segues: 00:09:00 •App: Swoosh 09 - IBActions (Handling Events) and Data Models: 00:16:00 •App: Swoosh 10 - Passing Data Between View Controllers: 00:12:00 •App: Dev Profile 01 - Auto layout for iPhones: 00:22:00 •App: Dev Profile 02 - Auto layout for iPads (Size Classes): 00:20:00 •App: Window Shopper 01 - Custom Text Fields: 00:18:00 •App: Window Shopper 02 - Input Accessory Views: 00:15:00 •App: Window Shopper 03 - Unit Testing our Data: 00:17:00 •App: Window Shopper 04 - Calculation Algorithm: 00:13:00 •App: Window Shopper 05 - Custom Drawing with drawRect: 00:12:00 •App: Coder Swag 01 - Project creation: 00:23:00 •App: Coder Swag 02 - Tableviews, Delegate, and Data Source: 00:33:00 •App: Coder Swag 03 - Collection Views (Grid Layouts): 00:13:00 •App: Coder Swag 04 - Working with Data Models: 00:14:00 •App: Coder Swag 05 - Displaying Data in Collection View Cells: 00:20:00 •Intro to Chat App: 00:04:00 •App: Smack - Project Setup: 00:26:00 •App: Smack - SWReveal: 00:20:00 •App: Smack - ChannelVC UI: 00:25:00 •App: Smack - LoginVC UI: 00:22:00 •App: Smack - CreateAccountVC UI: 00:19:00 •App: Smack - Web request and API: 00:09:00 •App: Smack - Hosting API: 00:20:00 •App: Smack - Locally Hosting API: 00:18:00 •App: Smack - Creating a web request in Xcode: 00:28:00 •App: Smack - Registering a User: 00:16:00 •App: Smack - Logging in a user: 00:20:00 •App: Smack - Creating a user: 00:26:00 •App: Smack - Avatar Picker Part 1: 00:19:00 •App: Smack - Avatar Picker Part 2: 00:20:00 •App: Smack - Generate a Avatar BG Color: 00:26:00 •App: Smack - LoggedIn Interface: 00:23:00 •App: Smack - Profile View: 00:25:00 •App: Smack - Logging in users: 00:23:00 •App: Smack - Getting channels: 00:19:00 •App: Smack - Channels TableView: 00:14:00 •App: Smack - Add Channel VC: 00:19:00 •App: Smack - Sockets and Channels: 00:26:00 •App: Smack - Refining Login Flow: 00:19:00 •App: Smack - Fetching Messages: 00:20:00 •App: Smack - Sending First Message: 00:17:00 •App: Smack - Displaying Chat Messages: 00:18:00 •App: Smack - Sockets and Messages: 00:19:00 •App: Smack - Typing Users: 00:22:00 •App: Smack - Unread Channels: 00:18:00 •Where to go from here: 00:08:00 •I'm Back: 00:08:00 •Intro to App: Pixel City: 00:02:00 •Creating Xcode Project: Pixel City: 00:04:00 •Installing Alamofire / AlamofireImage Cocoapods: 00:07:00 •Building MapVC UI /Conforming to MKMapViewDelegate /Setting Delegate of mapView: 00:15:00 •Requesting Location Services in iOS 11 / Centering Map On User Location: 00:18:00 •Adding UITapGestureRecognizer to Drop Custom Pins on MapView: 00:15:00 •Setting a Custom Map Annotation Color: 00:05:00 •Animating Photos View / Programmatically adding spinner and label subviews: 00:20:00 •Adding UILabel for Pull Up View / Adding UICollectionView Programmatically: 00:17:00 •Getting API Key from Flickr / Using Flickr API URL Format: 00:14:00 •Using Alamofire to Download URLS: 00:21:00 •Using Alamofire to Download Images / Cancelling All Sessions: 00:16:00 •Setting Up UICollectionView / Adding Images / Reloading UICollectionView: 00:10:00 •Building PopVC / Presentation PopVC When UICollectionViewCell is Tapped: 00:16:00 •Adding 3D Touch Peek: 00:15:00 •Challenge 1: 00:02:00 •Setting up developer: 00:10:00 •Implementing Google AdMob: 00:19:00 •Fetching a list of Products: 00:15:00 •Starting an in-app Purchase: 00:09:00 •Testing in-app Purchases: 00:18:00 •Restoring in-app Purchases after App Deletion: 00:09:00 •Intro to App: GoalPost: 00:03:00 •Creating Xcode Project / Project Folders: 00:04:00 •Building GoalsVC: 00:14:00 •Building GoalCell: 00:14:00 •What is Core Data?: 00:06:00 •Creating Goal Core Data Entity and Attributes: 00:08:00 •Displaying Static GoalCells in UITableView / Creating GoalType Enum: 00:10:00 •Building CreateGoalVC: 00:15:00 •Creating a UIViewController Extension: 00:11:00 •Creating a UIView / UIButton Extension: 00:19:00 •Building FinishGoalVC / Passing Data from CreateGoalVC: 00:19:00 •Saving Goal Data to Persistent Store: 00:13:00 •Fixing Dismissal of FinishGoalVC: 00:07:00 •Fetching Data from Persistent Store / Filling UITableView with Fetched Data: 00:16:00 •Removing Objects from Persistent Store using UITableView Delete Action: 00:11:00 •Setting Goal Progress for UITableViewCell: 00:15:00 •Challenge 2: 00:01:00 •Intro to App: Breakpoint: 00:03:00 •Creating Xcode Project / Setting Up Project Folders: 00:05:00 •Creating Firebase Project: 00:11:00 •Setting Up DataService / Creating Firebase Database Users: 00:11:00 •Building AuthVC and LoginVC in Interface Builder: 00:18:00 •Creating InsetTextField and ShadowView Subclasses: 00:18:00 •Setting up AuthService: 00:13:00 •Building FeedVC and GroupsVC in Interface Builder: 00:16:00 •Presenting LoginVC from AppDelegate / Allowing Login with Email: 00:22:00 •Building MeVC and Adding to UITabBarController: 00:10:00 •Creating CreatePostVC and Uploading Posts to Firebase: 00:20:00 •Creating UIView Extension for Binding Views to Keyboard: 00:15:00 •Building FeedCell: 00:10:00 •Writing the Message Model and Getting All Feed Messages from Firebase: 00:21:00 •Converting UIDs into Emails and Reversing the Order of a TableView: 00:20:00 •Creating CreateGroupVC and Connecting @IBOutlets/Actions: 00:15:00 •Creating UserCell: 00:16:00 •Searching for Email Accounts to Add to Group: 00:19:00 •Adding Users to Group with didSelectRowAt indexPath: 00:21:00 •Creating Groups and pushing them to Firebase: 00:16:00 •Creating GroupCell: 00:15:00 •Creating Group Model and Getting All Groups from Firebase: 00:19:00 •Building GroupFeedVC: 00:18:00 •Initializing Group Data for a Group and Presenting on GroupFeedVC: 00:16:00 •Downloading All Message for a Group and Animating Upon New Message: 00:24:00 •Creating a UIViewController Extension for Presenting GroupFeedVC: 00:07:00 •Challenge 3: 00:02:00 •Intro to app: 00:02:00 •Intro to CoreML: 00:05:00 •What is machine learning?: 00:08:00 •Creating Xcode 9 project: 00:03:00 •Building UI: 00:18:00 •AVFoundation: 00:18:00 •Tap gestures to take snapshot on item: 00:11:00 •Core ML Xcode 9 Beta 4 Update / Fix Preview Photo Crash: 00:03:00 •Downloading CoreML models: 00:21:00 •Adding UI controls for flash control: 00:07:00 •Training your app to speak what it sees: 00:18:00 •App: RampUp - Intro to ARKit App: 00:02:00 •App: RampUp - Resources: 00:04:00 •App: RampUp - Project creation: 00:11:00 •App: RampUp - SceneKit, 3D models: 00:11:00 •App: RampUp - Ramp picker popover: 00:14:00 •App: RampUp - 3D models in SceneKit for popover: 00:18:00 •App: RampUp - 3D models in SceneKit for popover part 2: 00:12:00 •App: RampUp - Detecting taps on 3D objects: 00:17:00 •App: RampUp - Placing ramps in ARKit: 00:24:00 •App: RampUp - Moving objects in 3D space in augmented reality: 00:20:00 •ARKit - where to go next: 00:04:00 •Assignment - Complete iOS 11 and Swift 4: 00:00:00
Overview This comprehensive course on Maximise Your Personal Productivity: Negotiation Skills Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Maximise Your Personal Productivity: Negotiation Skills Course 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 Maximise Your Personal Productivity: Negotiation Skills Course. It is available to all students, of all academic backgrounds. Requirements Our Maximise Your Personal Productivity: Negotiation Skills Course 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 5 sections • 28 lectures • 02:03:00 total length •Introduction: 00:02:00 •The Secrets of Highly Productive People: 00:07:00 •Introduction: 00:06:00 •Basic Concepts: 00:09:00 •Step #1 Collect: 00:08:00 •Step #2 Process Part 1: 00:06:00 •Step #2 Process Part 2: 00:08:00 •Step #3 Organise: 00:04:00 •Step #4 Plan: 00:05:00 •Step #5 Execute: 00:03:00 •Final Remarks of Effective Time Management and Personal Productivity with GTD: 00:02:00 •What Makes Us Not Get Work Done?: 00:02:00 •Pomodoro as The Way to Really Get Work Done: 00:03:00 •Running Pomodoros Smoothly: 00:05:00 •The Powerful Secret of Taking a Break: 00:06:00 •Final Remarks: 00:01:00 •Introduction: 00:01:00 •Approaches to Delegate Work - Part 1: 00:04:00 •Approaches to Delegate Work - Part 2: 00:01:00 •Approaches to Delegate Work - Part 3: 00:04:00 •Delegating Work - Final Tips: 00:01:00 •Introduction: 00:04:00 •The Elements of Negotiation: 00:07:00 •The Negotiation Process - Part A: 00:06:00 •The Negotiation Process - Part B: 00:03:00 •The Negotiation Process - Part C: 00:05:00 •6 Things That You MUST DO to be More Successful on Your Negotiations: 00:06:00 •5 Things That You MUST AVOID on Negotiations: 00:04:00