47321 Courses

Duration 1 Days 6 CPD hours This course is intended for This course is intended for SharePoint administrators who work in a Windows network environment. At least one year of experience managing SharePoint servers and using PowerShell is recommended. Overview At Course Completion?Configure SharePoint Servers using PowerShell?Manage SharePoint Server Administration with PowerShell?Manage SharePoint Server Maintenance with PowerShell This course provides students with the knowledge and skills needed to use PowerShell to administer SharePoint Servers. Students will learn how to manage day-to-day and automated tasks carried out by SharePoint Administrators. Install and Configure SharePoint Servers with PowerShell Overview Preparing the Server Configure Server Features Configure Prerequisite Applications Install SharePoint Software Configure SharePoint Farm Review Lab 1: Configure SharePoint Servers with PowerShell Administering SharePoint Servers with PowerShell Overview Administering Users and Groups Administering the Farm Administering Shared Services & Features Administering Sites Administering Databases Review Lab 1: Administering SharePoint Servers with PowerShell Maintaining SharePoint Servers with PowerShell Overview Managing Backups / Restores Monitoring and Auditing Managing Notifications Scheduling Tasks Review Lab 1: Maintaining SharePoint Servers with PowerShell

Duration 5 Days 30 CPD hours This course is intended for This course is intended for administrators in a Microsoft-centric environment who want to build reusable units of automation, automate business processes, and enable less-technical colleagues to accomplish administrative tasks. Overview Describe the correct patterns for building modularized tools in Windows PowerShell Build highly modularized functions that comply with native PowerShell patterns Build controller scripts that expose user interfaces and automate business processes Manage data in a variety of formats Write automated tests for tools Debug tools This course covers advanced Windows PowerShell topics, with an emphasis on building reusable tools. Students are introduced to workflow, engage in best practices, and learn a variety of script development and toolmaking techniques. Tool Design Tools do one thing Tools are flexible Tools look native Start with a Command Why start with a command? Discovery and experimentation Build a Basic Function and Module Start with a basic function Create a script module Check prerequisites Run the new command Adding CmdletBinding and Parameterizing About CmdletBinding and common parameters Accepting pipeline input Mandatory-ness Parameter validation Parmeter aliases Emitting Objects as Output Assembling information Constructing and emitting output Quick tests An Interlude: Changing Your Approach Examining a script Critiquing a script Revising the script Using Verbose, Warning, and Informational Output Knowing the six channels Adding verbose and warning output Doing more with verbose output Informational output Comment-Based Help Where to put your help Getting started Going further with comment-based help Broken help Handling Errors Understanding errors and exceptions Bad handling Two reasons for exception handling Handling exceptions in our tool Capturing the actual exception Handling exceptions for non-commands Going further with exception handling Deprecated exception handling Basic Debugging Two kinds of bugs The ultimate goal of debugging Developing assumptions Write-Debug Set-PSBreakpoint The PowerShell ISE Going Deeper with Parameters Parameter positions Validation Multiple parameter sets Value from remaining arguments Help messages Aliases More CmdletBinding Writing Full Help External help Using PlatyPs Supporting online help ?About? topics Making your help updatable Unit Testing Your Code Sketching out the test Making something to test Expanding the test Going further with Pester Extending Output Types Understanding types The Extensible Type System Extending an object Using Update-TypeData Analyzing Your Script Performing a basic analysis Analyzing the analysis Publishing Your Tools Begin with a manifest Publishing to PowerShell Gallery Publishing to private repositories Basic Controllers: Automation Scripts and Menus Building a menu Using UIChoice Writing a process controller Proxy Functions A proxy example Creating the proxy base Modifying the proxy Adding or removing parameters Working with XML Data Simple: CliXML Importing native XML ConvertTo-XML Creating native XML from scratch Working with JSON Data Converting to JSON Converting from JSON Working with SQL Server Data SQL Server terminology and facts Connecting to the server and database Writing a query Running a query Invoke-SqlCmd Thinking about tool design patterns Design tools that use SQL Server for data storage Final Exam Lab problem Break down the problem Do the design Test the commands Code the tool

Tiny toes ballet is award winning and fully integrated with the Early Years Foundation Stage (EYFS) curriculum. It is the perfect introduction to the world of dance for boys and girls from walking to age 7. Our fun and inclusive toddler and kids dance classes nurture confidence and promote educational development. With our themed adventure sessions, they are so much more than a dance class and we are so excited to share them with you! Let your child discover the joy of dance with us whilst learning about the world around them!

Learn the basics of makeup artistry and build a solid foundation in sanitation, contouring, eye makeup, and special effects. You will get to know about the latest tools, learn about color theory, and gain skills that translate directly into creating bridal, brow, and lip makeup. Enhance your professional portfolio and show your talent to the world!

[Updated 2022] Microsoft Excel 2019: from ZERO to ADVANCED Working knowledge of Excel is vital for most office-based professionals today, and stronger Excel skills can open the door to jobs, promotions, and leadership opportunities. For example, if basic SUM and AVERAGE functions can help businesses calculate and analyse data better and quicker, think about how much more efficient advanced functions can make you. And to make you efficient and better at work, our Microsoft Excel experts have designed this Microsoft Excel course. Curriculum Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel Templates Learning Outcomes By the end of this course, you'll learn the following skills: Perform various calculations and get results in seconds rather than doing them manually Gain the ability to modify and format worksheets and learn to print and manage workbooks Learn various functions and how to work with lists Become an expert on data analysis 2019 features Learn to use visual elements like charts and data visualisation to see and understand trends, outliers, and patterns in data How to present data using PivotTables and PivotCharts as well as working with multiple worksheets and workbooks Using lookup functions and formula auditing, sharing and protecting workbooks, automating workbook functionality How to forecast data, create sparklines and mapping, usage of various Microsoft Excel templates Key Features of the Microsoft Excel Course : Accredited by CPD Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Accreditation All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed the course. *** Additional Gifts *** Free Life coaching Course This Microsoft Excel Skills course is designed for people with a career in Accounting, Finance, Marketing, Sales, Executive, Administration, Business Management, Manager, Human Resources, Customer Service, Assistant, and Reception. In this course, we will go in-depth into Microsoft Excel applications, which are delivered in a simple way to be understood. CPD 15 CPD hours / points Accredited by CPD Quality Standards Career path No matter where you are or what you do, if you are working with digital data, having Microsoft Excel skills is a must. With skills, you can explore opportunities everywhere, including- Administrative Assistant Accountants Retail Manager Cost Estimator Financial Analyst Project Manager Business Analyst Data Journalist And much more! Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Elevate your administrative prowess with our Administrative Assistant course. Learn to manage daily routines, communication, records, and office technology effectively. Become the organizational backbone in any professional setting with top-tier relationship and conflict management skills.

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

I'm delivering a short intro to the full Inspired Excellence programme called 1st Step to Excellence, on Friday, 9th February from 9:30 - 11am, where I'll share information about the program, answer your questions and whet your appetite with a couple of techniques that you and your children can start using straight away to 'train your brain'!

Explore the laws of the universe with this Cambridge self-paced course from Spark Generation! You will have the flexibility to learn when and where you want, as the course is one click away.

Explore the laws of the universe with this self-paced course from Spark Generation! From mechanics to electromagnetism, learn more about the world of matter and energy. This self-paced course guides you through real-world applications, experiments, and problem-solving exercises. Join us to unravel the mysteries of the physical world!