Aabyss Blog Heading Background

News & Opinion

Gain the edge on the world of business technology and cyber security

How to Use Excel Sparklines

on 05-Dec-2016 13:54:08 By | Andrew Allen | 0 Comments | Tips & Tricks
Excel Sparklines were introduced in Excel 2010 version. It is small line chart that could be easily embedded with the text and gives a great presentable output for easier depiction when aligned next to the tabular data. They are supported in Excel 2010 and above version only. Although sparkline’s design is not limited to lines they can also be represented as columns or win loss. The below example depicts how sparklines look: When to Use: Excel Sparklines can be useful if you have your data in a tabular format. You can place the sparklines next to each row to give a clear graphical presentation of the data selected in that particular row. How to Use: Below listed steps give a clear understanding on how to use excel sparklines: Click on the cell where you want to insert the “Sparkline(s)”. Go the “Insert” tab on the top ribbon. Select the Type of “Sparkline” (Line, Column, Win/ Loss), in this case we will take “Line Sparkline” as example. Line Type of Sparklines So, this was all about how to use excel sparklines. You can also do formatting, add markers, axis, etc to enhance the sparklines. Below section suggests on type of sparklines and their formatting. Type of Excel Sparklines: Line – These sparklines are displayed in the format of simple lines. You could change the style of line, sparkline color and marker color. Column – These sparklines are displayed in the format of bars. If the data is of positive value then the column would be lying on the upper axis. For negative data value the column would be below the axis. Likewise for zero value the column would not be displayed and an empty space would be left at that data point. In these sparklines too, you can change the style of column, sparkline color and marker color. Win / Loss – These sparklines are displayed in the format of bars like “Column” sparklines although these only represent profit or loss. If the data is showing profit (positive data points) then bars would be above the axis and if the data is showing loss (negative data points) then the bars would be inverted and will be below the axis. If the data is of zero value then the column would not be displayed and an empty space would be left at that data point, as shown in above figure as well. In these sparklines as well, you can change the style of column, sparkline color and marker color. You can change the type of sparklines for the whole group or for single row by un-grouping the sparklines first. Thus each row can have a different type of sparkline.
Read More

Six Steps to Better Data Backup and Quicker Recovery

on 25-Dec-2014 16:35:46 By | Andrew Allen | 0 Comments | Productivity Tips & Tricks
Think Quicker Recovery Time, Not Quicker Backup - While incremental backups are much faster than executing a full-backup, they also prolong recovery time. In the event of data loss, a full restore will require loading the most recent full backup and then each incremental backup tape. Having too many incremental backup tapes not only adds time to this restoration process, but it also increases the probability of not recovering all of your data. A tape could be lost, unintentionally skipped over, or contain corrupted data. Be sure to focus on optimizing the restore time to ensure faster data recovery. A quicker recovery time should be the main objective, not the need for a quicker backup process.
Read More

Seven ‘Must Haves’ for Your Small Business Website

on 18-Dec-2014 16:30:05 By | Andrew Allen | 1 Comment | Tips & Tricks
Your website represents your business and so building and maintaining it need to be of primary concern to you as a business owner. We often find business owners struggling with their websites saying things like: "My website looks great, but I am not able to convert" or "I invested so much into creating my website, but I don't get many hits.” These things are very common pains faced by businesses, especially small business. If you aren’t sure where to start your site improvement project, this post will get you rolling in the right direction with seven key areas you need to pay attention to when it comes to your website.
Read More

Five Ways Your Business Can Improve Its Search Engine Rankings

on 06-Nov-2014 15:49:25 By | Andrew Allen | 0 Comments | Strategy Tips & Tricks
In an age where most business happens online, not showing up in Google search results can really hurt you. While there’s no real shortcut to showing up consistently on web searches, there are a few quick fixes to get your site to show up on your potential customer’s search results...
Read More