Discover how to utilize VBA to automate procedures and effortlessly generate reports with a single button press. Streamline your tasks and achieve seamless productivity by performing various actions at the click of a button. No prior knowledge of VBA is required but familiarity with Excel will be an advantage.
Visual Studio Code is currently the number #1 IDE among the programmer's community. All the big companies are moving towards using VS Code for active development. Get ahead of the curve and learn to use Visual Studio Code with ease.
Description Do you want to know how to be an expert in creating forms and gathering data? Are you looking for the easiest method regarding MS InfoPath? You may look at the MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course. This course may assist you to get an approximate idea about this field. The MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course incorporates some basic ideas regarding the use of MS InfoPath. It enables to know you how to make forms and collect data by using Infopath within SharePoint. It also teaches you how to edit, create, and publish a form along with a strong command of associated properties. It gives you a proper direction to use Infopath forms by utilizing WebParts. After the end of the course, you will be an expert on some advanced functions of InfoPath that enables you to modify data source and work with it vivid sections. 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 InfoPath 2013: Working With InfoPath 2013 in SharePoint 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 InfoPath 2013: Working With InfoPath 2013 in SharePoint 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 SharePoint and InfoPath Using InfoPath with SharePoint 00:04:00 Exploring the InfoPath Interface 00:03:00 Creating a Form from an Existing List 00:03:00 Creating a new List and Form within InfoPath 00:04:00 Creating a Form in InfoPath Using SharePoint Designer 00:02:00 Editing a Form 00:02:00 Publishing a Form 00:02:00 Restoring the Default SharePoint Form 00:03:00 Working with List Forms Components of the InfoPath Form 00:03:00 Formatting Text in the Form 00:03:00 Spellcheck Your Form 00:02:00 Inserting or Deleting a Table 00:02:00 Formatting a Table 00:03:00 Add or Remove Rows and Columns 00:02:00 Merging and Splitting Cells 00:04:00 Adding or Removing a Field 00:03:00 Resizing and Formatting a Field 00:03:00 Changing Field Controls 00:05:00 Inserting a Section 00:03:00 Inserting a Picture 00:02:00 Inserting a Button 00:05:00 Inserting a Calculated Value 00:04:00 Setting Default Field Values 00:05:00 Creating a Validation Rule 00:04:00 Creating a Formatting Rule 00:04:00 Creating an Action Rule 00:05:00 Modifying or Deleting a Rule 00:02:00 Setting the Form Load Rules 00:03:00 Advanced InfoPath Features Exploring the Fields Pane 00:02:00 Creating a Data Source 00:05:00 Modifying and Deleting a Data Source 00:02:00 Creating a View 00:03:00 Configuring View Settings 00:03:00 Creating Cascading Columns 00:06:00 Understanding Repeating Sections and Tables 00:03:00 Creating a Repeating Section 00:04:00 Using Repeating Tables to Add Multiple Items to a List 00:08:00 Using Repeating Sections to Show Existings Records 00:07:00 Hiding a Form Section Based on Field Values 00:05:00 InfoPath Forms Within SharePoint Using the InfoPath Form WebPart on a SP Page 00:04:00 Using Form Views for Different Groups 00:06:00 InfoPath Form WebPart and WebPart Filters 00:08:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
The Azure Container Service (ACS) is a cloud-based container deployment and management service that supports popular open source tools and technologies for container and container orchestration. ACS allows you to run containers at scale in production and manages the underlying infrastructure for you by configuring the appropriate VMs and clusters for you. This Azure - Containers is designed to instruct you on Azure, and specifically how it pertains to containers. In this course, you will gain a comprehensive overview of containers and spend time understanding what containers are within Azure. You will learn how to use docker host to manage both on-premises and Azure containers. Learn how to use ACS to scale and orchestrate applications using DC/OS, Docker Swarm, or Kubernetes. This course also covers Azure container clustering options. On completion this course, you will be confident enough to use Azure Containers. Finally, you will look at how to install ACS. What Will I Learn? Understand Containers in Azure Deploy Containers Install ACS Understand multi-container applications Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:01:00 Introduction to Containers Introduction to Containers 00:04:00 Docker 00:04:00 Deploying Containers 00:08:00 Multi-container Applications 00:02:00 Azure Container Registry 00:03:00 Azure Container Clustering Options 00:02:00 Installing ACS 00:04:00 Conclusion Course Recap 00:02:00 Course Certification
This course explains how huge chunks of data can be analyzed and visualized using the power of the data analyst toolbox. You will learn Python programming, advanced pivot tables' concepts, the magic of Power BI, perform analysis with Alteryx, master Qlik Sense, R Programming using R and R Studio, and create stunning visualizations in Tableau Desktop.
ð Unlock Your Presentation Potential with PowerPoint Mastery Basics! ð Are your presentations lacking that wow factor? Do you find yourself struggling to engage your audience and convey your message effectively? It's time to transform your presentations into captivating masterpieces with our groundbreaking course - PowerPoint Mastery Basics! ð Why PowerPoint Mastery Basics? â Unleash Your Creativity: Discover the hidden features of PowerPoint that will turn your slides from dull to dynamic. Learn how to design visually stunning presentations that captivate your audience's attention. â Boost Your Efficiency: Say goodbye to hours spent tweaking your slides. Master time-saving techniques and shortcuts that will streamline your workflow, allowing you to create impactful presentations in record time. â Command Attention: Learn the art of storytelling through slides. Understand how to structure your content for maximum impact, keeping your audience engaged from start to finish. â Professionalism Redefined: Elevate your presentations to professional standards. Discover design principles, formatting tricks, and visual hierarchy techniques that will make your slides stand out in any professional setting. â Interactive Learning: Our course is not just about theory; it's a hands-on experience. Dive into practical exercises and real-world examples that reinforce your learning and ensure immediate application of newfound skills. â Lifetime Access and Updates: Get unlimited access to the course content and benefit from future updates. Stay ahead of the curve as PowerPoint evolves, and continue to refine your skills over time. ð Who Can Benefit? ð©âð¼ Business Professionals: Impress your clients and colleagues with polished presentations that convey your ideas persuasively. ð¨âð« Educators: Transform your classroom experience with engaging presentations that enhance learning and retention. ð©âð» Entrepreneurs: Pitch your ideas with confidence and leave a lasting impression on potential investors and partners. ð¨âð Students: Stand out in your academic presentations with visually compelling slides that showcase your understanding of the subject matter. ð Don't miss out on this opportunity to revolutionize your presentations and leave a lasting impact! Join PowerPoint Mastery Basics today! Course Curriculum Basic Overview 02:46 Using The Right Mouse Button 02:49 The Home Menu - Clipboard Sub Menu - Editing Sub Menu 02:56 The Home Menu - Slides Sub Menu 03:24 The Home Menu - Font and Paragraph Sub Menus 03:19 The Home Menu - Drawing Sub Menu - Dictation Sub Menu 06:14 The Home Menu - Importing from Keynote and Google Docs 00:00 The Insert Menu - 3D Models and Add Ins 00:00 The Insert Menu - The Images Sub Menu 00:00 The Insert Menu - Media Sub Menu 00:00 The Design Menu 00:00 The Transitions Menu 00:00 The Animations Menu - Part One 00:00 The Animations Menu - Part Two 00:00 The Slide Show Menu 00:00 The Presenter View 00:00 The Review Menu 00:00 Sharing and Collaboration 00:00 The View Menu 00:00 View and Outline Command Example 00:00 Advanced Overview and Workspace 00:00 The File Menu - Export Command 00:00 The File Menu - Options Sub Menu 00:00 Adding Sections 00:00 Using Smart Art 00:00 Hyperlinks 00:00 Adding 3D Images 00:00 Using the Actions Button 00:00 Using the Zoom Feature 00:00 Using the Screen Recorder 00:00 Using the Picture Background 00:00 Slide Master - Picture Background 00:00 Slide Master - Part 2 00:00 Using the Slide Sorter View 00:00 Using the Presenter View (1) 00:00 Using the Presenter View (2) 00:00 Present Your Presentation Online 00:00 Insert Menu - Add Ins (1) 00:00 Insert Menu - Add Ins (2) 00:00 Conclusion and Collaboration 00:00
Description MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields. The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities. 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 Excel 2016 Introduction 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 Excel 2016 Introduction 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 Getting Started with Excel What is Excel 00:02:00 Opening Excel 00:04:00 Navigating the Excel User Interface 00:07:00 Using the Excel Ribbon 00:03:00 Understanding Excel Work Components 00:04:00 Using the Backstage View 00:03:00 Creating Workbooks and Using Templates Creating a New Workbook 00:03:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using Convert and Checking Compatiblity 00:02:00 Entering Data Navigating a Worksheet by Mouse or Keyboard 00:05:00 Excel Data Types 00:03:00 Cell and Range Addressing 00:02:00 Data Selection Techniques 00:05:00 Common Excel Commands 00:07:00 Using the Autofill Handle 00:03:00 Excel Formula Basics Data What are Formulas and Functions 00:02:00 Components of a Formula 00:06:00 Calculation Hierarchy Using the Order of Operations_Revise 00:02:00 Creating Basic Formulas 00:08:00 Working with Basic Functions and Autosum 00:04:00 Using Cell References 00:04:00 Using the Quick Analysis Tool 00:01:00 Adjusting a Worksheet Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:03:00 Formatting and Aligning Worksheet Data Formatting and Aligning Data 00:06:00 Merging Data 00:03:00 Wrapping Text Orientation 00:02:00 Formatting Numbers 00:03:00 Using Borders and Shading 00:03:00 Using the Format Painter 00:01:00 Removing Formatting Quickly 00:01:00 Using Cell Styles and Themes Understanding Cell Styles 00:02:00 Applying Cell Styles 00:04:00 Applying Themes 00:03:00 Inserting Objects and Graphics Inserting and Formatting Images 00:03:00 Inserting and Formatting Shapes 00:04:00 Inserting and Formatting Smart Art 00:04:00 Inserting Screenshots 00:02:00 Inserting Hyperlinks 00:03:00 Inserting Symbols and Equations 00:03:00 Inserting Word Art Or Text Boxes 00:04:00 Inserting Other Excel Objects 00:04:00 Arranging Objects 00:04:00 Proofing a Workbook Using Find and Replace 00:04:00 Finding and Replacing Formatting 00:01:00 Using Got to and Go to Special 00:02:00 Using the Spell Checker 00:03:00 Using the Theasaurus and Translation Feature 00:03:00 Printing an Excel File Printing and Previewing Excel Files 00:03:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:04:00 Formatting a Page with the Page Layout Tab 00:03:00 Printing Titles and Specific Worksheet Areas 00:05:00 Exporting to PDF and XPs 00:02:00 Managing Worksheets Renaming and Coloring Worksheet Tabs 00:03:00 Adding, Deleting, and Navigating Worksheets 00:03:00 Moving and Copying Worksheets 00:04:00 Hiding and Unhiding Worksheets 00:02:00 Navigating and Viewing Excel Files Viewing Workbooks 00:03:00 Using Zoom Tools 00:02:00 Configure Sheet Options 00:02:00 Using Freeze Panes and Split Commands 00:05:00 Working with Window Commands 00:04:00 Adjusting Workbook Properties 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description There are different methods to draw diagrams, and shape in the world. But, you are in dilemma that which path you should choose. You even don't know which course will be more suitable for you. Don't worry. You can see the MS Visio 2016 Introduction course. Hope you will get an approximate solution from this course. MS Visio is a part of MS Office that deals with the concept of drawing shapes and diagrams by using templates and stencils. The purpose of the course is to make you effective in drawing diagrams, shapes, compound lines, and arrangement of the object providing you with the basic concepts of different patterns and templates. The course teaches you how to construct figures, play with text, simply formatting, create organization charts, place shape properties, and work with pages. In the end, students will come to confirm a document knowing the fact how to save and print it. 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 2016 Introduction 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 2016 Introduction 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 the Visio Environment Understanding the Visio Environment 00:05:00 Using the Backstage View 00:04:00 Using the Home Tab 00:05:00 Using the Insert and Design Tabs 00:03:00 Using the Data and Process Tabs 00:03:00 Using the Review and View Tabs 00:03:00 Using The Shapes Pane 00:04:00 Controlling Window Layout 00:03:00 Creating Diagrams Using Diagram Templates 00:07:00 Inserting Shapes 00:07:00 Manipulating Shapes 00:08:00 Using the Size & Position Window 00:08:00 Using the Pan and Zoom Window 00:04:00 Using the Shape Data Window 00:03:00 Adding Text 00:05:00 Formatting Text 00:04:00 Changing Shape Stacking 00:04:00 Formatting a Diagram Grouping Objects 00:05:00 Aligning and Distributing Objects 00:05:00 Formatting Objects 00:06:00 Applying Themes and Backgrounds 00:04:00 Applying Borders and Titles 00:03:00 Adding Pages 00:03:00 Working with Background Pages 00:04:00 Creating an Organization Chart Creating an Organization Chart 00:04:00 Using Org Chart Shapes 00:05:00 Using Org Chart Layout Options 00:04:00 Splitting and Synchronizing an Organization Chart 00:04:00 Using the Org Chart Tab 00:03:00 Using the Organization Chart Wizard 00:06:00 Creating a Flow Chart Creating a Flow Chart 00:03:00 Inserting and Connecting Flow Chart Shapes 00:07:00 Using Additional Connectors 00:04:00 Creating a Cross Functional Flow Chart 00:05:00 Creating an Office Layout Creating an Office Layout 00:04:00 Creating the Room 00:06:00 Adding Windows and Doors 00:04:00 Adding Furniture 00:03:00 Finalizing Documents Finalizing Visio Drawings 00:03:00 Sharing Visio Drawings 00:02:00 Saving Visio Drawings 00:02:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Duration 5 Days 30 CPD hours This course is intended for System administrators System engineers Overview By the end of the course, you should be able to meet the following objectives: Install and configure ESXi hosts Deploy and configure vCenter Use the vSphere Client to create the vCenter inventory and assign roles to vCenter users Create virtual networks using vSphere standard switches and distributed switches Create and configure datastores using storage technologies supported by vSphere Use the vSphere Client to create virtual machines, templates, clones, and snapshots Create content libraries for managing templates and deploying virtual machines Manage virtual machine resource allocation Migrate virtual machines with vSphere vMotion and vSphere Storage vMotion Create and configure a vSphere cluster that is enabled with vSphere High Availability (HA) and vSphere Distributed Resource Scheduler Manage the life cycle of vSphere to keep vCenter, ESXi hosts, and virtual machines up to date This five-day course features intensive hands-on training that focuses on installing, configuring, and managing VMware vSphere 8, which includes VMware ESXi 8 and VMware vCenter 8. This course prepares you to administer a vSphere infrastructure for an organization of any size. This course is the foundation for most VMware technologies in the software-defined data center. Course Introduction Introductions and course logistics Course objectives vSphere and Virtualization Overview Explain basic virtualization concepts Describe how vSphere fits in the software-defined data center and the cloud infrastructure Recognize the user interfaces for accessing vSphere Explain how vSphere interacts with CPUs, memory, networks, storage, and GPUs Installing and Configuring ESXi Install an ESXi host Recognize ESXi user account best practices Configure the ESXi host settings using the DCUI and VMware Host Client Deploying and Configuring vCenter Recognize ESXi hosts communication with vCenter Deploy vCenter Server Appliance Configure vCenter settings Use the vSphere Client to add and manage license keys Create and organize vCenter inventory objects Recognize the rules for applying vCenter permissions View vCenter logs and events Configuring vSphere Networking Configure and view standard switch configurations Configure and view distributed switch configurations Recognize the difference between standard switches and distributed switches Explain how to set networking policies on standard and distributed switches Configuring vSphere Storage Recognize vSphere storage technologies Identify types of vSphere datastores Describe Fibre Channel components and addressing Describe iSCSI components and addressing Configure iSCSI storage on ESXi Create and manage VMFS datastores Configure and manage NFS datastores Deploying Virtual Machines Create and provision VMs Explain the importance of VMware Tools Identify the files that make up a VM Recognize the components of a VM Navigate the vSphere Client and examine VM settings and options Modify VMs by dynamically increasing resources Create VM templates and deploy VMs from them Clone VMs Create customization specifications for guest operating systems Create local, published, and subscribed content libraries Deploy VMs from content libraries Manage multiple versions of VM templates in content libraries Managing Virtual Machines Recognize the types of VM migrations that you can perform within a vCenter instance and across vCenter instances Migrate VMs using vSphere vMotion Describe the role of Enhanced vMotion Compatibility in migrations Migrate VMs using vSphere Storage vMotion Take a snapshot of a VM Manage, consolidate, and delete snapshots Describe CPU and memory concepts in relation to a virtualized environment Describe how VMs compete for resources Define CPU and memory shares, reservations, and limits Deploying and Configuring vSphere Clusters Create a vSphere cluster enabled for vSphere DRS and vSphere HA View information about a vSphere cluster Explain how vSphere DRS determines VM placement on hosts in the cluster Recognize use cases for vSphere DRS settings Monitor a vSphere DRS cluster Describe how vSphere HA responds to various types of failures Identify options for configuring network redundancy in a vSphere HA cluster Recognize vSphere HA design considerations Recognize the use cases for various vSphere HA settings Configure a vSphere HA cluster Recognize when to use vSphere Fault Tolerance Managing the vSphere Lifecycle Enable vSphere Lifecycle Manager in a vSphere cluster Describe features of the vCenter Update Planner Run vCenter upgrade prechecks and interoperability reports Recognize features of vSphere Lifecycle Manager Distinguish between managing hosts using baselines and managing hosts using images Describe how to update hosts using baselines Describe ESXi images Validate ESXi host compliance against a cluster image and update ESXi hosts Update ESXi hosts using vSphere Lifecycle Manager Describe vSphere Lifecycle Manager automatic recommendations Use vSphere Lifecycle Manager to upgrade VMware Tools and VM hardware