How do you use excel?

Question

I just started my mgtsc312(statistics) class in the lab and i have no idea how to use excel. This other girl and I were like the only ones amongst 65ppl who had difficulty keeping up. We were asked to do introductory problems to see what level we were at and two guys had to keep helping me...but i need to learn this quickly is there a site i can read up on with introductory problems that I could do and has solutions? thnx.

Answer 1

Hello Cindy,  This is quite a question, firstly taking a course in Excel statistics, yet looking for an introductory course to Excel.  I would love to help you through your course, and yet I'm thinking of places on-line where you can quickly learn the fundamentals required for your advanced Excel course.  Firstly, I would like to introduce you to www.mrexcel.com, where even when I have difficulty with advanced functions & formulas, this message board is not only quick with replies, but very informative.   Whether it be Excel 2003 or previous versions, I would suggest a basic understanding of Excel, along with a basic understanding of it's features.....

Spreadsheet Basics

 Screen elements

 Adding and renaming worksheets

 The standard toolbar - opening,

closing, saving, and more.

Customizing Excel

 Menus

 Customize toolbars

 Recording a macro

 Running a macro

Modifying A Worksheet

 Moving through cells

 Adding worksheets, rows, and

columns

 Resizing rows and columns

 Selecting cells

 Moving and copying cells

 Freeze panes

Formatting Cells

 Formatting toolbar

 Format Cells dialog box

 Dates and times

 Styles

 Style dialog box

 Create a new style

 Format Painter

 AutoFormat

Formulas and Functions

 Formulas

 Linking worksheets

 Relative, absolute, and mixed referencing

 Basic functions

 Function Wizard

 Autosum

Sorting and Filling

 Basic ascending and descending sorts

 Complex sorts

 Autofill

 Alternating text and numbers with Autofill

 Autofilling functions

Graphics

 Adding clip art

 Add an image from a file

 Editing a graphic

 AutoShapes

Charts

 Chart Wizard

 Resizing a chart

 Moving a chart

 Chart formatting toolbar

 Copy a chart to Microsoft Word

Page Properties and Printing

 Page breaks

 Page orientation

 Margins

 Headers, footers, and page numbers

 Print Preview

 Print

Keyboard Shortcuts

Keyboard shortcuts can save time and the effort of switching from the keyboard to the mouse to execute simple commands.

Document Actions

Cursor Movement

Formulas

Formatting

Text Style

Selecting Cells.  etc...

Again, I would love the opportunity to assist you in learning Excel, however, as previously mentioned, I wouldn't know where to begin.

With statistics you could be looking at functions to prepare for the following:

Database, Date & Time, Engineering, External, Financial, Information, Logical, Lookup & Reference, Maths, Text, & as you mentioned, Statistical, such functions as AVEDEV, AVERAGEA, COUNTIF, LARGE,  jst to mentiona  few of Excel statistical built-in functions.

In trust, Paul

Technology facilitator

dot-com

Answer 2

There are many good tutorial sites for software like excel.

Google is a very useful tool to find these but I did some homework for you and came up with this website. http://www.baycongroup.com/el0.htm