2362 Microsoft courses delivered On Demand

Azure Storage is Microsoft's cloud storage solution for modern data storage scenarios. Azure Storage offers a massively scalable object store for data objects, a file system service for the cloud, a messaging store for reliable messaging, and a NoSQL store.  This Azure - Azure Storage is designed to instruct you on Azure, and specifically how it pertains to containers. In this course, you will gain a comprehensive overview of storage in Azure. The course will teach you how to work with Azure storage accounts. You will learn how to expose file shares to multiple VMs in Azure at the same time. It guides you the procedures of using Blob storage, File Storage, and Content Delivery Network. Additionally, you will know how to monitor the storage and look at Azure File Sync. You will also review CDN profile. Finally, the course teaches you how to work with Backup Vault and site Recovery. What Will I Learn? Work with Azure storage accounts Use Blob Storage Use Content Delivery Network Work with Backup Vault and Site Recovery Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:03:00 Working with Storage Azure Storage Overview 00:03:00 Working with Azure Storage Accounts 00:09:00 Storage Access 00:05:00 Using Azure Blob Storage 00:06:00 Using Azure File Storage 00:04:00 Azure File Sync 00:10:00 Monitoring Storage 00:03:00 Content Delivery Network 00:03:00 CDN Profile 00:06:00 Azure Backup Vault 00:04:00 Azure Site Recovery 00:03:00 Conclusion Course Recap 00:03:00 Course Certification

SQL Azure is Microsoft's cloud database service. Based on SQL Server database technology and built on Microsoft's Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change.  This Azure - SQL focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software. Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure's data services, from a single database instance to a massive scale data warehouse for working with Big data. You'll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database. Finally, you'll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools. What Will I Learn? Overview and provision Azure SQL Connect to Azure SQL DB and Migrate DB to Azure Work with SQL security and metrics Configure SQL DB auditing Copy and export a database Use DB Self-Service Restore and SQL DB Geo-Replication Who is the target audience? Students wanting an understanding of Azure SQL and to build their skills. Requirements Basic understanding of Azure and SQL concepts Introduction Introduction FREE 00:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Course Certification

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Ethical Hacking and Pentesting Ultimate Hands-on Online Training Course Overview Are you looking to begin your ethical hacker career or want to develop more advanced skills in ethical hacker? Then this ethical hacker course will set you up with a solid foundation to become a confident ethical hacker and help you to develop your expertise in ethical hacker. This ethical hacking and pentesting ultimate hands-on online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this ethical hacking and pentesting ultimate hands-on online training course will set you up with a solid foundation to become a confident ethical hacker and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a ethical hacker. The ethical hacking and pentesting ultimate hands-on online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a ethical hacker. This comprehensive ethical hacking and pentesting ultimate hands-on online training course is the perfect way to kickstart your career in the field of ethical hacker. This ethical hacking and pentesting ultimate hands-on online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a ethical hacking and pentesting ultimate hands-on online training or want to learn more skills on ethical hacker but unsure of where to start, then this ethical hacking and pentesting ultimate hands-on online training course will set you up with a solid foundation to become a confident ethical hacker and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This ethical hacking and pentesting ultimate hands-on online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who is this Ethical Hacking and Pentesting Ultimate Hands-on Online Training course for? This comprehensive ethical hacking and pentesting ultimate hands-on online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of ethical hacker. Entry Requirement There are no academic entry requirements for this ethical hacking and pentesting ultimate hands-on online training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method This ethical hacking and pentesting ultimate hands-on online training 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 can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Course Overview Course Overview Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox Video and lab - Creating a Virtual install of Kali using VirtualBox Video and Lab - Creating a Virtual Install of CSI Linux 2021.2 Video and lab - Creating an Unattended Virtual Install of XP Using Virtualbox Video - Installing the VirtualBox Extension pack Video - Taking a Snapshot of Your Current Configuration Passive Reconnaissance Video and Lab - Gathering Information Using Maltego Video and Lab - Gathering Information Using CSI Linux Investigator Video and Lab - Preparing CSI Linux to Use Shodan Video and Lab - Using Shodan to Find Vulnerable Devices Nmap Video and Lab - Introduction to NMap Video and lab - NMap Scripting Engine (NSE) Video and lab - Scanning for WannaCry Ransomware Scanning for Vulnerabilities Using Nessus Video and Lab - Installing NESSUS Using Docker Video and lab - Scanning for Vulnerabilities Using Nessus Video - Using Your Nessus Scan Results Scanning for Vulnerabilities Using OpenVAS Video and Lab - Installing OpenVAS Using Docker Video and Lab - Scanning for Vulnerabilities Using OpenVAS Exploiting Microsoft Windows Video and Lab- Using Metasploit to Launch a DOS Attack Against Windows XP Video and Lab - Establishing A VNC Shell Using Meterpreter Video and Lab - Using Meterpreter to backdoor Windows XP Exploiting Linux Video and lab - Installing Metasploitable2 Using VirtualBox Social Engineering Video and Lab - Using the Social Engineering Toolkit (SET) BASH Scripting for Pentesters Video and Lab - Introduction to BASH Scripting Video and Lab - Creating a BASH Script for Scanning Vulnerable Ports Video and Lab - Password Cracking Using Medusa Video and Lab - Passwords Cracking Using Mimikatz Pentesting Wireless Networks Video and Lab - Installing a Wireless Adapter in Kali Video and Lab - Hacking a Wireless Network Using Kali Linux Wireless Deauthentication Attack PMKID Client-less Wireless Attack Using Bettercap Web Based Application Attacks Video and Lab - Installing w3af in Kali Linux Using Docker Video and Lab - Conducting A Website Vulnerability Scan Using w3af Video and Lab - Performing a Browser Based Attack Video and lab - SQL Injection Attack Using SQLmap Browser Exploitation Framework (BeEF) Video - Configure Kali for Exploitation the WAN Video and lab - The Browser Exploitation Framework (BeEF) Remaining anonymous Video and Lab - Anonymize Kali Using Whonix,,,,, Capture The Flag Walkthrough - Mr. Robot Video Walk Through -Key #1 Video Walk through - Key #2 Video Walk Through - Key #3 Capture The Flag Walkthrough - Stapler Video - Capture the Flag - Stapler Part 1 Video - Capture the Flag - Stapler Part 2 Video - Capture the Flag - Stapler Part 3 Order Your Certificate Now Order Your Certificate Now Get Your Insurance Now Get Your Insurance Now Feedback Feedback Certificate of Achievement Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Unlock Your Potential with the C# Coding & SQL Programming Bundle! Elevate your skills with this comprehensive bundle of 20 courses that dive deep into the realms of C# coding and SQL programming. With a focus on practical application, these courses are designed to equip you with the tools you need to succeed in today's tech-driven world. Learning Outcome: Master C# coding fundamentals for versatile software development. Develop advanced C# applications and programs with ease. Harness the power of SQL programming to manage and manipulate data. Create web GIS applications using C# ASP.NET CORE MVC and Leaflet. Build AutoCAD programs and integrate them with SQL databases. Gain expertise in LINQ, ADO.NET, and other essential coding techniques. Create Excel and Word Add-ins using C# for enhanced productivity. Develop a solid foundation in SQL for data science and analytics. Immerse yourself in the dynamic landscape of C# coding and SQL programming through this bundle of expertly crafted courses. Whether you're a beginner looking to establish a strong foundation or an experienced developer aiming to refine your skills, this bundle has something for everyone. Delve into interactive hands-on projects and gain practical insights that will set you apart in the competitive tech industry. CPD 190 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring software developers seeking proficiency in C# and SQL. Current developers aiming to expand their skill set. Tech enthusiasts who want to embark on a coding and programming journey. Career path Junior C# Developer: £30,000 - £45,000 SQL Database Administrator: £35,000 - £50,000 Web Application Developer: £40,000 - £55,000 Software Engineer: £45,000 - £65,000 Data Analyst with SQL Skills: £35,000 - £50,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

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 Access 365 Advanced 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 the professional training that employers are looking for in today's workplaces. The Access 365 Advanced Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Access 365 Advanced 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 Access 365 Advanced Course, like every one of Skillwise'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 Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Access 365 Advanced ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Access 365 Advanced 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 Access 365 Advanced course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Access 365 Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Access 365 Advanced was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Access 365 Advanced is a great way for you to gain multiple skills from the comfort of your home. Module 1: Improving the Structure of a Database Using the Table Analyzer Wizard 00:09:00 Append Querying to Normalize a Table 00:10:00 Creating a Junction Table 00:06:00 Module 2: Maintaining a Database Backup Up a Database 00:03:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:03:00 Using the Database Documenter Tool 00:02:00 Using the Analyze Performance Tool 00:02:00 Module 3: Working with Navigation Forms and Startup Options Creating a Navigation Form 00:03:00 Modifying a Navigation Form 00:05:00 Setting the Startup Options 00:03:00 Module 4: Configuring Access for Multiple Users Using the Database Splitter 00:04:00 Configuring Trusted Locations 00:03:00 Password Protecting a Database 00:04:00 Password Protecting Modules 00:02:00 Converting a Database to an ACCDE File 00:02:00 Module 5: Automating Processes with VBA Understanding VBA Basics 00:03:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:09:00 Converting a Macro to VBA 00:02:00 Module 6: Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:07:00 Using the After Update Event Command 00:04:00 Resource Resource - Access 365 Advanced Final Exam

