1510 Editor courses

Course Overview The "Adobe Lightroom CC" course offers learners an in-depth understanding of the powerful photo editing and organising tools within Adobe Lightroom CC. This course is designed to help individuals at all levels develop proficiency in managing and editing their images efficiently. It covers both the Lightroom Classic CC and Lightroom CC applications, offering learners insights into non-destructive editing techniques, file management, and advanced photo adjustments. Upon completion, learners will be equipped to enhance their photography workflow, ensuring that they can bring their creative visions to life with ease. Course Description This comprehensive course covers key areas of Adobe Lightroom CC, including the differences between Lightroom Classic CC and Lightroom CC, and their respective strengths. Learners will explore how to organise and edit photos using a variety of features such as editing tools, presets, and colour corrections. Additionally, learners will gain knowledge on how to submit photos efficiently within Lightroom and learn best practices for organising a photo library. Throughout the course, participants will develop the skills necessary to refine their editing abilities, increase productivity, and optimise their overall workflow in a professional photography environment. Course Modules Module 01: Lightroom Classic CC Module 02: Lightroom CC Module 03: Photo Submission (See full curriculum) Who is this course for? Individuals seeking to enhance their photo editing skills. Professionals aiming to streamline their photo management and editing processes. Beginners with an interest in photography and photo editing. Photography enthusiasts wanting to optimise their Lightroom workflow. Career Path Professional Photographer Photo Editor Graphic Designer Digital Imaging Specialist Content Creator Photography Studio Assistant

Linux training course description A Linux foundation appropriate for all flavours of Linux, focussed on getting network engineers up and running with Linux. The command line is used throughout. The course progresses from the basics of Linux commands onto useful tools such as grep, then shell features such as piping and then onto shell scripting. Administration aspects covered are the tasks network engineers are most likely to encounter such as software installation. Hands on exercises concentrate on network related tasks such as installing net-snmp and using shell scripts to provide network automation. What will you learn Use Linux commands to perform a variety of tasks from manipulating files to handling processes. Create and edit files with vi. Work with permissions. Write simple shell scripts. Install software packages. Configure base networking. Linux training course details Who will benefit: Network engineers. Prerequisites: TCP/IP Foundation Duration 5 days Linux training course contents What is Linux? Linux distributions, open source software. Getting started Logging in, changing passwords, logging out. Hands on Basics and root access. Linux basics Command structure. The Linux manuals, basic commands (who, date, tty, uname, echo, banner...). Hands on Using the CLI. Connecting to a network IP configuration, DHCP, static addressing, routing, ifconfig, ping, netstat, traceroute, dig. Hands on Network configuration and testing. Managing Software Package Concepts, Comparison of package formats, RPM, rpm Commands, Yum, Debian Packages, dpkg, apt-cache, apt-get, dselect, aptitude, Converting Between Package Formats, Dependencies and Conflicts, Startup Script Problems, Shared Libraries, Library Management Hands on Installing network packages such as nmap and net-snmp. Processes and log files ps, kill, background processes, at, exec, priorities. Managing Linux log files. Syslogd. Setting the time. Cron and cronjobs. Managing Processes, the Kernel: The First Process. Hands on Controlling daemons and services. Setting up a TFTP server. Filesystem commands Home directories, manipulating files and directories, Filesystem layout, Pathnames, hard and symbolic links. Viewing files. Hands on Exploring the filesystem, working with network device configuration files. The Linux editors ed, vi, shell escapes, .exrc. Hands on Editing network device configuration files. Extracting data from files grep, find, cut, sort and paste… Hands on Working with syslog files. Permissions Theory, chmod, chown, newgrp. Hands on Handling permission problems. The shell Metacharacters, piping and redirection. Hands on Running SNMP commands and working with their output. Basic shell scripting What are shell scripts? Simple scripts, control structures. Variable. Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. Positional parameters: $0 to $9, $#, $* and others. shift parameter substitution. Control statements: The test command, if , while loops, for loops, the case statement. Hands on Automating network tasks. Customising your environment Environmental variables, stty, .profile and other startup files. Hands on Customising Linux. Introduction to administration The root user, su. Managing users and groups. Hands on The power of root. Archiving files Backups, tar, cpio, dd, gzip. Hands on Working with tar files. Booting Linux and Editing Files Installing Boot Loaders, GRUB Legacy, GRUB 2, Alternative Boot Loaders, the Boot Process, Boot Messages, Runlevels and the Initialization Process, Runlevel Functions, Runlevel Services, Alternative Boot Systems , Upstart, system. Hands on Installing network services on Linux.

