367 Courses in London

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.

This course provides detailed safeguarding adults & children awareness, including essential knowledge in the recognition and reporting of abuse and neglect, procedures and responsibilities. This is for all workforce involved in Social Care from the health, public, independent, or voluntary sectors. This subject forms standard 10 & 11 in The Care Certificate.

Overcome social awkwardness and social anxiety the fast, fun and easier way. DO YOU find yourself drying up or going blank when under pressure, or get tongue-tied when someone makes a smart remark? One of the reasons that you dry up or get tongue-tied – is because you are programmed to go into your head and try to think of something to say. Most of us have become left-brain dominant because of the way we’ve been educated and we don’t know how to activate our powerful and more creative right-brain. This is why the "I Don't Know what to Say" Improvisation Course is so effective at overcoming social difficulties. It gives you access to your spontaneous right-brain, and in fact, enables you to operate from both right and left-brain together. It is probably one of the fastest and most effective ways of building verbal confidence as well as liberating you on all sorts of levels.

Coaching workshop for managers who want to use their coaching capabilities to improve the business performance of their coachees.

2 day Leadership workshop * Pre workshop Leadership diagnostic analyses your current leadership behaviour and impact on business results * Workshop format includes Diagnostic report debrief & planning for change, Leadership Style, Creating and communicating Vision, Goal setting and commitment to achievement, Coaching & Developing Staff, Performance Management, Rewards and Recognition, Teamwork and Motivation, via simulations, discussion and your current real-world issues. *Leadership diagnostic re-measure after 6 months to quantify improvement, change etc.

Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. Course Overview Develop true expertise and learn every aspect of Social Media Marketing across 10 modules of interactive content such as Facebook, LinkedIn, Snapchat, YouTube and Instagram. Gain relevant and deep knowledge of social strategy, research and content from industry skills experts. Become a certified social media marketing specialist: Join over 200,000 members around the world, working for some of the world’s top companies using DMI to keep their careers and skills relevant. 81% of our members have been promoted upon completion of one of our courses and 53% have got a salary increase. Get certified with the DMI SPECIALIST digital marketing certification and become a professional digital marketer. Get world class, specialist knowledge and insight: Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. With 10 modules focused on every aspect of social media marketing, DMI Specialist is the most comprehensive Social Media Course available anywhere. Program learning outcomes and content: What Will I Learn? Get the know-how, experience and the insights to be able to work and speak with authority in this face-paced industry. In short, you’ll be a skilled digital marketer, capable of building digital marketing strategies from scratch. We’ve added 8 new soft skill lessons to give you the most industry ready certification available, anywhere. Who is this for? The DMI Specialist Social is for individuals who are responsible for social media marketing campaigns. This includes: • Digital marketing generalists • Marketing Specialists • Marketing Managers • Content creators • Social media consultants • Individuals pursuing profession in social media marketing. • Anyone who wants a career change Course Content: Social Research: Just who are your audience? What do they do, think, feel, eat, love, hate and ‘like’? And what do they think about you? Knowledge is power. And both knowledge and power are fascinating. This module gives you the research techniques to know your audience, and cultural and industry trends. Every day the very people you want to reach throw up gigantic amounts of data. Without the right tools and thinking, it’s a critical mass of meaningless banality. With the right tools and thinking, you have insight deep into hearts and souls. Delve into these tools and put them to use, including the new Google Analytics 4 platform. Social Content: Facebook kittens. Twitter debates. Instagram filters. People can’t get enough content on social media – so better content means better opportunities. So, what does your audience want to see, like and share? With streamlined planning, clever strategy and targeted scheduling, putting the right content in front of the right people is no longer a shot in the dark! Now, you can create amazing content formats that capture the attention of audiences across all social platforms. You can strategize and plan using cutting-edge tools that make your channels stand out from all the others. This module covers the various content formats across platforms, the power and practice of scheduling content and how you can bring it all together with super strategies. Facebook, Instagram and Pinterest: Facebook, Instagram and Pinterest are powerhouses of the social media world. They provide you and your brand with the chance to interact with your customers across the globe at scale. But, each of them has unique features, analytics, and quirks. The module gives you a deep understanding of how these platforms work, how to make your brand stand out in these different spaces, and why you need a spread of messaging across each to succeed. • Build an active, engaged and captive community across each channel. • Create compelling and clever ads that target your audience at the right time. • Use analytics to understand what your audience is doing. Then tweak your content to resonate in all the right ways. • Master the key features of each channel to advertise, strategize and optimize. • Manage each platform so you get the best reach and results. • Reach billions of social loving people every day! Twitter: Twitter marches to its own drum in the social media world – less post and wait, more what’s happening right now. It’s a platform that allows your audience to see, report and comment on world events in almost real-time. It’s also a place where the audience is young, wealthy and educated. Twitter literally challenges you to be ‘more clever’, and this module shows you how. • What a successful Twitter account looks and acts like. • How to use Twitter Ads Manager to advertise effectively. • The right Twitter Ad format for your campaign. • Using Twitter Analytics to react and connect better. • How to create more Tweet-friendly content – snappy, shareable and short. • When to post for maximum impact and engagement. LinkedIn: This module will introduce you to the platform and show you how to use features such as Company pages and Showcase pages, to create a stellar presence for your company – and gain a deep understanding of what that means on LinkedIn. You will understand the unique advertising features and content formats on offer such as Text ads, Sponsored ads, Sponsored InMails, Display ads, and the aptly named Dynamic ads. See what best practice means on this platform, strategize like a CEO and measure the effectiveness of your campaigns. Linkedin can be a tricky platform to master as the tone is hard to crack. But do Linkedin well and your competitors will be scrambling to copy you! You’ve got this – because we do. YouTube & Social Video: YouTube because you have eyes to see. And a picture speaks a thousand words – and this being social, should inspire a few thousand too. Social video is one of the most awesome tools in your new bag of digital tricks. And video is no longer the preserve of guys with film study degrees. This superpower is now yours, and here we give you all the tech and thought basics to make it happen, including how to set up and manage a YouTube channel and create strategies that don’t treat creativity like a buzzword. Learn how video sits within the rest of your mix across platforms, build your online audience and use advertising and analytics for visual campaigns that mesmerise. • Set up and manage a dynamic YouTube channel. • Get creative with social video strategies that engage and convert. • Learn how video sits within the rest of your social media mix. • Build and develop your online audience in a way that benefits your brand. • Use advertising and analytics to deliver mesmerizing visual. Social Apps: If you’re looking to create a buzz online, then social apps are the place to be. Think fun, engaging, and ‘out of the box’ as that’s what these platforms are made for and audiences flock to them (particularly a young demographic). Discover how to use TikTok, Snapchat, WeChat, WhatsApp, and Twitch to tune into your audience effectively. Take a dive into features and understand how to manage content to make the most of everything you post. You’ll also understand how to advertise on the apps that suit your brand. Plus, take inspiration from the best by seeing what campaigns worked and why, so you can TikTok your way to social success. Social Commerce and Affiliate Marketing: With so many eyes on social media, it pays (literally) to know how to market and sell your products online. Social commerce happens when an astute marketer combines the best of social media with the best of e-commerce. You’ll explore the ins and outs of social commerce along with how to create a successful online shop. The latest tactics and tools will be covered so you can make social buying seamless from the first click to the last. You’ll also explore how to optimize paid commerce activity – including cart abandonment – to get the best results. Looking for a way to earn extra money while you grow? Use your social media to tap into affiliate marketing – a great way to earn commission by promoting another company’s products or brand you admire. When it comes to influencing, social media allows you to think BIG. Tap into the world of social influencers by connecting and collaborating with people that think like you. Or reach out to your influencer crush and shine a light on your brand by getting into their social feed. Social Customer Service: One of the best dynamics of social media is how it manages to be collective – the thoughts of billions – yet also personal (it’s about what I ‘like’). This leaves scope for important personal interaction – meaning social customer service is an opportunity for your brand to stand out. This module examines the customer experience. It looks at how to break your audience down into buyer personas so you know them better – and so serve them better. It shows you which platforms do service best and how. Need a social customer service strategy? – no problem. Want to understand how to manage social customer service effectively? – that’s easy. Not sure how to measure and analyze customer service performance? – well, you will now! This module focuses on your customer’s happiness so you can build a contented online community. An audience that feels connected to your brand, so they’ll tell everyone else how great it really is. Social Strategy: So, you have the skills, tools, followers, know-how, tech, smarts and big ideas. Now learn to tie it all together with cutting-edge social strategies practiced by the world’s leading brands. And work out how your social offering sits with – or carries – the rest of your marketing mix. Here we look at planning a dynamic social media strategy that works for you. We dive into setting objectives and social KPIs so you know what you want and can track how you’re getting there. Social media and content production budgets are also explored so you put your money in the places that work, rather than those that don’t. Turn your social media dream into a reality by crafting a social strategy that lets you and your brand sparkle. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Interior design tutor one to one open 7 days 9 am to 9 pm

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Budgeting is more than mere vague oversight. Budgeting should deliver the corporate strategy, add shareholder value and lead to a well-run business - for the benefit of all involved in it. Effective budgeting leads to real control - effective day-to-day operational control and more. This course demonstrates what proper budgeting and operational control can do. This course will help ensure that participants: Appreciate the importance of the budgeting process Take ownership of it Use it as a daily working tool - not an annual exercise - to help run their part of the operation Improve their reporting against budget Ensure their delivery against budget 1 Objectives of budgets The budget process Stages - what is the prime aim of a budget? What is forecasting? ObjectivesPlanningImplementation 2 Budget and cost control focus Choosing objectives Links with corporate strategy Links with resource management Can the accounting systems cope? 3 Traditional budgeting and control Benefits and drawbacks The process Control and feedback Reporting - what can be expected? 4 Advanced budgeting and control Understanding the business process Taking out costs Cost awareness ZBB - as valid as ever 5 Reports Reports for action The purpose of a report Content - deliverables and feedback Culture is so important