• No products in the basket.

Overview:

During this excellent Excel 2007: Essentials course is intended to give you a solid understanding of how to use Excel 2007. If you’re a beginner level user of Excel 2007, or if you’ve just updated to Excel 2007, then this course contains all the information you need, and it will help you to get up to speed with simple tasks and the more difficult projects that can be undertaken using Excel 2007. Learners of this Excel 2007: Essentials course will be taught by an expert instructor who has years of experience and tons of insider tips and tricks to share with you. Be guided through all the essential features of Excel 2007, like how to create better spreadsheets and improve your spreadsheet analysis.

Our courses couldn’t be more convenient, the course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

What skills will I learn?

  • Learn to work with the Excel 2007 interface
  • Learn to input data into Excel 2007
  • Learn to find data, sort multiple columns, and import text files
  • Learn to match case and entire cell contents

Meet the instructor:

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience consulting and developing office solutions.  Michael started his career in consulting and development at the White House Communications Agency in Washington DC where he spearheaded the development of a standalone HRIS system for the White House’s Military Office. He parleyed his experience with VBA and VB into a successful consulting practice in the private sector, developing middleware and reporting solutions for a wide variety of industries.

Course outline:

  • Module 01: Working with the User Interface
  • Module 02: Entering & Managing Data
  • Module 03: Using Formatting Techniques
  • Module 04: Formula Basics
  • Module 05: Useful Functions
  • Module 06: Creating Reports
  • Module 07: Sharing & Distributing Your Work
  • Module 08: Tips & Tricks

What are the requirements?

  • You must be 16 or over
  • You should have a basic understanding of English, Maths and ICT
  • You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

  • You will have one assignment. Pass mark is 65%.
  • You will only need to pay £19 for assessment.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

Certification:

Those who successfully pass this course will be awarded a Excel 2007: Essentials certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.

Career Path:

This excellent Excel 2007: Essentials course will qualify you to be an Executive Assistant. As an Executive Assistant you’ll usually be working in an office as part of a team, you’ll work under more senior members of staff and can work your way up the company, so pay will go up with experience. The average salary of an Executive Assistant in the UK is £30,627, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:

  • Executive Assistant
  • Office Assistant
  • Accounts Assistant
  • Administrator
  • PA

Course Curriculum