For the Postgraduate Diploma (PG Dip.) you will study the four modules (60 credits) from the Postgraduate Certificate (PG Cert.) plus an additional three modules (60 credits) from the MA Business of Motorsport Master’s Degree. N.B. The Postgraduate Diploma (PG Dip.) does not include the Executive Project (Dissertation) the final module of the MA.

The Postgraduate Certificate (PG Cert.) consists of the first four modules from the MA Business of Motorsport Master’s Degree. You can then achieve a Postgraduate Diploma (PG Dip.) Business of Motorsport by studying the PG Dip. Top-Up, a further three modules from the MA.

This course aims to equip you with the skills to create an operational mobile Instagram app feed using React Native and ChatGPT. Additionally, it offers comprehensive resources to develop a well-rounded project that you can showcase as a prototype upon completion. You will use all the latest and trending tools for application development from scratch.

Recognizing the brilliance of someone psychological disturbance normalizes their experience and opens the door to transformative change. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Invention- between Prof. Ernesto Spinelli and Dr. Betty Cannon “When I first saw the topic of this year’s dialogues, I asked myself whether I had anything to contribute. After all, I told myself, I do not usually work with psychoses or other so-called ‘extreme’ or’ irregular’ states of consciousness. This started me thinking about a series of demonstration videos that I have been making with students and supervisees over the last couple of years as part of a book project. Do those videos display ‘extreme states’? To my surprise, the answer is yes. They are filled with experiences that might be described as hallucinations (positive and negative), dissociative states, paranoia, delusions, manic and depressive states, crippling anxiety, schizoid withdrawal, depersonalization and derealization, and body dysmorphic phenomena. Not to mention the so-called normal neurotic trances that Freud called transference, countertransference and defenses, psychedelically induced extreme states, and those nightly hallucinations, our dreams. So why did I not remember at least some of these states as being ‘extreme’? Perhaps the answer lies in my perspective on therapy, which is largely existential-phenomenological. I think that the following quote, from a letter that Sartre wrote to R.D. Laing, captures the essence of this perspective: “Like you, I believe that one cannot understand psychological disturbances from the outside, on the basis of a positivistic determinism or reconstruct them with a combination of concepts that remain outside the experience as lived and experienced. I also believe that one cannot study, let alone cure, a neurosis without a fundamental respect for the person of the patient, without a constant effort to grasp the basic situation and relive it, without an attempt to rediscover the response of the person to that situation and––like you, I think––I regard mental illness as the ‘way out’ that the free organism, in its total unity, invents in order to be able to live through an intolerable situation.”* When a client and I together are able to appreciate the true brilliance of this invention, my experience is that it not only normalizes the client’s experience, it also opens the doorway to change. It allows us to invent something new.” Dr. Betty Cannon. Betty Cannon, PhD, is a licensed psychologist who has taught and practiced in Boulder, Colorado, for over 40 years. She is Professor Emerita of the Colorado School of Mines and president and founder of the Boulder Psychotherapy Institute, which has trained mental health professionals in Applied Existential Psychotherapy since 1989. In addition to existential philosophy, especially the philosophy of Sartre, AEP has roots in Gestalt therapy, classical and contemporary psychoanalysis, humanistic psychology (especially the person-centered therapy of Carl Rogers), and body-oriented psychotherapy. Betty is a member of the editorial boards of the Journal for the Society of Existential Analysis and Sartre Studies International. She is the author of Sartre and Psychoanalysis and numerous articles and chapters on existential therapy. Her mentor was Hazel E. Barnes, who translated Sartre into English and who was the world’s foremost Sartre scholar until her death in 2008. Betty is her literary executor, and her book on Sartre is dedicated to Hazel. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 25 October from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

