Hardata Solutions

Hardata Solutions Hardata's speciality is large scale data mining and analysis. We use the latest technology and methods to bring data to life through data visualisation

Hardata works with organisations and businesses to provide smart, data-informed strategies. We understand that Business Intelligence, Data Analysis and Data Visualisation are crucial factors in developing business solutions and this is at the heart of our business core values. We collaboratively design flexible end-to-end analysis and insights to create a sustained competitive advantage and transform businesses

31/01/2023

An interactive financial report with Excel.

DM for your business spreadsheets, reports and templates

31/01/2023

An interactive financial report with Excel
DM for business temolates, dashboard and reports

22/01/2023

It's been a while since we interacted with our followers here.

We are available to assist with business solution sheets, projects, and training in data analysis.

We will be posting videos of sample interactive dashboards to give you an idea of our services

EXCEL HACK #8 – EMBED AN EXCEL SPREADSHEET IN WORDSometimes it’s useful to show a part of your spreadsheet in a Word do...
30/06/2018

EXCEL HACK #8 – EMBED AN EXCEL SPREADSHEET IN WORD
Sometimes it’s useful to show a part of your spreadsheet in a Word document. One of the best ways to do this is by embedding the spreadsheet directly into your document.

Here’s how to do this:

Select the section of the spreadsheet that you want to embed in your Word document

Next, copy it to the clipboard using the shortcut Ctrl+C. Now either open an existing Word document or create a new one. Place your cursor where you’d like the spreadsheet copy to appear.

Go to the Paste button in the toolbar and click Paste Special.

Choose the option for Microsoft Office Excel Worksheet Object. Then make sure the Paste Link option is selected and click OK.

You should now see a copy of your spreadsheet duplicated in your Word document, like below

29/06/2018

EXCEL HACK #7 – QUICKLY ADD THE CURRENT DATE OR TIME TO YOUR SPREADSHEET
Ever need to add today’s date or the current time into a cell in your spreadsheet? Here’s a fast way to do just that.

Just click into an empty cell and use these shortcut keys:

Current Date – press Ctrl + ; (semicolon)
Current Time – press Ctrl + Shift + : (colon)

EXCEL HACK #6 – INSERTING/DELETING NEW ROWS OR COLUMNS THE EASY WAYNeed to add a column or row to your spreadsheet quic...
28/06/2018

EXCEL HACK #6 – INSERTING/DELETING NEW ROWS OR COLUMNS THE EASY WAY
Need to add a column or row to your spreadsheet quickly? Save yourself time and hassle by using this simple shortcut key combo. First, select a column or row. Then press Ctrl + Shift + ‘plus sign’ (the button with = and +). A new column or row will appear to the left or above the column or row you selected.

You can also insert multiple rows and columns this way. Just select the number of rows or columns you want to insert before using the shortcut. So if you select three columns and use the shortcut, you’ll get three new columns next to your selected columns.

Deleting columns and rows is just as easy as adding them. Simply select the columns or rows you wish to delete. Then press Ctrl + minus-sign. Goodbye unneeded columns!

27/06/2018

EXCEL HACK #5 – MAKE NUMBER FORMATTING EASIER
If you have a long column of numbers that you’d like to display in currency format or as a percentage, here are a couple shortcut keys you’ll want to memorize to save yourself time:

$ Currency Formatting
Select the column of numbers, then press Ctrl + Shift + $ to display the numbers as currency complete with a dollar sign, commas and 2 decimal places.

% Percent Formatting
Select the column of numbers, then press Ctrl + Shift + % to display the numbers as a percent.

26/06/2018

EXCEL HACK #4 – USE SHORTCUTS TO SELECT ROWS OR COLUMNS
While selecting entire columns and rows with the mouse is pretty easy by simply clicking to the left of a row or the top of a column, using keyboard shortcuts can save you time and scrolling, especially on very large spreadsheets. To select either a row or column, click anywhere in the row or column you want to select.

To select an entire row, press Shift + Spacebar.
To select an entire column, press Ctrl + Spacebar.

EXCEL HACK #3 – START A NEW LINE IN A SELECTED CELLSometimes you’d like to add a line break within a cell, even if the ...
25/06/2018

EXCEL HACK #3 – START A NEW LINE IN A SELECTED CELL
Sometimes you’d like to add a line break within a cell, even if the cell is wide enough to fit all the words. Most users quickly find out that pressing the Enter key won’t let you start text on the next line, like it does in Microsoft Word. Pressing Enter just takes you to the next cell in the spreadsheet.

To add a new line to a cell, press Alt + Enter while you are typing inside the cell. This will move the cursor down so you can type on the next line. Note that this is different than Excel’s Wrap Text function, which will only put information on the second line if the column is too small. The Alt + Enter command forces a line break, regardless of the column width.

EXCEL HACK #2 – RESIZE COLUMNS TO FIT WITH 2 CLICKSThe standard column sizes in Excel don’t leave a lot of room for tex...
23/06/2018

EXCEL HACK #2 – RESIZE COLUMNS TO FIT WITH 2 CLICKS
The standard column sizes in Excel don’t leave a lot of room for text, so you’ll often see columns that look like the pic below

It’s easy to resize each column individually by clicking and dragging with the mouse, but there’s a faster way. Just hover your cursor to the right of the column you want to resize and double-click.

To resize multiple columns, simply select the columns or rows, then double-click next to any of the selected columns to expand the columns all at once.

Whether you’re crunching sales figures, importing an email list, or analyzing data for a monthly report, chances are you...
22/06/2018

Whether you’re crunching sales figures, importing an email list, or analyzing data for a monthly report, chances are you need to use Microsoft Excel for some of your day-to-day work. While most of us aren’t die-hard spreadsheet junkies, learning some time-saving shortcuts can help you get things done faster and more efficiently in Excel.

Here are some of our favorite Microsoft Excel hacks that make quick work of resizing columns, changing number formatting and even embedding a spreadsheet into a Word document

EXCEL HACK #1 – SELECT EVERYTHING WITH A SINGLE CLICK
Ever need to quickly select your entire spreadsheet? You can do it with a single click, just by clicking the arrow in the upper left corner of your spreadsheet.

18/06/2018

Select all cells with one click
Have hundreds (or even thousands) of rows of data—and need to select them all?

You can give yourself a finger cramp from tons of endless clicking and scrolling. Or, you can use this simple trick to select all cells with one single click.

All it takes is clicking on that light gray triangle that appears in the top left corner of your spreadsheet. Click it once, and every single cell in the spreadsheet will be selected. It’s as easy as that!

Address

Accra
P.O.BOXMD1492MADINA

Telephone

+233264661860

Website

Alerts

Be the first to know and let us send you an email when Hardata Solutions posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Hardata Solutions:

Shortcuts

Share

Category