Excel Intermediate - Maintain Your Data
The skills and knowledge acquired in Microsoft Excel 2016 – Intermediate enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.
In this course you will learn:
At the completion of this course you should be able to:
- Use the fill operations available to fill a data series
- Use a range of techniques to work with worksheets
- Apply a variety of page setup techniques
- Apply borders to cells and ranges in a worksheet
- Use common worksheet functions
- Create more complex formulas and functions
- Create and use defined names in a workbook
- Apply a range of number formatting techniques to worksheet cells
- Apply conditional formatting to ranges in a worksheet
- Use goal seeking to determine the values required to reach a desired result
What to bring:
- Pen
- Paper
Other Information:
- To ensure resources are ready for you at the start of your course, we ask you ideally enrol at least one week before the course commences.
- All courses need a minimum number of students to run ("we try our hardest to get those") . If your course does not have enough students it will be cancelled before the commencement and you will be informed.
<p><p>The skills and knowledge acquired in Microsoft Excel 2016 – Intermediate enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function
...<p><p>The skills and knowledge acquired in Microsoft Excel 2016 – Intermediate enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function
...If there isn't a class to suit you, please the waiting list.