3239 Microsoft courses

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.

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.

Excel Macros Certificate Course Finding out about Excel macros is vital for any individual who uses Excel at home or work. Regardless of whether you're hoping to build your overall Excel information or improve your abilities in the work environment, this course covers all you require. This course gives a thorough manual for Excel macros, including the references to utilize, and how to record and save macros. From proficient tips and counsel to top to bottom full scale classes and genuine equations you can quickly apply, this course covers all you require to think about each component of Excel macros.   You Will Learn: A comprehensive definition of Excel macros and how they work How to reference and record macros How to run, name and save macros Professional tips and expert advice Macro categories and practical coding   Benefits of Taking This Course: You will save time and increase productivity You will be able to interpret data faster and more effectively You will learn basic VBA coding and how to make it work for you You will be able to automate and optimise essential data You will understand the security risks associated with macros

Register on the Excel 2016 Advanced Formulas and Functions today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Excel 2016 Advanced Formulas and Functions is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel 2016 Advanced Formulas and Functions Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Excel 2016 Advanced Formulas and Functions, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Advanced Functions Work with Ranges 00:18:00 Use Specialized Functions 00:12: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 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:06:00 Watch and Evaluate Formulas 00:09:00 Automating Workbook Functionality Search for Invalid Data and Formulas with Errors 00:04:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Other Functions and Formulas Use Text Functions 00:30:00 Use Specialized Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Automate SUM Functions 00:30:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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

Client service managers, also known as customer care managers and client relations managers, are responsible for handling client queries and complaints in a professional and helpful manner. They also implement strategies for improving customer service and manage clients. If you're considering a career in client service management, then this Client Services Manager course is for you. In this course, you will learn the value of excellent customer service, master the art of business communication and learn how to identify your clients' needs. You will also get step-by-step training on how to resolve client queries, complaints and requests. Throughout, you will develop your business communication skills, to be able to build and maintain strong working relationships that will leave lasting impressions. Your Learning Goals: Maintain strong working relationships with clients and understand their needs Be able to implement effective customer service policies and procedures Sharpen your active listening and interpersonal communication skills Learn how to monitor and measure customer service satisfaction levels Understand how to deal with client requests and queries professionally Master the art of business communication with our step-by-step training Familiarise with the goal-setting process and how to create practical targets Take steps to become a fully certified client services manager and enrol today! Who is this Course for? This training program is suitable for those who work in client-facing roles and want to take their knowledge to the next level by progressing to management level. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion of this course, learners will have the practical skills and knowledge to progress to senior client-based roles such as: Client Services Manager Client Services and Events Administrator Head of Client Services Client Services Coordinator Service Delivery Manager Client Services Consultant Course Curriculum ***Customer Service Training*** Understanding Customer Service Understanding Customer Service 00:17:00 Identifying Customer Expectations 00:06:00 Providing Excellent Customer Service 00:07:00 Focusing on the Customer Focusing on the Customer 00:08:00 Customer Service and the Telephone Customer Service and the Telephone 00:08:00 Handling Complaints Handling Complaints 00:12:00 Enduring Stress Enduring Stress 00:13:00 Business Communication Identifying Basic Communication Techniques 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 Identifying Goals Identifying Goals 00:10:00 Effective Energy Distribution Energy Distribution 00:09:00 Time Logs 00:11:00 Working with Your Personal Style Personal World View 00:10:00 Strengths 00:09:00 Building Your Toolbox A Building Your Toolbox 00:10:00 Establishing Your Action Plan Establishing Your Action Plan 00:11:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10: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:12:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:10:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08: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:05:00 ***Handling a Difficult Customer*** Getting Started 00:05:00 The Right Attitude Starts with You 00:25:00 Stress Management (Internal Stressors) 00:35:00 Stress Management (External Stressors) 00:25:00 Transactional Analysis 00:25:00 Why are Some Customers Difficult 00:25:00 Dealing with the Customer Over the Phone 00:35:00 Dealing with the Customer In Person 00:25:00 Sensitivity in Dealing with Customers 00:30:00 Scenarios of Dealing with a Difficult Customer 00:15:00 Following up With a Customer Once You Have Addressed Their Issue 00:12:00 Wrapping Up999 00:07:00 ***Retail Customer Service*** Introduction To Retail Customer Service 00:15:00 Understanding Customer Expectations 00:10:00 Customer Value And Satisfaction 00:15:00 Customer Service And Customer Satisfaction In Retailing 00:10:00 Importance of measuring customer satisfaction 00:20:00 Strategic Management 00:30:00 Types of Decision making Process 00:15:00 Provide Customer Service Excellence To The External Customer 00:30:00 Provide Customer Service Excellence To The Internal Customer 00:10:00 Standards of Performance 00:30:00 The Retail Marketing Mix 00:30:00 Levels Of Customer Satisfaction 00:15:00 Brand Loyalty 00:15:00 Customer Satisfaction Questionnaire 00:15:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

You can increase your understanding of various tools in Word 2016 by completing this Word 2016 Intermediate course. You will learn how to manage and view data in Word. This skill will help you gain new career opportunities upon completion. In this Word 2016 Intermediate course, you will be able to confidently work with styles, create templates and more. This course will teach you how to use specific features such as charts and applying columns. Learn how to easily modify columns, collaborate with others and work with pictures by taking this course. You can also practice what you learn throughout the course. Word 2016 Intermediate is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Word 2016 Intermediate is packed with 58 modules and 4 hours, 46 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

This course will introduce you to the basics of Word 2016. By completing this Word 2016 Introduction course, you will have skills to stand out from the crowd. You will learn how to create and manage documents in Word. You will learn how to add data, graphs and charts to documents. In this Word 2016 Introduction course, you will be able to confidently enhance documents. This course will teach you how to use specific features such as photo editing and page breaks. Learn how to easily modify margins, proofread documents and print word documents by taking this course. You can also practice what you learn throughout the course Word 2016 Introduction is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Word 2016 Introduction is packed with 82 modules and 4 hours, 32 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

This Word 2016 Advanced course will take you through key tools in Word 2016. You will learn about working with master documents, tables and more. If you are interested in becoming an advanced level Word 2016 user, then this course is for you. You will be able to create forms and long documents. Upon completion, you will understand how to use various functions and tools in Word 2016. This course will guide you through working with mail merge, automating and using the outline tool function. To finalise what you have learned, you will have the chance to complete an assessment. MS Word 2016 Advanced is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our MS Word 2016 Advanced is packed with 70 modules and 2 hours, 40 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Enrol in this Nonprofit Training Courses for Staff, Boards, and Volunteers bundle and earn free certificates in 21 subjects, including Grant Writing, Fundraising, Charity Accounting, Bid Writing, Digital Marketing, Ethical Leadership, Team Management Skills, and many more!