Skip to main content

Posts

Showing posts from December, 2020

Ms Excel - Templates

 Creating a Template Goto the file section and choose on New button and select the template that you want Saving the template  Goto Save as and choose to save in Excel Template format as shown below

Ms Excel - Charts

Creating Charts in Excel Choose a the collection of cells for which you want to build charts out of and select charts option near recommended charts button from insert toolbar  And then select the type of chart that you want to build  Moving the charts to another sheet Select the chart and go into the design page and choose move chart , as shown below Creating Pie charts Choose the data that you need in to illustrate in a Pie chart and then choose pie chart option from charts bar, and customize your Pie chart by choosing on necessary attributes inside the '+' button next to the chart They can only handle single row or single column of data.

Excel Course - Beginner to Advanced - Udemy Notes - Basic operations in Excel and how to do it

  Ribbon tab - the top tool-bar of the Excel Sheets  Formula bar - the bar below the Ribbon Tab of the excel sheet Status bar - the bottom most tool bar where you can zoom in and zoom out of an excel sheet Excel workbook - A sheet of an excel, where it is made up of Rows and columns - it has about some 1,048,576 ROWS and 16,384 COLUMNS  Upto 256 Sheets can be added for Excel to optimally work, but then the limit on the number of sheets that can be added totally depends on the Processing power of the CPU To change the number type format ·          Home -> number format -> change the type of number format Relative reference It refers to the way by which Cells across another locations can be referenced and used from some other cell position - Example as given below, Values from B4 to B8 can be referenced and added in another totally different position ABSOLUTE REFERENCE - When some cells are referenced by absolute reference then the reference of it does not change