Computer presentation .pptx

uyhfgf

1. Computer presentation Submitted to:- Dr. syed Faisal SUBMITTED BY………….. • Antony • Rashmi sharma • Naman Kapoor • Tanishka beniwal • Khushi •Farhan ahmed Group four …………………

2. TOPICS…… FORMATTING  CREATING GRAPHS  PRINTING THE WORKSHEET MACRON TABLES

3. Introduction of formatting

4. Alignment in Excel (Change it + Other Options) • In Excel, the alignment helps you to align the text and values in the worksheet cells. By default, the number aligns to the bottom right and the text aligns to the bottom left of the cell. In this tutorial, we will learn to adjust the text alignment in two ways- Horizontally and Vertically. Change Alignment using the Ribbon :- To change the alignment of the text in Excel from the ribbon. • First, select the range of cells that you want to realign. • Next, go to the Home tab and select the Alignment group.

5. Data alignment Vertical Alignment Horizontal alignment You can use the following options to align the data vertically. Top Align- It allows you to align the text as well as the number to the top of the ce ll. Middle- Aligns the data to the center of the cell. Bottom- This is the default option, and it puts contents to the bottom of the cell. To align the data horizontally, then use the below options:- Left Alignment- Aligns the text to the left edge of the cell. Center- It puts the text and number in the middle. Right- Aligns the contents to the right side of the cell.

6. Other Options Text Orientation (Rotate Text) :- It allows you to change the Orientation of the text vertically or diagonally. Wrap Text : - This option helps you to wrap the lengthy text into multiple lines in a cell. Indent : - There are two indents in the alignment group. When you click on the Increase Indent icon, it moves your text further to the right. However, to get the text back to the left, click on the Decrease Indent icon. Merge :- It is used to combine the selected cells into a single cell.

7. Change Text Alignment from Format Cells Options Another way to change the text alignment is through the format cell dialog box. Here, below are the steps for this. • Again, you need to select the cell that you want to re-align. • Next, open the Format cells dialog box from the bottom right corner arrow in the alignment group.

8. • Next, select the alignment tab from the format cells dialog box. In this, choose the desired option from the horizontal and vertical drop-down for aligning the text. • Now, select the horizontal and vertical text alignment from the drop-down options and click the Ok button to apply it to the selected cells.

9. For example, we select the “Distributed” in both horizontal and vertical text alignment. The below snapshot shows the text distributes equally across the height and width by increasing the space in between the words to fill the cell.

10. Print Worksheet in Excel You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table. You can also print a workbook to a file instead of a printer. This is useful when you need to print the workbook on a different type of printer from the one that you originally used to print it.

11. Print one or several worksheets Select the worksheets   that you want to print.  Select  File  >  Print , or press CTRL+P. Select the  Print  button or adjust  Settings  before you select the  Print  button. Print one or several workbooks All workbook files that you want to print must be in the same folder. Select  File  >  Open . Hold down CTRL click the name of each workbook to print, and then select  Print . Print all or part of a worksheet Click the worksheet, and then select the range of data that you want to print. Select  File , and then click  Print . Under  Settings , select the arrow next to  Print Active Sheets  and select the appropriate option. Select  Print .

12. Print an Excel table Select a cell within the table to enable the table. Select  File , and then select  Print . Under  Settings , select the arrow next to  Print Active Sheets  and select  Print Selected Table . Select  Print . In the  Save Print Output As  dialog box, enter a file name and then select  OK . The file will be saved in your  Documents  folder

13. CREATING GRAPHS

14. Types of garaph

15.  #Area Chart We can use  area charts  where we want to display  the changes  in  a data series over time.  This (  area chart  ) is almost  similar to  the  line chart,  the only difference is that in this the part below the line is filled with  some color . Types of Area Chart in Excel The sub-types of area charts are: Area Stacked Area 100% Stacked Area 3-D Area 3-D Stacked Area 3-D 100% Stacked Area

16.   # Column Chart We can use  column charts to compare two or more  data . If we talk about  default chart  in Excel , then this chart has been defined by Excel  as By Default Chart . In this chart, data appears in the form of  columns . With the help of which it becomes easy to compare  data . You can also apply it with the help  of short cut     ALT+F1 . Note:  If we talk about which are the most commonly used  types of chart in Excel,  then we will call you  column chart . Types of Column Chart in Excel Generally there are some types of column charts: Clustered Column chart Stacked Column chart 3D Column chart

17. #Bar Graph Here we can say that  Bar Chart  is a form of  Column Chart,  in this also  the chart  appears in the form of a graph, the  only difference  is that  the Column Chart is vertical  and  the Bar Chart is Horizontal.  . Note:  Bar chart's  X-axis  (Horizontal) contains numeric values ​​and  Y-axis  (Vertical) contains  data ranges . Type of Bar Chart in Excel Type of Bar Char is as follows: Clustered Bar Stacked Bar 100% Stacked Bar 3-D Clustered Bar 3-D Stacked Bar 3-D 100% Stacked Bar

18.   # Line Graph We should use line charts   when data  trends  are changing over time. This is then used to display it  in a graph . The lines representing data series in  a line chart  are  horizontal lines .  By looking at these lines, we can easily compare which data values ​​have  increased or decreased  and when . And it can also be found out how much was there at which  time . Types of Line Chart in Excel There are following types of line charts: Line Stacked Line 100% Stacked Line Stacked Line with Markers 3-D Line

19.  #Pie Chart Pie charts  in Excel are applicable only where there is only  one data set .  Its structure is  circular  and all the values ​​are shown in  different colors .  In this, the value whose  share  is in the total value is shown. This also comes in the list  of important types of charts in excel . Note: Pie charts show only positive values. Types of Pie Chart in Excel Following are the types of pie charts: Pie 3-D Pie Pie of Pie Bar of Pie

20. #Radar Chart If we want to display the  comparative  value of  multiple data categories  then we can use  radar chart .  It forms a  net like shape. There are many  axes  in it and the value is visible  relative  to  the center point of all the axes. We can use it when the given data is not  comparable  to  each other .

21. #Scatter chart Another name for  scatter chart is XY Chart  . It is used to show two or more data sets in the form of  a comparative graph . Scatter charts  are generally used to compare numeric values. In this  the graph  is shown through points. This is a different  type of chart in excel than all other types of charts . Type of Scatter Chart Scatter Scatter with Smooth Lines and Markers Scatter with Smooth Lines Scatter with Straight Lines and Markers Scatter with Straight Lines

22. Introduction of macros

23. What is an Excel Macro? Excel Macro is a record and playback tool that simply records your Excel steps and the macro will play it back as many times as you want. VBA Macros save time as they automate repetitive tasks. It is a piece of programming code that runs in an Excel environment but you don’t need to be a coder to program macros. Though, you need basic knowledge of VBA to make advanced modifications in the macro. Why are Excel Macros Used in Excel? As humans, we are creatures of habit. There are certain things that we do on a daily basis, every working day. Wouldn’t it be better if there were some magical way of pressing a single button and all of our routine tasks are done? I can hear you say yes. Macro in Excel helps you to achieve that. In a layman’s language, a macro is defined as a recording of your routine steps in Excel that you can replay using a single button. For example, you are working as a cashier for a water utility company. Some of the customers pay through the bank and at the end of the day, you are required to download the data from the bank and format it in a manner that meets your business requirements. You can import the data into excel and format. The following day you will be required to perform the same ritual. It will soon become boring and tedious. Macros solve such problems by automating such routine tasks . You can use a macro to record the steps of

24. Importing the data Formatting it to meet your business reporting requirements. What is VBA in a Layman’s Language? VBA is the acronym for Visual Basic for Applications. It is a programming language that Excel uses to record your steps as you perform routine tasks. You do not need to be a programmer or a very technical person to enjoy the benefits of macros in Excel. Excel has features that automatically generated the source code for you. Read the article on VBA for more details. Excel Macro Basics Macros are one of the developer features. By default, the tab for developers is not displayed in Excel. You will need to display it via customize report Excel Macros can be used to compromise your system by attackers. By default, they are disabled in Excel. If you need to run macros, you will need to enable running macros and only run macros that you know come from a trusted source If you want to save Excel macros, then you must save your workbook in a macro-enabled format *.xlsm The macro name should not contain any spaces. Always fill in the description of the macro when creating one. This will help you and others to understand what the macro is doing.

25. Step by Step Example of Recording Macros in Excel We will create a macro enabled template that will import the above data and format it to meet our business reporting requirements. Enable Developer Option To execute VBA program, you have to have access to developer option in Excel. Enable the developer option as shown in the below Excel macro example and pin it into your main ribbon in Excel. we will learn how to create a macro in Excel:

26. Step 1) Go to main menu “FILE” Select option “Options.”

27. Step 2) Now another window will open, in that window do following things Click on Customize Ribbon Mark the checker box for Developer option Click on OK button

28. Step 3) Developer Tab You will now be able to see the DEVELOPER tab in the ribbon Step 4) Download CSV First, we will see how we can create a command button on the spreadsheet and execute the program. Create a folder in drive C named Bank Receipts Paste the receipts.csv file that you downloaded

29. Step 5) Record Macro Click on the DEVELOPER tab Click on Record Macro as shown in the image below You will get the following dialogue window

30. Enter Import Bank Receipts as the macro name. Step two will be there by default Enter the description as shown in the above diagram Click on “OK” tab Step 6) Perform Macro Operations/Steps you want to record Put the cursor in cell A1 Click on the DATA tab Click on From Text button on the Get External data ribbon bar You will get the following dialogue window Go to the local drive where you have stored the CSV file Select the CSV file Click on Import button

31. You will get the following wizard Click on Next button after following the above steps

32. Follow the above steps and click on next button Click on Finish button Your workbook should now look as follows

33. Step 7) Format the Data Make the columns bold, add the grand total and use the SUM function to get the total amount. Step 8) Stop Recording Macro Now that we have finished our routine work, we can click on stop recording macro button as shown in the image below

