/

Excel Data Analysis for modern managers

PCWorkshops
(4.8)17 reviews
Recent reviews of this course provider

Pivot tables in 45 minutes

Excellent course. My teacher Sarah was really good and took me through how to cr...more

See all reviews
Add to shortlistShortlisted by 16 people

https://www.hotcourses.com/courses-by-subject/Excel-Data-Analysis-for-modern-managers-courses/56115106/

Course description

Excel Data Analysis for modern managers:

Make it easy to spot trend and key values in data quickly. Excel Techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data. These Excel skills are common tools that data scientists depend on to gather, transform, analyze, and visualize data.

Course Description

  • Working with 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 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
  • Subtotals, Group, Outline
  • Cross Referencing data:
    • Hlookup
    • Vlookup
    • Match, Index
  • 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:
    • Pivot Tables
    • Pivot charts

What is included:

  • You can bring your own Laptop - let us know beforehand
  • You canbring your own data and examples - let us know beforehand
  • Refreshments: Tees, coffees and light refreshments, but no lunch
  • Certificates: You will get attendance certificates
  • Notes: You will get brief course notes
  • On-site support: 1-hour consultation after the course, bookable, online, on-site or at our office

Additional entry requirements

Excel Beginners

Course info
422 views
Start Date: Fri 19th July 2019
START DATES
JULY 2019
Sun Mon Tue Wed Thu Fri Sat
AUGUST 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

London, WC2N 4JF, You study this on your computer

Time:

11:00am - 6:00pm, Any time

Duration:

1 Day, By arrangement

Attendance:

Online, Part time day

Qualification:

Qualification awarded by the course provider

Level:

Beginner IntermediateAdvanced

From: £290

Summary of all course reviews for PCWorkshops

17 reviews

(94%)
(6%)

Average student ranking

Reviews of other courses at PCWorkshops

pcworkshops

Pivot tables in 45 minutes
5 5
Hotcourses
December 2017

Excellent course. My teacher Sarah was really good and took me through how to create pivot tables step by step. She made it simple and straightforward. I can now create a pivot table with confidence. You also get a certificate of attendance. I would highly recommend this course to a friend. Sharmini Shanthakumar

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

pcworkshops

Java taster
5 5
Hotcourses
December 2017

Sarah is an excellent mentor . She taught me well in such a short span of time and gave sufficient material to get a feeling of programming in Java. Thanks!! Rahul

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

Please note reviews of Java Programming "Taster" Course, 1 Day are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Excel Data Analysis for modern managers by PCWorkshops on Hotcourses
Add to shortlist

You might like...

Others viewed...

  • People who viewed this course also viewed

  • Microsoft Excel 2013 VBA

    from: £405.00

    Vantage Training Ltd

    (CENTRAL ENGLAND)