Excel 2016 Level 3: Automating Worksheet Functionality
R150.00 Ex.VAT 15%
In Excel 2016, you can view, add, or even edit the properties of an existing workbook. These properties can include information such as who authored the workbook, date information, and more. This type information is referred to as metadata, and it can very useful when managing multiple workbooks. Over the course of this topic you will learn all about workbook properties and how to work with them.
Available!
Return to StoreIn this course, we will learn how to:
- Update workbook properties
- Create and edit a macro
- Apply conditional formatting
- Add data validation criteria to a workbook
Related Products
-
-
Hiring for Success: Behavioral Interviewing Techniques
R599.00 Ex.VAT 15%Interviewing sounds easy enough: you arrange for a conversation between you and potential candidates, and then select the best person for a particular position. But what if you could refine the process in such a way that you were confident that you are selecting the right person? How do you separate the good from the great, when they have similar work experience and strengths to offer? This workshop will give you the skills and tools to hire successful candidates. -
Effective Planning and Scheduling
R599.00 Ex.VAT 15%This course will teach you how to use a variety of planning and scheduling tools, including the work breakdown structure, network diagrams, program evaluation and review technique (PERT), and Gantt charts. You will also learn how to properly estimate time, schedule resources, identify task dependencies, manage risks, communicate your schedule, and keep the schedule updated.
