4501 Productivity courses delivered On Demand

Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and conflicts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant office applications in general. Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course. Apart from that,the Microsoft Office 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts. The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Level 3 Diploma in Microsoft Access 2010 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 Level 3 Diploma in Microsoft Access 2010 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. Module 01: Beginner Getting Started Database Concepts FREE 00:04:00 Exploring the Access Environment 00:11:00 Getting Help 00:02:00 Databases and Tables Planning and Designing Databases 00:12:00 Exploring Tables 00:11:00 Creating Tables 00:33:00 Fields and Records Changing the Design of a Table 00:15:00 Finding and Editing Records 00:06:00 Organizing Records 00:16:00 Data Entry Rules Setting Field Properties 00:14:00 Working with Input Masks 00:07:00 Setting Validation Rules 00:06:00 Basic Queries Creating and Using Queries 00:13:00 Modifying Query Results and Queries 00:05:00 Performing Operations in Queries 00:17:00 Using Forms Creating Forms 00:11:00 Using Design View 00:14:00 Sorting and Filtering Records 00:04:00 Working with Reports Creating Reports 00:10:00 Modifying and Printing Reports 00:16:00 Module 02: Intermediate Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Module 03: Advanced Querying with SQL SQL and Access FREE 00:06:00 Writing SQL Statements 00:18:00 Attaching SQL Queries to Controls 00:06:00 Advanced Queries Creating Crosstab Queries 00:05:00 Creating Parameter Queries 00:11:00 Using Action Queries 00:17:00 Macros Creating, Running, and Modifying Macros 00:08:00 Attaching Macros to the Events of Database Objects 00:05:00 Advanced Macros Creating Macros to Provide User Interaction 00:20:00 Creating Macros that Require User Input 00:04:00 Creating AutoKeys and AutoExec Macros 00:07:00 Creating Macros for Data Transfer 00:07:00 Importing, Exporting, and Linking Importing Objects 00:14:00 Exporting Objects 00:06:00 Working with XML Documents 00:13:00 Linking Access Objects 00:13:00 Using Hyperlink Fields 00:06:00 Database Management Optimizing Resources 00:16:00 Protecting Databases 00:05:00 Setting Options and Properties 00:06:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The Microsoft Office has released a 2016 version that contains its improved and upgraded applications. One of these applications is the Access 2016. This application is considered as an information tool that helps you store information from reference up until the analysis stage. This Microsoft Office 2016 Access Beginner - Complete Video Course is designed to give details in different ways in utilizing Access 2016. The main purpose of Access 2016 is to organize and manage your data. Learning about Access 2016 can be a burden if you are not provided with the chance to explore it first. Knowing the application itself should be done to make sure that you are using the right key features. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Office 2016 Access Beginner - Complete Video Course 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 Microsoft Office 2016 Access Beginner - Complete Video Course 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. Module 01 Orientation to Microsoft Access FREE 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Module 02 Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Module 03 Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Module 04 Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Module 05 Create a Report 00:23: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 Mock Exam Mock Exam- Microsoft Office 2016 Access Beginner - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Access Beginner - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Nowadays almost every job in the business world involves office products. Whether you're an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. The Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 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 Microsoft Office 2016 Access Complete Video 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 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. Microsoft Access - Beginner Orientation to Microsoft Access FREE 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:23: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 Microsoft Access - Intermediate Relational Database Design FREE 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 Microsoft Access - Advanced Add Controls to Forms FREE 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 Mock Exam Mock Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Welcome to Microsoft Access 2007 course for beginners. Microsoft Access is the word most popular database software designed by Microsoft. This course is designed for beginners who are targeting the basics of Microsoft 2007. Learn about the basic tools of Microsoft Access. Explore the basic functions and features of Microsoft Access. Study how to create simple databases from scratch. Learning about Microsoft Access 2007 will help you excel within your professional lives.This course will provide you with the necessary skills, knowledge and information of Microsoft Access 2007. Who is the course for? New staff or workers who want to learn about the Microsoft Access 2007. People who have an interest in the basics and features of the Access 2007. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, 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 hard copy 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 Access 2007 for Beginners will be very beneficial and helpful, especially to the following professionals: Technical Support. Technical Sales. Business Analyst. Web Developer. Microsoft Access 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

