683 Microsoft Certification courses in Cardiff delivered On Demand

Overview This comprehensive course on New Functions in Microsoft Excel 2021 will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This New Functions in Microsoft Excel 2021 comes with accredited certification 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 New Functions in Microsoft Excel 2021. It is available to all students, of all academic backgrounds. Requirements Our New Functions in Microsoft Excel 2021 is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 10 lectures • 01:11:00 total length •Introduction and Agenda: 00:07:00 •RANDARRAY: 00:04:00 •UNIQUE: 00:05:00 •SEQUENCE: 00:04:00 •SORT and SORTBY: 00:09:00 •SORT A Practical Example: 00:04:00 •FILTER: 00:07:00 •FILTER A Practical Example: 00:08:00 •Other Useful New Functions: 00:15:00 •Using the New Functions in Reports: 00:08:00

Overview This comprehensive course on AutoCAD Programming Using C#.NET Level 7 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming Using C#.NET Level 7 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 AutoCAD Programming Using C#.NET Level 7. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming Using C#.NET Level 7 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 193 lectures • 16:44:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Who is this course for?: 00:01:00 •Module 03: What Will I Learn from this Course?: 00:01:00 •Module 04: What is CSharp (C#)?: 00:01:00 •Module 05: What is AutoCAD .NET API?: 00:01:00 •Module 06: What are the advantages of programming in AutoCAD .NET API?: 00:02:00 •Module 01: Section Overview: 00:01:00 •Module 02:.NET Framework Architecture Overview: 00:03:00 •Module 03: .NET Framework Class Library, Common Type System, Common Language Runtime: 00:03:00 •Module 04: More about.NET Framework Common Language Runtime (CLR): 00:02:00 •Module 05: Visual Studio 2017 Integrated Development Environment (IDE): 00:03:00 •Module 06: Visual Studio 2017 IDE Demo: 00:07:00 •Module 01: Section Overview: 00:03:00 •Module 02: DataTypes and Variables - Value Types (signed/unsigned integers): 00:04:00 •Module 03: DataTypes and Variables - Signed and Unsigned Integer Demo: 00:06:00 •Module 04: DataTypes and Variables - Floating Point and Decimal: 00:02:00 •Module 05: DataTypes and Variables - Floating Point and Decimal Demo: 00:04:00 •Module 06: DataTypes and Variables - Boolean: 00:03:00 •Module 07: DataTypes and Variables - Reference Types: 00:03:00 •Module 08: DataTypes and Variables - Class Type: 00:03:00 •Module 09: DataTypes and Variables - Class Type - Demo: 00:11:00 •Module 10: DataTypes and Variables - Interface Type: 00:01:00 •Module 11: DataTypes and Variables - Array Type: 00:02:00 •Module 12: DataTypes and Variables - Array Type - Demo (Single Dimension): 00:08:00 •Module 13: DataTypes and Variables - Array Type - Demo (Multi Dimension): 00:10:00 •Module 14: C# Operators Overview: 00:02:00 •Module 15: C# Assignment Operators: 00:03:00 •Module 16: C# Assignment Operators - Demo: 00:06:00 •Module 17: C# Unary Operators: 00:02:00 •Module 18: C# Unary Operators - Demo: 00:02:00 •Module 19: C# Primary Operators: 00:03:00 •Module 20: C# Primary Operators - Demo: 00:07:00 •Module 21: C# Equality Operators: 00:01:00 •Module 22: C# Equality Operators - Demo: 00:02:00 •Module 23: C# Additive Operators: 00:02:00 •Module 24: C# Additive Operators - Demo: 00:01:00 •Module 25: C# Multiplicative Operators: 00:01:00 •Module 26: C# Multiplicative Operators - Demo: 00:01:00 •Module 27: C# - Relational and Type Operators: 00:04:00 •Module 28: C# - Logical, Conditional and Null Operators: 00:04:00 •Module 29: C# - Logical, Conditional and Null Operators - Demo: 00:07:00 •Module 30: C# Keywords (Reserved Words): 00:04:00 •Module 31: C# - Conditionals Overview: 00:01:00 •Module 32: C# Conditionals - If-Then-Else Statement: 00:03:00 •Module 33: C# Conditionals - If-Then-Else Statement - Demo: 00:07:00 •Module 34: C# Conditionals - Switch Statement: 00:03:00 •Module 35: C# Conditionals - Switch Statement - Demo: 00:00:00 •Module 36: C# - Loops Overview: 00:04:00 •Module 37: C# Loops - For Loop: 00:02:00 •Module 38: C# Loops - For Loop - Demo: 00:02:00 •Module 39: C# Loops - Foreach Loop: 00:02:00 •Module 40: C# Loops - Foreach Loop - Demo: 00:05:00 •Module 41: C# Loops - While Loop: 00:02:00 •Module 42: C# Loops - While Loop - Demo: 00:02:00 •Module 43: C# Loops - Do While Loop: 00:02:00 •Module 44: C# Loops - Do While Loop - Demo: 00:03:00 •Module 45: Modifiers Overview: 00:04:00 •Module 46: Debugging Overview: 00:03:00 •Module 47: Debugging - Demo 1: 00:05:00 •Module 48: Debugging - Demo 2: 00:12:00 •Module 49: Debugging - Demo 3: 00:06:00 •Module 50: Error and Exception Handling - Overview: 00:02:00 •Module 51: ExceptionHandling - Demo 1: 00:07:00 •Module 52: ExceptionHandling - Demo 2: 00:07:00 •Module 53: ExceptionHandling - Demo 3: 00:13:00 •Module 54: Introduction to Object Oriented Programming (OOP): 00:04:00 •Module 55: OOP - Encapsulation - Demo (Part 1): 00:11:00 •Module 56: OOP - Encapsulation - Demo (Part 2): 00:12:00 •Module 57: OOP - Inheritance - Demo (Part 1): 00:07:00 •Module 58: OOP - Inheritance - Demo (Part 2): 00:05:00 •Module 59: OOP - Polymorphism - Demo (Part 1): 00:10:00 •Module 60: OOP - Polymorphism - Demo (Part 2): 00:03:00 •Module 01: AutoCAD .NET API - Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Using AutoCAD .NET API in C# - Hello AutoCAD Demo Part 1: 00:12:00 •Module 04: Using AutoCAD .NET API in C# - Hello AutoCAD Demo - Part 2: 00:04:00 •Module 05: AutoCAD .NET API Object Hierarchy: 00:03:00 •Module 06: AutoCAD .NET API - Application Object Overview: 00:03:00 •Module 07: AutoCAD .NET API - Document Object Overview: 00:03:00 •Module 08: AutoCAD .NET API - Database Object Overview: 00:03:00 •Module 01: Creating AutoCAD Objects using AutoCAD .NET API - Overview: 00:01:00 •Module 02: Creating a Line Object - Lab (Part 1): 00:14:00 •Module 03: Creating a Line Object - Lab (Part 2): 00:03:00 •Module 04: Creating a MText Object - Lab: 00:10:00 •Module 05: Creating a Circle Object - Lab: 00:07:00 •Module 06: Creating an Arc Object - Lab: 00:05:00 •Module 07: Creating a LWPolyline Object - Lab: 00:05:00 •Module 01: Manipulate AutoCAD Objects - Overview: 00:01:00 •Module 02: Copy Object using C# - Theory: 00:01:00 •Module 03: Copy Object using C# - Lab (Part 1): 00:11:00 •Module 04: Copy Object using C# - Lab (Part 2): 00:02:00 •Module 05: Copy multiple objects using C# - Lab (Part 1): 00:09:00 •Module 06: Copy multiple objects using C# - Lab (Part 2): 00:01:00 •Module 07: Erase Object using C# - Lab (Part 1): 00:06:00 •Module 08: Erase Object using C# - Lab (Part 2): 00:05:00 •Module 09: Move Object using C# - Lab (Part 1): 00:06:00 •Module 10: Move Object using C# - Lab (Part 2): 00:02:00 •Module 11: Mirror Object using C# - Lab (Part 1): 00:10:00 •Module 12: Mirror Object using C# - Lab (Part 2): 00:02:00 •Module 13: Rotate Object using C# - Lab (Part 1): 00:07:00 •Module 14: Rotate Object using C# - Lab (Part 2): 00:03:00 •Module 15: Scale Object using C# - Lab: 00:05:00 •Module 16: Copy Object Exercise: 00:02:00 •Module 17: Copy Object Solution: 00:06:00 •Module 18: Erase Object Exercise: 00:02:00 •Module 19: Erase Object Solution: 00:07:00 •Module 20: Move Object Exercise: 00:02:00 •Module 21: Move Object Solution: 00:06:00 •Module 22: Mirror Object Exercise: 00:02:00 •Module 23: Mirror Object Solution: 00:06:00 •Module 24: Rotate Object Exercise: 00:02:00 •Module 25: Rotate Object Solution: 00:06:00 •Module 26: Scale Object Exercise: 00:01:00 •Module 27: Scale Object Solution: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Layers Overview: 00:03:00 •Module 02: Listing all the Layers in the drawing using C#: 00:11:00 •Module 03: Creating a Layer in AutoCAD using C#: 00:09:00 •Module 04: Updating a Layer in AutoCAD using C#: 00:09:00 •Module 05: Turning the Layer On/Off in AutoCAD using C#: 00:05:00 •Module 06: Thawing/Freezing Layer in AutoCAD using C#: 00:04:00 •Module 07: Deleting a Layer in AutoCAD using C#: 00:03:00 •Module 08: Locking/UnLocking a Layer in AutoCAD using C#: 00:05:00 •Module 09: Assigning a Layer to an AutoCAD object using C#: 00:03:00 •Module 10: Exploring AutoCAD Dictionaries - LineTypes Overview: 00:01:00 •Module 11: Listing all the LineTypes in the drawing using C#: 00:07:00 •Module 12: Loading a LineType in the drawing using C#: 00:07:00 •Module 13: Setting the Current LineType in AutoCAD using C#: 00:03:00 •Module 14: Deleting a LineType in AutoCAD using C#: 00:03:00 •Module 15: Setting a LineType to an object using C#: 00:04:00 •Module 16: Exploring AutoCAD Dictionaries - TextStyles Overview: 00:01:00 •Module 17: Listing all the TextStyles in the drawing using C#: 00:08:00 •Module 18: Updating current TextStyle Font in AutoCAD using C#: 00:10:00 •Module 19: Setting the Current TextStyle in AutoCAD using C#: 00:08:00 •Module 20: Setting a TextStyle to an object using C#: 00:04:00 •Module 01: User Input Functions Overview: 00:01:00 •Module 02: Using GetString Method - Lab (Part 1): 00:13:00 •Module 03: Using GetString Method - Lab (Part 2): 00:10:00 •Module 04: Using GetPoint Method - Lab: 00:12:00 •Module 05: Using GetDistance Method - Lab: 00:04:00 •Module 06: Using GetKeyWords Method - Lab (Part 1): 00:12:00 •Module 07: Using GetKeyWords Method - Lab (Part 2): 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 01: Selection Sets and Filters - Overview: 00:02:00 •Module 03: Using SelectAll Method - Lab (Part 2): 00:02:00 •Module 04: Using SelectOnScreen Method - Lab (Part 1): 00:06:00 •Module 05: Using SelectOnScreen Method - Lab (Part 2): 00:01:00 •Module 06: Using SelectWindow Method - Lab: 00:08:00 •Module 07: Using SelectCrossingWindow Method - Lab: 00:08:00 •Module 08: Using SelectFence Method - Lab: 00:08:00 •Module 09: Using PickFirstSelection Method - Lab: 00:11:00 •Module 10: Using SelectionSet Filters - Overview: 00:01:00 •Module 11: Using SelectionSet Filters - Selecting Lines: 00:09:00 •Module 12: Using SelectionSet Filters - Selecting MTexts Lab: 00:07:00 •Module 13: Using SelectionSet Filters - Selecting Polylines Lab: 00:03:00 •Module 14: Using SelectionSet Filters - Selecting Blocks (FrenchDoors) Lab: 00:07:00 •Module 15: Using SelectionSet Filters - Selecting Blocks (BiFoldDoors) Lab: 00:04:00 •Module 16: Using SelectionSet Filters - Selecting objects in a Layer (Walls) Lab: 00:07:00 •Module 17: Using SelectionSet Filters - Selecting all objects in a Layer (Stairs) Lab: 00:05:00 •Module 18: Using SelectionSets and Filters - Exercises: 00:02:00 •Module 01: TitleBlock Project - Overview: 00:05:00 •Module 02: Creating Project and TBlock Class - Lab: 00:14:00 •Module 03: Creating Classes for each Paper Sizes - Lab: 00:07:00 •Module 04: Creating TitleBlock Class - Lab: 00:14:00 •Module 05: Handling User Selected Paper Size - Lab: 00:05:00 •Module 06: Creating the TitleBlock Border Lines - Lab: 00:06:00 •Module 07: Creating the Horizontal Partition Lines - Lab (Part 1): 00:11:00 •Module 08: Creating the Horizontal Partition Lines - Lab (Part 2): 00:05:00 •Module 09: Creating Vertical Partition Lines - Lab: 00:11:00 •Module 10: Project Check on the Partition Lines - Lab: 00:07:00 •Module 11: Creating the TitleBlock Labels - Lab (Part 1): 00:10:00 •Module 12: Creating the TitleBlock Labels - Lab (Part 2): 00:09:00 •Module 13: Creating the TitleBlock Labels - Lab (Part 3): 00:11:00 •Module 14: Project Check on the Labels: 00:07:00 •Module 15: Creating Drawing Information Texts: 00:08:00 •Module 16: Debugging the TitleBlock Project - Lab: 00:10:00 •Module 17: Completing and Running the TitleBlock Plugin: 00:05:00 •Module 18: Audit Drawing Project - Overview: 00:02:00 •Module 19: Audit Drawing Project - Demo: 00:07:00 •Module 20: Creating the AuditDrawing Project: 00:11:00 •Module 21: Creating the AuditDrawing DisplayOnScreen Method: 00:14:00 •Module 22: Creating the AuditDrawing Write to TXT File Method: 00:08:00 •Module 23: Creating the AuditDrawing Write to CSV File Method: 00:06:00 •Module 24: Creating the AuditDrawing Write to HTML File Method: 00:14:00 •Module 25: AuditDrawing Plugin Demo: 00:04:00 •Module 26: Creating the AuditBlock Method: 00:05:00 •Module 27: Creating the AuditBlock GatherBlocksAndCount Method: 00:16:00 •Module 28: Creating the AuditBlock DisplayOnScreen Method: 00:06:00 •Module 29: Creating the AuditBlock WriteToTXTFile Method: 00:05:00 •Module 30: Creating the AuditBlock WriteToCSVFile Method: 00:05:00 •Module 31: Creating the AuditBlock WriteToHTMLFile Method: 00:07:00 •Module 32: AuditBlock Completed Component - Demo: 00:12:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming Using C#.NET Level 7: 00:00:00

