Transcription of Formulas and Functions with Excel - CDTL
{{id}} {{{paragraph}}}
Example: bachelor of science
Formulas and Functions with Excel - CDTL
Centre for Development of Teaching and Learning (CDTL) National University of Singapore email: Formulas and Functions with Excel Kiruthika Ragupathi Assistant Director (Educational Technology) TABLE OF CONTENTS Introduction .. 4 Exploring the Excel Workspace .. 4 Navigating the Workbook .. 4 Setting up Data .. 6 Inserting a new column or row .. 6 Formatting the worksheet .. 6 Verifying Data .. 8 Formulas and Functions .. 8 Constructing a formula .. 8 Inserting a function .. 10 Built-in Functions .. 12 Mathematical Calculations .. 14 Conditional Calculations.
Need to perform complex calculations and data analysis? The usage of formulas and functions is what gives an Excel spreadsheet much of its power.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: