Vlurn

28

Jul'15

Common Errors Encountered in a Financial Model due to MS Excel

A financial model, like any other analytical model, isn’t error proof. The financial modelling related errors can be divided into two – MS Excel related errors Errors due to poor knowledge of finance and industry

Read More

15

Jun'15

Shortcuts for editing object in MS PowerPoint (Changing dimension, positioning and orientation)

An object in PowerPoint may refer to a text box, a picture, a table, a shape or any such thing. Mostly our slides are composed of a lot of objects and so there is a constant need of editing them in terms of their dimensions, orientation or positioning. The above mentioned shortcuts help us do that efficiently. 

Read More

20

May'15

Numbers – The Spreadsheet Application of Apple Mac

MS Excel isn’t the only spreadsheet application around, though its popularity makes it far more recognizable than others. Nevertheless, there are other equally effective spreadsheet applications around. The most popular amongst them is Numbers, the spreadsheet application of Apple’s OS Mac.

Read More

19

May'15

Shortcuts for editing content in the text box in MS PowerPoint

Unlike MS Word, you can’t write anywhere on a PowerPoint slide just by double – clicking and typing. You can only write inside a text box and to add content on a specific point of a slide you first need to insert a text box there. There can be several text boxes on a single slide. To edit the content inside a text box quickly, you need to have a good knowledge of various shortcuts. Here we have highlighted the six most important ones.

Read More

12

Feb'15

5 Reasons Why Online Training is the Next Big Thing in India.

Online education is something which was hard to imagine 10 years ago and today it is making some strong progress across the world. Though in a larger domain it is hard to imagine someone taking 100% education online and complete elimination of traditional brick and mortar form of education, it is very well possible that specialized skills, vocational education and certain portions of higher education can be better delivered and received online.

Read More

26

Jul'14

Shortcut differences between MS Excel and Mac Numbers

A previous article on Mac keyboard has already made the users aware about how different it is from a normal desktop windows keyboard. In this article we go one step further and see how much the shortcuts of Numbers (the spreadsheet application of Mac) differ from that of Excel. 

Read More

20

May'14

How to view and edit a presentation simultaneously in MS PowerPoint

One action that many of us do frequently on MS PowerPoint is going for slideshow to check how the slides look after some editing/modifications. This consumes time and is equally irritating. But you will be delighted to know that MS PowerPoint has a wonderful feature in place which allows us to view and edit a slide simultaneously. This is how it is to be used.

Read More

20

May'14

Shortcuts to be used during Presentation mode

Apart from the general shortcuts which come handy in all three Microsoft Office applications, and the ones we discussed in our previous articles, there are few specific ones which can be used during delivering presentations. These shortcuts allow for swift navigation and editing even during a running presentation. 

Read More

20

May'14

Grouping Utility in MS PowerPoint

When we work with objects like shapes and pictures in a presentation, sometimes there is a need to combine them. The purpose might be moving them to some other slide or creating a new object using the existing ones. The grouping utility of MS PowerPoint helps us in performing this function. Let’s see how it is done. 

Read More

20

May'14

Grid Lines and Guides in MS PowerPoint

Gridlines and Guides is an important feature in PowerPoint which is often neglected. This is because it doesn’t have a direct use in presentation making. Instead it aids in making presentations cleaner and more precise. Before moving forward, it is imperative to understand the difference between the two. 

Read More

16

Apr'14

New Window Utility in MS Office

Sometimes our task requires constantly moving between two ends of the same Excel sheet or between two separate sheets of the workbook. It is time consuming and downright irritating. However, MS Excel has already provided us with amazing feature called New Window Utility in ms Office to deal with this.   So how this utility helps us? Clicking on new window will open the same workbook in a different window. This will allow us to refer to the sheets in our workbook from a separate window and excuse us from navigating the same sheet. This new window is actually just another view of the current file. It’s not a different version of the current file. So, any changes made in the current window will be reflected in the new window as well and vice-versa. You don’t need to save changes made in the new window separately! And MS Excel doesn’t ask you to save separately also.   The following video will explain it further.

Read More

16

Apr'14

10 Important ALT Based Shortcuts in MS Excel

All versions of MS Office applications have prompted users to use more of the keyboard. If you just press ALT in MS Office application, you will notice that all tabs get highlighted with an alphabet. If you then press any alphabet highlighting a tab, you are directed to that tab and all buttons in that tab now get highlighted with different alphabet or group of alphabets.   The following video will help you understand how to use these shortcuts in ms excel.

Read More

16

Apr'14

5 Important Selection Shortcuts in Excel

Whenever you will be working on MS excel, there will always be need of selecting data for copy-pasting or highlighting or other editing purpose. Sometimes you may have to select only few specific cells from a large number of cells. Selection shortcuts in excel make this task very easy for you. In the table we have discussed in brief the 6 most important selection keys.

Read More

16

Apr'14

5 Important Navigation Shortcuts in MS Excel

Shortcuts make the work on MS Excel a lot easier. You may have noticed, as you shuffle lesser between mouse and keyboard, your speed of work grows manifold. Navigation within a sheet or between different worksheets, Excel files and other applications is a part of our daily working and so the navigation keys have a huge role to play in optimizing our efficiency. In the table we have highlighted 5 very important navigation shortcuts.

Read More

16

Apr'14

Common Errors in a Financial Model due to Poor Knowledge of Finance Industry

Even after taking care of excel related errors in a financial model, it can still give you undesired results because of errors creeping into the financial model due to poor knowledge of finance industry. This article gives in brief the common errors that you can find in a financial model

Read More

2014-2015 | Vlurn Education Pvt. Ltd . All Rights Reserved