3011 Link courses in Cardiff delivered Online

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

Get inside my mind as I work out how to paint these silhouetted boats and harbour in colourful Vibrant acrylics.

This is such an iconic Brazilan Street, Pelourinho Salvador. It takes a while to paint but is really worth the effort.

I love elephants and I'll show you how to capture the drama of the light & dark shapes to bring this scene to life.

Get inside my mind as I work out how to paint these lively hounds in colourful Vibrant acrylics.

New Orleans, so inspirational, with the mix of a street busker and a Harley. Just blobs of light and dark shapes.

You find these Iconic street café scenes all over the world, this is in Rome Italy. Figures cars & a few buildings.

Taxis in Madeira, Painting this subject could be a little complicated, I have broken it down into easy stages. Such a beautiful unusual composition.

Capture the iconic Cornish scene, with lots of tips for textures on rocks & grass. and easy ways to paint the sea.

Weymouth is a very inspirational town, This is such an iconic painting of a summer day on the beach with the Jubilee clock in the background. Step by step instruction 40 mins