The Recreational Mini Bundle offers a rare blend of practical creativity and wellbeing-focused skills that align with job roles across community services, media, wellness, and nature-focused careers. With gardening, horticulture, photography, nutrition, and Adobe Premier Pro forming the foundation, this bundle proves you’re not just creative—you’re employable. Description There’s a rising demand for recreational professionals who combine hands-on skills with digital competence. From photography studios and nutrition consultancies to landscaping businesses and wellness brands, employers want staff with a mix of gardening and horticulture understanding, digital fluency in Adobe Premier Pro, and lifestyle awareness through nutrition. Whether you're aiming to enter media, community wellness, or creative industries, this bundle makes you a versatile candidate. You’ll bring more than one tool to the job—you're prepared for hands-in-soil gardening and screen-based Adobe Premier Pro editing alike. This kind of flexibility gives employers fewer reasons to say “no.” Hiring managers are now looking beyond CVs—they want skill variety. Gardening, horticulture, photography, nutrition, and Adobe Premier Pro make up a compelling case to say yes—to you. FAQ Is this just for hobbyists? No—this is designed to make you employable across gardening, photography, nutrition, and creative production roles. What careers does this support? Wellness assistant, garden designer, media editor, nutrition adviser, Adobe Premier Pro assistant, and photography support roles. Can I apply to community centres or councils? Absolutely—gardening, horticulture, and nutrition are often key in local services and wellbeing projects. How does photography tie in? Photography complements creative portfolios, social media, and documentation roles in recreational industries. Why is Adobe Premier Pro included? Because creativity is now digital—having Adobe Premier Pro skills gets you noticed by media and lifestyle employers. Why should I enrol now? Versatility is in demand. Be the applicant who offers gardening, horticulture, photography, nutrition, and Adobe Premier Pro—before that role is gone.

🚀 Unlock the Power of Facebook Ads for Unstoppable Marketing Success! 🎯 Are you ready to take your marketing strategies to the next level and harness the immense potential of Facebook Ads? Look no further! Introducing our comprehensive online course: 'Utilize Facebook Ads for Marketing Mastery.'   🔥 Why Choose This Course? With over 2.8 billion active users, Facebook offers an unparalleled platform for reaching your target audience. This course is your definitive guide to leveraging Facebook Ads effectively, whether you're a novice or an experienced marketer looking to refine your skills.   💡 What You'll Learn: ✅ Step-by-step guidance on setting up and optimizing Facebook Ad campaigns. ✅ Strategies to identify and target your ideal audience for maximum engagement and conversions. ✅ Advanced tactics to create compelling ad creatives that captivate and convert. ✅ Techniques to analyze metrics and fine-tune your ads for exceptional ROI. ✅ Proven methods to scale your campaigns and skyrocket your business growth.   🎓 Course Highlights: 🚀 Expert-led modules designed for all levels of expertise. 📈 Real-world case studies and practical examples for hands-on learning. 💬 Interactive Q&A sessions to address your specific queries. 🔑 Insider tips and industry secrets shared by seasoned marketing professionals. 🏆 Certification upon completion to showcase your expertise.   🌟 Join thousands of successful marketers who have transformed their businesses using our actionable strategies and unparalleled insights. 📢 Limited Time Offer: Enroll now to secure your spot and embark on your journey toward mastering Facebook Ads for unparalleled marketing success! 👉 Don't miss out! Seize this opportunity to dominate the digital landscape with targeted, high-converting Facebook Ads. Enroll today and watch your business soar to new heights! [Enroll Now Button] 🌐 Visit our website for more information and testimonials from our thriving community of successful marketers. Let's elevate your marketing game together!   Course Curriculum Module 1-Thank You For Enrolling! How Is The Class Setup For Your Maximum Return Thank You For Enrolling! How Is The Class Setup For Your Maximum Return 00:00 Module 2-Best Facebook Marketing Strategy For 2017 Best Facebook Marketing Strategy For 2017 00:00 Module 3-Best Easy Facebook Marketing Strategy For 2017 Best Easy Facebook Marketing Strategy For 2017 00:00 Module 4-Best Facebook Messaging Strategy For 2017 Best Facebook Messaging Strategy For 2017 00:00 module 5-Within 5 Minutes, Positive Replies Come Back Within 5 Minutes, Positive Replies Come Back 00:00 Module 6-The Best Facebook Marketing Happens With My Profile The Best Facebook Marketing Happens With My Profile 00:00 Module 7-Facebook Groups Are Powerful For Networking And Learning Facebook Groups Are Powerful For Networking And Learning 00:00 Module 8-What Works Best For Marketing With Facebook Pages What Works Best For Marketing With Facebook Pages 00:00 Module 9-Facebook Page Insights Tutorial Facebook Page Insights Tutorial 00:00 Module 10-Facebook Page Post Creation Tutorial Facebook Page Post Creation Tutorial 00:00 Module 11-Facebook Page Profile Picture And Cover Photo Creation Facebook Page Profile Picture And Cover Photo Creation 00:00 Module 12-Facebook Page Profile Picture And Cover Photo Creation Facebook Page Profile Picture And Cover Photo Creation 00:00 Module 13-Start Learning About Facebook Ads Here Start Learning About Facebook Ads Here 00:00 Module 14-The Best Facebook Ad I Ever Created On 10,000 Tested The Best Facebook Ad I Ever Created On 10,000 Tested 00:00 Module 15-Scaling Up The Best Facebook Ad I Ever Created Scaling Up The Best Facebook Ad I Ever Created 00:00 Module 16-How I Analyze And Improve My Ads Over Time How I Analyze And Improve My Ads Over Time 00:00 Module 17-Getting A Facebook Ad Mainstream And Expanding Targeting Getting A Facebook Ad Mainstream And Expanding Targeting 00:00 Module 18-Making An Ideal Offer For Facebook Ads Making An Ideal Offer For Facebook Ads 00:00 Module 19-Facebook Ads Tutorial From August 2016 Facebook Ads Tutorial From August 2016 00:00 Module 20-Facebook Ads Power Editor Tutorial Draft Lesson 00:00 Module-21 Boosting A Post With A Page Post Engagement Ad Boosting A Post With A Page Post Engagement Ad 00:00 Module 22-Why I Took A Month Off Of Advertising On Facebook Why I Took A Month Off Of Advertising On Facebook 00:00 Module 23-The Benefits Of Taking A Break From Facebook Ads The Benefits Of Taking A Break From Facebook Ads 00:00 Module 24-The Best I Can Do Is Make A Business I Would Enjoy Working With As A Customer The Best I Can Do Is Make A Business I Would Enjoy Working With As A Customer 00:00 Module 25-7.2 Million Views On My Most Viral Video On Facebook 7.2 Million Views On My Most Viral Video On Facebook 00:00 Module 26-Give And Take On Facebook Give And Take On Facebook 00:00 Module 27-Live Questions And Answers About Facebook, Youtube, And Working Online Live Questions And Answers About Facebook, Youtube, And Working Online 00:00 Module 28-Start Listening To My Facebook Marketing And Advertising Audio Lectures Here Start Listening To My Facebook Marketing And Advertising Audio Lectures Here 00:00 Module 29-Starting With Why! Starting With Why! 00:00 Module 30-Understand How You Act As A User And You Will See What You Can Do As A Giver! Understand How You Act As A User And You Will See What You Can Do As A Giver! 00:00 Module-31 All Feedback Received Is Helpful! All Feedback Received Is Helpful! 00:00 Module 32-What Works On You Might Work On Others! What Works On You Might Work On Others! 00:00 Module 33-What Is Working The Very Best Today For Me On Facebook What Is Working The Very Best Today For Me On Facebook 00:00 Module 34-Lipstick On A Pig! Lipstick On A Pig! 00:00 Module 35-Case Study With A Shop Owner Case Study With A Shop Owner 00:00 Module 36-What Is The Most Powerful Way To Use Facebook For Getting Organic Reach What Is The Most Powerful Way To Use Facebook For Getting Organic Reach 00:00 Module 37-Video Is The Most Powerful Form Of Communication Online Today Video Is The Most Powerful Form Of Communication Online Today 00:00 Module 38-How To Make Magnificent Videos On Facebook! How To Make Magnificent Videos On Facebook! 00:00 Module 39-The Power Of Producing Videos Daily! The Power Of Producing Videos Daily! 00:00 Module 40-How Easy Is It To Start Making Videos On Facebook How Easy Is It To Start Making Videos On Facebook 00:00 Module 41-Branding On Facebook Branding On Facebook 00:00 Home 42-The Importance Of Knowing Exactly Who The Potential Client Is The Importance Of Knowing Exactly Who The Potential Client Is 00:00 Module 43-Personal Facebook Profiles Have Amazing Power! Personal Facebook Profiles Have Amazing Power! 00:00 Module 44-My Personal Profile Helped Me Start And Grow My Business First My Personal Profile Helped Me Start And Grow My Business First 00:00 Module 45-Working At The Right Pace Working At The Right Pace 00:00 M0dule 46-How To Know If I Am Working On The Right Pace! How To Know If I Am Working On The Right Pace! 00:00 Module 47-Facebook Groups Are The Easiest Way To Reach The Newsfeed Facebook Groups Are The Easiest Way To Reach The Newsfeed 00:00 Module 48-Facebook Groups Help Make Personal Connections And Are Great For Learning! Facebook Groups Help Make Personal Connections And Are Great For Learning! 00:00 Module 49-Facebook Pages And Advertising Explained Facebook Pages And Advertising Explained 00:00 Module 50-Your First Facebook Page Likes Should Be Friends And Family Your First Facebook Page Likes Should Be Friends And Family 00:00 Module 51-My Ideal Facebook Marketing And Advertising Strategy My Ideal Facebook Marketing And Advertising Strategy 00:00 Module 52-Daily Progress Rather Than Perfection! Daily Progress Rather Than Perfection! 00:00 Module 53-Alternatives To Making Videos Alternatives To Making Videos 00:00 Module 54-The Best Tips And Tricks I Know For Facebook The Best Tips And Tricks I Know For Facebook 00:00