34. Step 9) Replay the Macro Before we save our work book, we will need to delete the imported data. We will do this to create a template that we will be copying every time we have new receipts and want to run the Import Bank Receipts macro. Highlight all the imported data Right click on the highlighted data Click on Delete Click on save as button Save the workbook in a macro enabled format as shown below Make a copy of the newly saved template Open it Click on DEVELOPER tab Click on Macros button

35. You will get the following dialogue window Select Import Bank Receipts Highlights the description of your macro Click on Run button

36. You will get the following data Congratulations, you just created your first macro in Excel.

37. INDRODUCTION OF TABLES

38. What is a table in Excel? Excel table is a named object that allows you to manage its contents independently from the rest of the worksheet data. Tables were introduced in Excel 2007 as in improved version of Excel 2003 List feature, and are available in all subsequent versions of Excel 2010 through 365. Excel tables provide an array of features to effectively analyze and manage data such as calculated columns, total row, auto-filter and sort options, automatic expansion of a table, and more. Typically, a table contains related data that are entered in a series of rows and columns, though it can consist of a single row and/or column. The screenshot below shows a difference between a usual range and a table:

39. How to make a table in Excel Sometimes, when people enter related data in a worksheet, they refer to that data as a "table", which is technically incorrect. To convert a range of cells into a table, you need to explicitly format it as such. As is often the case in Excel, there is more than one way to do the same thing. 3 ways to create a table in Excel :- To insert a table in Excel, organize your data in rows and columns, click any single cell within your data set, and do any of the following: 1. On the Insert tab, in the Tables group, click Table . This will insert a table with the default style.

40. 2. On the Home tab, in the Styles group, click Format as Table , and select one of the predefined table styles. f you prefer working from the keyboard rather than using a mouse, the fastest way to create a table is pressing the Excel Table shortcut : Ctrl + T Whatever method you choose, Microsoft Excel automatically selects the entire block of cells. You verify if the range is selected correctly, check or uncheck the My table has headers option, and click OK .

41. As the result, a nicely formatted table is created in your worksheet. At first sight, it may look like a normal range with the filter buttons in the header row, but there is much more to it!

42. 5 most useful features of Excel tables As already mentioned, Excel tables offer a number of advantages over normal data ranges. So, why don't you benefit from the powerful features that are now only a button click away? 1. Integrated sorting and filtering options Usually it takes a few steps to sort and filter data in a worksheet. In tables, filter arrows are automatically added in the header row and enable you to use various text and number filters, sort in ascending or descending order, by color, or create a custom sort order.

43. If you don't plan to filter or sort your data, you can easily hide the filter arrows by going to the Design tab > Table Style Options group, and unchecking the Filter Button box. Or, you can toggle between hiding and showing the filter arrows with the Shift + Ctrl + L shortcut. Additionally, in Excel 2013 and higher, you can create a slicer to filter the table data quickly and easily. 2. Column headings are visible while scrolling When you are working with a large table that does not fit on a screen, the header row always remains visible when you scroll down. If this doesn't work for you, just be sure to select any cell inside the table before scrolling.

44. 3. Easy formatting (Excel table styles) A newly created table is already formatted with banded rows, borders, shading, and so on. If you don't like the default table format, you can easily change it by selecting from 50+ predefined styles available in the Table Styles gallery on the Design tab. Apart from changing table styles, the Design tab lets you turn the following table elements on or off: Header row - displays column headers that remain visible when you scroll the table data. Total row - adds the totals row at the end of the table with a number of predefined functions to choose form.

45. Apart from changing table styles, the Design tab lets you turn the following table elements on or off: Header row - displays column headers that remain visible when you scroll the table data. Total row - adds the totals row at the end of the table with a number of predefined functions to choose form. Banded rows and banded columns - display alternate row or column colors . First column and last column - display special formatting for the first and last column of the table. Filter button - shows or hides filter arrows in the header row. The screenshot below shows the default Table Style Options:

46. 4. Automatic table expansion to include new data Usually, adding more rows or columns to a worksheet means more formatting and reformatting. Not if you've organized your data in a table! When you type anything next to a table, Excel assumes you want to add a new entry to it and expands the table to include that entry. As you can see in the screenshot above, the table formatting is adjusted for the newly added row and column, and alternate row shading (banded rows) is kept in place. But it's not just the table formatting that is extended, the table functions and formulas are applied to the new data too! In other words, whenever you draw a table in Excel, it is a "dynamic table" by nature, and like a dynamic named range it expands automatically to accommodate new values. To undo the table expansion , click the Undo button on the Quick Access Toolbar, or press Ctrl + Z like you usually do to revert the latest changes.

47. 5. Quick totals (total row) To quickly total the data in your table, display the totals row at the end of the table, and then select the required function from the drop-down list. To add a total row to your table, right click any cell within the table, point to Table , and click Totals Row . Or, go to the Design tab > Table Style Options group, and select the Total Row box: Either way, the total row appears at the end of your table. You choose the desired function for each total row cell, and a corresponding formula is entered in the cell automatically: