Conditional Formatting IF Statements

Conditional Formatting Using Formulas in Excel

A tutorial on using Conditional Formatting Formulas in Excel.

Excel Conditional Formatting using IF statements
Excel Conditional Formatting using IF statements

There are significant limitations with the preconfigured options for Conditional Formatting. They typically only apply so a single cell without consideration for multiple factors. For example, in a previous tutorial I showed how to highlight a cell for an overdue payment based upon the date that it was due and the date that you specify for comparison. That formatting remains even after the payment has been made.

In order to correct that problem we need to use statements to examine the contents of other cells.

Continue reading Conditional Formatting IF Statements

Conditional Formatting Based on a Date

Conditional Formatting Dates in Excel

A tutorial on applying conditional formatting to Excel based upon a date in the past, future or present.

Applying conditional formatting on a date within Excel can make it easy to highlight payments that are past their due date or to highlight upcoming events with colors changing as the event approaches.

Conditional Formatting Based on a Date
Conditional Formatting Based on a Date

Continue reading Conditional Formatting Based on a Date

How to Apply Conditional Formatting in Excel

A Tutorial on How to Apply Conditional Formatting in Excel

Conditional Formatting is one of the most useful features for making data of a certain criteria really stand out in large spreadsheets.

Conditional Formatting in Excel
Conditional Formatting in Excel

The formatting can be based on the values in a cell – such as a number above or below a certain range – or you can use conditional formatting based on another cell.

Conditional formatting can also be used to highlight dates, text or duplicate values.

To use conditional formatting just select the cells you wish to apply the formatting to and select the Conditional Formatting options from the Styles group on the Home tab of Excel.

Conditional Formatting in Styles Group
Conditional Formatting in Styles Group

Continue reading How to Apply Conditional Formatting in Excel

Microsoft Excel Training Part 2 – The Basics of Excel

Excel Training – The Basics of Microsoft Excel

How to add, subtract, multiply, divide, calculate percentages and calculate averages in Excel.

When you open Excel you’ll see a list of templates that are already designed with certain functionalities such as budgets, invoicing, planners, journals, and lists.

If you click on the header on the top you can choose from even more templates under categories for business, personal, finance, lists, and more. You can perform a search for a specific type of template and find even more templates from which you can choose.

Excel 2013 start screen with templates.
Excel 2013 start screen with templates.

Continue reading Microsoft Excel Training Part 2 – The Basics of Excel

Microsoft Excel Training Part 1 – Introduction to Excel

Microsoft Excel Training Part 1 – Introduction to Excel

Microsoft Excel is one of the most used software programs in the world with over 750 million installations worldwide and knowledge of Excel is considered a required skill for many jobs. It is now considered the industry standard for creating spreadsheets and has desktop (PC and Mac), mobile and cloud versions of the program.

Excel is used for everything from personal and company financial data, stock market analysis, storage of names and addresses and student grades, to advanced statistics and scientific work.

Within my own office I use Excel primarily for budgets and for calculating the landed cost of goods and final sales prices after mark-ups.
Some of my clients use Excel as their primary accounting system in lieu of software programs such as Intuit QuickBooks.

During this course we’ll go through all of the basics including formatting, formulas, charts and graphs, and then move onto more advanced topics such as macro programming and Pivot Tables in later lessons.

Continue reading Microsoft Excel Training Part 1 – Introduction to Excel

Salesforce Training Part 1

Salesforce Training Part 1

Salesforce – What is it?

Many business owners find the need to keep their company information up and available at every time. CRM tools can assist them with that. Salesforce can be defined as one of the most popular CRM tools presently available and it has a user friendly dashboard that can be used to access your company information with less hassle. Then you can get an overall idea about the different aspects of your company and check whether they are organized. It has been awarded as the Best CRM Software because of the above mentioned features.

Who uses it?

Salesforce has over two and a half million users worldwide and and had revenue over over 5 billion US dollars in fiscal year 2015. It’s popular among people who are looking for a customizable cloud based account in order to manage client based contacts and accounts. You can access the database at any time you want and get the required information that you want. The mobile platform has helped people to engage with its core tools on the go.

Continue reading Salesforce Training Part 1

Formatting Cells in Excel

A Tutorial on Formatting Cells in Excel

How to use Cell Styles, Number Format, Font Settings and keyboard shortcuts to format cells in Excel.

How to Format in Excel

 

Cells in a Microsoft Excel spreadsheet can be formatted using tools similar to word processors with bold, italics, strikethroughs, etc, but with additional options for formatting as currency, percentages, dates, times, zip codes, phones numbers and more.

All formatting options are easily found on the Home tab of Excel or by right-clicking a cell and choosing the Format Cells option.

Continue reading Formatting Cells in Excel

How to Calculate Percentages in Excel

A tutorial on how to Calculate Percentages in Excel

Calculating percentages in Excel is also easy but it requires the use of formatting options. We start with performing calculations to work out the divisions of numbers and then format the cell with the resultant figure as a percentage.

The formatting of the cells is accomplished either by first clicking on the cell you wish to format with your left mouse button then clicking on the % icon found on the Number Format group of the Home tab of Excel or by clicking on the cell with your right mouse button and choosing the Format Cells option and clicking percentage.

If you enter the formula =9/5 and hit the enter key you’ll get 1.8 and if you format 1.8 as a percentage it becomes 180%.

Continue reading How to Calculate Percentages in Excel

How to Multiply in Excel

A Short Tutorial on How to Multiply in Excel

Multiplication in Excel can be performed by typing a formula containing the numbers you wish to multiply or by multiplying the numbers contained within cells in your spreadsheet.

For the first method you can just click on any cell within a spreadsheet and type an = sign followed by a number you wish to multiply followed by an * sign and then hit the enter key on your keyboard or click the check mark √ on the formula bar.

How to multiply in Excel
How to multiply in Excel

Continue reading How to Multiply in Excel