WEBVTT

00:02.390 --> 00:02.920
Hello.

00:02.960 --> 00:09.410
My name was now and then the creator of this course Excel essentials level 2 for intermediate and advanced

00:09.410 --> 00:10.450
students.

00:10.550 --> 00:15.860
Now at the moment I'm assuming that you already have the fundamentals of Excel mastered that is you

00:15.860 --> 00:19.540
know what a spreadsheet is you know how to write a basic formula.

00:19.550 --> 00:24.830
And you know where everything on the screen is no need to worry if not because we'll go through things

00:24.830 --> 00:27.420
step by step in depth way.

00:27.580 --> 00:33.290
Now one of the criticisms I hear when I speak to other students particularly of xol courses is that

00:33.290 --> 00:37.370
they're taught a bunch of formulas but they have no context.

00:37.370 --> 00:42.260
So they think the formulas are fantastic but they can't actually say a reason why they would ever want

00:42.260 --> 00:49.150
to use them now for that reason I'm deliberately structured this course into individual projects.

00:49.160 --> 00:52.250
Now you may have a look at the project title and think you know what.

00:52.250 --> 00:59.540
I have no need to work out how to create a relational database for example but within each of the sections

00:59.870 --> 01:05.960
there are some powerful techniques that if you just build it from scratch and you follow the course

01:05.960 --> 01:12.140
sequentially and complete each of the sections each of the lectures in those sections you will see some

01:12.140 --> 01:20.140
powerful formulas at work in context and hopefully then you will be a short leap to be able to say.

01:20.270 --> 01:26.120
I say I can apply this in this project but I am working on at work or this other project that I am working

01:26.120 --> 01:26.880
on at work.

01:27.050 --> 01:32.030
So although you may look at the titles and think I dont need that work through it anyway because there

01:32.030 --> 01:39.740
are gems hidden in every section So the aim of this course is to enable you to build powerful solutions

01:39.740 --> 01:45.710
using just the standard Excel functions may be combined in a way that you wouldn't think to normally

01:45.920 --> 01:50.830
but you can achieve things that people generally dont think you can achieve with Excel.

01:51.020 --> 01:55.180
Okay so thank you again for choosing this course and I'll see you in the next lecture.

01:55.340 --> 01:55.980
Thank you.
