Excel Techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data.Course Outline Working with Excel sheets and files, calculating using multiple sheets or files, getting trends over sheets of files, linking files for auto-updating of values Working with Names and Ranges, to simplify cell-referencing and copying of form Working with Array Formulas getting a range of results (for each value in a range) Working with Excel Tables/Database: Working with Records and Fields Working with Filters Sorting Data Conditional Formatting Data Validation to maximise accurate user input Finding errors and formulae to clean data (Trim, Left, Right, Iferror, Ifblank, etc), remove duplicates Custom lists and using drop lists in cells Excel Subtotals, Group, Outline Cross Referencing data: Hlookup Vlookup Match, Index Excel Function wizard for statistical functions: If, Sumif(s), Averageif(s), Countif(s) Dsum, Daverage, Dcount For large dataset, organising columns, remove or add columns, filter relevant records: Advanced Filter Setting up criteria Using Wildcards Summarising and categorising data and finding trends: Insert, create and amend Pivot Tables Custom Calculations Amending calculations Working with dates, sorting pivots, Create Pivot Charts Overview of Excel Charts and Sparklines
Venue: PCWorkshops at Regus, Golden Cross House, 8 Duncannonn Street, Greater London, WC2N 4JF
Excel data Analytics 1-Day Course: GBP 290.0
VenuePCWorkshops At Regus
AddressGolden Cross House, 8 Duncannon Street, London, Greater London,
Explore localWhat's on in London
Local tourist information guide
Other eventsWhat's on at PCWorkshops At Regus
Main photo may be copyright © LoveEvvnt
Located 200 metres from Trafalgar Square, Chandos house offers accommodation in London. Guests benefit from terrace. Free WiFi is available throughout the property.
Club Quarters, Trafalgar Square
Just off Trafalgar Square, Club Quarters has an elegant brasserie and boutique rooms with free Wi-Fi. The National Gallery and Nelsons Column are a 2-minute walk away..
Covent Garden Apartments
Situated just a few metres from Trafalgar Square, Covent Garden Apartments offer self-catering accommodation in Central London. The property is 100 metres from Charing Cross and 200 metres from Embankment on the River Thames..
Citadines Trafalgar Square
Citadines Trafalgar Square London offers modern, self-catering accommodation in central London. Trafalgar Square is just 150 metres away, and Embankment Underground Station is a 2-minute walk..
View all hotels near PCWorkshops At Regus
Your comments:comments powered by Disqus
Disclaimer: This event is not organised by BritEvents, and we cannot be held responsible for the accuracy of the information provided, errors, or omissions. Always check the information provided before you book tickets.