3142 Microsoft courses in Lowestoft delivered Online

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum You Can Master Microsoft Outlook You Can Master Microsoft Outlook Promo 00:02:00 You Can Ask Me Anytime 00:01:00 Your Facebook Support Group 00:01:00 Quick Win - How To Send an Email in Outlook 00:01:00 Quick Win - How To Print an Email in Outlook 00:01:00 Another Quick Win - You Can Work Offline With Outlook 00:01:00 Getting Started With Outlook Outlook Environment 00:03:00 Outlook Opening 00:02:00 Outlook Interface Options 00:04:00 Sending and Receiving Email in Outlook 00:03:00 Sending and Receiving Email in Outlook with Attachments 00:02:00 File Menu Account Settings in Outlook 00:06:00 Automatic Replies in Outlook 00:04:00 Mail Box Settings in Outlook 00:02:00 Rules and Alerts Settings in Outlook 00:04:00 Exporting and Importing Rules and Alerts in Outlook 00:01:00 Opening Options in File Outlook 00:04:00 Home - New Email in Outlook Quick Win - How To Create Folder in Outlook 00:01:00 Quick Win - How To Change Outlook Style 00:01:00 Quick Win - How To Use Quick Access Toolbar 00:01:00 New Email Options in Outlook 00:03:00 Clipboard in New Email 00:05:00 Basic Text in New Email 00:07:00 Name, Include and Tags in New Email 00:03:00 Inserting Table Into New Email 00:10:00 Inserting Images Into New Email 00:10:00 Inserting Shapes Into New Email 00:06:00 Inserting SmartArt Into New Email 00:04:00 Inserting New Chart Into New Email 00:05:00 Taking Screenshot Into New Email 00:02:00 Links, Text and Symbol 00:03:00 Themes, Show Fields, Encrypt, Tracking and More Options in New Email 00:03:00 Formatting Text in New Emails 00:03:00 Text Style in New Email 00:04:00 Reviewing Menu in New Email 00:03:00 Home - New Appointment New Appointment at Home Menu 00:06:00 Home - New Meeting New Meeting at Home Menu 00:01:00 Home - New Contact New Contact in Home Menu 00:05:00 Home - New Task Create New Task 00:03:00 Other New Item in Home 00:02:00 Home - Other Functions Email Deletion in Outlook 00:02:00 Responding to A Email in Outlook 00:02:00 Quick Steps, Tag and Other Functions 00:03:00 Send and Receive Complete Guide of Send and Receive 00:03:00 Home - Folder Complete Folder Guide 00:05:00 Review and Outlook View and Help in Outlook 00:04:00 Options Options Intro 00:03:00 General Options in Outlook 00:05:00 Mail Options in Outlook 00:06:00 Calendar Options in Outlook 00:03:00 Contact Options in Outlook 00:01:00 Task Options in Outlook 00:01:00 Search Options in Outlook 00:02:00 Language Options in Outlook 00:02:00 Ease of Access Options in Outlook 00:02:00 Advanced Option in Outlook 00:04:00 Ribbon and Quick Access Toolbar Customization 00:02:00 Security Is Everything Quick Win - Create Unknown Password 00:01:00 Security Is Everthing 00:01:00 Quick Win - Insecurity Is Coming from You And Others 00:01:00 Understand Security Type or Category 00:02:00 Life Savers - You Should Know These 00:04:00 Have Proper Password - Start Securing You Now 00:03:00 Don't Use the Same Password Anymore 00:02:00 Should You Use Longer Password or Complicated! 00:03:00 Last-Pass & Authy Mobile App 00:02:00 The Best and Only Solution to Make and Keep Password Un-Crack-Able 00:08:00 Lastpass Setup and Configure 00:10:00 Last-Pass Options Part 1 00:03:00 Last-Pass Options Part 2 00:04:00 Last-Pass Option Part 3 00:04:00 2FA Makes You Even Stronger in Password 00:05:00 Security Is Everything, Keep Secured Your Devices 00:07:00 Security on Your Data and Privacy 00:08:00 Conclusion Congratulations 00:01:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

In this course, you will learn how to create your own Azure Functions apps and visualize how full applications can be built using Azure Functions. We will also explore the tools needed to support development, both locally and in the Azure portal, and explore the different triggers, bindings, and deployment models that are possible.

Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK. Learning Outcomes Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface. Develop proficiency in advanced data transformation techniques and data model creation. Integrate Python with Power BI and harness the benefits of both for enhanced data analytics. Master the art of 'Storytelling with Data' to deliver impactful presentations and reports. Understand and implement Row-Level Security and harness Power BI Cloud services efficiently. Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for? Individuals keen on obtaining the Microsoft power bi certification UK. Analysts and data professionals aspiring to enhance their data visualisation skills. Business professionals wanting to leverage Power BI for insightful business decision-making. Tech enthusiasts aiming to amalgamate programming (Python) with data analytics. Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities. Career path Data Analyst: Average Salary £30,000 - £40,000 Annually Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually Power BI Developer: Average Salary £40,000 - £50,000 Annually Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually Prerequisites This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:03:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 00:00:00 Assignment Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Duration 0.625 Days 3.75 CPD hours This course is intended for This course is intended for individuals who want to gain basic knowledge of Windows 10 and Microsoft Office. Course Outline Introduction to the Windows 10 Desktop Managing Files and Folders in Windows 10 Word 2016 Ribbon and Navigation Excel 2016 Ribbon and Navigation PowerPoint 2016 Ribbon and Navigation Outlook 2016 Email/Calendar/Contacts Basics (lecture/demo only)

