Are you tired of struggling with Microsoft Excel? Do you want to use Excel with ease to solve complex problems, automate spreadsheets, and master graphs for presentations instead of pulling your hair out?
We can help!
Once you’ve got the basics covered, take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.
Our Microsoft Excel & Advanced Microsoft Excel courses now both offer a BRAND NEW 2019 VERSION.
CPD
48 CPD hours / points
Accredited by The CPD Certification Service
Course media
Description
Why Excel Matters:
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.
We also know how difficult it is to find quality instruction that is:
Easy to follow
Gets you the results you want
Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel course.
What you get with this Microsoft Excel duo:
280 modules of training, covering the most business-relevant areas of Microsoft Excel.
190+ videos and over 130 downloadable exercises.
Tailored learning. If you have some Excel knowledge, you can use the filter to show only what you most need to learn.
You’ll be an advanced level user after taking this Microsoft Excel course.
What you will learn in these courses:
Microsoft Excel:
How Excel works, how to navigate and design a spreadsheet
The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
To use PivotTables, Pivot Charts and Basic Macros
To create beautiful looking graphs and charts
Formatting, including; conditional, cell and number formatting
How to print what you want
Our Microsoft Excel course now also offers a BRAND NEW 2019 VERSION.
Advanced Microsoft Excel:
Use advanced graphs in minutes instead of wasting hours trying to figure them out
Increase interactivity by automating your spreadsheets with macros and VBA
Solve complex problems with superpower functions
Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
And more!
Our Advanced Microsoft Excel course now also offers a BRAND NEW 2019 VERSION.
More about us:
We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels.
Simon has been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis. He can bring these years of practical experience to our Advanced Excel course, ensuring that the course explains advanced concepts clearly and concisely, and with real, practical applications.
Who is this course for?
Suitable for all levels of Excel user
Requirements
Microsoft Excel is available in versions: 2003 PC, 2007 PC, 2010 PC, 2013 PC, 2016 PC, 2019 PC, 2011 MAC, 2016 MAC Advanced Microsoft Excel is available in versions: 2007 PC, 2010 PC, 2013 PC, 2016 PC, 2019 PC
Questions and answers
No questions or answers found containing ''.
CDL Watts asked:
Whilst the course is expected to take 36 hrs, will a deadline to completion be imposed, in respect of a 'reasonable time' from the date of enrolment?
Answer:
Good morning.
Thank you for contacting us,
Not to worry, The 36Hrs in an estimated time of completion, You will definitely have 12 months to complete the course and pop in and out as many times you wish.
Please let me know if you have any questions so we may assist.
Thank you.
Hello I was wondering after completion of the course if students can go online and refer to completed course content please?
Answer:
Good morning.
Thank you for contacting us,
Correct! Also, you may wish to save and print the certificate of attainment which is the certificate of completion. This will show the modules you have completed and the time spent on each one of them.
Let us know if you have further questions.
Thank you.
What device or software do I need on my tablet for this course
Answer:
Good morning.
Thank you for contacting us,
You will need to have the Excel software installed on your device to be able to download and practice the exercises. I suggest you download 2013 or 2016 version as they are best ones to have.
Please let me know if you have further questions.
Thank you.
Is £20 pound the total cost for course & certificate if i register before discount date expires ?
Answer:
Hi Anthony,
Thank you for contacting us!
The £20 price will get you access to the two Excel courses for twelve months from the date of redemption, and all of our courses include Certificates that can be generated by yourself once you have completed them.
Kind regards,
James M
Hello,
Would I need to have Microsoft office on my pc, as I didn't purchase that when I purchased it? Thank you.
Answer:
Hello Deborah,
Thanks for contacting us!
Access to a version of Microsoft Excel would be recommended when taking these courses as they contain downloadable exercises for you to work through, in addition to the text, images, and videos.
Otherwise, just an internet connection and an internet browser are needed to view all the content from the courses on our platform.
Please contact Support on ExcelwithBusiness if you have any further questions or queries.
Kind regards,
James M
Is there a big jump in skill from the basic course to the advanced, Thanks
Answer:
Good morning.
Thank you for contacting us,
The Basic course will take you from a beginner level to an intermediate level, leaving you ready for you take the Advanced excel course.
Let me know if you have further questions so we may assist.
Thank you.
Good afternoon.
Unfortunately, this will not work I'm afraid. The course it's based on the actual Excel Software. The downloads will only work if you have the Microsoft Excel installed on your device.
Please let me know if you have further questions so we may assist.
Thank you.
I have an Android tablet with Excel version 1.0.1. installed. Could I do this course on this version of Excel or would I better doing it on my laptop?
Answer:
Good morning.
Thank you for contacting us,
Good morning.
The course is 100% online and although we recommend completing on a computer, it is available on any device. I do however strongly recommend this course to be done on a computer/laptop.
Let us know if you have further questions.
Happy learning!
Hi, is there practice questions I can download and practice myself?
Answer:
Good morning.
Thank you for contacting us,
The course is 100% online and although we recommend completing on a computer, it is available on any device as long as you have a good internet connection.
No questions will be downloadable as they all need to be completed online only. However, you will have downloadable exercises in which you can practise the task given to you.
Please let us know if you have further questions.
Thank you.
Hi, is the cost of the certificate included in the £39 fee? And is there an exam at the end?
Thanks
Answer:
Good morning.
Thank you for getting in touch.
That is correct, The certificate will be included in the fee. Please note there will be no extra payment for this course or certificate.
For each course, you will have 2 test to do. The first test will tell you the current knowledge you have if the subjects and the second test will be your final test, so hopefully, you will your improvement.
Please let us know if you have further questions.
Kind regards,
Hi ,
This maybe a stupid question .Can i use an ipad to study this or do i need a laptop?
Answer:
Good morning.
Thank you for contacting us,
The course is 100% online only, You can use any device as long as you have a good internet connection.
If you have any additional questions so we may assist.
Kind regards,
I'm interested in this course, however i wouuld like to know why jump from begginer to advance, what about intermediate level?
Thanks
Answer:
Hello Flor,
Just to clear up, the beginner is our standard Excel course we offer, so it is not a jump in that respect. We also offer a basic excel course, which will teach you the very basics.
Do you get a certificate after you’ve completed the course?
Answer:
Good afternoon.
Thank you for contacting us,
Correct, at the end of your course you will receive a certificate of attainment which will be the certificate of completion, this will have the module you have completed and the time you have spent on each one of them.
Please let me know if you have further questions.
Thank you.
Good afternoon.
Thank you for contacting us,
Correct, You may complete the course using Office 365.
Let us know if you have further questions.
Thank you,
Good morning.
Thank you for contacting us.
Correct, the course will be online only. This can work using any device as long as you have a good internet connection.
Please let me know if you have further questions so we may assist.
Thank you.
Good afternoon.
Thank you for getting in touch.
Once you have purchased a course from reed. You will receive a login from Excel with Business. They will send you instructions on how to access the courses and the platform.
Let us know if you have further questions so we may assist,
Thank you.
Good morning!
Thank you for getting in touch.
Correct! At the end of your course, you will receive a certificate of attainment which will be the certificate of completion. This will have the modules you have completed and the time spent on each one of them. No extra fees for the certificate as it will al bee covers with the initial fee on the site.
Please let me know if you have further questions so e may assist. :)
Thank you.
Hi
I really want to do an excel course that covers this range but I only have a Mac. Can I do this full course on the Mac?
Answer:
Good morning.
Thank you for contacting us.
The Mac version will only be available for the Microsoft Excel course. Unfortunately, we do not have the Mac version for the Advanced Excel course I'm afraid.
Please let me know if you have further questions so we may assist.
Thank you.
Good morning.
Thank you for contacting us,
The course is 100% online and although we recommend completing on a computer, it is available on any device. as long as you have a good internet connection.
No physical workbooks, CD's will be sent.
Let me know if you have further questions.
Happy learning!
i have a good knowledge of excel but would like to enhance my excel knowledge to expert level, is the excel bundle the best course(s)
Answer:
Good morning.
Thank you for contacting us,
The Beginner will teach you the basics of Excel such as Formulas, macros, PivotTable. which will be super quick for you grasp as you have a good knowledge already.
The Advanced Excel will go in further detail, teach Arrays, PowerPivot, Data Validation and more. I think this could be a little more challenging to you. If you have any questions regarding the course contact support for further information.
Thank you.
Good morning.
Thank you for contacting us,
Correct! The course will be compatible with the 2010 version. You will get a chance to change the version in the course if you wish to upgrade to the latest one!
Please let us know if you have further questions so we may assist.
Thak you.
I have a chromebook will I be able to learn take up the excel course please.
Answer:
Good morning.
The course is 100% online and although we recommend completing on a computer, it is available on any device as longs you have a good intent connection.
Please note you will need to have the Excel Software installed in your device, this is so you may interact and download the exercises from the course.
Let me know if you have further questions os we may assist.
Happy learning!
Am I able to download onto my android phone and my kindle? Or do I need a laptop?
Answer:
Good morning.
Thank you for contacting us,
The course is 100% online and although we recommend completing on a computer, it is available on any device as long as you have a good internet connection
Let me know if you have further questions.
Happy learning!
Good afternoon.
Thank you for contacting us.
That is correct,
At the end of your course, you will receive a certificate of attainment which will be the certificate of completion.
Let me know if you have further questions so we may assist.
Thank you.
Hi do you receive the certificate through the list or is it only available via printing it off yourself? Thanks
Answer:
Good morning,
Thank you for contacting us,
You will be able to print and save PDF once the course is completed.
Let me know if you have further questions so we may assist.
Thank you.
Good morning.
Thank you for contacting us,
That is correct, at the end of your course, you will receive a certificate of completion which will be the certificate of attainment that will be CPD certified.
Let us know if you have further questions.
Thank you.
Good afternoon
yesterday I bought a course Microsoft excel beginner and advanced and I m not happy of this purchase.How you can make a refund?
Answer:
Good morning,
Thank you for contacting us,
I apologise for any issues you have come across. As you have purchased through Reed please note the refund will have to go through them directly as they have taken payment from you.
Please let me know if you have further questions so we may assist.
Thank you.
Upon completion of the course and taking a test, can you re-take the test if you should not happen to pass?
Answer:
Good morning.
Thank you for contacting us,
Please note the test result is not based a pass or fail. This will be measured b a score, so the highest the better. We can only rest the test there has been a technical issue that has prevented you from taking the course.
Let us know if you have further questions.
Thank you.
Does this course cover in depth training on using the sort function?
Answer:
Good morning.
Thank you for contacting us,
Within this course, you will be learning the following:
- How Excel works, how to navigate and design a spreadsheet
- The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
- To use PivotTables, Pivot Charts and Basic Macros
- To create beautiful looking graphs and charts
- Formatting, including; conditional, cell and number formatting
- How to print what you want
And other functions! Let us know if you have any questions.
Please could you tell me if you get a recognized certificate at the end of the course?
Answer:
Good morning.
Thank you for contacting us,
At the end of your course, you will receive a certificate of attainment which will be the certificate of completion. Note this will not be a formal certificate like a degree of a Diploma.
Let me know if you have further questions so we may assist.
Kind regards.
I do not have my log on details for my excel course, can you re send please
Answer:
Good morning.
Thank you for contacting us.
Sometimes the login details might arrive to your spam folder. If you definitely have not received it, please contact Excel with Business as they will be in charge of sending you the log in details.
Thank you.
I signed up for Excel course and now cannot find how to access to start the training. I paid for this a few weeks ago but am just able to now start.
Answer:
Good morning.
Thank you for contacting us.
Please note that Excel with Business has sent you the log in details already. Please do contact them directly as they will send this to you again.
Sometimes this could arrive to your spam folder. make sure you check there also.
Let me know if you have further questions.
Thank you
Hello, good afternoon.
Would we receive the certification through e-mail ?
Answer:
Good morning.
Thank you for contacting us.
Once you complete the course, you can save it as PDF and print if necessary.
Otherwise, You may contact us directly and we can send this to you.
Please let us know if you have further questions.
Kind regards.
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such,
content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility
is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to
the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.
CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.
A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.
An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
We have partnered with DivideBuy to offer interest-free credit (0% APR) on course purchases over £50.
Monthly instalments can be spread over 3, 6, 9 or 12 months, depending on the total value of courses in your basket:
Spend a minimum of £50.00 to apply for up to 3 monthly instalments
Spend a minimum of £250.00 to apply for up to 6 monthly instalments
Spend a minimum of £450.00 to apply for up to 9 monthly instalments
Spend a minimum of £600.00 to apply for up to 12 monthly instalments
Interested?
Select DivideBuy at checkout
The cost of the first instalment is indicative as you may be required to pay a deposit.
This will be deducted from your total amount to pay.
Credit subject to status. UK orders only.
We have partnered with DivideBuy to offer interest-free credit (0% APR) on course purchases over £50.
Monthly instalments can be spread over 3, 6, 9 or 12 months.
Amount
Period
Total
£32.67/mo.
for 3 months
for 3 months
£98.00
Interested?
Select DivideBuy at checkout
The cost of the first instalment is indicative as you may be required to pay a deposit.
This will be deducted from your total amount to pay.
Credit subject to status. UK orders only.