For my independent learning project, I decided to use Lynda.com again. Lynda.com is a learning platform website that helps individuals learn business, software, technology, and creative skills to achieve personal and professional goals. It includes a library of videos and tutorials of top-quality courses taught by industry experts. For my EME class, I was assigned an assignment that I have to use Excel for. I decided to use Lynda.com to become more educated using Excel. I did an Excel tutorial to learn the basis, since I was unfamiliar using this program. This was a great opportunity to learn more about Excel and do great on my assignment.
This is a screenshot of me using Lynda.com to learn new skills on Excel!
Prior to my assignment in this EME class, I had never used Excel. I knew that Excel is used by teachers for grading and by many business professionals. Microsoft Excel is a spreadsheet program. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. For my assignment, I had to interpret data from a survey I made and report it onto an Excel file.
The tutorial I chose was called "Excel Quick Tips." It provided me with so many techniques. I had absolutely no experience using Excel before so I was not even aware of the basic functions. This tutorial provided me with everything I needed to know. For example, it had tutorials on how to add and reference worksheets, select specific rows and columns, rotate and align cell data, freeze and lock panel options, and more! I watched all the tutorials. I learned how to use my mouse to drag series of data to different rows and columns. I also learned how to select the cells to merge them and then click merge and center. I also learned to use my mouse clicks or add or remove columns and rows.
I had so much fun learning how to use Excel on Lynda.com!
Here are some notes I took!
- To resize columns and rows: click the column or row, select the Home tab, then click the "format" button within the Cells group
- To add or removes columns: Click the Insert button within the Cells group and add or remove it
- Change the workbook names at the bottom on the left
- To change alignment: select the cells where you would like to apply the formatting, right click on the selection then click format Cells, click the Alignment tab, then use the mouse to change the orientation of the text or enter a value.
-To make a chart: highlight data and click insert and choose the appropriate graph
- Use format printer: click on a cell that has the correct formatting for your spreadsheet. Then in the ‘Home’ tab in the top ribbon, select ‘Format Painter’ under the clipboard section.Then your cursor will have a small paintbrush next to it so simply highlight the cells or cells you want to fit the format a click.
Prior to my assignment in this EME class, I had never used Excel. I knew that Excel is used by teachers for grading and by many business professionals. Microsoft Excel is a spreadsheet program. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. For my assignment, I had to interpret data from a survey I made and report it onto an Excel file.
The tutorial I chose was called "Excel Quick Tips." It provided me with so many techniques. I had absolutely no experience using Excel before so I was not even aware of the basic functions. This tutorial provided me with everything I needed to know. For example, it had tutorials on how to add and reference worksheets, select specific rows and columns, rotate and align cell data, freeze and lock panel options, and more! I watched all the tutorials. I learned how to use my mouse to drag series of data to different rows and columns. I also learned how to select the cells to merge them and then click merge and center. I also learned to use my mouse clicks or add or remove columns and rows.
I had so much fun learning how to use Excel on Lynda.com!
Here are some notes I took!
- To resize columns and rows: click the column or row, select the Home tab, then click the "format" button within the Cells group
- To add or removes columns: Click the Insert button within the Cells group and add or remove it
- Change the workbook names at the bottom on the left
- To change alignment: select the cells where you would like to apply the formatting, right click on the selection then click format Cells, click the Alignment tab, then use the mouse to change the orientation of the text or enter a value.
-To make a chart: highlight data and click insert and choose the appropriate graph
- Use format printer: click on a cell that has the correct formatting for your spreadsheet. Then in the ‘Home’ tab in the top ribbon, select ‘Format Painter’ under the clipboard section.Then your cursor will have a small paintbrush next to it so simply highlight the cells or cells you want to fit the format a click.
Comments
Post a Comment