Category: Advanced Excel

Advanced Excel – Quick Guide ”; Previous Next Advanced Excel – Chart Recommendations Change in Charts Group The Charts Group on the Ribbon in MS Excel 2013 looks as follows − You can observe that − The subgroups are clubbed together. A new option ‘Recommended Charts’ is added. Let us create a chart. Follow the steps given below. Step 1 − Select the data for which you want to create a chart. Step 2 − Click on the Insert Column Chart icon as shown below. When you click on the Insert Column chart, types of 2-D Column Charts, and 3-D Column Charts are displayed. You can also see the option of More Column Charts. Step 3 − If you are sure of which chart you have to use, you can choose a Chart and proceed. If you find that the one you pick is not working well for your data, the new Recommended Charts command on the Insert tab helps you to create a chart quickly that is just right for your data. Chart Recommendations Let us see the options available under this heading. (use another word for heading) Step 1 − Select the Data from the worksheet. Step 2 − Click on Recommended Charts. The following window displaying the charts that suit your data will be displayed. Step 3 − As you browse through the Recommended Charts, you will see the preview on the right side. Step 4 − If you find the chart you like, click on it. Step 5 − Click on the OK button. If you do not see a chart you like, click on All Charts to see all the available chart types. Step 6 − The chart will be displayed in your worksheet. Step 7 − Give a Title to the chart. Fine Tune Charts Quickly Click on the Chart. Three Buttons appear next to the upper-right corner of the chart. They are − Chart Elements Chart Styles and Colors, and Chart Filters You can use these buttons − To add chart elements like axis titles or data labels To customize the look of the chart, or To change the data that’s shown in the chart Select / De-select Chart Elements Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart. Step 2 − Click on the first button Chart Elements. A list of chart elements will be displayed under the Chart Elements option. Step 3 − Select / De-select Chart Elements from the given List. Only the selected chart elements will be displayed on the Chart. Format Style Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart. Step 2 − Click on the second button Chart Styles. A small window opens with different options of STYLE and COLOR as shown in the image given below. Step 3 − Click on STYLE. Different options of Style will be displayed. Step 4 − Scroll down the gallery. The live preview will show you how your chart data will look with the currently selected style. Step 5 − Choose the Style option you want. The Chart will be displayed with the selected Style as shown in the image given below. Format Color Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart. Step 2 − Click on Chart Styles. The STYLE and COLOR window will be displayed. Step 3 − Click on the COLOR tab. Different Color Schemes will be displayed. Step 4 − Scroll down the options. The live preview will show you how your chart data will look with the currently selected color scheme. Step 5 − Pick the color scheme you want. Your Chart will be displayed with the selected Style and Color scheme as shown in the image given below. You can change color schemes from Page Layout Tab also. Step 1 − Click the tab Page Layout. Step 2 − Click on the Colors button. Step 3 − Pick the color scheme you like. You can also customize the Colors and have your own color scheme. Filter Data being displayed on the Chart Chart Filters are used to edit the data points and names that are visible on the chart being displayed, dynamically. Step 1 − Click on the Chart. Three Buttons will appear at the upper-right corner of the chart. Step 2 − Click on the third button Chart Filters as shown in the image. Step 3 − Click on VALUES. The available SERIES and CATEGORIES in your Data appear. Step 4 − Select / De-select the options given under Series and Categories. The chart changes dynamically. Step 5 − After, you decide on the final Series and Categories, click on Apply. You can see that the chart is displayed with the selected data. Advanced Excel – Format Charts The Format pane is a new entry in Excel 2013. It provides advanced formatting options in clean, shiny, new task panes and it is quite handy too. Step 1 − Click on the Chart. Step 2 − Select the chart element (e.g., data series, axes, or titles). Step 3 − Right-click the chart element. Step 4 − Click Format <chart element>. The new Format pane appears with options that are tailored for the selected chart element. Format Axis Step 1 − Select the chart axis. Step 2 − Right-click the chart axis. Step 3 − Click Format Axis. The Format Axis task pane appears as shown in the image below. You can move or resize the task pane by clicking on the Task Pane Options to make working with it easier. The small icons at the top of the pane are for more options. Step 4 − Click on Axis Options. Step 5 − Select the required Axis Options. If you click on a different chart element, you will see that the task pane automatically updates to the new chart element. Step

Advanced Excel – Handling Integers ”; Previous Next In Power View, to convert a table to a chart, at least one data column needs to be aggregated. In Excel 2013, Power View aggregates both decimal numbers and integers by default. A Data Model designer can still specify other default behavior, but that is the default. In Power View, in the Power View Fields, some number fields will have a Sigma Σ symbol next to them. They are aggregates, meaning they will be summed or averaged. Step 1 − Click on Stacked Bar Chart. Power View has taken the Year as aggregate, as that is the only numeric field in the selected fields. Step 2 − Click on the drop-down arrow next to a text (non-numeric) field in the Power View Fields. Step 3 − Drag that field to Σ VALUES box. Power View has taken it as Count of the Values of the Field. Power Query Power Query is a data discovery and query tool in Excel 2013. You can use Power Query to Import data from external data sources, including big data sources like Hadoop and Facebook, shaping the data before you bring it into Excel and bringing in only the data you need. Search for public data from sources such as Wikipedia. Merge data from a variety of data sources, or append tables together, such as data from several shared tables in SQL Azure. Bring the result into Excel as a single table for − Visualizing in Power Map and Power View. Further analysis and modeling in Power Pivot. Share queries to the Power BI data catalogue so others can use it as a starting point for their data exploration. “Unpivot” source data from a PivotTable or matrix format to a flat table. To summarize, the Power Query Data Sources are − Web page, Excel or CSV file, XML file, Text file, Folder, SQL Server database, Microsoft Azure, SQL Database, Access database, Oracle database, IBM DB2 database, MySQL database, PostgreSQL Database, Sybase Database, Teradata Database, SharePoint List, OData feed, Microsoft Azure Marketplace, Hadoop File (HDFS), Microsoft Azure HDInsight, Microsoft Azure Table Storage, Active Directory, Microsoft Exchange and Facebook. Power BI Desktop Power BI is a collection of online services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. Power BI extends to all your mobile devices, too. Power BI introduces the Power BI Desktop, a dedicated report-authoring tool that enables you to transform data, create powerful reports and visualizations, and easily publish to the Power BI service. Power BI Desktop lets you create a collection of queries, data connections, and reports that can easily be shared with others. Power BI Desktop integrates proven Microsoft technologies – the powerful Query engine, data modeling, and visualizations – and works seamlessly with the online Power BI service. With the combination of Power BI Desktop (where analysts and others can create powerful data connections, models and reports) and the Power BI service (where Power BI Desktop reports can be shared so the users can view and interact with them), new insights from the world of data are easier to model, build, share, and extend. Data analysts will find Power BI Desktop a powerful, flexible, and a highly accessible tool to connect with and shape the world of data, build robust models, and create wellstructured reports. You can perform the following tasks in Power BI − Connect to Data Shape Data Combine Data Build Reports Share Your Work Connect to Data You can contact various web resources and find the ever-growing data in the world. You can Connect to the Data Source so that you can retrieve the Data you want and Adjust the data to meet your needs. The process of adjusting the connected data is called shaping the data. Shape Data As you Shape the Data, a Query Editor follows your instructions to adjust the data while loading. The original data source is not affected; only this particular view of the data is shaped. Steps to Shape Data may include − Rename a Table Rename a Column Transform a Data Type Delete Column Change text to numbers Remove Rows Setting the First Row as Headers Combine Data If the tables are a result of the queries you applied to the data, they are often referred to as queries. You can combine two tables, or queries, into one. There are two primary ways of combining queries – merging and appending. When you have one or more columns to add to another query, you merge the queries. When you have additional rows of data to add to an existing query, you append the query. If you have enough Data to create interesting Reports, save the Data as Power BI Desktop (.pbix) file. You can Load this data file whenever you want and you can make changes and Reload. Build Reports You can build Reports in Power BI Desktop Report view. The Report view has five main areas − The ribbon, which displays common tasks associated with reports and visualizations. The Report view, or canvas, where visualizations are created and arranged. The Pages tab area along the bottom, which lets you select or add a report page. The Visualizations pane, where you can change visualizations, customize colors or axes, apply filters, drag fields, and more. The Fields pane, where query elements and filters can be dragged onto the Report view, or dragged to the Filters area of the Visualizations pane. You can create different types of interesting reports and visualizations. Share Your Work You can share a completed Power BI Desktop report with the others on the Power BI service. There are a few ways to share your work in Power BI Desktop. You can publish to the Power BI service upload the .pbix file directly from the Power BI service save the .pbix file and send it like any other file Print Page