If you've never work with OneNote before, or you've opened it and struggled, join this OneNote Online course to discover the easy way to create notebook. OneNote Online is a note-taking application that allows you to create basic notes to drawings, links, and embedded files. By enrolling in this course, you'll learn the basics of OneNote Online in Office 365, and learn to create a notebook and add content. Furthermore, learn to navigate and create notebooks by adding text, images, web content, tables, or embedded objects. You'll also learn to share and print OneNote Online notebooks. Join us today. Explore what else is in the course! What Will I Learn? Work with OneNote Create a New Notebook Add and Format Content Use Search Requirements Basic Computer Skills Who is the target audience? Anyone wishing to get an understanding of the online version of OneNote in Office 365. Introduction Introduction FREE 00:02:00 Working with OneNote Overview of OneNote 00:05:00 Creating a New Notebook 00:05:00 Navigating in OneNote 00:05:00 Adding Sections and Pages 00:06:00 Adding Content 00:08:00 Formatting Content 00:06:00 Using Tags 00:05:00 Using Search 00:04:00 Using Print and Sharing Options 00:05:00 Using Immersive Reader 00:05:00 Conclusion Course Recap 00:03:00 Course Certification

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Simple Habits Of Greatness. The certification that you will receive upon completing this Simple Habits Of Greatness will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Simple Habits Of Greatness Lifetime access to the course No hidden fees or exam charges 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? Simple Habits Of Greatness is CPD Qualification Standards and CiQ accredited, 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 Simple Habits Of Greatness 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. Creating Good Habits Course Promo 00:03:00 Lesson 01: Introduction 00:02:00 Lesson 02: Habits - Meaning, Characteristics, And Role 00:05:00 Lesson 03: Habit Formation 00:05:00 Lesson 04: Types Of Habits 00:04:00 Lesson 05: Breaking Bad Habits And Breaking Down The Habit Loop 00:14:00 Lesson 06: Habits, Health, And Success 00:06:00 Lesson 07: Powerful Daily Routine For A Healthier Life 00:09:00 Lesson 08: 20 Best Habits To Have In Life 00:03:00 Lesson 09: Destructive Habits 00:03:00 Lesson 10: Conclusion - Final Thoughts & Ideas 00:01:00

