3919 Office Skills courses

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

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

Dive into the heart of Big Data Infrastructure, exploring storage systems, distributed file frameworks, and processing paradigms. This course provides a comprehensive understanding of key components like HDFS, Apache Spark, and Cassandra, offering insights into their architecture, use cases, and real-world applications. This course is a deep dive into the complex landscape of Big Data Infrastructure. From unravelling the architecture of Apache Spark to dissecting the benefits of distributed file systems, participants gain expertise in assessing, comparing, and implementing various Big Data storage and processing systems. Scalability, fault-tolerance, and industry-specific case studies add practical depth to theoretical knowledge. After the successful completion of this course, you will be able to: Understand the Components of Big Data Infrastructure, Including Storage Systems, Distributed File Systems, and Processing Frameworks. Identify the Characteristics and Benefits of Distributed File Systems Such as Hadoop Distributed File System (H.D.F.S). Describe the Architecture and Capabilities of Apache Spark and its Role in Big Data Processing. Recognise the Use Cases and Benefits of Apache Cassandra as a Distributed N..O.S.Q.L Database. Compare and Contrast Different Big Data Storage and Processing Systems Such as Hadoop, Spark, and Cassandra. Understand the Scalability and Fault-tolerance Mechanisms Used in Big Data Infrastructure, Such as Sharding and Replication. Appreciate the Challenges Associated with Deploying and Managing Big Data Infrastructure, Such as Hardware and Software Configuration and Security Considerations. Explore the intricacies of Big Data Infrastructure, from understanding storage systems to unraveling the nuances of distributed file frameworks and processing engines. Gain a comprehensive view of scalability, fault-tolerance mechanisms, and industry-specific challenges through engaging case studies. Equip yourself to navigate the dynamic landscape of Big Data with confidence and expertise. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Big Data Infrastructure Self-paced pre-recorded learning content on this topic. Big Data Infrastructure Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be an added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone who is eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Big Data Infrastructure Engineer Hadoop Administrator Spark Developer Cassandra Database Administrator Big Data Solutions Architect Data Infrastructure Manager NoSQL Database Analyst Big Data Consultant Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Are you ready to embark on an enlightening journey of wisdom with the SAP Training & Quality Assurance bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - SAP Training & Quality Assurance (QA) - CPD Certified. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: SAP S4HANA Controlling - Cost Center Accounting Course 02: SAP Controlling (CO) - Product Costing S4HANA Course 03: Quality Management Course 04: Business Project Manager Training Course 05: Agile Scrum Master Certification Course 06: Rapid Business Improvement Course 07: Automation of Processes Course 08: RCA: Root Cause Analysis Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the SAP Training & Quality Assurance (QA) - CPD Certified bundle illuminate your path to wisdom. The SAP Training & Quality Assurance (QA) - CPD Certified bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the SAP Training & Quality Assurance (QA) - CPD Certified package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the SAP Training & Quality Assurance bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the SAP Training & Quality Assurance (QA) - CPD Certified community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the SAP Training & Quality Assurance bundle. Establish robust bases across each course nestled within the SAP Training & Quality Assurance bundle. Decipher intricate concepts through the articulate content of the SAP Training & Quality Assurance bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the SAP Training & Quality Assurance bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The SAP Training & Quality Assurance bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the SAP Training & Quality Assurance bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The SAP Training & Quality Assurance bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the SAP Training & Quality Assurance bundle allows learners to make meaningful contributions to their chosen fields. Embark on the SAP Training & Quality Assurance journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the SAP Training & Quality Assurance bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the SAP Training & Quality Assurance bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hard copy Transcript - £9.99

Elevate your career with our Receptionist course! Gain mastery in communication, front desk management, scheduling, and more. Become an office cornerstone. Enrol now!

Looking for an easy to use and functional spreadsheet application. Look no further as this course will get you started on becoming a professional on the most important spreadsheet application, Microsoft Excel 2007. Microsoft Excel 2007 is part of the Microsoft Office suite of programs which is the most widely used software package on Earth. Excel 2007 is a great tool for simple or complex calculations, particularly ones which you want to repeat. You can use this software to visualize data as well. You can use this useful tool to deal with large quantities of data, for quick data manipulation, for checklists and status reporting. Use pivot tables to aggregate and filter data. During this course, you will learn all the functions of Microsoft Excel 2007 and will make you a professional at representing your data. At the end of the course you will be able learn all there is to know about Microsoft Excel and be fully capable of presenting data or solving any problems regarding Microsoft Excel. Course Highlights Certified Microsoft Excel 2007 Complete Course - Beginner to 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 Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced into 26 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 22 hours, 30 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 Certified Microsoft Excel 2007 Complete Course - Beginner to 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? Certified Microsoft Excel 2007 Complete Course - Beginner to 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 Certified Microsoft Excel 2007 Complete Course - Beginner to 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 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Final Exam

