59270 Courses

Learn the art of leatherwork in a fun, empowering space. Create unique, stylish pieces while connecting with like-minded women. Craft, create, and take home something truly special!

How to overcome lust and live a life of purity.

A three-day course of videos to give you a taste of Vinyasa yoga. The videos include a full-body vinyasa flow, core strength yoga and eagle pose

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     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

My personal steps on how I built my beauty business from my nan's conservatory to my own salon in months!

Duolingo Test Preparation

Want to learn everything about Python, from installing to coding, with a liberal does of fun sprinkled into the learning? Then, this Python Programming Tutorials For Beginners is what you need.

The Birth of the Industrial Revolution in Britain 1707 to 1830   Course Description   Introduction The Industrial Revolution started in Britain in the eighteenth century. A number of factors converged to create the conditions for developments in industry and science. Agricultural improvements created a cadre of wealthy landowners with money to invest. Improved educational opportunities, particularly in Scotland, created a broader set of young people with ideas and ambition. Greater religious freedom allowed individuals of talent to develop businesses. Interest in science and technology blossomed and the birth of the coffee house culture brought people with ideas into the orbit of those with money. But it was not all rosy. The new culture of ideas and experimentation was almost entirely limited to men. A woman’s place was seen to be in the home. At the same time the slave trade flourished providing much of the wealth for investment and, shamefully, Britain was a key facilitator in this odious business – and there were few voices of dissent at the time. And the poor lived short and brutish lives of hard physical work in grim conditions with an inadequate diet and very little healthcare. In this course I am going to take you through the key milestones of the early industrial revolution – in the textile industry, in coal mining and iron production, in civil engineering; in the development of steam power and the birth of the railways.     Course Pre-Requisites There are no course pre-requisites.     What Students will Learn The history of the industrial revolution in Britain from 1707 to 1830 The factors that created the conditions for the industrial revolution Developments in the textile industry in the eighteenth century The development of steam as a source of power The birth of steam locomotion Developments in coal, coke and iron Civil engineering in the eighteenth century Scientific developments in the eighteenth century     Curriculum SS1 The Birth of the Industrial Revolution 6 mins SS2 The Textiles Revolution 13 min SS3 The Birth of the Steam Engine 10 mins SS4 The Age of Steam Locomotion 14 mins SS5 Fuelling the Industrial Revolution 10 mins SS6 The Engineering Revolution 6 mins SS7 The Scientific Revolution 18 mins SS8 Black Lives during the Industrial Revolution 5 mins SS9 The Birth of the Industrial Revolution 2 mins SS10 The Industrial Revolution History Quiz 19 mins   Total time: 1 hour 44 minutes     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in finance processes. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

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