Microsoft Excel: Beginner to Pro Level in Microsoft Excel

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.

This lecture focuses on the magic of Microsoft Excel which is seen through the linking of data:

1. Within the same MS Excel file

2. Across different MS Excel files

The easy to follow example allows you to see a scenario where the spreadsheet links apply. Using this key function will allow you to create a series of Microsoft Excel Files which are linked and codependent.

Download both excel files in order to practice and perfect this skill.

One of the eccentric features of MS Excel is the chart creation tool. This allows you to simply highlight pre-entered data from a table and to select the type of chart which best presents the data. With various types of charts and designs, this lecture will guide you not only on how to select charts but also how to edit and adjust properties to suite your needs.

Examples of charts in this lesson include:

1. Pie Charts

2. Line Charts

3. Radial Charts

4. Bar Charts

This lecture shares and explains a very effective MS Excel tool that can assist you when dealing with large data sheets. In some cases, you may be working on a workbook that has a large list of entries going down or across the workbook. There may be instances where certain data will need to be filtered or resorted according to a preferred order.

By way of 2 examples, part one and part two of this lecture shows you how to navigate through a database sheet.

This advanced formulas lecture seeks to combine all skills and tricks gained in the previous lecture to create intelligent spreadsheets. Here we cover other non-mathematical formulas (those that are not numeric based). The functions you will learn in part 2A and 2B include the following:

• The Conditional Formatting Tool

• The "IF" Formula Function

• The Cell Locking Function

By learning and mastering the above functions, you will learn how a spreadsheet can truly offer startling features which can be of great help in any professional industry or discipline.

After watching Part 2A and 2B of this lecture, you may proceed to download the exercise and fully customize the spreadsheet so it matches what is covered on the video.