bedfalo.blogg.se

Whether you are upgrading your existing computer, or buying a new computer for a new employee, most new computers don’t come equipped with Microsoft Office – unless you pay extra. One of the best times to switch your office software is when you buy a new computer. ppt) so you can exchange files with people who use Word, Excel, and PowerPoint. OpenOffice opens and creates Microsoft-compatible files (.doc. OpenOffice is also a great choice for your home computer. If you work for a company where you can choose the software that runs on your computer, OpenOffice might be a good option. Not everyone can select their word processor or spreadsheet. OpenOffice even includes a drawing program – all for free. I have prepared data for salesmen for month wise sales and recording macro to prepare a report.In addition to the free software that lets you surf the Web and manage your email, we recommend the free OpenOffice software suite, which you can use instead of the Microsoft Office word processor, spreadsheet, and presentation software. Find the main tabs then Developer check box.Īctivate developer tab in MS Excel Creating a macro.A new dialog box appears, Find the customize ribbon from the dialog box.Follow these steps to activate the Developer tab. By default, it is not activated in excel. MS Excel provides a developer tab to work with macros. It is capable to perform any kind of complex calculations easilyĬlick here to read about more advantages.It reduces the errors occurring with repetitive tasks.User can use their names for each macro.User can record numerous formatting commands or formulas in a single worksheet.Repeat a number of commands in just one click or using the shortcut key.Similarly, a spreadsheet provides a feature called macro to record the commands, tasks, or the activities performed by the user on a specific worksheet or set of worksheets, and then it can be used to avoid repetition of commands or similar tasks in other worksheets.Ī macro is a recorded name of set of tasks or commands in MS Excel which is used to repeat them by single click or shortcut key. So if you want to learn something you can record the contents in your own voice and listen as many times as you want and you can learn anything easily. The best way to remember and learn something is by listening.