Excel 2007 Simplified

(1 Reviews)

Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE

Description

This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics – to reach a higher-intermediate level. With shortcuts, tricks and tips – you will be able to work smarter and faster.

If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there’ll be some items which we cover, that you have no idea that Excel was capable of doing!

We don’t want you to spend a day of your life in the classroom… learn 99 quick and very useful, practical things which you can apply on your job or on your projects.

We’ll cover:

Working with Data – using series, symbols and special characters, hide rows and freeze panels
Formulas and Functions – Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums
Copying Data – transposing rows into columns and paste specials
Using Excel lists – sort and filter a list, remove duplicate records, count filtered records, look up information in a list
Data Patterns – Pivot tables, pivot charts, what-if analysis
Creating charts – histogram, trendlines, piecharts, error bars
Presenting data – formatting columns and numbers
Saving and printing worksheets – printing multiple worksheets, area, cell ranges, repeat headings of a row or column
Extending excel – hyperlinks, embed a chart, importing a worksheet
Customizing Excel – custom workspace, custom view, macros

The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn’t too dissimilar from 2010.

Where necessary, we provide a spreadsheet – but as long as you have Excel 2007, you’ll be able to copy and do exactly what you see on the screen by pausing the video and following along.

The course will take approx 7.5 hours to complete.

Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.

What Will I Learn?

Work with Formulas and Functions
Copy data and formats
Use excel lists
Create charts
Present worksheets nicely
Save and print worksheets

Who is the target audience?

This is for those who are beginners in Excel and want to take it further to higher intermediate level – using Excel 2007
You should know the “basics” in Excel and we take it from near-beginner, to higher intermediate

Requirements

Students will need to have Excel 2007 installed, as this is the system used in the teaching

Course content

11 Sections 100 lectures 8 hours 4 mins in total

Certification

After successfully completing the course, you will be able to get the and internationally accepted certificate to share your achievement with potential employers or include it in your CV.

Student Reviews

Excellent

5 Average 1 Reviews

Reviews

Great learning experience with iStudy. Clear lessons and easy to follow. Really impressed.

Loved the flexibility. Studied at my own pace and finished quickly.

Excellent course quality. I feel more confident in my skills now.

iStudy delivered exactly what I needed. Very smooth process.

Customer support was fast and helpful. Got answers straight away.

Great platform. Well-structured lessons and simple navigation.

Really happy with the experience. The certificate arrived quickly.

Clear teaching style and easy to understand. Highly recommend.

Self-paced learning was a huge benefit. Finished around my schedule.

Great value for money. Quality courses and helpful support.

I enjoyed learning with iStudy. Everything was straightforward.

Quick, simple and informative. Made studying stress-free.

Fantastic support team. They resolved my issue in minutes.

Course material was clear and engaging. Very happy overall.

Loved the layout and simple step-by-step lessons.

Prompt certificate delivery. Really impressed with the service.

Good quality courses and easy platform to use.

Very convenient. Learned at my own pace without pressure.

Great experience from start to finish. Worth every penny.

Clear content, supportive team and fast responses. Highly recommend iStudy.

Frequently Asked Question

Are there any prerequisites for taking the course?

There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course.

Can I access the course at any time, or is there a set schedule?

You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience.

How long will I have access to the course?

For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime.

Is there a certificate of completion provided after completing the course?

Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks.

Can I switch courses or get a refund if I'm not satisfied with the course?

We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase.

How do I track my progress in the course?

Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course.

What if I have technical issues or difficulties with the course?

If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.