Mastering Excel Basics and Features for Efficient Data Handling
Enhance your Excel skills with this detailed guide covering a range of topics from basic commands like copy/paste to advanced features such as merging cells, using formulas for dynamic date and time entries, and utilizing auto-fill for increased efficiency in data manipulation and presentation.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Excel Updates Excel Updates Using Formulas Using Formulas Glenn Nathan Instructional Technology ESC Region 19
Excel Basics Quick Commands in Excel Copy Ctrl+C Paste Ctrl+V Cut Ctrl+X Pressing Enter in a cell because you want to input information on another line Alt+Enter
Excel Basics How do I combine cells? Use the Merge and Center feature. This will combine multiple cells into one giant cell, however it only keeps the text from one cell.
Excel Basics How do I get the cell to expand as I enter information?
Excel Features Now your turn to practice. Select 10 cells and merge them together. In your new cell, enter the following information on a different line: Name Title Telephone Number Email Address Be sure your information all fits into the cell. (Hint: this has been mentioned but by a different name) Move your cell to another spot on the excel document
Excel Features Us there a way to enter the date so that it continually updates and inputs the current date? =TODAY() Your turn!! Can you reformat the cell to present your date with a different format? Right Click on the Cell Select Format Cells Select the format you wish to be displayed and click on OK Your turn to change the date format!
Excel Features Us there a way to enter the date AND time so that it continually updates and inputs the current date? =NOW() Your turn!! Can you reformat the cell to present your date and time with a different format? Right Click on the Cell Select Format Cells Select the format you wish to be displayed and click on OK Your turn to change the date and time format!
Excel Features Using auto-fill Left-click on the bottom right corner with the square. Hold and drag for the cells you want to auto-fill.
Excel Features This works to also complete a series or even formulas. You can change what information is entered into the cells by clicking on the icon.
Excel Formulas Formula Rules Always use the = sign to begin entering a new formula Addition Subtraction Multiplication Division Exponent Percent + - * / ^ %
Excel Formula A quick way to get the SUM of a series of cells is to click on the cell where you want the SUM and press ALT+
Excel Features How do I separate information into cells? Place last name in a cell Place first name in a cell
Excel Features Follow the wizard! Look at how you want to separate information In this example you would separate by comma
Excel Features You can also join text together using concatenation Here is the formula =CONCATENATE(E42,F42)
EXCEL TASK You can adjust the view by freezing rows or columns
EXCEL TASK You can adjust the view by freezing rows or columns
EXCEL TRICK Freeze the Top Row Freeze the First Column Create a custom pane. Place your cursor on the row or column after the row or column you want to freeze.
EXCEL TRICK By pressing F7 you can do a quick spell check of your excel document
Excel Task Go to my website to download the practice excel file. www.esc19.net Select Programs ----> Research and Analysis ----> Data Analysis Professional Development ----> HEADSTART PRACTICE FILE Open the file and begin by formatting the cell. Make the table look appealing. Set the spacing correctly. Everyone s Cost per hour must be completed as $125.00
Excel Task Given the following Excel sheet: Create the formula for Total Billable Hours and Total Revenue Format those cells appropriately Separate names into their own cells (Last Name and First Name) Resort the table in Alphabetical Order according to last name Move the information to a new sheet Find the total number of contact hours, PD hours, and billable hours Find the total number of billable hours
Excel Task Look at your original file.
Excel Task Can you take your original table and make it look like the following in less than 30 seconds?
Next Task Write a report (in MS WORD) to your supervisor discussing the information in the excel sheet. You must have one report for each consultant which breaks down their total in comparison to the overall total. Does this seem like a lot of work???? NOT IF YOU MAIL MERGE!!!!!
Mail Merge in WORD Lets walk through the process together. Follow along, take notes, and get ready to learn how to make custom letters, reports, etc. from your organized excel documents.