Overview Master Microsoft Visio 2016 and elevate your workflow by attending the Microsoft Visio 2016 - Complete Bundle course.In the comprehensive Microsoft Visio 2016 - Complete Bundle course, you'll learn about creating, shaping and connecting text in Microsoft Visio 2016. You'll learn how to add images to a diagram, precise object alignment, and other essentials, for effective data management. You'll also learn how to integrate hyperlinks into your work while collaborating with co-authors, and save your work in different formats to share your work in several platforms. Save time and grow your diagramming skills with Microsoft Visio 2016, by enrolling today! 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 Visio 2016 - Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Visio 2016 - Complete Bundle 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 12 sections • 40 lectures • 16:10:00 total length •Navigate the Visio Environment: 00:15:00 •Create a Basic Drawing: 00:30:00 •Use the Help System: 00:15:00 •Use Drawing Components: 00:30:00 •Modify a Drawing: 00:15:00 •Work with Callouts and Groups: 00:15:00 •Create a Basic Organization Chart: 00:30:00 •Do More with Organization Charts: 00:15:00 •Make a Basic Floor Plan: 00:30:00 •Model a Room Layout: 00:15:00 •Create a Cross-Functional Flowchart: 00:30:00 •Modify a Cross-functional Flowchart: 00:15:00 •Create Network Diagrams: 00:15:00 •Use Shape Data: 00:15:00 •Use Layers: 00:30:00 •Work with Shape and Connector Styles: 00:15:00 •Work with Themes and Variants: 00:15:00 •Work with Containers: 00:15:00 •Work with Shape Styles: 00:30:00 •Use 3D Shapes: 00:30:00 •Apply Backgrounds, Borders, and Titles: 00:30:00 •Create Custom Stencils: 00:30:00 •Create Simple Custom Shapes: 00:30:00 •Create Master Shapes: 00:30:00 •Create Custom Templates: 00:30:00 •Generate a Pivot Diagram from an Excel Spreadsheet: 00:30:00 •Create a Chart from a Project File: 00:30:00 •Create a Timeline from a Project File: 00:30:00 •Connect to an Access Database: 00:30:00 •Create Macros: 00:30:00 •Modify ShapeSheets: 00:30:00 •Use Advanced Shape Tools: 00:30:00 •Save and Share Drawings with One Drive: 00:30:00 •Review Drawings: 00:30:00 •Insert Drawings into Other Office Files: 00:30:00 •Export Drawings: 00:30:00 •Print Drawings: 00:30:00 •Activities - Microsoft Visio 2016 - Complete Bundle: 00:00:00 •Mock Exam- Microsoft Visio 2016 - Complete Bundle: 00:20:00 •Final Exam- Microsoft Visio 2016 - Complete Bundle: 00:20:00

