200 likes | 317 Views
This beginner-friendly Microsoft Excel tutorial, presented by Garth, Paul, Kat, and Stephen, guides users through the fundamental features and functionalities of Excel. Covering system requirements, getting started, number formatting, and chart creation, this tutorial is designed to enhance your data management skills. Users will learn how to format spreadsheets, analyze and share information effectively, and create visually appealing charts. Ideal for anyone looking to gain confidence in using Excel, and maximize their productivity with this powerful tool.
E N D
MICROSOFT EXCEL TUTORIAL:A PROCESS MANUAL FOR BEGINNERS Presented by: Garth, Paul, Kat, Stephen
Introduction System Requirements Getting Started with Excel Formatting Numbers Creating a Chart / Graph Conclusion and Summary Questions? Overview ENGL 393
Microsoft Excel is one of the most prevalent and effective data management applications on the market. +create and format spreadsheets +analyze and share information Introduction ENGL 393
ComponentRequirement Computer & 500 MHz processor Memory 256 MB RAM Hard Disk 1.5 GB Drive CD-ROM or DVD Display 1024x768 Operating System Microsoft Windows XP w/ SP 2 System Requirements ENGL 393 **Requirements Listed for newest version: Microsoft Office Excel 2007
Open Excel from the Windows Start Menu, or launch the program from a short-cut on the desk-top. Getting Started with Excel ENGL 393 Double Click on the desk-top icon to launch the Microsoft Office Excel
Add commas to show thousands, millions, etc Add $ to show monetary value Formatting Numbers ENGL 393
Enter the data Formatting Numbers Cont’d… ENGL 393
Select a Cell Formatting Numbers Cont’d… ENGL 393
Formatting Numbers Cont’d… • Go to Format at the top menu • Select Cells
Formatting Numbers Cont’d… • Click the Number tab • Select Currency
Formatting Numbers Cont’d… • Check to see if a “$” is listed under Symbol • Click OK
Formatting Numbers Cont’d… • Dollar Sign should appear • Repeat the steps
Introduction Charts are easy to read Visual representation of data is often better than plain text Charts appeal to a larger audience Creating a Chart ENGL 393
Highlight cells including labels Choose Insert, then Chart Choose your chart sub-type Creating a Chart ENGL 393
Press next Preview the data Press next Create titles for chart and x & y axis Creating a Chart ENGL 393
Creating a Chart • Press Finish • Move chart to appropriate section of sheet
Effective Efficient User-friendly Intuitive Design Flexible Conclusion ENGL 393
Download a Free Trial http://office.microsoft.com/en-us/excel/FX100487621033.aspx The free trial is good for the first 60 days. After that you will have to upgrade or lose the license for the product. Getting Microsoft Excel ENGL 393