Advanced Microsoft Excel Training Course on Bookkeeping Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Introduction Introduction 00:02:00 PowerShell Basic Introduction PowerShell Introduction 00:05:00 PowerShell Console (PowerShell ISE, VS Code) 00:05:00 PowerShell Useful Commands (Get-Help) 00:04:00 PowerShell Useful Commands (Get-Command) 00:01:00 PowerShell Useful Commands (Get-Module) 00:03:00 Visual Studio Code Editor Initial Setup Visual Studio Code Setup 00:02:00 VS Code Interface & Install PowerShell Ext 00:03:00 Write & Test PowerShell Script 00:02:00 Connect To Azure Active Directory through Powershell Azure Active Directory Introduction 00:04:00 Prerequisite & Install AZURE AD PS Module 00:03:00 Connect to Azure AD PowerShell with Microsoft Office 365 Subscription 00:04:00 Install All Office 365 Service's Module (To Prepare All-in-one Scripts) 00:03:00 All-In-One PowerShell Script To Connect All M365 Services 00:09:00 Administration Of Microsoft Office 365 User Accounts View Microsoft Office 365 User Accounts 00:05:00 Create Single Microsoft Office 365 User Account 00:09:00 Create Multiple Microsoft Office 365 User Accounts 00:04:00 Modify Microsoft Office 365 User Account Properties 00:08:00 Delete Microsoft Office 365 User Accounts 00:03:00 Block Microsoft Office 365 User Accounts 00:02:00 Administration Of Microsoft Office 365 Licenses And Service View M365 Licenses Details 00:04:00 View M365 License's Services Details 00:03:00 Assign Licenses to Single User Account (Older AzureAD Module) 00:02:00 Assign Licenses to Multiple User Account 00:02:00

Microsoft Office 365 is an innovative computer program and highly suggested for individuals who are regularly on the go. This Office 365 Core Apps course introduces you to the Microsoft Word, Excel, and PowerPoint Online apps which are an integral part of the Office 365 suite. By enrolling in this course, you'll acquire essential skills for producing professional work with the Microsoft Office suite and access many of the Office tools and features online from any device with an Internet connection. This course includes both basic and advanced features of MS Office and explains the difference in the online versions of Word, Excel, and PowerPoint, and how to edit the online documents. You'll also learn to open and save online documents in desktop versions of Office products. What Will I Learn? Open and save online files in Office Edit documents in Office Online Learn what is different in Microsoft Word, Excel, and PowerPoint Online View and add comments to documents Print and share documents Use co-authoring for collaboration Requirements Familiarity with the desktop versions of Microsoft Word, Excel, and PowerPoint Introduction Introduction FREE 00:02:00 Working with Word, Excel, and PowerPoint Online Opening Files in Office 00:06:00 Saving Files 00:04:00 Editing Documents in Office Online 00:04:00 What is Different in Word? 00:05:00 What is Different in Excel? 00:05:00 What is Different in PowerPoint? 00:06:00 Viewing and Adding Comments 00:07:00 Printing and Sharing Documents 00:06:00 Using Co-Authoring for Collaboration 00:04:00 Course Recap 00:01:00 Course Certification

Duration 3 Days 18 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. Use advanced analysis techniques. Enhance reports and dashboards. Publish and share reports and dashboards. Extend Power BI beyond the desktop. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Using Advanced Analysis Techniques Topic A: Create Calculated Tables, Variables, and Parameters Topic B: Enhance Visuals with Statistical Analysis Topic C: Perform Advanced Analysis Enhancing Reports and Dashboards Topic A: Enhance Reports Topic B: Enhance Dashboards Publishing and Sharing Reports and Dashboards Topic A: Publish Reports Topic B: Create and Manage Workspaces Topic C: Share Reports and Dashboards Extending Power BI Beyond the Desktop Topic A: Use Power BI Mobile Topic B: Extend Access with the Power BI API Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) 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 Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) 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.

Microsoft Azure is an ever-expanding set of cloud services to help your organization meet your business challenges. It's the freedom to build, manage, and deploy applications on a massive, global network using your favorite tools and frameworks. If you are an administrator, developers, or database administrators then this Azure - Introduction will be beneficial for you. Learn the fundamentals of working in a Microsoft Azure environment to help improve your business. The Azure - Introduction will help you get started with Microsoft Azure technologies such as infrastructure, virtual machines, virtual networking, identity, and storage. You will learn how Microsoft Azure can help you build and manage your business's applications and cloud services and help improve overall business productivity. You will learn the procedures of managing Azure from the Classic, New Portal and Azure PowerShell. You will know the steps of authenticating Azure PowerShell. You will also learn various types of cloud services along with the Microsoft Azure. What Will I Learn? Understand the Cloud Learn about the different types of Cloud services Understand Azure services Learn about Azure PowerShell and authenticating Azure PowerShell Requirements This course is suggested for It-related professionals that possess limited/no knowledge of cloud technologies and would like to become familiar with Microsoft Azure. Basic computer skills are required. Basic computer skills are required. Familiarity with the concept of cloud computing and storage is helpful, but not required. Introduction Introduction FREE 00:03:00 Overview of Cloud Services What is the Cloud 00:03:00 Types of Cloud Services 00:04:00 Azure Data Centers 00:03:00 Setting up a Free Trial 00:04:00 Azure Service Overview Compute Services 00:02:00 Networking 00:02:00 Storage 00:02:00 Data and Analytics 00:02:00 Web and Mobile 00:03:00 Miscellaneous 00:02:00 Azure Deployment Models 00:06:00 Azure Management Interfaces 00:02:00 Azure Portal 00:06:00 Azure Powershell 00:07:00 Conclusion Course Recap 00:02:00 Course Certification

Learn to effectively monitor the performance, health, and availability of Azure Services and your cloud resources