• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3835 Courses delivered Online

Adventures in Excel

By Ideas Into Action

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

Adventures in Excel
Delivered Online On Demand
£4.99

New Excel Functions

By Ideas Into Action

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

New Excel Functions
Delivered Online On Demand
£4.61

LEVEL 1: IN WHAT WAYS DO WE DISCRIMINATE? DISCRIMINATION INCLUSION PROFILES

By Six Stages Diversity Framework

These events are designed to introduce the BOOK & basic ideas behind Understanding & Dealing with Everyday Racism The Six Stages Framework

LEVEL 1: IN WHAT WAYS DO WE DISCRIMINATE? DISCRIMINATION INCLUSION PROFILES
Delivered OnlineFlexible Dates
FREE

PODCAST DISCUSSION: "IF RACISM WAS A VIRUS" THE SIX STAGES FRAMEWORK

By Six Stages Diversity Framework

These events are designed to work on the ideas introduced in Level 1: Understanding & Dealing with Everyday Racism The Six Stages Framework

PODCAST DISCUSSION: "IF RACISM WAS A VIRUS" THE SIX STAGES FRAMEWORK
Delivered OnlineFlexible Dates
FREE

The Life Garage

By Metanoeo Coaching and CIC

The Life Garage - you service your car so why not your life? Skills, tools and ideas for living life well.

The Life Garage
Delivered Online On Demand
FREE

Educators matching "Ideas"

Show all 1087
Battle Of Ideas

battle of ideas

London

The UK's premier festival of ideas, produced by the Academy of Ideas. Join us at this year's festival at Church House, London, on Sat 15 & Sun 16 October.From the cost-of-living crisis to the war in Ukraine, and from culture wars to institutions in meltdown, this has been a year of enormous challenges. The death of Queen Elizabeth II marks both the end of an era and of an important connection with the past. In just a few days in September, we had both a new prime minister and a new king. Yet our political leaders – only recently in some turmoil themselves – don’t seem up to the task, and many people feel like their voices aren’t being heard. We need to get beyond lurching from one emergency to another and start moving society forward. We must understand how we got here, with an eye to shaping a better future. The aim of the Battle of Ideas festival and events is to provide an opportunity to debate the issues in a full and frank manner, bringing together a wide variety of voices and, most importantly, creating a space for everyone to have their say. THE STATE WE’RE IN Rising inflation, falling living standards and eye-watering bills are front and centre of most people’s minds. And after the pandemic, the already-weak institutions of government seem incapable of rising to these challenges. If the failure to prepare for Covid was bad enough, the absence of any meaningful planning on a wide variety of issues – from energy to healthcare, housing to infrastructure – has truly been exposed. We seem to find ourselves in a state of permanent crises – from not being able to get a GP appointment to civil servants revolting against their ministers. Russia’s invasion of Ukraine has thrown into question our previously held assumptions about international relations and shaking up the world order. There is a general feeling of instability, with uprisings in Iran – where women are burning their head scarves in protest against the morality police – and shock election results in both Italy and Sweden. When the Cold War ended, we were told we were at the End of History, that there was no more need for big ideas. There was no alternative to the world envisaged by globalist thinkers: a free market, managed by technocratic experts moving the whole world towards some form of liberal democracy. Recent events have challenged such complacency.