Overview This comprehensive course on Programming AutoCAD to Excel using VB.NET will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Programming AutoCAD to Excel using VB.NET 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 Programming AutoCAD to Excel using VB.NET. It is available to all students, of all academic backgrounds. Requirements Our Programming AutoCAD to Excel using VB.NET 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 7 sections • 102 lectures • 09:34:00 total length •Introduction: 00:04:00 •Who is this course for?: 00:02:00 •What will you learn from this course?: 00:05:00 •Tools needed: 00:01:00 •Course Prerequisites: 00:04:00 •Section Overview - Export AutoCAD Objects to Excel: 00:02:00 •Exporting Lines to Excel - Overview: 00:02:00 •Creating the VB.NET-Excel Project: 00:06:00 •Design of User Interface to Export Lines: 00:10:00 •Creating the Common Utility Class: 00:19:00 •Creating the ExportLines Method: 00:12:00 •Running and Testing ExportLines Method: 00:06:00 •Exporting MTexts to Excel - Overview: 00:02:00 •Creating the ExportMTexts Method: 00:11:00 •Export Polylines to Excel - Overview: 00:01:00 •Creating the ExportPolylines Method: 00:12:00 •Running and Testing ExportPoylines Method: 00:12:00 •Export Blocks (Without Attributes) to Excel - Overview: 00:01:00 •Creating the ExportBlocks Method: 00:12:00 •Creating Export Blocks UI and Running the Code: 00:06:00 •Exporting Blocks (With Attributes) to Excel - Overview: 00:02:00 •Creating the User Interface for exporting Blocks to Excel: 00:05:00 •Creation of BlocksForm UI: 00:04:00 •Coding the BlocksForm Load Event: 00:08:00 •Testing the BlocksForm UI: 00:03:00 •Coding the BlocksForm to populate the Listboxes: 00:15:00 •Coding the BlocksForm Export Button: 00:04:00 •Coding the ExportBlocksWithAttributes Method: 00:21:00 •Running and Testing ExportBlocksWithAttributes Method: 00:02:00 •Section Overview - Import Excel File into AutoCAD: 00:01:00 •Importing Lines from Excel File into AutoCAD - Overview: 00:01:00 •Creating ImportExcelUtil Class: 00:02:00 •Creating the ImportLines Method: 00:19:00 •Creating the UI for the ImportLines Method: 00:02:00 •Coding the ImportLines UI code behind.: 00:07:00 •Running and Testing ImportLines Method: 00:08:00 •Importing MTexts into AutoCAD - Overview: 00:01:00 •Creating the ImportMTexts Method: 00:11:00 •Creating ImportMTexts User Interface: 00:02:00 •Running and Testing ImportMTexts Method: 00:02:00 •Importing Polylines from Excel File into AutoCAD - Overview: 00:01:00 •Creating the ImportPolylines Method: 00:14:00 •Creating ImportPolylines User Interface: 00:02:00 •Running and Testing ImportPolylines Method: 00:03:00 •Running and Testing ImportPolylines (from a File) Method: 00:02:00 •Importing Blocks (without Attributes) from Excel File into AutoCAD - Overview: 00:01:00 •Creating the ImportBlocks Method: 00:09:00 •Creating the ImportBlocks User Interface: 00:02:00 •Running and Testing ImportBlocks Method: 00:03:00 •Importing Blocks (with Attirubtes) from Excel File into AutoCAD - Overview: 00:02:00 •Creating the ImportBlocksWithAttributes Method: 00:25:00 •Creating the UI for ImportBlocksWithAttributes Method: 00:04:00 •Running and Testing ImportBlocksWithAttributes Method: 00:03:00 •Exporting Lines to a File - Overview: 00:02:00 •Creating the ExportToFile Utility Class: 00:04:00 •Creating ExportLinesToFile Method: 00:14:00 •Creating the UI for ExportLinesToFile Method: 00:08:00 •Running and Testing ExportLinesToFile Method: 00:02:00 •Exporting MTexts to File - Overview: 00:01:00 •Creating the MTextToFile Method: 00:06:00 •Creating the UI for the ExportMTextToFile Method: 00:01:00 •Running and Testing ExportMTextToFile Method.: 00:08:00 •Exporting Polylines to File - Overview: 00:02:00 •Creating ExportPolylinesToFile Method: 00:11:00 •Exporting Polylines to File - User Interface: 00:01:00 •Running and Testing ExportPolylinesToFile Method: 00:02:00 •Exporting Blocks (without Attributes) to File - Overview: 00:02:00 •Creating the ExportBlocksToFile Method: 00:10:00 •Creating ExportBlocksToFile User Interface: 00:02:00 •Running and Testing ExportBlocksToFile Method: 00:02:00 •Exporting Blocks (With Attributes) to a File - Overview: 00:02:00 •Creating the EXportBlocksWithAttributesToFile Method: 00:19:00 •Creating the UI for ExportBlocksWithAttributesToFile Method: 00:06:00 •Coding the BlocksForm for ExportBlocksWithAttributeToFile Method: 00:04:00 •Running and Testing ExportBlocksWithAttributesToFile Method: 00:03:00 •Importing Text File into AutoCAD - Overview: 00:01:00 •Importing Lines from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportFileUtil Class: 00:01:00 •Creating the ImportLinesMethod: 00:17:00 •Creation of ImportLines User Interface: 00:03:00 •Coding the ImportLines UI button: 00:05:00 •Running and Testing the ImportLines Method: 00:04:00 •Importing MTexts from Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportMTexts Method: 00:09:00 •Creating the TextStyle Manipulation Code: 00:02:00 •Creating the UI for the ImportMTexts Method: 00:01:00 •Running and Testing the ImportMTexts Method: 00:04:00 •Importing Polylines from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportPolylines Method: 00:18:00 •Creating the ImportPolylines UI: 00:02:00 •Running and Testing ImportPolylines (from a File) Method: 00:02:00 •Importing BLocks (without Attributes) from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportBlocks (without Attributes) Method: 00:15:00 •Creating the ImportBlocks UI: 00:05:00 •Running and Testing ImportBlocks (without Attributes) Method: 00:04:00 •Importing Blocks (with Attributes) from a Text File into AutoCAD - Overview: 00:02:00 •Creating the ImportBlocksWithAttributes from a File Method: 00:24:00 •Creating the ImportBlocksWithAttributes (from a File) UI (Part 1): 00:06:00 •Creating the ImportBlocksWithAttributes (from a File) UI (Part 2): 00:04:00 •Running and Testing ImportBlocksWithAttributes (from a File) Method: 00:03:00 •Conclusion: 00:01:00 •Assignment - Programming AutoCAD to Excel using VB.NET: 00:00:00