You will hardly find a company or business who doesn't use Microsoft Excel. It is one of the most popular spreadsheet tools that is used to store, organize and analyse data. You can also manipulate the data to create useful visuals to understand trends and calculations. Having a professional Microsoft Excel degree can become an asset for you. Whether you are planning to start your career or want a promotion, our Microsoft Excel 2010 Intermediate Level will help you greatly. Please note that this course is for intermediate level. If you haven't completed the beginners course, then it will be a bit difficult for you to cope up with the intermediate features. But, if you are a quick learner and can adapt with changes, then you can enrol to this course without any doubt and master Microsoft Excel easily. It will help you to stand out in the crowd with your advanced MS Excel skills to that you can stay ahead in the workplace. Course Highlights Microsoft Excel 2010 Intermediate Level 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 2010 Intermediate Level into 13 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 10 hours, 40 minutes 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 2010 Intermediate Level 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 2010 Intermediate Level 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 2010 Intermediate Level 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 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

Learning Objectives Introduction , Linking Workbooks and Worksheets , Working with Range Names , Sorting, Filtering, and Subtotaling , Analyzing and Organizing with Tables , Using Conditional Formatting , Displaying Data Graphically , Understanding PivotTables, PivotCharts, and Slicers , Working with Advanced PivotTables and PowerPivot Features , Conclusion   Pre-Requisites Excel 365 Introduction course or equivalent knowledge or experience.   Description In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features. Section 01 Lesson 01: Linking Workbooks and Worksheets 00:06:00 Lesson 02: Linking Workbooks with 3D References 00:05:00 Lesson 03: Understanding the Consolidate Feature 00:06:00 Section 02 Lesson 01: What are Range Names 00:04:00 Lesson 02: Creating Range Names Using the Name Box and Define Name 00:06:00 Lesson 03: Creating Range Names Using Create from Selection 00:03:00 Section 03 Lesson 01: Understanding the Differences Between Sorting and Filtering 00:03:00 Lesson 02: Sorting Lists 00:06:00 Lesson 03: Filtering Lists 00:08:00 Lesson 04: Creating Subtotals 00:06:00 Section 04 Lesson 01: Creating Tables and Understanding the Benefits 00:07:00 Lesson 02: Understanding the Elements of a Table 00:06:00 Lesson 03: Formatting a Table 00:08:00 Lesson 04: Sorting and Filtering Tables 00:03:00 Lesson 05: Filtering with Slicers 00:04:00 Lesson 06: Calculating with Tables 00:04:00 Lesson 07: Removing Erroneous Table Data 00:03:00 Lesson 08: Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 Lesson 01: What is Conditional Formatting 00:04:00 Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules 00:07:00 Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales 00:06:00 Lesson 04: Using Custom Fonts and Colors 00:04:00 Lesson 05: Using Custom Conditional Formatting 00:06:00 Lesson 06: Modifying or Removing Conditional Formatting 00:05:00 Section 06 Lesson 01: What are Charts 00:05:00 Lesson 02: Creating Charts 00:06:00 Lesson 03: Understanding Chart Elements 00:05:00 Lesson 04: Modifying Chart Elements 00:09:00 Lesson 05: Changing and Moving Charts 00:04:00 Lesson 06: Filtering a Chart 00:04:00 Lesson 07: Formatting Charts 00:07:00 Lesson 08: Adjusting Numbering 00:06:00 Lesson 09: Creating Dual Axis Charts 00:05:00 Lesson 10: Forecasting with Trendlines 00:05:00 Lesson 11: Creating a Chart Template 00:04:00 Lesson 12: Displaying Trends with Sparklines 00:07:00 Section 07 Lesson 01: What is a PivotTable 00:06:00 Lesson 02: Creating a PivotTable 00:07:00 Lesson 03: Working with the PivotTable Fields Pane 00:09:00 Lesson 04: Basic Data Organization and Analysis with PivotTables 00:06:00 Lesson 05: Formatting PivotTables 00:06:00 Lesson 06: Creating a PivotChart 00:04:00 Lesson 07: Modifying and Formatting a PivotChart 00:04:00 Lesson 08: Adding Slicers and Timeline Slicers 00:03:00 Lesson 09: Formatting Slicers 00:04:00 Lesson 10: Using the Ideas Feature 00:03:00 Section 08 Lesson 01: Using the PivotTable and PivotChart Wizard 00:02:00 Lesson 02: Adding a Calculated Field 00:05:00 Lesson 03: Adding a Calculated Item 00:04:00 Lesson 04: Applying Conditional Formatting to a PivotTable 00:02:00 Lesson 05: Creating Filter Pages for a PivotTable_1 00:03:00 Lesson 06: Enabling the PowerPivot Add: In 00:06:00 Final Exam Final Exam - Excel 365 Intermediate 00:20: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