Category Archive: Online ms excel certification

Analyze Data Using These Easy but Effective MS Excel Tricks

Analyze-Data-Using-These-Easy-but-Effective-MS-Excel-Tricks


Everyone adores MS Excel. The powerful Excel software not only excels in doing basic computations but is also used for various formidable purposes, like financial modeling and business strategies. For novices, employing the skills of MS Excel can open new vistas in the world of data analytics. It is even being said – prior to R or Python, better grab the knowledge about Excel. Excel, with its wide array of functions, visualizations and skills empowers the users to quickly generate insights about data from the data, which would take a great toll otherwise.

Dexlab

ANZ uses R programming for Credit Risk Analysis

At the previous month’s “R user group meeting in Melbourne”, they had a theme going; which was “Experiences with using SAS and R in insurance and banking”. In that convention, Hong Ooi from ANZ (Australia and New Zealand Banking Group) spoke on the “experiences in credit risk analysis with R”. He gave a presentation, which has a great story told through slides about implementing R programming for fiscal analyses at a few major banks.

 
ANZ uses R programming for Credit Risk Analysis
 

In the slides he made, one can see the following:

 

How R is used to fit models for mortgage loss at ANZ

A customized model is made to assess the probability of default for individual’s loans with a heavy tailed T distribution for volatility.

One slide goes on to display how the standard lm function for regression is adapted for a non-Gaussian error distribution — one of the many benefits of having the source code available in R.

Dexlab

How to Create a Macro With MS Excel

Did you know that with Excel you can now automate tasks by writing so called programs macros. In this tutorial, we will learn how do so, by learning to create a simple macro, which will executable after clicking a command button. To begin you must first turn on the developer tab:

 
How to Create a Macro With MS Excel
 

Developer tab:

Do the following steps to turn the developer tab on:

 

  1. First right click anywhere on the ribbon, and then click on Customize the Ribbon.

 

Dexlab

Learn To Use The AND Function in Excel WS

In this Excel tutorial, we at DexLab Analytics will dig a little deeper with our Excel knowledge and explain how to use the Excel AND function with proper examples, and syntax use.

 
Learn To Use The AND Function in Excel WS

What is the AND function?

The MS Excel AND function works to return TRUE if all the conditions are true. And it returns FALSE if any of the conditions are false. The AND function is an internal function in Excel that is categorized as a Logical Function. It can be utilised as a Work Sheet (WS) function in Excel. Moreover, as a worksheet function, the AND function may as well be included as a part of a formula in a normal excel cell of a worksheet.

Dexlab

Tips to Make Sense of All The Big Data Around Us, You Can Make a Difference

Tips To Make Sense Of All The Big Data Around Us, You Can Make A Difference
 

We are all in the midst of the onslaught of information overload in many ways. We create it, transfer it and heartily participate in it. To get a grasp of the actual reality faced by businesses of all sizes, one needs to understand the exact scenario. According to IDC1, “The big data and analytics market will reach $125 billion worldwide in 2015” Further, IDC predicts, “Clearly IoT (Internet of Things) analytics will be hot, with a five-year CAGR of 30%.”

admin