All ms excel shortcut key pdf

July 2017 Internet Technology and Web Design

Solution for O level student PART 1 Title-Internet Technology and Web Design Year-July 2017 CLICK BELOW TO DOWNLOAD PAPER PART 1 Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

Know more>>

Excel lesson 7

How to Create Budget In Excel Spreadsheet with Template "Money is a tool. Used properly it makes something beautiful- used wrong, it makes a mess!" - Bradley Vinson It takes discipline to use money properly. In this tutorial, we are going to look at how we can use Excel to properly manage our personal finances. We will cover the following topics. Why manage Budget? Major components of a personal finance system Using Excel to set personal budgets, record income and expenses Visualizing the data using charts Why manage Budget? Let's face it, the world we live in is fuelled by money. We go to school to get a good job, engage in business and other related activities with the main goal of making money. If we do not manage our personal finances properly, then all of our efforts go to waste. Most people spend more than they earn. In order to be financially successful, one needs to develop a habit of spending less than they earn and invest the surplus in ...

Know more>>

Excel lesson 3rd

Excel Data Validation, Filters, Grouping In this tutorial, we are going to cover the following topics. Data validation Data filters Group and Ungroup Ading images to spreadsheets Data validation Data validation is very important in the sense that it helps us avoid mistakes that can be avoided . Let's assume you are recording student exam marks and you know the minimum is 0 and the maximum is 100. You can take advantage of validation features to ensure that only values between 0 and 100 are entered. Add a new sheet in your workbook by clicking on the plus button at the bottom of the worksheet. Add a column for S/N, Name and Score. Your sheet should look as follows S/N Name Score 1 Jane 2 James 3 Jones 4 Jonathan 5 John Click on the DATA tab Select the cells C2 to C6 (The cells that will be used to record the scores) Click on Data validation drop down list. Click on Data validation. You will get the following dialogue window Click...

Know more>>

Information Technology

Search This Blog