Overview: Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive HR Management mega bundle. This 20 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the HR Management bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the HR Management bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This HR Management Bundle consists of the following premium courses: Course 01: HR Management Course 02: HR Virtual Interview Techniques Course 03: Managing Online Meetings Course 04: Decision Making in High Stress Course 05: Supporting a Grieving Employee Course 06: Working from Home Essentials Course 07: HR Crisis Communication Training Course 08: Employment Law for HR Course 09: Administrative Management Course 10: Managing Budgets Course 11: Business Analysis Course 12: Business Ethics for the Office Course 13: Diploma in Management Skills Course 14: Goal Setting & Accomplishment Course 15: Team Management Advanced Training Course 16: Talent Management Course 17: Ethical Leadership Principles Course 18: Risk Management: Risk Assessment & Analysis Course 19: Conflict Management and Crucial Communications Course 20: Customer Relationship Management Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes of this HR Training Bundle: This unique HR Management mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to HR Management to uplift your morale Key Features of the HR Management Course: FREE HR Management CPD-accredited certificate Get a free student ID card with HR Management training (£10 applicable for international delivery) Lifetime access to the HR Management course materials The HR Management program comes with 24/7 tutor support Get instant access to this HR Management course Learn HR Management training from anywhere in the world The HR Management training is affordable and simple to understand The HR Management training is entirely online Enrol in HR Management today and start your journey towards becoming successful! Description: The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificates: PDF Certificate: Free for all 20 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99) Who is this course for? The HR Management bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This HR Management bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. Certificates Digital certificate - Included Hard copy certificate - Included You will get the Hard Copy certificate for the title course (HR Management) absolutely Free! Other Hard Copy certificates are available for £14.99 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