Want to work in transcription, virtual assistance, or admin support? The Transcription: Audio Typing: 8-in-1 Premium Online Courses Bundle gives you all the skills employers are looking for — especially in remote work, legal, medical, and publishing sectors. Courses included: Audio Typing ESOL Creative Writing Documents Control Touch Typing Communication Skills Problem Solving Public Speaking 🚨 FOMO alert: Transcription roles are competitive — applicants with audio typing and touch typing credentials rise to the top. 💰 Big value alert: 8 powerhouse skills, 1 affordable bundle. ⭐ Learner-loved — Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot. 📝 Description Start with the essential: audio typing. Whether for medical dictations, legal notes, or content creation, audio typing is the #1 skill transcription employers look for. Trained audio typing professionals have a huge hiring edge. Next, ESOL. Transcription and communication roles often support diverse clients, so having ESOL knowledge makes you flexible, clear, and globally employable. For content-focused roles, creative writing is your secret weapon. Whether you’re working in publishing, transcription, or copy editing, having creative writing skills makes your output compelling and polished. Administrative precision is a must, and that’s where documents control comes in. Employers want people who can handle documents control in healthcare, law, and government settings. It’s a high-trust skill. Speed matters. That’s why touch typing remains an in-demand standard. Efficient touch typing allows you to meet deadlines, take dictations, and manage large volumes of data — and hiring managers know it. Good communication isn’t optional — it’s expected. Whether verbal or written, communication skills help you transcribe accurately, collaborate with clients, and resolve issues fast. You’ll also face challenges. That’s why problem solving is vital. People who can approach complex audio files, tight deadlines, or client issues with strong problem solving are more likely to get — and keep — the job. Finally, public speaking might not sound transcription-related, but it shows confidence, clarity, and verbal precision — which all translate to better writing and communication skills. With this powerful stack — audio typing, ESOL, creative writing, documents control, touch typing, communication skills, problem solving, and public speaking — you’re ready for hire. ❓FAQ Q: What jobs can this help with? A: Transcriptionist, virtual assistant, editor, content creator, admin, and more. Q: Do I need a degree? A: Not at all. Employers want skills — and this bundle delivers. Q: Will I receive certificates? A: Yes, one for each of the 8 courses. And you're backed by Compete High's 4.8 on 'Reviews.io' and 4.3 on Trustpilot.

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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 Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00