MS Excel Data Analysis for Modern Managers 1-Day C Miscellaneous

ms_excel_data_analysis_for_modern_managers_1day_c


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

Price

Excel data Analytics 1-Day Course: GBP 290.0

Links:

Tickets: https://go.evvnt.com/583653-0?pid=269
Facebook: https://go.evvnt.com/583653-2?pid=269

More details


Date(s)7 Feb 2020
WebsiteVisit website
VenuePCWorkshops At Regus
AddressGolden Cross House, 8 Duncannon Street, London, Greater London,
WC2N4JF

Explore localWhat's on in London
 Local tourist information guide
Other eventsWhat's on at PCWorkshops At Regus


Main photo may be copyright © LoveEvvnt


Nearest Hotels

Chandos house

ROOMS FROM£0
92mAWAY
0

Located 200 metres from Trafalgar Square, Chandos house offers accommodation in London. Guests benefit from terrace. Free WiFi is available throughout the property.

Postcode: WC2N 4HS
Distance from PCWorkshops At Regus:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Club Quarters, Trafalgar Square

ROOMS FROM£128.52
143mAWAY
4

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..

Postcode: WC2N 5BY
Distance from PCWorkshops At Regus:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

The Grand at Trafalgar

ROOMS FROM£128.52
146mAWAY
4

Just off Trafalgar Square, in Central London, this beautifully restored Victorian building houses a 4-star luxury hotel offering free Wi-Fi and elegant air-conditioned rooms..

Postcode: WC2N 5BY
Distance from PCWorkshops At Regus:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Covent Garden Apartments

ROOMS FROM£183.2
163mAWAY
0

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..

Postcode: WC2N 6NE
Distance from PCWorkshops At Regus:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

Citadines Trafalgar Square

ROOMS FROM£182
188mAWAY
4

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..

Postcode: WC2N 5EA
Distance from PCWorkshops At Regus:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

The Trafalgar Hilton

ROOMS FROM£191.2
219mAWAY
4

This deluxe 4-star hotel is on Londons famous Trafalgar Square, just half a mile from Westminster. There is a roof-top bar with spectacular views of the Square..

Postcode: SW1A 2TS
Distance from PCWorkshops At Regus:
0.1 miles

CHECK AVAILABILITYHotel details, map & prices

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.

Event Details

Date7 Feb 2020
Time(s)11:00 AM - 6:00 PM
CostGBP 290.0
VenuePCWorkshops At Regus
Golden Cross House, 8 Duncannon Street
London
Greater London
WC2N4JF
Phone02071646359
CategoryMiscellaneous


LoveEvvnt

Added
18 Jan 2020

Contact organiser

View full profile