1: WORKING WITH THE USER INTERFACE
1. Introducing the Ribbon User Interface 00:00:00
2. Introducing Workbooks & Worksheets 00:00:00
3. Introducing the Formula Bar 00:00:00
4. Saving with Different File Extensions 00:00:00
5. Customizing the User Interface 00:00:00
2: ENTERING & MANAGING DATA
1. Getting Data into Excel 00:00:00
2. Importing Text Files 00:00:00
3. Using the Freeze Panes Functionality 00:00:00
4. Using the Zoom Functionality 00:00:00
5. Using Hot Keys 00:00:00
6. Managing Rows & Columns 00:00:00
7. Finding Data 00:00:00
8. Matching Case & Entire Cell Contents 00:00:00
9. Replacing Data 00:00:00
10. Finding & Replacing Empty Values 00:00:00
11. Sorting Data 00:00:00
12. Sorting Multiple Columns 00:00:00
13. Filtering Data 00:00:00
3: USING FORMATTING TECHNIQUES
1. Formatting Numbers & Dates 00:00:00
2. Formatting Cells 00:00:00
3. Setting the Font Type, Color & Size 00:00:00
4. Using Borders & Cell Styles 00:00:00
5. Adding Shapes & Pictures 00:00:00
6. Creating WordArt 00:00:00
4: FORMULA BASICS
1. Constants, Formulas & Cell References 00:00:00
2. Understanding the Order of Operations 00:00:00
3. Using Formulas with Dates & Text 00:00:00
4. Linking Cells & Using Comparison Operators 00:00:00
5. Creating an Absolute Reference 00:00:00
6. Defining Named Ranges 00:00:00
7. Exploring the Function Library 00:00:00
8. Using the AutoSum Function 00:00:00
5: USEFUL FUNCTIONS
1. Using the INT Function 00:00:00
2. Using the Rounding Function 00:00:00
3. Using the ABS Function 00:00:00
4. Using the SUBTotal Function 00:00:00
5. Using Logical Functions 00:00:00
6. Using the AND & the OR Function 00:00:00
7. Using LEFT, RIGHT & MID Functions 00:00:00
8. Using the UPPER, LOWER, PROPER & TRIM Functions 00:00:00
9. Using COUNT Functions 00:00:00
10. Using the VLOOKUP Function 00:00:00
6: CREATING REPORTS
1. Creating a Subtotal Report 00:00:00
2. Using Conditional Formatting 00:00:00
3. Creating & Managing Conditions 00:00:00
4. Creating a Chart 00:00:00
5. Refining Charts 00:00:00
6. Using Basic Chart Types 00:00:00
7: SHARING & DISTRIBUTING YOUR WORK
1. Inserting Headers & Footers 00:00:00
2. Adding Comments 00:00:00
3. Adjusting Page Layout 00:00:00
4. Distributing Your Worksheets 00:00:00
5. Protecting Your Worksheets 00:00:00
6. Understanding Compatibility 00:00:00
8: TIPS & TRICKS
1. Using the Fill Handle 00:00:00
2. Filling in a Series of Numbers 00:00:00
3. Typing in Multiple Cells at Once 00:00:00
4. Leveraging a Custom List & Transposing a Range 00:00:00
5. Deleting & Inserting Blank Cells 00:00:00
6. Filling Holes in Your Data 00:00:00
7. Getting a List of Unique Records & Parsing Text 00:00:00
8. Rearranging Columns & Linking to Multiple Cells 00:00:00
9. Using Right Mouse Button Drag Options 00:00:00
10. Make Format Painter Persist & Paste Special Formats 00:00:00
11. Formatting Portions of Text & Multiple Sheets 00:00:00
12. Creating Cell Border Effects & Sorting on Color 00:00:00
13. Turning Formulas into Hard Data 00:00:00
14. Copy Formula References & Highlight Formulas 00:00:00
15. Creating Dynamic Charts & Combination Charts 00:00:00
16. Add a Secondary Axis, Average Line & Smooth Line 00:00:00
17. Comparing Data Dynamically with Charts 00:00:00
18. Final Comments & Credits 00:00:00

Course Reviews

5

5
1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. MS Excel 2007 Essentials Online Course

    5

    1training gave me the opportunity to study from home whilst working. The nature of distance learning meant I could do it in my free time with no specific deadline pressure. Overall, I was pleased with how the course functioned.

397 STUDENTS ENROLLED

CPD Accredited

UKRLP

ACCREDITED CERTIFICATE

Photo of Milford Sound in New Zealand

Awarded by iAP

Awarded by iAP

CPD Accredited Partner

CPD Accredited

CPD Membership No: 10582

Study independently accredited and recognised CPD courses. Gain your certification today.

SYSTEM REQUIREMENT

Processor
1 gigahertz (GHz)
RAM
1 GB
Operating Systems
Windows 7
Windows 8
Browsers
Google Chrome
Safari 6 or above
Mozilla Firefox
Internet Explorer 8 or above
Compatibility
Windows, Mac, iOS, Android

cvAll students enrolled with 1TRAINING are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews MORE INFO

 

cvIf you need career support 1TRAINING is here for you. We provide excellent career support through our Career Support Service.
MORE INFO

NUS EXTRA CARD

NUS Extra Card Every student of 1training is eligible to apply for an NUS Extra card, allowing you to enjoy great saving by top brands on the high-street and online.

Course Reviews

  • Digital Marketing and Advertising Course Online

    Digital marketing course 3

    Mostly good: accessible, straightforward to understand, but giving enough detailed info to make you think you are learning. However, sometimes more detail on "how to do it" rather than "what you have to do" would have been good. Also, three enquiries about how to access support materials (as advertised) went either unanswsered or unsatisfactorily answered. I still have not received them.
  • Diploma in Office Administration and Receptionist Skills

    I would defiantly recommend this course 5

    The course that I applied for was office administration and reception course. This course by far has given me the best knowledge and understanding, I would defiantly recommend this course to those who are looking into working or building a career in a business environment.
  • Digital Marketing and Advertising Course Online

    Average 3

    Interesting set of videos to help you understand more about digital marketing for beginners. But the module books were below standard to understand, with very little detail about topics covered. The exam was also multiple choice and require very little effort for achieving an Advanced Certificate in Digital Marketing Essentials. .
X