Notes Module 2 - Why Learn Excel o Excel is the most...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Why Learn Excel? o Excel is the most popular spreadsheet tool today. o Excel has been regarded as the true “killer app” by many experts. o You probably already use or will soon be using Excel at work, and possibly at home. o Excel can be used for simple data management and problem-solving, as well as complex decision making. o From a Learning Standpoint: Excel can be used to cultivate Critical Thinking and Decision Making Skills Based on Robert Reich (former US Secretary of Labour): o Four Skills required for future job roles: o A good educational program is comprehensive across these skills. What can it be used for? o Business Use Context o Personal Use Context What other alternatives exist? o Other Vendors Microsoft Office Excel 2013 (Excel): o a computer program used to enter, analyze, and present (quantitative) data o a spreadsheet program A spreadsheet is a collection of text and numbers laid out in a rectangular grid. o Often used in business for accounting, budgeting, financial analysis, inventory management and other functions. An electronic spreadsheet program such as Excel aids a multitude of problem-solving & decision-making processes through providing: o data management features o automatic calculation functions o presentation tools o decision analysis functions Excel: o a computerized spreadsheet application used to build and manipulate worksheets and workbooks Worksheet: o a spreadsheet that may contain data including text, numbers, formulas, charts etc. o Sometimes a charts based worksheet is referred to as a “Chartsheet” Workbook: o a collection of related worksheets within one file
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
File Tab: o Consists of file operations commands such as opening, closing, saving, printing, and sharing files. o The options and features available here are part of the “Backstage view” Tabs & Ribbon: o Each tab corresponds to sets of features displayed horizontally as a ribbon. o A ribbon consists of groupings, and controls. o Tabs are designed to be task-oriented and consist of several logical groupings of controls that perform similar functions. Quick Access Toolbar: o Contains controls / commands that are most commonly used. Additional controls can be added through Excel Options settings through the Office Button. Select All button: o used to select all elements of the worksheet Status Bar: o Displays information about a selected command or operation in progress. o Also displays basic summary information about a selected range of values. HANDY HACK: o You can customize the status bar to show the types of summary information you are interested in. o Just right-click the status bar and select the options you wish to use. Cells, Ranges, and References: Each cell is referenced by its intersecting column (letter) and row (number): o e.g. cell A1 is the topmost left cell in the spreadsheet.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern