83 Numbers courses in Edinburgh

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online

Edinburgh city centre sketching tours with ink and watercolour artist Mark Kirkham, known locally as The Edinburgh Sketcher

Learn the basics of calligraphy using the foundational hand with local artist Panna Chauhan at The Arienas Collective and create a framed abstract piece to take home.

A NEW one-day watercolour painting workshop for beginners run by local artist and printmaker Lou Davis in our Edinburgh City Centre workshop space. Join artist Lou Davis for a whole day learning to paint in beautiful fluid watercolours. Lou uses watercolour to create simple and approachable patterned and abstract pieces that allow you to get acquainted with this medium in a way that helps you focus, shut out the outside world and simply create. In this workshop, you’ll learn everything you need to get started painting beautiful and relaxing projects using watercolour. We’ll cover a number of projects throughout the day, that will take you through the basics of watercolour from colour mixing and making different brush strokes, learning about paper types and water control, through to mixed media techniques: adding textures, working with masking fluid and embellishing your pieces with pens and metallic paints. This workshop is perfect if you’re new to watercolour and offers a really beautiful way to explore the medium, it’s also good if you’re experienced in watercolour and are interested in using your painting and drawing time to relax and de-stress. All materials for this workshop will be provided, and the price includes morning and afternoon refreshments from local suppliers. You are welcome to bring your own lunch, or there are several cafés and takeaway options nearby. Earth conscious credentials We are mindful of the effect we have on the environment, and do our best to minimise our impact. You will take the lovely watercolours you have created home with you on the day, and workshop correspondence and notes are sent to you electronically. Favourite feedback We love to hear what you think about our workshops. Here's a favourite review for previous watercolour painting workshop with Lou. A totally peaceful and mindful three hours spent being guided and inspired by Lou…Just going with the flow. Enjoying the process. And being quite surprised by the results. Lynn is a wonderful host at The Arienas Collective…Thanks Lynn and Lou for a mindful morning. [Judith] More information The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description. All the equipment and materials you need are included in the price, unless stated otherwise. Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk. Accessibility The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement. Allergies The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative. Minimum number no refund policy To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund. We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking. Private workshop bookings Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 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 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Macrame class with local artist Lucy Wayman hosted by The Arienas Collective creative workshop space in Edinburgh City Centre.

A three-hour workshop designed to inspire and guide you in writing your personal stories led by local bestselling author and certified book coach Emma Dhesi. This beginner-friendly workshop is designed as a no-pressure, exploratory space where you can connect with your creativity and reflect on your personal experiences. It's ideal for anyone who wants to explore memoir writing and storytelling techniques, whether you’re reflecting on your own life, telling a loved one’s story, or capturing memories tied to a craft or creative activity. You will: Learn practical techniques for uncovering and organising your ideas through memory mapping. Practice sensory writing to make your memories vivid and immersive. Write a heartfelt first scene of your memoir or personal essay, using a simple three-part structure: Hook, Scene, and Reflection. Share your work (optional) and receive encouraging feedback in a supportive group setting. Emma will provide guidance and step-by-step activities to help you structure and enhance your writing, and you will leave with the start of a memoir chapter, or personal essay, and practical tools to continue writing at home. All materials are included, plus a handout with writing prompts, tips, and recommended memoirs for further inspiration. Just bring your ideas and enthusiasm! If you have specific memories or objects you’d like to write about, feel free to bring those for inspiration. More information The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description. All the equipment and materials you need are included in the price, unless stated otherwise. Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk. Accessibility The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement. Allergies The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative. Minimum number no refund policy To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund. We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking. Private workshop bookings Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

Learn to make colourful monotype gelli prints with local artist and printmaker Lou Davis at The Arienas Collective in Edinburgh's beautiful Georgian New Town City Centre.

Adobe Lightroom Classic helps solve two of the main problems that afflict digital photographers: how to organise all your files, and how to edit them without spending all of your spare time at a computer screen. Lightroom Classic is a convenient and flexible desktop programme that helps you to organise and sift your photographs into collections, and also gives access to a powerful set of tools that edit, enhance and export your pictures. You can use intuitive pre-set tools, you can create your own favourite adjustments, you can edit large numbers of images with one click of a mouse, and you can fine-tune your image-editing by selectively working on parts of a picture. And you can experiment, secure in the knowledge that you are working in a non-destructive environment and that your pictures are safe. This practical short course will introduce you to the principles of file organisation and image-editing, giving you the knowledge and confidence to choose when to work with this convenient and flexible programme, and whether or not you need the full power of Photoshop Creative Suite. Sample picture files will be provided for you to work with, or you can bring a selection of your own. If you work in RAW, please also bring JPEGs on a memory stick, external hard drive or cloud storage such as Dropbox. Please note this course does not cover the new version of LightRoom CC (which is specifically designed for mobile devices) and only uses the most recent version of LightRoom Classic. Morning You will get to know the Lightroom layout and workspace, importing a set of files into the catalogue and starting to organise the files into collections and adding useful file information. You will explore the opportunities for viewing and aids for analysing the pictures. You will start to use the convenient ‘quick develop’ editing tools. We will then explore the digital image-editing workflow. The usual flow is to correct and optimise before we enhance, interpret or exaggerate. The basic areas to consider are cropping, cloning, colour and tone. Taking each in turn, we will correct and clean up the pictures in a measurable and controllable way. We will investigate techniques to control digital noise, colour distortions and lens corrections. We will work on individual files and also start applying corrections to batches. We will create and apply pre-set corrections. Afternoon Having corrected and optimised the picture files, we can start interpreting, enhancing and exaggerating – the fun part of image-editing! We can try colour to black-and-white conversions, using the many pre-sets to guide; we can selectively boost or restrain colours; we can add grain and textures, vignettes and split tones; we can mix and match these effects and create and save our own favourite effects. We can apply adjustment effects to selected picture areas. Image editing is all good fun, but how do we know where to start? Or when to stop? We‚’ll have a look at some photographic styles and techniques from photography’s rich history to give us some ideas and then try to replicate them. We will discuss ways of using the programme and the technology to develop photographic projects. And we will look at how Lightroom can help us to export those projects as books, prints and slideshows. Designed for those who are already familiar with some digital photography processes but who want to pursue a particular aspect and develop skills in a specific genre. This course is the perfect follow-on from our Digital SLR training courses and will support you in building upon your existing knowledge of camera skills and allow you to work confidently on your own projects. Some prior digital SLR photography experience is therefore recommended.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

Make two silver clay rings on this one day intermediate workshop in Edinburgh City Centre.