Microsoft Excel - Learn Advanced Tips

Course details

Microsoft Excel - Learn Advanced Tips is a course aimed at the excel user who is fairly competent on the software but is just looking for a few more handy tips and tricks to really get to know what this software can do. If you are handling data, or have the responsibility for analyzing data or presenting information in a useful format - reports for your team, or managers etc., then this course will be very handy.

We don't want you to spend a day of your life in the learn 4 useful, practical things which you can apply on your job or on your projects.

1. Goal seek and 'what if' analysis

• When working with worksheet models - do you have the answer you want, but must work backward to find the input value that gives you that answer? Goal seek will help you. If you have to analyse scenarios for forecasting - what if X happens, instead of Y? The 'what if' section will help you.

2. Data Tables

• Data can be confusing and difficult to interpret or understand if it's not presented in logical format. Data tables can really help.

3. Using Pivot Tables

• A pivot table is an interactive worksheet table that quickly summarizes large amounts of data using a format and calculation methods that you may choose yourself.

4. Extended graphics

• Analyse the trends that are apparent and create charts to present information clearly for work reports, essays and assignments.

A booklet with screen shots is given in lecture one, so that you can follow step by step what we do in each lecture. We also provide a spreadsheet with each lecture - for you to practice what was done in that lecture.

Why choose Edplx?

• Internationally recognised accredited qualification
• Access to our free career advisors
• Approved UK Learning Centre
• 1 year accessibility to the course
• Attain PDF or hardcopy certificate to show employers
• Study at your own pace anywhere
• Employer has access to certificate validation
• Tutor Support available Monday-Friday
• Invitation to job fairs

Course Curriculum

This Course will cover some of the following topics:-

Introduction

• Introduction to Excel
• Downloadable Resource

Goal Seek

• Goal Seek and "what-if" analysis
• Creating a Chart
• Loan Mortgage Analysis
• Changing Interest Rate
• One Input Data Table
• Two Input Data Table
• Using Pivot Tables
• Changing Layout of Pivot Table
• Filtering Fields
• Format Report
• Creating a Chart From a Pivot Table
• Extended Graphics
• Combi Charts

Conclusion 

• Final Words

Benefits

Edplx has connections and great business relationships with respectable companies within the job industry. This plays an important role in assisting all our students searching for internships, apprenticeships and part/full time jobs. We also provide all our students with the opportunities to speak to our talented career advisors and experts. You will also be invited to career fairs to give you the chance to present yourself to potential employers, once you sign up for it.

Certification

Upon completion of the course, internationally recognised certificates that can be traced by employers are available upon completion.

Who is this Course for

This course is suitable for those who are at an intermediate 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. Updated on 31 January, 2023