To combine workbooks in excel follow the steps below Step 1: Copy the workbook in the same folder, the open a new work book and press ALT F11, It will open Microsoft Visual Basic for applications automatically, click on Insert, and click on Module, Copy and Paste the code below inside the module Sub GetSheets() […]
Scenario Manager helps Management on Decision making, Things to consider while working on a Scenario Manager using Excel are: Cost, Revenue and Profit.This Article will help users of Excel to create a Scenario Manager in ExcelStep 1: input the data you want to work on in the sheet Step 2: click on data and select […]
This topic will help excel users to make use of the sum function in excel Step1: input the data Note: when calculating the sum using the sum function in excel select the box you want to use for the total then type =sum( pick the first box that has the first figure and drag it […]
Solarex Information Technology World 2020 | All Rights Reserved.
