6272 Courses delivered Online

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course. Module 1: Getting Started with Access What is a Database 00:03:00 Database Terminology 00:05:00 The Access Interface 00:08:00 What is a Flat File Database 00:03:00 What is a Relational Database 00:10:00 Relating Tables 00:10:00 Reviewing The Access Ribbon 00:02:00 Module 2: Working with Data Working with Tables 00:07:00 Navigating Tables 00:04:00 Editing Data 00:03:00 Adding New Records 00:05:00 Using Subdatasheets 00:04:00 Module 3: Creating Databases and Objects Understanding Database and Table Design Principles 00:08:00 Using Table Data Sheet View 00:03:00 Working with Field Data Types 00:07:00 Using Table Design View 00:04:00 Calculating Numbers 00:05:00 Calculating Dates 00:02:00 Calculating Strings 00:03:00 Using The Lookup Wizard 00:12:00 Lookup Wizard Linking Tables 00:09:00 Using Indexes 00:04:00 Module 4: Working with Queries What are Queries? 00:08:00 Creating Simple Queries 00:05:00 Entering Criteria-Exact Match and Range Operators 00:05:00 Understanding And Versus Or 00:06:00 Using Wildcards 00:05:00 Using Key Words 00:04:00 Sorting and Hiding Fields 00:03:00 Creating Multi-Table Queries 00:03:00 Additional Tips C4 00:06:00 Module 5: Working with Reports What are Reports 00:05:00 Understanding Report Types 00:03:00 Building Good Reports 00:02:00 Using AutoReport 00:08:00 Understanding The Report Wizard 00:11:00 Using the Report Design View 00:08:00 Printing Reports 00:04:00 Creating labels 00:08:00 Additional Tips C5 00:10:00 Module 6: Working with Forms What are Forms 00:04:00 Understanding Form Types 00:03:00 Creating Forms 00:03:00 Navigating Forms 00:03:00 Editing Data in Forms 00:05:00 Understanding the Form Wizard 00:05:00 Using Form Design View 00:04:00 Working with Controls 00:10:00 Using Form Layout View 00:04:00 Additional Tips C6 00:07:00 Resource Resource - Access 365 Beginner 00:00:00 Final Exam Final Exam - Access 365 Beginner 00:20:00

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

Craft beautiful creations with the course "Discovering Crochet: From Beginner to Skilled Artisan." Unveil the secrets of this timeless art as you journey through modules covering equipment, yarn selection, basic and advanced stitches, beginner patterns, crochet techniques, and project initiation. With our course, you'll unlock the mastery of crochet and unleash your artistic potential. Join us and let the threads of your imagination weave wonders! Learning outcomes: Gain a comprehensive introduction to the art of crochet. Familiarise yourself with the essential equipment required for crochet. Understand the characteristics and types of yarn for optimal project selection. Master a variety of basic and advanced crochet stitches. Create beautiful crochet patterns suitable for beginners. Explore various techniques and apply them to your crochet projects. Discovering Crochet: From Beginner to Skilled Artisan is an enchanting journey into the crochet world. Immerse yourself in the fundamentals of this craft as you progress through modules designed to expand your skills and ignite your creativity. Learn about the equipment needed to embark on your crochet adventures and explore the vast realm of yarn, understanding its unique properties and suitability for different projects. Dive into the art of creating basic and advanced stitches, discovering how they intertwine to form intricate patterns. As you grow in confidence, embrace the world of crochet projects, from the simplicity of beginner patterns to the complexity of advanced techniques. Unleash your imagination and breathe life into your creations. Our course provides a solid foundation for aspiring artisans, allowing you to unlock the potential of this craft and develop your unique style. Join us on this transformative journey, where every stitch becomes a stroke of artistry. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for the following: Beginners eager to learn the art of crochet. Craft enthusiasts seeking to expand their creative repertoire. Individuals looking for a meditative and fulfilling hobby. Those who wish to create beautiful, handmade gifts for loved ones. Career path Some of the career paths related to this field are: Freelance crochet artist: £18,000 - £30,000 per year. Crochet pattern designer: £20,000 - £35,000 per year. Craft store owner/manager: £22,000 - £40,000 per year. Crochet instructor/tutor: £15 - £30 per hour. Handmade crochet product seller: £10,000 - £30,000 per year.

