Posts

Showing posts from February, 2021
Image
  INTRODUCTION & USE OF MOUSE:   A mouse is a handheld device that lets you select and move items on your screen. When you move the mouse on your desk, the mouse pointer on your screen moves in the same direction.   START A PROGRAM:   You can start an office program to perform a task such as creating a letter, analyzing financial data or designing a presentation. Click Start. Click Programs. Click the program you want to start. The program appears on your screen. The office Assistant welcome appears the first time you start a program. Click this option to start using the program A button for the program appears on the taskbar.                                      EXIT A PROGRAM :                                                          When you finish using a program, you can exit the program. You should always exit all programs before turning off your computer. Click file Click Exit to shut down the

Microsoft Office best definitions and introduction

Image
Microsoft Office best definitions and introduction 

Top useful tips for MS Excel part 2

Image
Top useful tips for MS Excel part 2   To insert a new row or column, use Ctrl+Plus, this brings up the insert dialog box, you can select insert an entire row, an entire column,   To highlight an entire row, use Shift+Space, to highlight an entire column use Ctrl+Space.   To remove an entire column, Ctrl+Minus, but if you wanna avoid the dialog box, we're gonna highlight the entire column first, and then we're gonna do Ctrl+Minus. If you wanna drag an entire row and drop it somewhere else,   To hide a column use Ctrl+0, to hide an entire row, use Ctrl+9. When I first receive a new workbook from someone else, I wanna check if anything has been hidden in there or not. The shortcut key I use is Alt+; That highlights the visible cells only, and this way I get a visual indication that some rows and columns have been hidden. If nothing comes up, nothing is highlight, it means that no rows or columns have been hidden. For updating information herewe use the shortcut key Ctr

Top useful tips for MS Excel

Image
Top useful tips for MS Excel   I’m reall y excited about today's topic. It's a highly useful topic on Excel shortcuts that you should know. Your colleagues should know. Anyone who works with Excel should know. Let's get started. Click anywhere inside your data set, use Ctrl+Shift+L to add a filter to this, and then you can go about using the usual filter options, filter for names, press enter, that's my list. To deactivate the filter, click inside the data set, Ctrl+Shift+L takes it away. It's a toggle Ctrl+Shift+L puts it back Ctrl+Shift+L takes it away. Click anywhere inside the data set and press Ctrl+T. The table has headers, click on OK. The design tab is activated, you have a lot more table options. You can decide on the style you want, you can add a total row to this, summarize with a pivot table, or remove duplicates. Now there are many more advantages to tables. If for some reason you want to convert this back to a range, just click on convert to the range.

Microsoft Word Tips and Tricks

Image
Microsoft Word Tips and Tricks There are certain secret things in Microsoft Word which will really amaze you, these hidden tips and tricks of MS Word really mak e you go crazy. These tips will help you do things at your cursor point where you don't have to go to a special menu, tabs or options watch closely.  . Magical tip number on e this is a very handy new way to create tables Type plus and few minus or hyphens and again type plus sign and press the Enter key Voila you created a table with one row and 3 columns. Now to add more rows, take the cursor to the last cell in the columns and press the tab key.  . Note : you have to start with a plus and end with the plus sign and press Enter. The number of hyphens represents the column gap. In this way, you can create a table with different column width  . Magical Tip section. 2 – A handy way to create automatic horizontal lines or borders Tip 2. Type 3 or more asterisk and press enter. Tip 3. Type 3 or more hyphen and