Learn Advance Excel, Data Analysis, Sql and Python Programming using notebook jupyter
GOAL SEEK GOAL SEEK is an excel in built in what_if_analysis tool that shows how one value is a formula impacts another.THE GOAL SEEK changes the variable to study the variation in the results…… It also determines what value you should input in a cell to get the desired results in a formula.. Steps …
HOW TO CREATE PIVOT TABLE AND CHART *CREATE A TABEL WITH THE REQUIRED INFORMATION. *GO TO INSERT , CLICK ON PIVOT TABLE OR CHART. *A PIVOT TABLE RANGE WILL BE PRESENTED. *FILL IN THE NECESSARY DATA REQUIRED THEN CLICK ON ENTER. *THE PIVOT TABL WILL BE SHOWN DEPENDING WETHER YOU CHOSE IT TO BE ON …
SCENARIO MANAGER EXCEL SCENARIO MANAGER is a collection of digital tools that allows a user to create ,analyze and compare data results in different business situations Key uses of scenario manager 1.RECORD SCENARIOS 2.CREATE TESTSTEPS AND TESTSTEPVALUES MANUALLY 3.MERGE TESTSTEPS 4.ADD ATTACHMENTS 5.RECORD ,EDIT AND EXPORT PICTURES E.T.C
HOW TO CREATE A FORM USING EXCEL *Create a table with header in microsoft excel *Go to files then click on “OPTIONS” *After clicking on “OPTIONS”,Click on “QUICK ACCESS TOOL BAR” *Under “CHOOSE COMMANDS FROM” Click on “COMMAND NOT IN RIBBON” *Then search for “FORM” and click on ENTER *Back to home; Highlight the cells …
As a leading Information Technology company in Ibadan and Nigeria, we are passionate in sensitizing children, students and youth in starting Information Technology early in life as this will help them to go far in their chosen career. There are limitless opportunities in Information Technology and there is no age barrier, the earlier they start …
