Excel : Level 1 : Post 10 : Excel Templates

An excel template is also a workbook, but it is used to make a new workbook. You will have properly formatted sheets, all you have to do is to insert your data values at designed places in the sheet. This is how a template works. Apart from a big list of available templates, you can… Read More »

Excel : Level 1 : Post 9 : The File menu

In this post, we will work on different workbook file operations. File menu works in the backstage view, this view is a part of the workbook but not worksheet. We see the backstage view when we click File button. Create a New Workbook FILE–>NEW–>Select the BLANK WORKBOOK (You will also see multiple templates here) CTRL+N… Read More »

Excel : Level 1 : Post 8 : Formatting the Worksheet

While there are people who consider formatting not as important, a larger group of people (including myself) believes that this is one of the important tasks to accomplish to get a super final product. All the number crunching and calculations that you have done on a worksheet comes alive if supported by good formatting. You… Read More »

Excel : Level 1 : Post 7 : Tables

Simply put, a table is a range of data. Each row in a table is an observation for a single entity. Each column consists of a very specific information. An intersection of a row and column reflects data about a very specific information of a very specific observation. For example, a row could contain information… Read More »

Excel : Level 1 : Post 6 : Cells and Ranges

We are aware with the fact that a cell is the elementary unit of an excel worksheet. It can hold your values, text, formulas etc. Each cell comes with an address of its own. This address is unique to a cell and is made up of row number and column alphabet. Once you are working… Read More »

Excel : Level 1 : Post 5 : Vital operations in a Worksheet

Fundamentals of Excel Worksheets There are certain key-points about Excel worksheet we all must be aware of. I have listed them below: Activating a worksheet: simply click on the worksheet you want to work with, it will be activated Add a new worksheet: a plus sign is present below, near the worksheet names, use it… Read More »

Excel : Level 1 : Post 4 : Number Formatting

Using formatting techniques, we can change the values inside a cell according to our needs. In this post, we will see a number of formatting options to enhance the appearance of a worksheet. By default, the values that we enter in a cell are not formatted. In easy words, a cell simply contains some numerals… Read More »

Excel : Level 1 : Post 3 : Editing Worksheet Data

The fact is very well known to us that an excel workbook can hold any number of worksheets. And we also know the dimension of each worksheet from the previous post. We now need to know about how are we going to edit all the large/small data present on our worksheet(s). This post deals with… Read More »

Excel : Level 1 : Post 2 : Creating your first Excel Workbook

In this example, we create a simple monthly projection of sales and we try to create a chart for this projection. Simply follow the steps as instructed: Start by giving appropriate titles to your columns. Keep it a habit of writing variable names in the row 1 of your worksheet. Enter month names as suggested… Read More »

Excel : Level 1 : Post 1 : The goodness of MS-Excel

We all are well aware of the fact that MS-Excel is the world’s biggest and mostly used spreadsheet software. You can imagine how big it is when I say that there are companies out there who are solely working on MS-Excel and MS-Office suite. Excel has been categorized as the world’s standard and all the… Read More »

MATLAB : Post 33 : Sub-Functions

I discussed about function M-Files in my previous posts. Sub-functions are similar to function M-files. The only difference is that sub-functions resides inside another function M-file. Whereas a function M-file is a separate and physical entity. A function M-file can be used in any other M-file, whether script or function. But a sub-function is an… Read More »

MATLAB : Post 32 : BREAK and CONTINUE statements

Both these statements are used with loops (for and while). Their function is pretty literal with their names. break will stop execution of a loop and continue will start the loop’s next iteration from the start. Following example will make sure that you understand these concepts. I invested a capital and expects it to get… Read More »

MATLAB : Post 30 : Branching using IF and SWITCH commands

Branching commands come in handy when you want to perform a selected operation if a certain condition is true. In short, your actions depends upon your conditions. A particular condition should trigger a particular action. To perform such tasks, we use branching commands in MATLAB. Many of us, who are familiar with programming know these… Read More »

MATLAB : Post 29 : MATLAB Graphics : Special Effects

As of now, our discussion was mainly concentrated on MATLAB graphics commands which were working on a single figure window. In this post, we will talk about commands in MATLAB which are responsible for working out multiple graph windows at once. We will also discuss command which is capable of generating animated graphics that changes… Read More »

MATLAB : Post 28 : MATLAB Graphics : Three Dimensional Plots

MATLAB also supports graphics/plots in 3 dimensions. There are several MATLAB routines for producing 3D plots. These routines are very much similar to what we have learnt for 2D plots so far. 3D plots can be divided in 2 parts: Curves plot3 Surfaces surf mesh # Secondary command to be used: meshgrid So these are… Read More »

MATLAB : Post 27 : MATLAB Graphics : Two Dimensional Plots

From this post, continuing to 3-4 next posts, I will talk about some advanced graphics commands in MATLAB.  In earlier posts, we discussed about 2 basic graphics commands. They were plot and ezplot. For a complete list of graphics commands, you may type help graphics on command window. It will give you a list of… Read More »

MATLAB : Post 26 : Calculus in MATLAB

Their are 2 main parts of calculus in mathematics. Differentiation Integration Both of these have dedicated built-in functions to work with. These functions uses symbolic expressions and character expressions as input. Let us work through both of them. Differentiation in MATLAB For differentiation, we use the diff function in MATLAB. Take a look at following… Read More »

MATLAB : Post 25 : Complex Arithmetic in MATLAB

We all are familiar with complex arithmetic in mathematics. They are numbers involving the iota value. Iota is generally represented by i and its value is square root of -1.  In MATLAB, we have 2 automatic variables which store this value. They are i and j. Automatic variables means that they are already stored in… Read More »

MATLAB : Post 24 : Scope of variables in M files

In this post, we will talk about the scope of variables we use in a script M file and and functions M file. The rule is very simple: Variables declared in a script M file are global Variables declared in a function M file are local (except input and output variables) Variables in script M… Read More »