Study Guides (248,064)
Canada (121,274)
Administration (1,201)
ADM1370 (78)
All (22)

Module 2 Lecture Notes.docx

19 Pages
199 Views
Unlock Document

Department
Administration
Course
ADM1370
Professor
All Professors
Semester
Fall

Description
Lecture 9Why are we learning ExcelWhy Learn ExcelExcelisthemostpopularspreadsheettooltodayExcelhasbeenregardedasthetruekillerappbymanyexpertsYouprobablyalreadyuseorwillsoonbeusingExcelatworkandpossiblyathomeExcelcanbeusedforsimpledatamanagementandproblemsolvingaswellascomplexdecisionmakingFromalearningstandpointexcelcanbeusedtocultivateCriticalThinkingandDecisionMakingSkillsBased on Robert Reich former US Secretary of LabourFourSkillsrequiredforfuturejobrolesAgoodinformationSystemseducationiscomprehensiveacrosstheseskillsIntroduction to Microsoft ExcelMicrosoft Office Excel 2010 ExcelAcomputerprogramusedtoenteranalyzeandpresentquantitativedataAspreadsheetprogramAspreadsheetisacollectionoftextandnumberslaidoutinarectangulargridOftenusedinbusinessforaccountingbudgetingfinancialanalysisinventorymanagementandotherfunctionsAnelectronicspreadsheetprogramsuchasExcelaidsamultitudeofproblemsolvingdecisionmakingprocessesthroughprovidingdatamanagementfeaturesautomaticcalculationfunctionspresentationtoolsdecisionanalysisfunctionsWorksheets and WorkbooksExcelacomputerizedspreadsheetapplicationusedtobuildandmanipulateworksheetsandworkbooksWorksheetaspreadsheetthatmaycontaindataincludingtextnumbersformulaschartsetcSometimesachartsbasedworksheetisreferredtoasaChartsheetWorkbookADM1370 QUIZ 21acollectionofrelatedworksheetswithinonefileBasic Components of the Excel InterfaceFile TabConsistsoffileoperationscommandssuchasopeningclosingsavingprintingandsharingfilesTheoptionsandfeaturesavailableherearepartoftheBackstageviewTabsRibbonEachtabcorrespondstosetsoffeaturesdisplayedhorizontallyasaribbonAribbonconsistsofgroupingsandcontrolsTabsaredesignedtobetaskorientedandconsistofseverallogicalgroupingsofcontrolsthatperformsimilarfunctionsQuick Access ToolbarContainscontrolscommandsthataremostcommonlyusedAdditionalcontrolscanbeaddedthroughExcelOptionssettingsthroughtheOfficeButtonSelect All ButtonUsedtoselectallelementsoftheworksheetStatus BarDisplaysinformationaboutaselectedcommandoroperationinprogressAlsodisplaysbasicsummaryinformationaboutaselectedrangeofvaluesHANDYHACKYoucancustomizethestatusbartoshowthetypesofsummaryinformationyouareinterestedinJustrightclickthestatusbarandselecttheoptionsyouwishtousePlanning for Good Workbook and Worksheet DesignPlan before you start entering dataDecideonthepurposeofthespreadsheetandhowitwillbeconstructedMakeitobviouswheredataistobeenteredUsetitlesheadingsinstructionscolorschemesandformstodesignateareasfordataentryWhereverpossiblesetupformulasandusecellreferencesforcalculationsAllowExceltodowhatitwasdesignedforieautomaticcalculationsoTrytominimizehardcodednumbersinyourcalculationsTest multiple times to make sure the results are what you expectCheckyourresultsagainstyourmentalmodelofwhattheresultsshouldbeFormat the worksheet so it looks aesthetically pleasingDocument the worksheet as thoroughly as possibleProvidesummariesorcommentsinaseparateworksheetincludingrangesbeingusedforcalculationsandanalysisSave your work regularly2ADM1370 QUIZ 2
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