/

Excel Intermediate Course, Private 1-to-1

(4.8)16 reviews
Recent reviews of this course provider

Great introduction to SQL!

I loved taking this course. I truly felt like i left understanding the basics of...more

See all reviews
Buy a voucher
Add to shortlistShortlisted by 14 people

https://www.hotcourses.com/courses-by-subject/Excel-Intermediate-Course-Private-1-to-1-courses/54690608/

Course description

Excel Intermediate Course, Private 1-to-1:

This Excel course is offered one-to-one or in small group of up to 4, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but habe many questions daily and want to be more proficients.

Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours

Course Outline

Working with Functions and Formulas

  • Creating Formulae in Excel, general calculations
  • The Function Wizard
  • Using Functions in Excel: The 5 Popular functions
  • If- function
  • Working with Names and Ranges
  • Copying formulae
  • Lookups - Vlookup, Hlookup, Index, Match

Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Filters and Sorting, Freeze panes, split, protecting and unprotecting
  • Using Excel as a Database- Advanced filter

Pivot-tables

  • Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional folmulas, Refresh Data.
  • Pivot Charts

Adding the Finishing Touches

  • Adding Comments
  • Using Themes
  • Adding Text Boxes

Charts and Sparklines

  • Adding and Editing Charts
  • Adding and Editing Sparklines

Adding Graphics

  • Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes

Additional entry requirements

General Computer Skllls

Course info
350 views
Start Date: Tue 22nd August 2017
START DATES
AUGUST 2017
Sun Mon Tue Wed Thu Fri Sat
SEPTEMBER 2017
Sun Mon Tue Wed Thu Fri Sat

Location:

Portsmouth, PO6 3EZ, Southend-On-Sea, SS1 1NE, Milton Keynes, MK9 2UB, London, WC2N 5BY

Time:

11:00am - 6:00pm

Duration:

1 day

Attendance:

Full time, Part time day

Qualification:

Qualification awarded by the course provider

Level:

Beginner IntermediateAdvanced

Class size:

Max size:8

From: £157.70

Summary of all course reviews for PCWorkshops

16 reviews

(94%)
(6%)

Average student ranking

Reviews of this course

pcworkshops

EXCEL
1 5
Hotcourses
Excel Intermediate Course, Private 1-to-1 (Booked online with Hotcourses)
by Fereydon - July 2017

Generally was waste of money , I didnt like the place where was in the library of the hotel , we couldnt talk or I couldnt hear tutor at all . In many subjects she wasnt comfortable at all . She was very nice and polite lady but unfortunately I did not find the course useful at all as I learnt through on line learning much better and more points

Was this review helpful? Yes No

pcworkshops

Fantastic course, highly recommended!
5 5
Hotcourses
by Lucy - March 2017

I had my course with Sarah today and I was really impressed. We worked through my spreadsheets which I brought with me on my laptop, and we also ran through some example spreadsheets so that I could get the hang of various functions and formulae not relevant to my spreadsheet, but useful to know and practice in general. It was actually really fun! I estimate today will make me about 20% more efficient in my work, so thank you Sarah! Also, the venue was lovely.

Was this review helpful? Yes No
MORE REVIEWS

Please note reviews of Excel Intermediate Course, Private 1-to-1 are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Reviews of other courses at PCWorkshops

pcworkshops

Great introduction to SQL!
5 5
Hotcourses
SQL Queries 1-Day Course (Booked online with Hotcourses)
by John - June 2017

I loved taking this course. I truly felt like i left understanding the basics of SQL and immediately booked the next level course. The course teacher Sarah was a delight and very knowledgable! Highly recommend it!

Was this review helpful? Yes No

pcworkshops

Strongly recommended
5 5
Hotcourses
by banox - January 2017

Very happy with the efficiency and proficiency in teaching. Many thanks!

Was this review helpful? Yes No
MORE REVIEWS

Please note reviews of MS Project Intermediate / Advanced, (2007, 2010, 2013,2016), Private, One-to-one, Customised are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course photos

  • Excel Intermediate Course, Private 1-to-1 by PCWorkshops on Hotcourses

Hotcourses promise to you

Here at Hotcourses, our aim is to make things as easy as possible for you when booking your course. That’s why we promise –

To keep the booking process safe and secure

Our payment systems are Verisign secured and all details are stored encrypted via Sagepay, a leading UK payment gateway.

That you can book with confidence

We don’t transfer your money to the people running your course until it starts, so that if the worst happens we can deal with it for you.

To be transparent

The organisers of the course are the ones who set the cancellation terms and any refund arrangements but we will show you these so you can make an informed booking.

View the cancellation policy for PCWorkshops

To share experiences

Some of our reviews are flagged as ‘Booked through Hotcourses Marketplace’ to indicate that you’re reading the genuine opinion of someone who has taken the course. How do we know? We took their booking!

Ask a question

Get course info
Add to shortlist