79 Row courses

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Let us privately guide you, photographically and scenically, around Chester to take the best photos of this historic Medieval City. The City walls are the longest, oldest and most complete city walls in the UK and make for an unbroken, elevated tour of the beautiful, photogenic City of Chester.  Our photographic tour of Chester will give you an opportunity to learn more about your camera while making some lasting memories of your trip. We’ll teach you technique on the go while we walk the walls and make stops on the way to dive into the City itself to capture some of the beauty inside the walls. Along the way, we will take in sights from the River Dee to the ancient Chester Rows, from the Victorian Eastgate Clock to Chester Cathedral. The important stuff The tours are 3 hours in length and cost £180 per person. Feel free to add up to 3 extra friends or family for only £85 per person. Tours run at 9am and 1pm, weekdays and weekends.

A full day class where you'll create a couple of pieces of jewellery from silver clay. You'll learn various different techniques and to start your silver clay journey.

Have you always fancied learning to crochet but never found the time or struggled with online tutorials? Our classes are friendly, relaxed and the perfect place to learn. Tea, coffee and biscuits are always included and BYOB is also encouraged - we’ll supply the glasses! Come along and enjoy the basics of crochet in this beginner course delivered over 5 sessions. Class number is limited to 6. Week 1 - Skill building. Learn chains, rows, turning and double crochet. Begin your 1st project. Week 2 - Learn slip stitch and weaving ends as you finish your project. Introduction to 2 new stitches. Week 3 - Make a Granny Square! Week 4 - Make some flowers and learn how to follow a pattern Week 5 - More pattern reading skills to make your final project. You will learn the most used stitches plus lots of tips to get you started. You will discover how to make granny squares which are the building blocks of many crochet projects including blankets, bags, clothes, even plant pots! All materials, drinks and nibbles included. £75 for 5 sessions. Payable by bank transfer. Dates : EVENING SESSIONS 4th March, 11th March, 18th March, 25th March, 8th April 6.30pm - 8.30pm DAYTIME SESSIONS 5th March, 12th March, 19th March, 26th March, 9th April 10.30am - 12.30pm Skill level - Complete Beginner Class duration approx 2 hours Please read our terms and conditions before booking.

An evening class to make some jewellery. Silver clay can be cut and sculpted and used to create wonderful textures. Designed for beginners.

First Aid, CPR, Heart attack, Cardiac arrest, Epilepsy, burns, bleeding, choking

It’s time to go out dancing once more!!! Join us to learn what is possibly the most popular & versatile social partner dance!   Learn to Modern Jive in a friendly and supportive atmosphere. With step-by-step guidance, you will develop fundamental skills and uncover the joy of social dancing.   Come join us and have fun dancing to a selection of your favourite tunes. Develop your confidence on the dance floor and gain fitness. Warning: Just Jiving is easy to learn and it is addictive!!!   CLASS COMMENCES on Thursday 19 September 2024 for 11 weeks Time: 7.30 – 9.00pm (weekly) Location: Waterloo Centre at Morley College, 61 Westminster Bridge Road, London, SE1 7HT Tube: Lambeth North (1min from the station)   *********************************************************************   This is the right time to COME and JOIN US IN THE FUN! Learn to dance, keep fit and have fun in this lively and supportive class!   The class is open to everyone from beginners to those with some previous experience. All welcome; No need to bring a partner! Come by yourself or bring your friends! The more, the merrier!   Our dance classes are run by Morley College, a prestigious Further Education College in central London recognised for its extensive and exceptional dance provision. You will receive the best dance tuition taught by highly qualified and experienced teachers with step by step demonstration. The classes are small with set maximum numbers giving you the unique individual personal attention, tailored to maximise your progress. You will learn how to Jive dance and be given plenty of opportunities to practice what you have learnt. Find your dancing feet in free-style dancing and discover the fun of social dancing with different partners in a friendly atmosphere!   ENROL NOW! Places are available. Enrolment is open and it’s ‘first come; first served’. Online: at Morley College website By phone: (020) 7450 1889 In person: 61 Westminster Bridge Road, London, SE1 7HT Fees: £155 / conc. £115   For further info, please contact Jive Dance via email. We will endeavour to respond as soon as possible.

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App