PowerPoint Diploma The PowerPoint Diploma course provides the knowledge and skills needed, in order to create and deliver PowerPoint (PPT) multimedia presentations. Widely used in education, training and business environments, PowerPoint provides the vehicle for creating professional slideshows, videos and presentations. It incorporates many features, including the ability to produce handouts of the presentation. This course provides the skills to add text, images and charts to any presentation. The certificate is awarded, after successfully completing a multiple-choice examination at the end of the course. The certificate may be printed out, or - for a small fee - posted to the team member at their home. What's Covered in the Course? Your employee will cover the following information: Create and save a PowerPoint presentation; Add, delete and arrange multiple slides; Insert charts, captions, quotes and name cards; Inserting and formatting text within your slides; Working with text alignment, bullet points, line spacing and columns; Utilise text direction and vertical alignment; Inserting images, shapes, charts and creating photo albums; Insert online and screenshot images; Insert tables, text boxes, headers and footers; Using SmartArt and other formatting features; Converting your presentations into different formats; Add and edit hyperlinks; Transitions and animations; Using Spell Checker and Thesaurus; Create and add screen recordings within your slides; Using linking and annotation features; Adding notes and comments; Use the handout and notes master tools. What are the Benefits of the Course? A competent working knowledge of this powerful communication tool adds value, both for the employee and for the organisation; A comprehensive syllabus, covering all a user needs to know about designing PowerPoint presentations; Improved levels of competence in the organisation; As there are no deadlines for this course, learners may complete their training at their own pace or as part of an in-house study group; Easy-to-manage course modules - this makes studying an enjoyable experience; Online support is available throughout the course; A certified and recognised diploma.

Overview Learn how to become an exemplary Receptionist and positively represent your company when interacting with all clients and customers. Every business needs an efficient administrator to manage the Front-Office, along with providing support and assistance to their boss. We can coach you to become an excellent Receptionist and gain all the required business skills that you'll need to succeed, and the confidence with which to use them. Description The course has been compiled by industry experts and provides an overview of the responsibilities of a valued Receptionist. You will be tutored in a wide range of administrative practises, so that you can immediately start to use them in the office. It also includes training in customer-facing etiquette and suggestions on how to positively improve your company's reputation with clients. Various other crucial office aptitudes will be covered, such as; Time Management, Travel Arrangement, Record Keeping, and Business Writing. Make sure you present the efficiency of your company by enrolling now. Learning outcomes:  Understand the basic requirements needed to run receptions areas efficiently Gain the all-round skills to be a first-class Receptionist Learn how to represent your boss and company in reception Be skilled in organising travel and arranging executive meetings for others Attain the ability to file and retrieve essential company records Acquire the skills to apply excellent communicate practises at work Display great customer service for clients and colleagues Be trusted to handle internal finances and petty cash funding Why People Love And Enrol In The Receptionist Skills From Studyhub: Instantly accessible CPD-accredited certificate on successful completion of this Receptionist Skills 24/7 access to the course for 12 months Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient assessment and instant results Method of Assessment To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. To enhance your knowledge regarding the course and to further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification After completing the MCQ assessment, you will qualify for the CPD Certificate from Studyhub, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15. Who is This course for? This course is primarily designed to provide coaching and training for those individuals who aspire to work as Receptionists or a similar role such as a Secretary or PA. Requirements There are no specific prerequisites to enrol in this Receptionist Skills. Anyone and everyone can take this course. The Receptionist Skills is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Career Path This course provides training and a comprehensive overview of all the skills and knowledge that are needed by a Receptionist or a similar administrative role. As such, it will cover the following roles and careers:  Receptionist Administrative Manager Personal Assistant Private Secretary Human Resources staff Course Curriculum Office Admin and Reception Module 1: Introduction to Reception and Receptionist 00:11:00 Module 2: Business Telephone Skills 00:19:00 Module 3: Representing Your Boss and Company 00:34:00 Module 4: Mail Services and Shipping 00:25:00 Module 5: Travel Arrangements 00:24:00 Module 6: Organising Meeting and Conferences 00:25:00 Module 7: Time Management 00:35:00 Module 8: Record Keeping and Filing Systems 00:28:00 Module 9: Business Writing Skills 00:40:00 Module 10: Organisational Skills 00:25:00 Module 11: Communication Skills 00:25:00 Module 12: Customer Service 00:16:00 Module 13: Effective Planning and Scheduling 00:46:00 Module 14: Invoicing/Petty Cash 00:27:00 Module 15: Business Environment 00:19:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Office Admin and Reception 00:20:00 Final Exam Final Exam - Office Admin and Reception 00:20:00