12 chapters, 55 lessons, 12 hoursThis course has over 12 hours of eLearning lessons, downloadable exercise files to help you learn and the ability for you to pause, rewind and repeat any of the lessons whenever you need. [wp_lightbox_prettyPhoto_anchor_text_image link=”http://www.elearncode.com/wp-content/uploads/2013/09/iactonline_paths.jpg” text=”View Course Path” description=”iactonline Training Paths”]
What does the course cover?Dashboards provide a visual way to view data. Excel Dashboards teaches the skills needed to structure a spreadsheet so that data can be presented using powerful and visually appealing charts and graphs which dynamically update when data changes or users modify settings. Learn to build powerful Dashboards in Excel.
Why take this course?This course covers everything from an introduction to how Excel works, selecting cells and modifying worksheets – right through to building formulas, sorting data and creating basic charts and graphs.
Who should attend?Anyone needing to learn how to use Excel or those familiar with other spreadsheet programmes but new to Microsoft Excel – and anyone who has not used the product for a period of time.
Detailed Course Breakdown and Sample Lessons:
Section 1: Introduction to Excel
Section 2: Selecting Cells and Ranges
Section 3: Modifying a Worksheet
Section 4: Modifying a Worksheet
Section 5: Building Simple Formula
Section 6: Absolute and Relative Referencing
Section 7: Sorting Data
Section 8: Charts and Graphs
Section 9: Importing Text and Graphics
Section 10: Printing and Page Setup
Section 11: Printing and Page Setup
Section 12: Sharing Workbooks with Others
Top 10 skills you’ll learn
Of the thousands of different things you can learn within Excel, here are the top 10 you will learn on this course:
- Navigate your way around a spreadsheet
- Open, Save and Close workbooks
- Select cells, rows and columns
- Build simple formulas
- Sort and organise data
- Import data from other applications
- Perform “what-if” analysis
- Create and enhance charts
- Start to print and export into presentations
How you can apply these skills?
Our Excel course shows in a series of practical hands on lessons how to use Excel in everyday life such as:
- Perform sales analysis
- Calculate expenses
- Design budgets
- Create invoices
- Creating a wide range of other powerful real world Excel spreadsheets
CertificationWhen you pass that you will receive an internationally recognised accreditation certificate like this:
What’s next?Upon completion, you can move onto Excel Level 2, then 3. After you have completed the 3 levels you will be ready to take the Expert or Specialist courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.
Careers that require these skills at this level?Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.
What people have said about this course:
I wanted to learn excel for my new Operations Manager job. Level 1 and 2 taught me what I needed to know so I felt confident using excel. I found this course to be very good. The instructor was very knowledgeable and professional and had a very good teaching manner. She was also patient and supportive.I really enjoyed the course, learned a lot and feel more equiped for day to day work with excel.
I have several Excel training courses in the past, usually in book form and have always struggled with them, but E Learning is the most student centred course I have tried. It is easy to navigate around and has given me the confidence I lacked in the past with Excel.When setting up my new business, I quickly realised I needed excel knowledge. I bought levels 1,2 and 3 from iactonline and I’m now up and running. I liked the way the instructor was really seemed to understand when to go into more detail on a topic. I couldn’t have set up my accounts without it.I needed to learn excel to make tracking client invoicing easier. I liked the way I could pick and choose what I wanted to learn and I now use excel every day! Best €20 a month I spend, it’s saved me loads of time. Thank youI wanted to do an online course to help me standardise some spreadsheets in the office. After reviewing all the options, I decided to go with iactonline because they seemed the most professional. I wasn’t disappointed, the course was easy to follow and the files I downloaded were really helpful. I’d recommend them to anyone.As an MD of 20 years, I wanted to get a better grip of Excel to speed up quotes. I bought annual membership for each of my finance team and it’s been great. They work more efficiently and in a much more streamlined way. There is a reason we keep coming back – our productivity increases substantially after every course.I wanted to learn more about excel as its use becomes increasingly prevalent in work. I found the course from iactonline easy to follow and engaging. I learned quickly and keep dipping back into the course whenever I have a query. I’ve been using excel for years, but really wanted to learn more about the complex aspects of it. I bought annual membership from iactonline and have completed four courses so far. Courses are enjoyable and easy to follow – it’s a great resource and I’m now the guy in the office that people go to with an excel query.Prev
The Personal Statement is one of the most crucial sections of applying for college entrance
It is a great chance to write about your thoughts and ambitions for your self, your own future and where you hope to go in life. Every high school student should at least termpapersworld.com/ take this badly. Here are a Couple of things that will help you create a personal statement that will Stick out and give you the most benefit: