News

Using Find and Replace in Excel

     You can use Excel's Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel's Go To Special feature to quickly select all cells...

How to Format Cells in Excel

  When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or another formatting (alignment, font,...

Excel Foundation Training

Excel Foundation TrainingThis training course is designed for incoming interns but can serve as a handy refresher for any person looking to up their Microsoft Excel game. Table of Contents What's...

Import SQL Database into Excel

  Import SQL Data into Excel File In this tutorial, we are going to import data from an external SQL database. This exercise assumes you have a working instance of SQL...

Create budget template

  We will cover the following topics. Why manage the Budget? Major components of a personal finance system Using Excel to set personal budgets, record income and expenses Visualizing the...

Excel Logical Functions explored.

  Things will not always be the way we want them to be. The unexpected can happen. For example, let’s say you have to divide numbers. Trying to divide any...