Advanced Excel – Additional Features ”; Previous Next Power View in Excel 2013 provides an interactive data exploration, visualization, and presentation experience for all skill levels as you have seen in the previous section. You can pull your data together in Tables, Matrices, Maps, and a variety of Charts in an Interactive View that brings your Data to life. New features have been added to Power View in Excel 2013. You can also publish Excel workbooks with Power View sheets to Power BI. Power BI saves the Power View sheets in your workbook as a Power BI report. Power View sheets can connect to different data models in one workbook. In Excel 2013, a workbook can contain − An internal Data Model that you can modify in Excel, in Power Pivot, and even in a Power View sheet in Excel. Only one internal Data Model, and you can base a Power View sheet on the Data Model in that workbook or on an external data source. Multiple Power View sheets, and each of the sheets can be based on a different data model. Each Power View sheet has its own Charts, Tables, and other Visualizations. You can copy and paste a chart or other visualization from one sheet to another, but only if both sheets are based on the same Data Model. Modify the internal Data Model You can create Power View sheets and an internal Data Model in an Excel 2013 workbook. If you base your Power View sheet on the internal Data Model, you can make some changes to the Data Model while you are in the Power View sheet itself. Step 1 − Select the worksheet Salesperson. You have a Range of Data of Salesperson and Salesperson ID. Step 2 − Now select the Worksheet Sales. You have a Range of Data of Sales. Step 3 − Convert the data in the worksheet Salesperson to table and name it Salesperson. Step 4 − Convert the data on the Sales Worksheet to table and name it Sales. Now, you have two tables in two Worksheets in the Workbook. Step 5 − Click on the Sales Worksheet. Step 6 − Click on the INSERT tab on the ribbon. Step 7 − Click on Power View. Power View sheet is created in the Workbook. In the Power View Fields list, you can find both the tables that are available in the Workbook. However, in the Power View, only the Active Table (Sales) Fields are displayed since only the active Data Table Fields are selected in the Fields List. In the Power View, Salesperson ID is displayed. Suppose, instead you want to display the names of the salespersons. Step 8 − De-select the Field Salesperson ID in Power View Fields. Step 9 − Select the Field Salesperson in the Table Salesperson in Power View Fields. You do not have a Data Model in the Workbook and hence no relationship exists between the two tables. Excel does not display any Data and displays messages directing you what to do. Step 10 − Click on the CREATE button. The Create Relationship Dialog Box opens in the Power View sheet itself. Step 11 − Create the relationship between the two tables using the Salesperson ID Field. You have successfully created the internal Data Model without leaving the Power View sheet. Print Page Previous Next Advertisements ”;

Advanced Excel – Templates ”; Previous Next Excel 2013 has thousands of online Templates of several categories that help you get started quickly by doing most of the set-up and design work for you. You can just focus on your data. Step 1 − Open Excel 2013. You will see many templates. You also see a Search Box on the top and some Categories below that. Step 2 − Click on the category – Business. You will get a message saying Excel is Searching Thousands of Online Templates. All the templates available in the category Business will be displayed. Also, all the categories available will be displayed on the right side, with the selected category listed as top most. The list of the categories gives the number of templates in each Category. Step 3 − Select another Category Sales from the Category List on the right side. The Category Sales moves up to the top most position in the Category List. The templates of the selected category Sales are displayed. Step 4 − Click on Regional sales chart Template. A brief description of the template, preview of the template and CREATE button are displayed. Step 5 − Click on CREATE. Excel creates a Sample Excel Worksheet with the Template you have chosen and with the sample data. Note that the Workbook Name, Worksheet Name, Chart Name are also given by Excel appropriately. Step 6 − Replace the data in the worksheet with your data. Your Excel Worksheet is ready with mere focus on data. Print Page Previous Next Advertisements ”;

