Microsoft Excel 2007: Essentials

0( 0 REVIEWS )
Overview This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you …


This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time! Microsoft Excel is a popular application that is used for management of data. Microsoft Excel is a part of Microsoft Office and considered to be the most versatile of the applications. Excel 2007 is a newer and modified version which has more advanced features and functions. The course will explore key topics such as entering and managing data, formatting techniques, formula basics, creating reports and distributing your work. This application will make you efficient in your day to day work, whether you are employed in administration or accounting.

Learning with Study 365 has many advantages. 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).

  • Who is it for?
  • Course outline
  • Course Duration:
  • Method of Assessment: 
  • Certification:
  • Entry Requirement:
  • Career Path:
  • Presenter Information:
  • Job seekers
  • Graduates
  • Administrators
  • PA professionals
  • Accountants
  • Bookkeepers
  • Business Owners

This course is comprised of the following modules:

  • 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

From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed the course.

Successful candidates will be awarded a certificate in Excel 2007: Essentials.

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

A training which will be beneficial to those of almost any career path since this is essentially a tool which is used by most corporations. Study these video tutorials effectively and become an expert in using excel for all corporate level tasks which you need to perform. Start with the basics and move on to understanding the more complex aspects of Excel. A career with bright prospects await you with the completion of this course. According to, some of the key job positions along with the average UK salary per annum you can go for after completing this course will be as follows.

  • Administrative Assistant - £16,876 per annum
  • Personal Assistant - £25,144 per annum
  • Secretary - £19,554 per annum
  • Accounts Administrator - £18,669 per annum
  • Payroll Administrator - £20,025 per annum
  • Accountant - £28,571 per annum
  • Accounts Assistant - £18,876 per annum
  • Bookkeeper - £20,786 per annum
  • Office Manager - £24,447 per annum
  • Junior Accountant - £17,750 per annum
  • Receptionist - £16,297 per annum
  • Small Business Owner - £24,297 per annum
  • Business Manager - £34,612 per annum

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.

He currently lives in Frisco, TX where he serves as a Senior Program Manager for a top technology firm.  Michael is the author of several books on Microsoft Access and Excel, and is the principle behind DataPig Technologies where he shares basic Access and Excel tips to the Office community.

Course Curriculum

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

Students feedback


Average rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

WhatsApp chat