Overview This comprehensive course on Python Programming: Beginner To Expert will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Python Programming: Beginner To Expert 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 Python Programming: Beginner To Expert. It is available to all students, of all academic backgrounds. Requirements Our Python Programming: Beginner To Expert 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 18 sections • 121 lectures • 15:27:00 total length •Intro 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 •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 •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 •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 •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 •When to use each one?: 00:05:00 •Compound Data Types: 00:03:00 •Dictionaries: 00:11:00 •Control Flow Part 1 Section Overview: 00:15:00 •Intro 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 •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 •Python Functions Section Overview: 00:03:00 •Intro to Functions: 00:02:00 •Python help Function: 00:03:00 •Defining Functions: 00:09:00 •Variable Scope: 00:08:00 •Doc Strings: 00:04:00 •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 •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 •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 •NumPy Section Overview: 00:04:00 •Intro 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 •Intro 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 •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 •Python Decorators: 00:27:00 •Property Decorator: 00:09:00 •Class Method Decorator: 00:07:00 •Static Methods: 00:10:00 •Inheritance from A to Z: 00:21:00 •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 •Do's And Don'ts Of Networking: 00:06:00 •Top Freelance Websites: 00:08:00 •Creating A Python Developer Resume: 00:06:00 •Resources - Python Programming: Beginner To Expert: 00:00:00 •Assignment - Python Programming: Beginner To Expert: 00:00:00

This video course teaches you how to secure Java framework applications with Spring Security. With the help of interesting activities and examples, you'll learn about using the capabilities of Spring Boot for securing web applications and you'll also delve into the Test-Driven Development approach to understand the features of Spring Security.

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

Learn how to code in HTML from scratch. Perfect for beginners and anyone who wants to learn HTML

Description Learn the fundamental features of Adobe Illustrator and start your journey to create wonderful vector images with the Adobe Illustrator CC Beginner course. At first, you will learn the things you can do with Illustrator and the importance of using Illustrator. The course familiarizes you with the Illustrator interface and shows you some of the basic features of Illustrator. The techniques of measuring and transforming objects, the use of shape tools, and the procedures of using the keyboards to control the tools fast will be discussed in the course. After that, the course shows you the techniques of applying fills and strokes so that you can fill your objects with colors, and able to put a stroke outside. Then the course explains the setting type and shows you some of the text tools. Next, the course discusses the various types of brushes and how to paint with the brushes. A detailed discussion will be presented on the strategies of applying effects such as shadow, transparency, etc. Finally, you will learn how to export your files from Illustrator so that you can share your works with others. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adobe Illustrator CC Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adobe Illustrator CC Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Introduction to Illustrator Why Adobe Illustrator? 00:03:00 Using Selection Tools 00:02:00 Creating New Documents 00:08:00 Saving Adobe Illustrator Files 00:06:00 Navigating the Interface 00:08:00 Managing Workspaces 00:05:00 Drawing Basics Creating Shapes 00:13:00 Using the Drawing Tools 00:10:00 Mastering the Pen Tool 00:09:00 Editing Shapes 00:08:00 Grouping and Aligning Shapes 00:06:00 Understanding Layers 00:06:00 Putting it all Together 00:07:00 Measuring and Transforming Objects Working with Rules and Guides 00:05:00 Discovering the Transform Panel 00:08:00 Using Transform and Distort 00:04:00 Applying Fills and Strokes Editing Fills with the Color Panel 00:08:00 Editing Fills with the Swatches Panel 00:09:00 Modifying Strokes 00:09:00 Creating Gradients 00:09:00 Using the Freeform Gradient 00:06:00 Setting Type Using Type Tools 00:10:00 Discovering Type Panels 00:08:00 Working with Adobe Fonts 00:04:00 Painting with Brushes Discovering the Brush Panel 00:06:00 Creating Custom Brushes 00:06:00 Using the Blob Brush 00:08:00 Applying Effects Using the Appearance Panel 00:04:00 Understanding the Effects Menu 00:07:00 Exporting from Illustrator Creating PDF's 00:07:00 Exporting to Other Formats 00:08:00 Importing Adobe PDF´s 00:03:00 Understanding Metadata 00:04:00 Printing your Document 00:07:00 Conclusion Course recap 00:01:00 Resources Resources - Adobe Illustrator CC Beginner 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

[vc_row][vc_column][vc_column_text]Spanish is one of the most widely spoken languages in the world. Moreover, it's one of the best languages to learn for travel and employment opportunities. Master Spanish by taking this course. This Complete Spanish Course - Beginner course will provide you with a comprehensive introduction to the Spanish language. It has different chapters, and each chapter will give you a new level of understanding of the language. You'll learn about Spanish alphabets, numbers, and tenses. You'll learn how to improve your pronunciation of words. We will also guide you through everyday topics and basic sentence structures. As a result, you can engage in basic conversations with native speakers.  Learning outcomes Improve your Spanish vocabulary Familiarise yourself with the Spanish alphabets and numbers Enhance your pronunciation of words Improve your Spanish grammar skills Learn about the gender rules in Spanish Enrich your knowledge of Spanish tenses Know the common conversational topics to speak with native speakers Who is this course for Anyone interested in learning Spanish can take this Complete Spanish Course - Beginner Course.  The knowledge you gain from the course will make you more employable.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of the English language, numeracy, and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. The 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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognised accredited qualification; Access to course content on mobile, tablet, and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Complete Spanish Course - Beginner Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Spanish Teacher Spanish Tutor Spanish Teaching Assistant Spanish Translator [/vc_column_text][/vc_column][/vc_row] Module 1 Spanish Course: Find out all about this course in less than two minutes 00:02:00 Spanish Course: The Alphabet. Pronunciation. Part 1 00:18:00 Spanish Course: The Alphabet. Pronunciation. Part 2 00:17:00 Spanish Course: Personal pronouns. Gender and number. Ser. Part 1 00:10:00 Spanish Course: Personal pronouns. Gender and number. Ser. Part 2. 00:14:00 Learn Spanish- Present tense. The articles. Use of the verb Tener 1 00:21:00 Use of the verb Tener 2. More numbers. Age. Vocabulary about clas 00:14:00 Learn Spanish- The hour. The times of day. Calendar. Frequency. P 00:11:00 Learn Spanish- The question and exclamation. Recap. Part 1 00:19:00 Learn Spanish- The question and exclamation. Recap. Part 2. 00:15:00 Module 2 Learn Spanish- The weather. Months and seasons. Hace and dentr 00:11:00 Learn Spanish- Present tense irregular. Vowel exchange. Part 1. 00:13:00 Learn Spanish- Present tense irregular. Vowel exchange. Part 2. 00:14:00 Learn Spanish- Present tense irregular. Irregular first person. Part 1. 00:11:00 Learn Spanish- Present tense irregular. Irregular first person. Part 2. 00:12:00 Learn Spanish- The verb Haber and the past perfect. Part 1. 00:15:00 Learn Spanish- The verb Haber and the past perfect. Part 2. 00:16:00 Learn Spanish- The verb Haber and the past perfect. Part 3. 00:09:00 Learn Spanish- Prepositions. Part 1. 00:14:00 Learn Spanish- Prepositions. Part 2. 00:17:00 Module 3 Learn Spanish- Numbers. Recap. Part 1. 00:12:00 Learn Spanish- Numbers. Recap. Part 2. 00:13:00 Learn Spanish- Reflexive verbs. Reciprocal verbs. Part 1. 00:11:00 Learn Spanish- Reflexive verbs. Reciprocal verbs. Part 2. 00:11:00 Learn Spanish- Personal hygiene and clothing. Part 1. 00:09:00 Learn Spanish- Personal hygiene and clothing. Part 2 00:12:00 Learn Spanish- Direct and Indirect Object Pronouns. 00:20:00 Learn Spanish- 'To like' and similar verbs. Indirect Object Verbs 00:27:00 Learn Spanish- 'To like' and similar verbs. Vocabulary 00:16:00 Learn Spanish- Present perfect tense 00:23:00 Module 4 Learn Spanish- Present continuous 00:22:00 Learn Spanish- The near or immediate future 00:14:00 Learn Spanish- Shopping 00:26:00 Learn Spanish- Present, Past, Future 00:20:00 Learn Spanish- Your house 00:31:00 Learn Spanish- Comparative 00:17:00 Learn Spanish- Superlatives 00:19:00 Learn Spanish- Demonstrative 00:24:00 Learn Spanish- Possesive 00:23:00 Learn Spanish- Basic conjunctions 00:22:00 Learn Spanish- Past Simple or Indefinite 00:33:00 Learn Spanish- The accent 00:43:00 Learn Spanish- The imperfect tense and the description 00:22:00 Learn Spanish- Of the future 00:19:00 Resources Resources - Complete Spanish Course - Beginner 00:00:00 Course Certification Order your Certificate 00:00:00

Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel Complete Course - Beginner Intermediate & Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel Complete Course - Beginner Intermediate & Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel Complete Course - Beginner Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting A Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working With Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working With Multiple Worksheets And Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines And Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00