Discuss Advanced Excel ”; Previous Next Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013. It has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner. Print Page Previous Next Advertisements ”;

Advanced Excel – Discontinued Features ”; Previous Next Discontinued / Changed features So far, you have seen the features that are added in Excel 2013. You also need to be aware of the − features existing in earlier versions of Excel that are no more available in Excel 2013, and the changed functionality in certain cases Save Workspace The Save Workspace command is no longer available in Excel. This command was used in earlier versions of Excel to save the current layout of all windows as a workspace. However, you can still open a workspace file (*.xlw) that was created in an earlier version of Excel. New from Existing In the earlier versions of Excel, the New from Existing option, which you get when you click File and then click New, let you base a new file on an existing one. This option is no longer available. Instead, you can open an existing Workbook and save it with a different file name. Step 1 − Click on File. Step 2 − Click on Save As. In the Save As dialog box give a different file name. Alternatively, check if the workbook you want to use is in the Recent Workbooks folder. Step 1 − Click on the File menu. Step 2 − Click on Open. Step 3 − Click on Recent Workbooks. If the file is available there, Step 4 − Right-click on its file name. Step 5 − Then Click on Open a Copy. Excel creates a copy of the file by adding a number to the file name. You can save the Workbook with a different file name as needed. Save as Template In the earlier versions of Excel, you can save a chart as a template on the Chart Tools ribbon by following the steps − Chart Tools → Design → Type. In Excel 2013, Save as Template is no longer available on the Ribbon. To save a chart as a template − Step 1 − Right-click on the Chart. Step 2 − Click on the Save as Template option. Excel saves the chart as a Chart template (*.crtx) in the default Microsoft Templates folder. You can use it to create a Chart or change a Chart Type. Step 1 − Select a Data Table. Step 2 − Click on the INSERT tab on the Ribbon. Step 3 − Click on Recommended Charts in the Charts group. The Insert chart window appears. Step 4 − Click on the All Charts tab. Step 5 − Click on Templates. Under the Header My Templates, your saved Chart Templates will be displayed. Similarly, to change a Chart Type − Step 1 − Right-click on a Chart. Step 2 − Click on Change Chart Type. The Change Chart Type window appears. Step 3 − Click on the All Charts tab. Step 4 − Click on Templates. Under the Header My Templates, your saved Chart Templates will be displayed. Split Box Control You used the Split Box Controls on the worksheet to split the window into panes at any position on the Worksheet in earlier versions of Excel. In Excel 2013, Split Box Control is removed. Instead, you can use the Split Command on the ribbon. Step 1 − Click on the VIEW tab on the Ribbon. Step 2 − Select the cell where you want to place the Split. Click on Split in the Window Group. The Split appears. As earlier, you can drag a split to reposition it, and double-click a split to remove it. Blank Workbook In the earlier versions of Excel, when you saved the Workbook settings, you frequently used a Workbook template called Book.xltx that is stored in the XLStart folder. This template would open automatically when you created a new blank Workbook. When you start Excel 2013, the Start screen appears and Excel does not open a new Workbook automatically. The blank Workbook, which you click on the start screen is not associated with Book.xltx. You can set up Excel to open a new Workbook automatically that uses Book.xltx − Step 1 − Click on File. Step 2 − Click on Options. The Excel Options window appears. Step 3 − Click on General. Step 4 − Uncheck the Show the Start screen when this application starts box under the Start up options. The next time you start Excel, it opens a Workbook that uses Book.xltx. Save Options In the earlier versions of Excel, when you saved a Workbook as a template, it automatically appeared in the My Templates folder under the Available Templates. In Excel 2013, when you save a Workbook as a template, it will not automatically appear as a personal template on the new page. Step 1 − Click on the File tab. Step 2 − Click on Options. Step 3 − Click on Save. In the default personal templates location box, enter the path to the templates folder you created. Microsoft Clip Organizer Microsoft Clip Organizer is no longer included in Office 2013. The Clip Organizer feature is replaced by the Insert Pictures dialog box (Insert > Online Pictures). This new Insert Online Pictures feature lets you find and insert content from the Office.com Clip Art collection and other online sources, such as Bing Image/Video search, Flickr, and your OneDrive or Facebook page. In Excel 2013, Microsoft Clip Organizer is not included. Instead, you can insert Pictures from online sources such as Bing Image Search, Flickr, your OneDrive, and Facebook. Step 1 − Click on the INSERT tab on the ribbon. Step 2 − Click on the Online Pictures button in the Illustrations group. An Insert Pictures dialog box opens. Step 3 − Select the picture from any of the sources. MS Office Picture Manager Microsoft Office Picture Manager is removed. Exit option In the earlier versions of Excel, you can exit Excel and close all the open workbooks at once. This was causing confusion among the different close and exit commands in Backstage View. Hence, it is removed.

Advanced Excel – File Formats ”; Previous Next Save a Workbook in another File Format When you save an Excel 2013 Workbook, by default it saves in the .xlsx format. Excel 2013 supports saving in other formats, but whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved. File Formats (File Types) that are supported in Excel 2013 − Excel File Formats Text File Formats Other File Formats Excel File Formats Format Extension Description Excel Workbook .xlsx The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm). Strict Open XML Spreadsheet .xlsx An ISO strict version of the Excel Workbook file format (.xlsx). Excel Workbook (code) .xlsm The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm) Excel Binary Workbook .xlsb The binary file format (BIFF12) for Excel 2007-2013. Template .xltx The default file format for an Excel template for Excel 2007-2013. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm). Template (code) .xltm The macro-enabled file format for an Excel template in Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm). Excel 97- Excel 2003 Workbook .xls The Excel 97 – Excel 2003 Binary file format (BIFF8). Excel 97- Excel 2003 Template .xlt The Excel 97 – Excel 2003 Binary file format (BIFF8) for an Excel template Microsoft Excel 5.0/95 Workbook .xls The Excel 5.0/95 Binary file format (BIFF5). XML Spreadsheet 2003 .xml XML Spreadsheet 2003 file format (XMLSS). XML Data .xml XML Data format. Excel Add-In .xlam The XML-based and macro-enabled Add-In format for Excel 2007-2013. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm). Excel 97-2003 Add-In .xla The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects. Excel 4.0 Workbook .xlw An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Excel 2013, but you cannot save an Excel file to this file format. Text File Formats If you save a workbook in any text format, all formatting is lost. Format Extension Description Formatted Text (Spacedelimited) .prn Lotus space-delimited format. Saves only the active sheet. Text (Tabdelimited) .txt Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. Text (Macintosh) .txt Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. Text (MS-DOS) .txt Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. Unicode Text .txt Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium. CSV (comma delimited) .csv Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. CSV (Macintosh) .csv Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. CSV (MS-DOS) .csv Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet. DIF .dif Data Interchange Format. Saves only the active sheet. SYLK .slk Symbolic Link Format. Saves only the active sheet. Other File Formats Format Extension Description DBF 3, DBF 4 .dbf dBase III and IV. You can open these files formats in Excel, but you cannot save an Excel file to dBase format. OpenDocument Spreadsheet .ods OpenDocument Spreadsheet. You can save Excel 2010 files so they can be opened in spreadsheet applications that use the OpenDocument Spreadsheet format, such as Google Docs and OpenOffice.org Calc. You can also open spreadsheets in the .ods format in Excel 2010. Formatting might be lost when saving and opening .ods files. PDF .pdf Portable Document Format (PDF). This file format preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. Data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods. XPS Document .xps XML Paper Specification (XPS). This file format preserves document formatting and enables file sharing. When the XPS file is viewed online or printed, it retains exactly the format that you intended, and the data in the file cannot be easily changed. Step 1 − Select the File menu. Step 2 − Click on the option Save As. You get a choice of places to save the Workbook, both on local devices (e.g. Computer) and internet (e.g. OneDrive). Step 3 − Click on Computer. The Save As Dialog box opens. Step 4 − Click on Save As type. The file formats will be listed. The file formats displayed depend on the type of active Worksheet in your Workbook (Data Worksheet, Chart Worksheet, or other type of Worksheet). Step 5 − Click on the File Format you want. File Formats that Use the Clipboard You can use the Clipboard to copy data to the clipboard in few File Formats, which you can paste into Excel using the command Paste or Paste Special. Format Extension Clipboard Type Identifiers Picture .wmf or .emf Pictures in

Advanced Excel – Useful Resources ”; Previous Next The following resources contain additional information on Advanced Excel. Please use them to get more in-depth knowledge on this topic. Useful Video Courses Advanced Excel (Power Query) Training Course Best Seller 58 Lectures 5.5 hours Tutorialspoint More Detail Advanced Excel A-Z (With VBA) in Telugu 93 Lectures 10.5 hours Vijay Kumar Parvatha Reddy More Detail Microsoft Excel – Beginners to Advanced Level 22 Lectures 3.5 hours Namita Devi More Detail Master MS Excel – Beginner to Advanced Course Featured 226 Lectures 22 hours Jay Pratap Singh More Detail Excel Advanced – Pivot Tables, Tables, Graphs and Creating Visual Reports 4 Lectures 1 hours Bizfacility More Detail Advanced Excel 2016 – Key Features 19 Lectures 2.5 hours Corporate Bridge Consultancy Private Limited More Detail Print Page Previous Next Advertisements ”;

Advanced Excel – Power View ”; Previous Next Power View is a feature of Microsoft Excel 2013 that enables interactive data exploration, visualization, and presentation encouraging intuitive ad-hoc reporting. Create a Power View Sheet Make sure Power View add-in is enabled in Excel 2013. Step 1 − Click on the File menu and then Click on Options. The Excel Options window appears. Step 2 − Click on Add-Ins. Step 3 − In the Manage box, click the drop-down arrow and select Excel Add-ins. Step 4 − All the available Add-ins will be displayed. If Power View Add-in is enabled, it appears in Active Application Add-ins. If it does not appear, follow these steps − Step 1 − In the Excel Options Window, Click on Add-Ins. Step 2 − In the Manage box, click the drop-down arrow and select COM Add-ins Step 3 − Click on the Go button. A COM Add-Ins Dialog Box appears. Step 4 − Check the Power View Check Box. Step 5 − Click OK. Now, you are ready to create the Power View sheet. Step 1 − Click on the Data Table. Step 2 − Click on Insert tab. Step 3 − Click on Power View in Reports Group. An Opening Power View window opens, showing the progress of Working on opening Power View sheet. The Power View sheet is created for you and added to your Workbook with the Power View. On the Right-side of the Power View, you find the Power View Fields. Under the Power View Fields you will find Areas. In the Ribbon, if you click on Design tab, you will find various Visualization options. Print Page Previous Next Advertisements ”;

Advanced Excel – Manage Passwords ”; Previous Next If you are using Workbook Analysis or Compare Files commands for Workbooks that are password-protected, you can avoid having to type the password each time those files are opened. Excel 2013 has a Password Manager, which can be accessed through the Workbook Passwords Command. Step 1 − Click on the INQUIRE tab on the ribbon. Step 2 − Click on Workbook Passwords in the Miscellaneous Group. The Password Manager window opens. Step 3 − Add passwords of your Workbooks. Add password descriptions also. Embed Worksheet Data in a Web Page To share a part of your worksheet on the web, you can simply embed it on your web page. Other people can then work with the data in Excel Online or open the embedded data in Excel. Share an Excel worksheet in an online meeting You can present your Workbook online if you have the Lync installed. Step 1 − Close all the Workbooks that you do not want to share and keep only the Workbook you want to share Open. Step 2 − Click on the File menu. Step 3 − Click on the option – Share. Step 4 − Click on Present Online. Step 5 − Under the option – Present Online, click Present. Step 6 − In the Share Workbook Window, pick a scheduled meeting or click Start a new Lync meeting, and then click OK. Step 7 − To stop sharing, click Stop Sharing at the top of the screen. You can present your Workbook online if you have a Skype Account also. Microsoft is introducing Skype for Business. Print Page Previous Next Advertisements ”;