Formatting an Excel Workbook: practical skills

Partner: Udemy
Affiliate Name:
Area:
Description: 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 INTRODUCTIONSection 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 IntroductionIntroducing a Demo WorkbookRelative Referencing, AutofillIF StatementLecture 1 Formatting an Excel Workbook IntroductionThe 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 courseWhat skills will be gained in the courseWhat skills are not covered in the courseLecture 2 Introducing a Demo WorkbookIntroduces 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, AutofillYou 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.</l
Category: Office Productivity > Microsoft > Microsoft Excel
Partner ID:
Price: 24.99
Commission:
Source: Impact
Go to Course