Overview This comprehensive course on Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! comes with accredited certification 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 Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 23 lectures • 01:56:00 total length •Excel promo: 00:01:00 •Getting the most of the course: 00:01:00 •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 •Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!: 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Overview This comprehensive course on Microsoft Excel Training: Depreciation Accounting will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel Training: Depreciation Accounting comes with accredited certification, 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 Microsoft Excel Training: Depreciation Accounting. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel Training: Depreciation Accounting 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 7 sections • 16 lectures • 01:01:00 total length •Introduction: 00:03:00 •Minimum requirements before taking the course: 00:01:00 •Download master depreciation template: 00:00:00 •Definition of Depreciation: 00:02:00 •Amortization: Depreciation vs Amortization: 00:02:00 •Related Terms to Depreciation: 00:02:00 •Most Common Methods of Depreciation: 00:09:00 •Accounting for Depreciation: 00:05:00 •Depreciation Tax Shield: 00:04:00 •Depreciation Tax Shield Under Various Depreciation Methods: 00:03:00 •Introduction and basics of Depreciation Model in Excel: 00:01:00 •Deep Dive into Depreciation Model: 00:07:00 •How to use the model with Example: 00:10:00 •Advanced functionalities of the Model: 00:11:00 •Thank you for Enrolling: 00:01:00 •Resources - Microsoft Excel Training: Depriciation Accounting: 00:00:00

