Excel MOOC

23/02/2018

New post added at ExcelMOOC - Create a Random Letters Generator in Excel

Although there is no function in Excel that allows a random letters generator. We can achieve this goal with the combination of a couple of Read More

23/02/2018

You can customize the look of your chart by formatting the various chart elements. These elements include the axes, titles, labels, legend, gridlines, data series, plot area (the area where the chart data appears), and the chart area (the overall background of the chart). http://excelmooc.com/format-the-excel-chart-elements/

21/02/2018

You can add visual interest to a chart element by customizing the element’s background, or what calls the fill. http://excelmooc.com/customize-the-excel-chart-elements-background/

19/02/2018

With ’s Replace feature, you can quickly and easily substitute one bit of text with another throughout a workbook. http://excelmooc.com/replace-text-in-a-workbook/

16/02/2018

Learning about the ACCRINTM Function in . Returns the accrued interest for a security that pays interest at maturity. https://goo.gl/xL9rkh

14/02/2018

The funtion ACCRINT, returns the accrued interest for a security that pays periodic interest. http://excelmooc.com/using-the-accrint-function-in-excel/

12/02/2018

Easily trim all leading and trailing spaces. http://excelmooc.com/tip-quickly-remove-spaces-from-the-beginning-and-end-of-your-data/

10/02/2018

Easily COUNT or SUM cells based on their Color in http://excelmooc.com/tip-easily-count-or-sum-cells-based-on-their-color/

08/02/2018

Learn How to Make a Supply and Demand Chart in http://excelmooc.com/how-to-make-a-supply-and-demand-chart/

06/02/2018

Learn How to Create a Car Loan Calculator and Amortization Schedule in http://excelmooc.com/how-to-create-a-car-loan-calculator-and-amortization-schedule-in-excel/

02/02/2018

Calendar. You can use it to plan the activities day by day or only to see the days and dates in the year. You can change the year and the month and all the dates changes. http://excelmooc.com/make-an-excel-calendar/