Study Guides (248,551)
Canada (121,622)
Administration (1,205)
ADM1370 (82)

Module2_Excel.docx

6 Pages
57 Views
Unlock Document

Department
Administration
Course
ADM1370
Professor
Craig Kuziemsky
Semester
Winter

Description
MICROSOFT EXCEL INTRODUCTION TO MICROSOFT EXCELA computer program used to enter analyze and present data o A spreadsheet programCollection of text and numbers laid in a rectangular gridMainly used for accounting budgeting financial analysis inventory etcProvides presentation tools automatic calculation functions and data management features o Allowing for problemsolving and decisionmaking WORKSHEETS AND WORKBOOKSExcel uses worksheets and workbooksWorksheeta spreadsheet containing data such as text numbers formulas charts etcWorkbooka collection of related worksheetsBASIC COMPONENTS OF EXCELOffice Buttonoperations such as opening saving printing etcRibbontabs groupings and controlsQuick Access Toolbarmost commonly used controls and commandsSelect All ButtonStatus Bardisplays basic summary information PROPER WORKBOOK AND WORKSHEET DESIGNPlan before data entry o Decide on the purpose of the spreadsheet and the construction o Setup formulas since Excel was designed for automatic calculationsTest to make sure the results are what is expectedFormat worksheets to make them visually appealingDocument the worksheet thoroughly o Providing summaries and comments in separate worksheetsRegularly save work
More Less

Related notes for ADM1370

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit