I’m going to make a bold assumption about you and say that you are here because you want to learn how to best use Excel, and that you want the whole process to be over as quick as possible so you can just get on and do stuff? If that isn’t exactly right, I would say you can easily relate to that point of view.
This course compliments the book I wrote a while back. The ethos is the same. It is practical, it shows not just the what to do but also the why you would even want to in the first place. I use real world examples throughout. Many of the lessons are inspired by colleagues who have asked me “Can you show me how to …”. The course is delivered using both videos and PDF notes that you download to refer to at any time.
Many websites that offer courses make you jump through hoops and expect you to read through pages and pages of
However if you want more convincing why this course represents great value for you then please read on
There are lots of different ways to learn how to use Excel. You can attend a course where you can interact with a tutor and attendees. This is great if you have the time and money. These types of courses certainly have their place, many people feel the classroom is the only place they can learn. I totally understand that. However, having clear text supported by videos that you can watch time after time will give you the best of both worlds. You are able to work at your own pace, rather than at the pace of the slowest member of the course you are on.
A recent search for local courses in my area (West Yorkshire) prices varied from £195 to £386. And they varied in content and delivery. Most were public courses of one or two days. The courses were usually split in to “Beginner”, “Intermediate” and “Advanced”. In theory, you could spend a week and £600 to get to become your own Excel Expert.
I have experience of one of the companies that I included in the price check. The course I attended was not for software but for a project management methodology course that lasted five days. I found it intense, comprehensive and challenging. The quality of the instruction was superb. I wouldn’t hesitate in recommending that company and course to anyone. That said, that particular week cost over £1200.
The one thing that I liked most about that course was the ability to ask questions and get straight answers. That is why I provide email support. You can ask me any questions relating to the course and its materials.
There are plenty of online courses. I’ve no experience of the companies I looked at when comparing prices and content so I can’t vouch for them. They varied in access and cost. The cheapest was £10. One was £29 (discounted from £597!!!!). Others gave you time limited access £29 a month for 12 months. There was no reason given for the discount, although I would be surprised if many were ordered at that price. One thing is for sure, after completing Practical Excel you will be able to write a formula to calculate discounts. Another thing. The materials are yours to keep. That is every PDF and every video. Not for 60 days, not for a year. You can access them any time from any compatible device.
Why you would want me to show you how to use Excel?
You’ll learn the essentials very quickly and get to see how to do the complicated stuff in a clear, concise and repeatable manner. Practical Excel 2010 is an absolute must have for anyone that wants to understand Excel and to produce effective spreadsheets. Inside you will find
- How Excel works
- What you need to do to present your data in an easy to understand and meaningful manner
- How you can use formulas, create charts and use “what If analysis” to interpret your data
- How to use Excel as a database, and how to get information from the data
- How to create and run macros to remove the need to do repetitive tasks
Do you find yourself at work wondering if there is an easier way to do things? If you keep lists of data, produce reports or have to work with figures I can bet you will have. When you ask techies how to do something, do you find that instead of explaining in an easy to understand and repeatable fashion that they solve the problem in a blur of keystrokes leaving you none the wiser? I work in a technical field and it has happened to me lots of times.
I started using Excel when it had to be installed from floppy disks, Windows was in version 3.1 and there wasn’t an Internet to ask for help. I wasn’t an overnight expert. It took me ages of using spreadsheets to do work stuff before I felt confident enough not to have a handy “How To” manual on my desk. I don’t know about you, but I find them very dry reading, and often I was left wondering whenever would I use most of the techniques they described.
Eventually, I became the go-to guy for colleagues using spreadsheets. If I didn’t already know the answer, I would go away and find out. I did my learning the hard way, trying out ideas and finding different ways to tackle problems. The one thing they all had in common was that the problems were real problems using real data. Every time I came up with a way of solving an issue, I’d keep a copy of that spreadsheet and also make some brief notes that I would keep in a hard back book. The result was that I built up a knowledgebase for myself.
The outcome from all these years of experience and problem solving is this e-Course. I’ve put together what I believe to be a comprehensive guide that can take you from beginner to expert in 8 modules. I’ve used real world data from publically available sources. The written materials are extensively illustrated with clear screenshots. The accompanying video clips are centred around showing you exactly what you need to do to achieve results.
Throughout the course, I don’t just show you what to do, but also why you would want to in the first place. Let us look at what you’ll learn
What is in the course?
- Understand the anatomy of an Excel Spreadsheet – the difference between worksheets and work books (module 1)
- Easy ways to open, save and close a workbook (module 1)
- How to use the Backstage View to control the information you share in a workbook (module 1)
- How to quickly access recent files (module 1)
- Printing your work (module 1)
- Configure options (module 1)
- How to customise the ribbon and quick access tool bar and why you would want to (module 1)
- How to add data to your spreadsheet (module 2)
- How to correct mistakes (module 2)
- What you need to do to copy, paste or move cell contents easily (module 2)
- How cell contents are classified, for example as text, numbers or dates (module 2)
- How you can format your data to get your message across (module 2)
- How to make changes to cells using find and find replace (module 2)
- Using proofing tools to make sure that your grammar and spelling are correct (module 2)
- What a custom list and where you will use them (module 2)
- An introduction to using formulas including using a constant (module 2)
- Making your work understandable for others using formatting (module 3)
- How to format a printed page (module 3)
- Formatting within a worksheet (module 3)
- Conditional formatting which varies depending on your data (module 3)
- Creating and using a table (module 3)
- How to create a simple chart (module 4)
- How to place charts on the page and within the worksheet (module 4)
- The best use for different types of chart (module 4)
- Editing parts of your charts to give greater understanding of your data (module 4)
- Creating dynamic charts, sparklines and using in-cell charts (module 4)
- How to use Excel as a database (module 5)
- Finding information within your database using simple and complex searches (module 5)
- How to use wildcards to find data (module 5)
- Using forms for data entry and searching (module 5)
- What freezing your panes means and why you need to use this on pretty much every spreadsheet you use (module 5)
- Creating hyperlinks so that you can move to other worksheets, documents or websites (module 5)
- Working with data from an external source such as the web (module 5)
- How to analyse your data using “What If Analysis” to turn your data in to useful information (module 5)
- How to create a pivot table and pivot charts to inform (module 5)
- How to best share your work (module 6)
- How to save yourself time by documenting your spreadsheets (module 7)
- Creating and running macros (module 8)
And much, much more…
This course will give you all the information you need to design and build informative and practical spreadsheets. You will be able to do so much more with your spreadsheets than an estimated 90% of Excel users. The modules are presented by text and by video using plain English rather than jargon. Where jargon has to be used, it is explained in an easy to understand manner.
ClickBank is the retailer of products on this site. CLICKBANK® is a registered trademark of Click Sales, Inc., a Delaware corporation located at 1444 S. Entertainment Ave., Suite 410 Boise, ID 83709, USA and used by permission. ClickBank’s role as retailer does not constitute an endorsement, approval or review of these products or any claim, statement or opinion used in promotion of these products.
I am very proud of this course, and I want you to be 100% happy with it. That is why I offer a 100% customer satisfaction guarantee. If for any reason you would like your money back, then I will refund it in full. No questions asked.
Two minutes from now you could be enjoying your very own copy of the “Practical Excel 2010 – The course”. Simply click on the “Order” link below and you will be taken to the secure payment site. Once your online payment has been processed, you will be taken to the delivery page, where your copy will be ready for you to download.
A Very Special Offer….
This is a brand new course in my portfolio, and I am offering the first 100 copies at the discounted price of £99.95. When the first 100 copies have been downloaded, the price will revert to the regular price of £149.95. In return, I ask two things. Firstly that you enjoy the course and secondly that you let me know how the course has helped you.
Thank you for choosing “Practical Excel 2010”. I know you will find this to be your very best start to effectively using Excel and to creating terrific spreadsheets.
This course is lavishly illustrated to show you exactly what you need
The first 100 customers get a £50 discount off the regular purchase price
All customers are covered by my 100% customer service guarantee
Please click the Order link below to get your copy now for only £99.95.
This site and the products and services offered on this site are not associated, affiliated, endorsed, or sponsored by Microsoft, nor have they been reviewed tested or certified by Microsoft.
1 I recommend that in general you complete a module a day. The first module (“A first look at Excel”) is quite light and if you’ve a fair amount of Excel experience already, it won’t take you very long. You may wish to do Module 2 (“Adding Data”) on the same day. The final modules are quite short and are laser targeted at very specific topics. You may want to do these on the same day
2 It is often said that only 10% of Excel users employ more than just the very basics. I’ve looked for sources of this quote and I can’t find them. I do stand to be corrected. But it does fit in with my experience.