Course Overview Take your Excel skills to the next level with the help of the Need to Know Advanced Excel Formulas and Functions course. In this course, the expert instructor will show you how to optimize the use of excel. You will learn a handful of useful functions and formulas that will increase your proficiency in excel. The Need to Know Advanced Excel Formulas and Functions course aims to increase your competence in excel. The course will teach you the fundamental math functions. You will understand the concept of relative reference and absolute reference. The course will educate you on Autosum. You will receive lectures on how to link sheets and workbooks. The course will enrich your understanding of vlookup and hlookup functions. You will become skilled in training functions. From this course, you will achieve the essential training to upgrade your MS excel skills in no time. This Need to Know Advanced Excel Formulas, and Functions course will help you build excellent expertise in excel. Enroll in the course to boost your abilities and your employability in the relevant job market. Learning Outcomes Understand how to build basic math formulas Enrich your understanding of Autosum and relative references Learn how to link sheets and workbooks Gain the skills for tracking functions Deepen your knowledge of Vlookup and Hlookup functions Build your skills to work with text functions Who is this course for? Those who want to upgrade their excel skills 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 Need to Know Advanced Excel Formulas and Functions course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Administrative Officer Need to Know Advanced Excel Formulas and Functions Building basic math formulas 00:08:00 Autosum and Relative references 00:09:00 Absolute references 00:06:00 Named Ranges 00:06:00 Linking sheets and workbooks 00:06:00 If, And, Or, and the nested If functions 00:16:00 Countif, Sumif, Averageif, Sumifs, and Countifs functions 00:09:00 Vlookup and Hlookup functions 00:15:00 Match and Index functions 00:07:00 Date and time formulas and functions 00:12:00 Text functions 00:11:00 Tracing formulas 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Do you want to know about MS Visio 365? Are you interested to get some specific and effective ideas about it? Do you want to learn how it works? Look at the MS Visio 365 Online course and mitigate your quest. MS Visio 365 is one of the parts of MS office. It is actually used to draw some critical and complex diagrams. The curse is designed in such a way that will assist you to learn the crucial methods of sketching shapes, diagrams. The purpose of this course is to enable you to make shapes, diagrams, and objects by using various templates and patterns. This course also enables you to draw your own shape. It teaches you to create diagrams, flow chart, connect shapes, and work with text, theme, and pages perfectly. 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? MS Visio 365 Online 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 MS Visio 365 Online 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 Understanding Visio Online What Is Visio 00:02:00 Comparing Visio Online vs 2016 00:04:00 Launching Visio Online 00:02:00 Getting Started with Visio Understanding the Visio Environment 00:04:00 Navigating and Zooming 00:03:00 Creating New Diagrams Accessing Visio Templates 00:03:00 Creating a Visio Diagram in OneDrive 00:02:00 Opening a Diagram in Visio 00:03:00 Working with Shapes Adding Shapes 00:04:00 Formatting Shapes 00:03:00 Manipulating Shapes 00:02:00 Changing Stacking Order 00:03:00 Selecting and Grouping Shapes 00:02:00 Searching for Shapes 00:02:00 Creating a Flow Chart Working with Basic Flowchart Template 00:03:00 Connecting Shapes 00:03:00 Adding Text to Shapes 00:02:00 Working with Visio Diagrams Inserting Pictures 00:02:00 Changing the Document Theme 00:02:00 Adding Pages to a Diagram 00:01:00 Sharing Visio Diagrams Sharing Diagrams in OneDrive 00:03:00 Reviewing Diagrams in OneDrive 00:02:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00