by Oluwaseun | Nov 23, 2022 | Project Management Tutorials and Articles
You can use the Workbook Analysis command to create an interactive report that can show detailed information about the workbook and its Structure, Formulas, Cells, Ranges and Warnings. Click the Inquire tab on the Ribbon. Click Workbook Analysis in the...
by Oluwaseun | Nov 23, 2022 | Project Management Tutorials and Articles
You can use Inquire to − Compare two workbooks. Analyze a workbook for problems or inconsistencies. View the links between workbooks. View the links between worksheets. View the relationships between cells. Clean excess cell formatting. Manage passwords. The INQUIRE...
by Oluwaseun | Nov 18, 2022 | Project Management Tutorials and Articles
The data that you obtain from different sources may not be in a form ready for analysis. You will understand how to prepare your data that is in the form of text for analysis. Initially, you need to clean the data. Data cleaning includes removing unwanted characters...
by Oluwaseun | Nov 16, 2022 | Project Management Tutorials and Articles
The Excel DATE function creates a valid date from the individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet. Purpose Create a date with year, month, and...
by Oluwaseun | Nov 14, 2022 | Project Management Tutorials and Articles
When you add text in a formula in Excel, you have to enclose the text with quotation marks (”…”). This is useful when you want to create a dynamic string that changes based on some conditions. But what happens when you want to put quotation marks as part...
by Oluwaseun | Nov 9, 2022 | Project Management Tutorials and Articles
In Microsoft Excel, you can use Conditional Formatting for data visualization. You have to specify formatting for a cell range based on the contents of the cell range. The cells that meet the specified conditions would be formatted as you have defined. You...
by Oluwaseun | Nov 7, 2022 | Project Management Tutorials and Articles
The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0, A1<10). The AND function can be used as the...
by Oluwaseun | Nov 3, 2022 | Project Management Tutorials and Articles
The VLOOKUP Function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information. In simple terms, the VLOOKUP function says the following to Excel, “Look for this piece of information (e.g.,...
by Oluwaseun | Nov 1, 2022 | Project Management Tutorials and Articles
The Excel DATE function creates a valid date from the individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet. Purpose Create a date with year, month, and...
by Oluwaseun | Oct 31, 2022 | Project Management Tutorials and Articles
Creating Data Model while Importing Data When you import data from relational databases like Microsoft Access database that contain multiple related tables, Data Model is automatically created if you import more than one table at once. You can optionally add tables to...