Microsoft Excel 2016

 Introduction to Microsoft Excel Macro. One of the most Microsoft Excel powerful feature that is called excel Macro. Macro is a way to automate your work. Let’s start with a simple idea. Now if you have ever found suffering the repeating the same steps over and over again or may be …

Microsoft Pivot Table One of the excel most creative and powerful tool is called a pivot table. It is a separate entity that you can create based on data. Typically, the data you used the source of the pivot table. Something is organized in the list. You can see below …

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. Those tools provide the ability to analyze data in a powerful skill and that helps you make better decisions. Using Goal Seek. Using Solver. Using Scenario Manager. Using data tables. Using Goal Seek. In the …

Learning Data Management Excel Features. In this lesson, we will learn Data Management Excel Features, where I have discussed following topics. Sorting data. Inserting subtotals in a sorted list. Using filters. Splitting data into multiple columns. Splitting and combining columnar data with Flash Fill. Removing duplicate records. Using validation tools. …

How to Secure and Share Excel Spreadsheet. In this article, we will learn How to Secure and Share excel spreadsheet. Where I have discussed following topics. Unlocking cells and protecting worksheets. Protecting workbooks. Assigning passwords to workbooks. Sharing workbooks. Tracking changes.   When you are creating Excel Spreadsheet. You want …

Microsoft Excel Spreadsheet Basics. In this article, we will learn about Microsoft Excel spreadsheet basics. Where I have discussed following topics. Renaming, inserting and deleting sheets. Moving, copying, and grouping sheets. Using formulas to link worksheets and workbooks. Locating and maintaining links.   Renaming, inserting and deleting sheets. Click on …

Adjusting Microsoft Excel Worksheet Views. It is very important to understand Adjusting Microsoft Excel Worksheet Views. So, In this article, we will show you how to work the Adjusting worksheets views. Where we will learn topics like Freezing and unfreezing panes, Splitting screens horizontally and vertically, Collapsing and expanding data …

How to Use Microsoft Excel Charts. In this lesson, we will learn How to use Microsoft Excel Charts. Where I have discussed following topics. Creating charts. Exploring chart types. Formatting charts. Working with axes, titles, and other chart elements. Creating incell charts with sparklines. Creating charts. Chart command is mostly …

How to Print Worksheet. In this lesson, we will learn how to print worksheet. Where I have discussed topics like Print preview, Workbook views, Orientation, Changing page size, Printing the highlight data, Print Tiles, Previewing page breaks, Working with Page Setup and printing controls and much more. Exploring the Page Layout tab and Page Layout view. …

Adjusting Microsoft Excel Spreadsheet Layout and Data. We will learn about Microsoft Excel spreadsheet layout and data. If you want to insert column and row and want to remove the row or column, or move or copy the sheet and also use find and replace commands. We will know all …