Excel MOOC

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

Create a Random Letters Generator in Excel - ExcelMOOC 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

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/

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/

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/

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

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

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

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

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

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/

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/