You will also cover conditional functions and using data across worksheets. In Excel 4a you will be introduced to lookup functions, which are used to examine data tables to extract specific information, and are widely used in professional environments (data analysis, building financial models). You will also look at absolute cell referencing (first seen in Excel 2) to create flexible custom calculations. In Excel 3, you will use functions to find the sum, average, maximum and minimum values within a dataset. In Excel 2 you will learn to create more efficient formulas, through absolute cell referencing, and more efficient workbooks, by learning how to use formulas across different worksheets within one Excel workbook. You will create a budget that includes basic calculations, copying cells and formulas efficiently, and you will also learn essential good practice principles to keep your Excel sheet clean and easy to use. Whether you are completely new to Excel or are self-taught and looking for a refresher, Excel 1 is a good starting point. The Excel Fundamentals workshops are designed to give you a good working knowledge of the basic functionalities in Excel, including how to set up efficient formulas and workbooks, condition-based functions and functions that assess data tables to extract specific information.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |