Microsoft Excel: Beginner to Pro Level in Microsoft Excel

As an introduction, this lecture looks at and explains:

• The main features found on the MS Excel Menu

• How to enter data of different forms such as: numbers, dates, currencies and others

• Rules to remember when entering information

• Cell editing and adjusting

By the end of this lecture you will be able to enter data that can be programmed at a later stage. This is essential for all advanced Microsoft Excel users.

After watching the Video, try the quiz in the resources tab.

A well designed Excel spreadsheet is often easy to read and interpret. There are a few key questions that each user has to ask themselves before entering data. This lesson is a guide to effective spreadsheet layout design and will allow the student to explore different ways of arranging data to suite the specific needs. Using a worked example, you will learn the following:

• Tabular Data Entry Techniques

• Layouts: Potrait vs Landscape

• Grouping of Information and relatability of cells ( Across a Row and/or down a column)

In this lesson we will look at the general presentation of typical spreadsheets. Rows and columns can be edited to make the entire spreadsheet both readable and attractive. Key helpful tools we will look at include:

• Border types

• Text Formatting

• Text Highlighting

• Color Fills

• Text Alignment

The learner will be able to customize each cell or group of cells accordingly thereby creating presentable and attractive excel sheets.

This lecture will advance your skills by showing you how to take full control of the appearance of a spreadsheet. Through this short video and exercise, you will learn how to fully transform any workbook so that it is presented and used in the most practical way possible. Learn the following key functions:

• Text Alignment

• Cell Merge Functions

• Format Painter Function

• How to create a 'data comparison' sheet

• Freeze Pane Function

There are many other skills and tricks that are included in this video which you will find helpful as a growing MS Excel user.

This exciting lecture looks at a different subject all together. Microsoft Excel Shortcuts make the user's experience with the software a little more rewarding.

After watching this short video, you will be able to use quick keyboard based shortcuts to navigate effectively as you prepare your Spreadsheet. While the lecture does not cover all existing shortcuts, you will, however, be able to speed up your production rate by learning some of these shortcuts.

The beauty of Microsoft Excel is that it is fully programmable. One of the reasons this software was designed is to assist in making sure the user does not have to enter tedious repetitive information into the excel sheet. Using formulas basically automates the workbook so that minimal data entry is required.

By way of example, this lecture focuses on the main excel formulas and the situations in which they apply.

Dates are an important element of Excel workbooks. Because of this, every user should be able to program cells with dates in order to avoid tedious unnecessary entries. The lecture focuses on the formulas that can be attached to date entry cells.

Attached and closely related to dates, we have Time Entries which are also covered in this lecture. The aim is to help the user understand the formulas that can be used in creating a timetable. The intelligent spreadsheet design allows automatic adjustment of linked cells.

After creating an impressive Excel spreadsheet, you might need to print it for use beyond the software. In this lecture, we focus on spreadsheet customization for printing purposes.

By way of an example, we also create a typical invoice thereby showcasing how different excel functions can be used collaboratively.