Overview This comprehensive course on Microsoft Access Databases Forms and Reports will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Access Databases Forms and Reports 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 Microsoft Access Databases Forms and Reports. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Access Databases Forms and Reports 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 2 sections • 16 lectures • 02:49:00 total length •Autoforms: 00:14:00 •Form Wizard: 00:09:00 •Changing a form with design view: 00:26:00 •Adding controls to your form: 00:21:00 •Subforms: 00:15:00 •Using Autoreport to create a report: 00:03:00 •Using the Report Wizard to create a report: 00:07:00 •Changing a report in design view: 00:11:00 •Adding Calculations to your report: 00:09:00 •Adding Groups, Sorts and Totals to reports: 00:16:00 •Making labels with the Label Wizard: 00:04:00 •Form and Report Properties: 00:06:00 •Exporting a report to Excel: 00:03:00 •Creating a menu with the Switchboard Manager: 00:17:00 •Finalizing the Application: 00:08:00 •Assignment - Microsoft Access Databases Forms and Reports: 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Overview This comprehensive course on Complete Microsoft Access Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Access Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Complete Microsoft Access Course. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Access Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 58 lectures • 08:04:00 total length •Orientation to Microsoft Access: 00:39:00 •Create a Simple Access Database: 00:10:00 •Get Help and Configure Options in Microsoft Access: 00:06:00 •Modify Table Data: 00:17:00 •Sort and Filter Records: 00:05:00 •Create Basic Queries: 00:15:00 •Sort and Filter Data in a Query: 00:14:00 •Perform Calculations in a Query: 00:08:00 •Create Basic Access Forms: 00:07:00 •Work with Data on Access Forms: 00:23:00 •Create a Report: 00:12:00 •Add Controls to a Report: 00:12:00 •Enhance the Appearance of a Report: 00:05:00 •Prepare a Report for Print: 00:03:00 •Organize Report Information: 00:15:00 •Format Reports: 00:12:00 •Relational Database Design: 00:16:00 •Create a Table: 00:09:00 •Create Table Relationships: 00:09:00 •Create Query Joins: 00:14:00 •Relate Data Within a Table.avi: 00:04:00 •Work with Subdatasheets from: 00:05:00 •Use Field Validation: 00:16:00 •Use Form and Record Validation: 00:14:00 •Create Parameter Queries: 00:12:00 •Summarize Data: 00:06:00 •Create Subqueries: 00:07:00 •Create Action Queries: 00:05:00 •Create Unmatched and Duplicate Queries: 00:06:00 •Data Normalization: 00:10:00 •Create a Junction Table: 00:04:00 •Improve Table Structure: 00:06:00 •Include Control Formatting in a Report: 00:04:00 •Add a Calculated Field to a Report: 00:05:00 •Add a Subreport to an Existing Report: 00:07:00 •Add Controls to Forms: 00:11:00 •Enhance Navigation and Organization of Forms: 00:14:00 •Apply Conditional Formatting: 00:04:00 •Import Data into Access: 00:08:00 •Export Access Data: 00:06:00 •Link Tables to External Data Sources: 00:05:00 •Create a Mail Merge: 00:02:00 •Create a Macro: 00:08:00 •Restrict Records by Using a Condition: 00:04:00 •Validate Data by Using a Macro: 00:05:00 •Automate Data Entry by Using a Macro: 00:04:00 •Manage a Database: 00:08:00 •Determine Object Dependency: 00:04:00 •Manage a Database: 00:07:00 •Determine Object Dependency: 00:04:00 •Document a Database: 00:04:00 •Splitting a Database for Multiple User Access: 00:05:00 •Implement Security: 00:03:00 •Convert an Access Database to an ACCDE File: 00:04:00 •Package a Database with a Digital Signature: 00:01:00 •Create a Database Switchboard: 00:05:00 •Modify a Database Switchboard: 00:02:00 •Set Start up Options: 00:04:00

