Edge Educations - Vivek Srivastava

  Excel 2016 Design Tab Lesson-4 Design Tab :- The Table Tools > Design tab allows to to change many different settings that apply to Tables, including the Table's name and style. You can also convert a Table back into an ordinary Range using this tab and quickly create Pivot Tables and Slicers.  Subtotal:-  The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others  and SUBTOTAL function can either include or exclude values in hidden rows. Get a subtotal in a list or database. Grand Totals:-  Grand Total for a range of cells Select the range of cells, and the blank row below the range, and the blank cells in the column to the right (cells A1:D5 in the example below) Click the AutoSum button on the Ribbon's Home tab. A SUM formula will be automatically entered for each Total. Report Layout:-  In Excel, Pivot tables have a defined basic structure, called a Report Layout (Form). In a new installation

  Excel 2016  Analyze  Tab Lesson-3 Analyze Tab: - The Excel Options control the behaviour and appearance of Excel, enabling you to adjust the operation of the spreadsheet package to suit the way you work. PivotTable Name -  The name given to this Pivot Table. It is used when Options -  Button with Drop-Down. The button displays the "PivotTable Options" dialog box, Layout & Format tab. The drop-down contains the commands: Options which display Options dialog box, Show Report Filter Pages, Generate Get Pivot Data. Active Field -  The name of the active field. Field Settings -  Displays the "Value Field Settings" dialog box. Drill Down:- Drill down is an analytics capability that allows users to instantly shift from an overview of data to a more detailed and granular view within the same dataset they are analyzing by clicking on a metric in a dashboard or report. Drill Up:- That's what we call “drill down,” as it's a feature allowing you to go much deeper

  Excel 2016 Insert Tab Lesson-2 Insert:- The Insert tab contains various items that you may want to insert into a document. These items include such things as tables, word art, hyperlinks, symbols, charts, signature line, date & time, shapes, header, footer, text boxes, links, boxes, equations and so on. Pivot Table:-  A pivot table is a special type of summary table that's unique to Excel. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas to perform the calculations. Pivot tables also let you play around with the arrangement of the summarized data. It's this capability of changing the arrangement of the summarized data on the fly simply by rotating row and column headings that gives the pivot table its name.Follow these steps to create a pivot table:  Open the worksheet that contains the table you want summarized by pivot table and select any cell in the table.Ensure that the table has no blank rows or

  Microsoft Excel 2016  Home Tab Lesson-1 Introduction:- Microsoft Excel Starter 2016 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items. ... If you find that you want more features, you can upgrade to Excel 2016 right from Excel Starter 2016. Total Column-16384 Total Row-1048576 1 Column+1Row=1Cell Default Row Height=15 Default Column Width=8.43 Method 1                                           Method  2 1.Start button                                      1.Start button 2.All Programs                                     2.All Programs 3.Ms Excel 2016                                  3.Accessories 4.Ok /Enter                                          4.Ms.Excel 2016 Ok Method 3                                                Method  4 1.Start  button                                        1.Start button  2.All Programs                                       2.Window + R 3.Search box