3111 Microsoft courses

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Description OneNote online is a part of the Office 365 suite apps that assist to take free notes from drawings, links, and implanted files. A OneNote notebook is assimilated to multi-subject notebook that contains sections and pages. Interestingly, all of the works are automatically saved in OneNote. The MS OneNote Online course precisely implements the concept of MS Office 365 suite to make a clear functioning idea to his learner about OneNote and how it works effectively. The course shows how it incorporates text, images, web content, rooted objects, tables, and many other things. It also teaches the student how to share and print the document from OneNote Online Notebook. At the end of the course, the learner can learn the all effective aspects and use of OneNote Online Notebook and can implement their learning knowledge reliably. 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 OneNote Online is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS OneNote Online is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:02:00 Working with OneNote Overview of OneNote 00:04:00 Creating a New Notebook 00:05:00 Navigating in OneNote 00:05:00 Adding Sections and Pages 00:06:00 Adding Content 00:08:00 Formatting Content 00:05:00 Using Tags 00:05:00 Using Search 00:04:00 Using Print and Sharing Options 00:05:00 Using Immersive Reader 00:05:00 Conclusion Course Recap 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Excel Pivot Tables, Pivot Charts, Slicers, and Timelines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 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 Excel Pivot Tables, Pivot Charts, Slicers, and Timelines. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables, Pivot Charts, Slicers, and Timelines is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 15 lectures • 01:21:00 total length •Getting started with your Pivot Table: 00:04:00 •Drill Down: 00:01:00 •Managing the Field List: 00:02:00 •Changing the Calculation type with Value Field Settings: 00:06:00 •Growing your Pivot Table with Multiple Fields: 00:04:00 •Formatting the Pivot Table: 00:05:00 •Sorting and Filtering the Pivot Table: 00:03:00 •Creating a Dashboard with Slicers, Timelines and Pivot Charts: 00:09:00 •Reporting by day, month, qtr, or year within the Pivot Table: 00:04:00 •Refreshing the Pivot Data with new data: 00:03:00 •Adding your own calculations into the Pivot Table: 00:03:00 •The power of the Filter Section in the Pivot Table: 00:04:00 •PowerQuery: 00:12:00 •PowerPivot: 00:21:00 •Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines: 00:00:00

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill 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 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner 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 Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

Duration 5 Days 30 CPD hours Overview Upon completing this course, you will be able to meet the following objectives: SD-WAN Overview Cloud Concepts Cloud Technologies SD-WAN Direct Cloud Access (DCA) SD-WAN SaaS Cloud On-RAMP for IAAS (AWS) Cloud On-RAMP for IAAS (AZURE) Cloud Configuration for GCP Cloud On-RAMP for MULTI-CLOUD Cloud On-RAMP for CO-LOCATIONS This is a 5 day hands-on course on Cisco SD-WAN Cloud Configuration, Monitoring and Troubleshooting. This course provides the student with the knowledge to connect SD-WAN to SaaS Applications, as well as the ability to connect their Branches to AWS, AZURE, GCP Data Centers in the Cloud. Students will also learn how to Configure, Monitor, and Troubleshoot SD-WAN Co-Locations and SD-WAN Multicloud. SD-WAN Overview SD-WAN Controller SD-WAN WAN Edges supported in Cloud Instances Cloud Concepts Cloud Ops vs WAN Ops Cloud Connectivity Cloud Access Control Cloud Network Connectivity Cloud Regions Cloud Availability Zones Virtual Networks Cloud Routing Internet Gateways VS VPN Gateways VPC/VNET: IP Addressing Cloud Network Load Balancing Cloud Peering Cloud Transit Networks Cloud Technologies Azure Azure Basics Resource Groups vNets Availability zones Availability Set Workload and Public IP Network Virtual Appliance Load Balancer User Defined Routes Network Security Group VPN Gateway Express Routes Creating VNET for SDWAN AWS AWS Basics Region VPCs Availability zones Subnets EC2 Instance Elastic IPs Security Groups Internet Gateway NAT Gateway Route Table VPN Gateway Direct Connect Elastic Load Balancer Subscribe to Amazon machine images Setting AWS resource limits AWS Transit Gateways Creating VPC for SDWAN AWS IAM Role AWS Security Groups Service limits AWS SSH key pair Google Cloud GCP Basics Project Region Virtual Private Cloud Availability Zone Subnets Compute Engine Cloud Load Balancer Cloud DNS VPC Routing Cloud VPN & VPC peering VPC Firewall Rules SD-WAN Direct Cloud Access (DCA) DCA Prerequisites DNS on VPN 0 DIA Central Policy Configuration Match Traffic Set QOS Set External Access SD-WAN SaaS Supported Platforms and Versions SaaS Prerequisites DNS on VPN 0 DIA SaaS Access Methods Cloud Access through Direct Internet Access Links Cloud Access through a Gateway Site Hybrid Approach Supported SaaS Applications SaaS Security Options SaaS Configuration Common Scenarios for Using Cloud onRamp for SaaS Specify Office 365 Traffic Category Enable Cloud onRamp for SaaS, Cisco IOS XE SD-WAN Devices Configure Applications for Cloud onRamp for SaaS Using Cisco vManage Configure Sites for Cloud onRamp for SaaS Using Cisco vManage View Details of Monitored Applications Cloud On-RAMP for IAAS (AWS) Prerequisite AWS Configuration Verify prerequisites Configure AWS for Cisco SD-WAN Cloud On-RAMP for AWS Overview Define WAN Edge Type used Define Template Attach Devices to Template Deploy Cloud Onramp AWS IAM Role Select Region Select CPU and Memory Transit Networking IP Addresses Discover and Map Host VPCs AWS to SD-WAN Security Monitor Cisco Cloud Onramp for AWS Troubleshoot Cisco Cloud Onramp for AWS Interconnecting Cisco SD-WAN with AWS Transit Gateway (TGW) Cloud On-RAMP for IAAS (AZURE) Prerequisite AZURE Configuration Cloud On-RAMP for AZURE Configure AWS for Cisco SD-WAN Define WAN Edge Type used Define Template Attach Devices to Template Deploy Cloud Onramp Select Region Discover and Map Host VPCs Monitor Cisco Cloud Onramp for Azure Troubleshoot Cisco Cloud Onramp for AZURE Azure Virtual Wan (VWAN) Integration Cloud Configuration for GCP Prerequisite GCP Configuration SD-WAN Configuration Configure Google Cloud for SD-WAN Google Cloud GCP Basics Deploy cEdge Catalyst 8000V Edges Setup IPSEC Connections Setup BGP Connections Cloud On-RAMP for MULTI-CLOUD AWS Transit Gateway Microsoft vWAN Create Cisco Cloud GW Discover host VPCs/VNets Map Branch nets to VPCs Cloud On-RAMP for CO-LOCATIONS SD-WAN CO-LOCATIONS Overview Colocation facilities Cisco Colocation Equipment Cisco Cloud Services Platform 5444 Cisco Network Function Virtualization Infrastructure Software (NFVIS) Virtual Network Functions Network Fabric Cisco Catalyst 9500-48Y4C switch Cisco Catalyst 9500-40X switch Device Configuration and Connectivity Sizing the Colocation Solution Devices Cisco Colocation Manager Deploy Network Services at the Network Edge Colocation Solution?Deployment Workflow Monitor Cisco SD-WAN Colocation Devices Cisco Colocation Manager States for Switch Configuration Cisco Colocation Manager States and Transitions from Host Cisco Colocation Manager Notifications VM Alarms Cloud Services Platform Real-Time Commands Colocation High Availability Troubleshoot Cisco SD-WAN Cloud onRamp for Colocation Solution Troubleshoot Catalyst 9500 Issues Troubleshoot Cloud Services Platform Issues DHCP IP Address Assignment Troubleshoot Cisco Colo Manager Issues Troubleshoot Service Chain Issues Troubleshoot Physical Network Function Management Issues Log Collection from CSP Troubleshoot vManage Issues Additional course details: Nexus Humans Cisco SD-WAN Cloud (SDWAN-CLD-CT) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco SD-WAN Cloud (SDWAN-CLD-CT) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview Getting Results with PowerBI Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Getting Results with PowerBI Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Getting Results with PowerBI Module 01: Tour of the screen 00:04:00 Module 02: Pulling in your data from different sources 00:12:00 Module 03: Creating your first Visual 00:09:00 Module 04: Building a visual from 2 tables 00:08:00 Module 05: Slicers 00:07:00 Module 06: Making a Combo Chart Visual 00:06:00 Module 07: Using PowerQuery to restructure the data 00:04:00 Module 08: Creating Map Visuals 00:03:00 Module 09: Creating a report by Year, Qtr, or Month 00:04:00 Module 10: Calculating % of total 00:02:00 Module 11: Creating your own Calculation 00:05:00 Module 12: Decomposition Tree Visual 00:02:00 Module 13: Pulling it all together 00:09:00 Assignment Assignment - Getting Results with PowerBI 00:00:00

This course first equips you with the fundamentals of Python and then progresses to teach you how to use various libraries such as NumPy, Pandas, Seaborn, Bokeh, and so on. This course contains several mini projects so that, by the end of this course, you will be equipped with the essential tools you need to become a visualization expert.

Overview This comprehensive course on ASP.Net MVC and Entity Framework will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ASP.Net MVC and Entity Framework 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 ASP.Net MVC and Entity Framework. It is available to all students, of all academic backgrounds. Requirements Our ASP.Net MVC and Entity Framework 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 5 sections • 22 lectures • 06:17:00 total length •Module 01: Install Visual Studio Community Edition: 00:02:00 •Module 02: Create ASP.Net MVC Project: 00:04:00 •Module 03: Setup Database: 00:06:00 •Module 04: Add Entity Framework Data Model: 00:06:00 •Module 05: Tour of Folder Structure and How to Add Views: 00:23:00 •Module 06: Scaffolding: Adding Controller and Views: 00:35:00 •Module 07: Managing Database Changes: 00:14:00 •Module 08: Customizing a View - Bootstrap: 00:20:00 •Module 09: Customizing a View - Additional Data: 00:09:00 •Module 10: Add Data Validations to Forms: 00:31:00 •Module 01: Understanding Authentication Functionality: 00:05:00 •Module 02: Adding User Data Points: 00:30:00 •Module 03: Control User Access: 00:07:00 •Module 04: Adding Roles and Authorizations: 00:37:00 •Module 01: Add Project to GitHub: 00:12:00 •Module 02: Understanding Package Management: 00:08:00 •Module 01: Add Lecturer and Enrollment Management Modules: 00:14:00 •Module 02: Install JQueryUI Javascript Libraries: 00:12:00 •Module 03: Implement JQueryUI Autocomplete: 00:35:00 •Module 04: Create an JQuery/Ajax Form: 00:34:00 •Module 05: Partial View and Data Refresh: 00:33:00 •Resources - ASP.Net MVC and Entity Framework: 00:00:00

Overview With the ever-increasing demand for Power BI in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Power BI may be. Learning about Power BI or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Power BI . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Power BI is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Power BI course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Power BI course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Power BI course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Power BI , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Power BI , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Power BI , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Power BI course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 01 Introduction to Power BI Desktop Introduction to Power BI Desktop 00:00 Module 02 Discovering and Loading File-Based Data With PowerBI Desktop Discovering and Loading File-Based Data With PowerBI Desktop 00:00 Module 03 Loading Data From Databases and Data Warehouses Loading Data From Databases and Data Warehouses 00:00 Module 04 DirectQuery and Connect Live DirectQuery and Connect Live 00:00 Module 05 Loading Data from the Web and the Cloud Loading Data from the Web and the Cloud 00:00 Module 06 Dealing with Datasets Dealing with Datasets 00:00 Module 07 Data Transformation Data Transformation 00:00 Module 08 Data Mashup Data Mashup 00:00 Module 09 PowerBI.com PowerBI.com 00:00