Overview This comprehensive course on AutoCAD Programming using C# with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using C# with Windows Forms comes with accredited certification, 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 AutoCAD Programming using C# with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using C# with Windows Forms 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 63 lectures • 09:11:00 total length •Introduction: 00:03:00 •Who is this course for?: 00:02:00 •Tools needed in this course: 00:01:00 •What will you learn from this course?: 00:05:00 •Controls Project Demo - Overview: 00:03:00 •Controls Demo Project Requirement - Explained: 00:03:00 •Create the Controls Demo Project: 00:03:00 •Controls Demo Project - Creating the Form (User Interface): 00:15:00 •Develop the Controls Demo Utility Class: 00:10:00 •Using Combobox Control to select an option: 00:13:00 •Using Textbox Control to select an option: 00:09:00 •Using Radiobutton Control to select an option: 00:06:00 •Using Checkbox Control to select an option(s): 00:18:00 •Developing Projects - Overview: 00:03:00 •Project 1: Creating a Rectangle - Project Overview: 00:03:00 •Project 1: Creating the Rectangle Utility Class: 00:17:00 •Project 1: Creating the User Interface: 00:10:00 •Project 1: Coding the User Interface28:50: 00:29:00 •Project 1: Running and Testing the Draw Rectangle Plugin: 00:08:00 •Project 2: Update Objects Layer - Overview: 00:02:00 •Project 2: Create the User Interface of Update Objects Layer Plugin: 00:09:00 •Project 2: Coding the Form Load Event: 00:07:00 •Project 2: Coding the Browse drawing Button: 00:03:00 •Project 2: Coding the Update Button control: 00:07:00 •Project 2: Coding the Update Layer Utility Class: 00:12:00 •Project 2: Running and Testing the Plugin: 00:08:00 •Project 3: Extracting Block Attributes to Files - Overview: 00:03:00 •Project 3: Creating the AutomaticBlockExtractor Project: 00:02:00 •Project 3: Creating the User Interface for the BlockExtractor Project: 00:09:00 •Project 3: Completing User Interface code: 00:22:00 •Project 3: Coding the AutoBlockExtractor Utility Class: 00:24:00 •Project 3: Running and Testing the AutomaticBlockExtractor Plugin in AutoCAD: 00:15:00 •Project 4: Updating MText Textstyle Project - Overview and Walkthrough: 00:05:00 •Project 4: Creating the UpdateTextStyle Utility Class: 00:19:00 •Project 4: Designing the UpdateTextStyle Plugin User Interface: 00:06:00 •Project 4: User Interface Code: 00:16:00 •Project 4: Running and Testing the UpdateTextstyle Plugin: 00:05:00 •Project 5: Converting Drawing to PDF Plugin - Overview: 00:03:00 •Project 5: Creating the PlotDWGtoPDF Project in Visual Studio 2019: 00:04:00 •Project 5: Creating the User Interface for MultiplePlotDWGtoPDF Project: 00:09:00 •Project 5: Coding the User Interface: 00:16:00 •Project 5: Developing the GetPlotSizes Method: 00:10:00 •Project 5: Developing the PlotCurrentLayout Method: 00:27:00 •Project 5: Testing and Running the MultiplePlotDWGtoPDF Project: 00:10:00 •Project 6: Multiple Object Extractor Project - Overview: 00:03:00 •Project 6: Creating the MultiObjectExtractor Project: 00:02:00 •Project 6: Designing the MultiObjectExtractor User Interface: 00:14:00 •Project 6: Coding the FormLoad Event: 00:07:00 •Project 6: Coding the BrowseDwg Button: 00:12:00 •Project 6: Coding the BrowseFile Button: 00:03:00 •Project 6: Coding the ProcessExtract Button: 00:05:00 •Project 6: Creating the Code Validation Methods: 00:10:00 •Project 6: Coding the ProcessDrawing Method: 00:19:00 •Project 6: Coding the ProcessObjectExtraction Method: 00:11:00 •Project 6: Coding the ExtractLine Method: 00:11:00 •Project 6: Coding the ExtractCircle Method: 00:04:00 •Project 6: Coding the ExtractPolyline Method: 00:11:00 •Project 6: Coding the ExtractMText Method: 00:05:00 •Project 6: Coding the ExtractBlock Method: 00:03:00 •Project 6: Coding the ExtractObjects Method: 00:02:00 •Project 6: Running and Testing the MultiObjectExtractor Plugin: 00:14:00 •Conclusion and Thank you: 00:01:00 •Assignment - AutoCAD Programming using C# with Windows Forms: 00:00:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00