In this excel blog, you will learn some of the amazing things which will add real value to your professional career. You are going to learn right from basic to some of the advanced stuffs with this blog.
We have covered formulas, Tools, charts, productivity techniques,Useful Excel Tips, Different kinds of formula with practical approach…
Excel is the universal language which speaks in all the offices. So learning this software tool is key at your workplace to go a long way. Efficient ways of using excel is vital in increasing productivity at your workplace.
Microsoft Office Tools plays a vital role in almost all the offices in modern days. I would this is like how our universal language “English” is for communication, similarly for all kinds of data driven work Microsoft Office Tools are universal products.
This is one aspect of Microsoft Office Tools and on the other hand knowing how to work with them will give you an edge at your work place. Mastering Microsoft Office Tools will definitely add value to your professional “CV”.
Once you finish basic stuffs with excel learning how do we advance to next level, is the common question runs in every advance excel aspirant.
After the basic thing you need to understand the version of excel you are working on and what the additional formulas in that version are of excel. You need to concentrate on some of the essential formulas which will be used day in day out at your work place for smooth operating of work. In this blog you will see some of the important formula, automation through VBA macros, new features of Excel 2016 version, interactive dashboards, efficient shortcut keys etc…
Productivity is the something your hiring manager expects from you on an hourly basis. Only way you can increase your work place productivity is by mastering the tools you working on.
Often times we follow the old traditional methods to work but we don’t realize the fact that we can minimize those steps to increase our productivity. Keeping this in mind in this blog we will show you “tricks that we can use in Microsoft Office Tools”, “tricks that can be vital in operating system Windows 10”, “office product productivity tools”.
And some of the must know productivity tools related to Microsoft products category.
Is it necessary to all the functions in excel??
Simply the answer is “not necessary”. Imagine you are an accounting professional and by learning engineering functions nowhere going to help you. Yes it is good know new things outside your professionalism but at the start not required.
In this blog we will show you formulas like MOD Function, SWITCH Function, AVERAGIF Function, FV Function, etc... And part from these functions you will also learn different types of charts like “bar chart, scatter chart as well.
Out of all the excel functions lookup and reference category functions are the most often used functions. VLOOKUP rules all the lookup functions. In this blog we dedicatedly discuss the formulas in the category of lookup and reference functions.
We will see some of the important lookup functions like VLOOKUP, HLOOKUP, INDEX, IFERROR with VLOOKUP, LOOKUP function, CHOOSE function etc.…
And also we will see some of the reference functions like COLUMN, TRANSPOSE, and VALUE etc... We will also cover practical examples like “How to Match Data in Excel”, “Error Fixing in VLOOKUP function”.
If you are working in any back or financial institutions then you must know financial functions in excel. Just imagine yourself in a loan department of the bank and you are required to tell the monthly EMI amount to the customer based on loan amount, tenure and interest rate. With the help of PMT function in excel you can quickly tell the monthly EMI amount to the customer.
In this blog we will show you Present Value Function (PV), Future Value Function (FV), Net Present Value Function (NPV), Payment Function (PMT), investment function like IRR, MIRR, RATE function, XIRR, IPMT function etc.…
Excel formula has categories based on the result of each function, so similarly we have a group called “Math Functions in excel”.
In this blog you will learn how to convert negative numbers to positive numbers using ABS function, how to generate random fraction numbers using RAND function, how to sum numbers using SUM function, how to round down decimal numbers using ROUNDDOWN function, how to round up using ROUNDUP. Apart from this you will learn functions like POWER, TAN, LOG, LN, SUMPRODUCT etc.…
Working with strings and numbers two different things in excel. So we have category of text and string functions in excel.
How do you substitute one string with another?? We can do this with SUBSTITUTE formula which is covered in this blog. Similarly to combine different cells data into one we will use CONCATENATE function, to remove unwanted spaces we use TRIM function, to find the number of characters in a cell we use LEN function, to extract number of characters from the left side of the string we have LEFT function, to make the string or text proper sentence we use PROPER function and many more TEXT and String functions are covered in this blog.
Calculations are easy in excel but if you want to do the calculations based on some logic then it requires logical functions to be used in excel.
We have different kind of logical functions like AND, OR, IF, TRUE, FALSE, XOR, NOT, IFERROR. We will show you all of these formulas with practical approach. You will get to know the scenarios of using these logical tests at your work place.
You must have come across many tips with excel. On similar note in this blog we are providing some of the important tips with regards to excel.
Number Formatting with Excel, Switching Columns to Row, Protecting and unprotecting the sheet, Excel vs CSV, Concatenation in Excel, Errors in Excel, Working with unwanted spaces, References, Drop Down List, Chart Wizard to create charts in excel, sorting data, working with external links with excel.
Statistics plays a vital role in decision making. Before we make the report ready we must use some of the statistical functions in excel.
How do you find the maximum value from the lot??? Use MAX function.
How do you find the Xth small value from the lot??? Use SMALL function.
How do you find the Xth largest value from the lot??? Use LARGE function.
Like this we can use statistical tests like P Value, F Test, Trend line, Frequency function, Forecast function etc.…
In order to get the information regarding to specific cell we have certain built-in formulas in excel.
How do you identify whether the cell is blank or not???
Whether the value in the cell is number or not???
Is the value in the cell is #N/A or not???
Check whether the cell contains an error or not???
All these things can be done by using information function like ISBLANK, ISNUMBER, ISNA, and ISERROR functions.
Charts tell the story better than the numbers alone can tell. So in excel we have variety of built-in charts to show the numbers. Charts are mainly used for presentation and dashboard purpose.
In this blog you will learn built-in charts like Pie Chart, Stacked Area Chart, Bubble Chart, Clustered Chart, etc.…
On top these built-in charts we can create our own charts like Waterfall Chart, Gauge Chart, Dynamic Chart, Pivot Chart, Combination Charts and many.