This Formatting in Excel course consists of 8 sections with a total of 31 lectures. This course is unique in that it uses a sequential approach so that you can be faster at using Excel and develop skills to create more user friendly and error free workbooks.
SECTION 1 INTRODUCTION
Section 1 is an introduction. You will be able to understand what skills you are expected to gain in this course and be able to identify many problems in an existing workbook so that these issues can later be rectified. You will also learn some basic Excel functions.
It is split into 4 lectures:
- Formatting an Excel Workbook Introduction
- Introducing a Demo Workbook
- Relative Referencing, Autofill
- IF Statement
Lecture 1 Formatting an Excel Workbook Introduction
The lecture provides: an overview of the course, objectives, skills to be gained, skills not covered, the basic structure of the course with 5 main sections or parts mentioned. These main parts are Introduction, Formatting an existing workbook, Formatting skills, Redesigning an existing workbook and Closing comments.
You will learn:
- The objectives of the course
- What skills will be gained in the course
- What skills are not covered in the course
Lecture 2 Introducing a Demo Workbook
Introduces presenters and the Unformatted Excel workbook. A summary of the problems with an existing Excel workbook is provided.
You will learn what to focus on to improve and develop an Excel workbook.
Lecture 3 Relative Referencing, Autofill
You will gain skills in:
- Applying steps for manual copying of formula.
- Setting the advanced options for working in Excel so that Autofill can be used.
- How to use Autofill for copying of data.
By default, in Excel a cell reference is a relative reference, which means that the reference is relative to the location of the cell.
