BI-812: EXCEL INTERMEDIATE ADDON
INTERMEDIATE E-MANUAL - AVAILABLE AS A DISTANCE LEARNING SELF PACED COURSE - CPE CERTIFICATE PROVIDED
Microsoft Excel - Produce Spreadsheets `Intermediate`E-Book is part of the FNS15 Training Package. This level extends the learner's basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. Some of the features include:
-
Plan, design and create spreadsheets using functions and formulas
-
Additional spreadsheet features
-
File extensions
-
Saving templates
-
Formatting cells
-
Auditing feature
-
Trace formula Precedents and Dependants
-
Working with tables
-
Use filters
-
Work with Text in a table
-
Charts, WordArt, clip art and text boxes
-
Working with multiple worksheets
-
Spreadsheet and data security
-
Protecting computer and printed data
-
Password protection
-
Locking and unlocking worksheet data
-
Import data from word into Excel
-
Introduction to Macros