Using ImportHTML to scrape Facebook Usage numbers

— 05:16:00
Today I’m going to show how to make an nice map visualization of the Facebook Penetration numbers per country using Google Spreadsheets. (adsbygoogle = window.adsbygoogle || []).push({}); For... More

Making SUMIFS, COUNTIFS, & AVERAGEIFS functions in Google Spreadsheet

— 05:15:00
Update Dec 2013: In the new version of Google Spreadsheets SUMIFS, COUNTIFS, and AVERAGEIFS are already built in. If you didn’t activate the new version yet: read on below! If you’re used to working... More

How to import Google Analytics data into Google Spreadsheets in 3 simple steps

— 05:14:00
Almost everybody that owns a website uses Google Analytics to analyze their visitor’s behaviour. While the Google Analytics web interface is useful, sometimes you just need a little more flexibility... More

Use Excel INDIRECT to dynamically refer to worksheets

— 05:13:00
Sometimes you want to make a reference to certain worksheets dynamically using the Excel indirect function. For example if you have data in the same format split over multiple worksheets and you want... More

Removing the last number of characters from a string in Excel and Google Spreadsheets

— 05:12:00
Sometimes you want to remove some number of last letters from a string in your spreadsheet. For this you can use a very handy function: LEFT() LEFT() returns the first X characters in a string,... More

How to get letter in alphabet based on number in Excel and Google Spreadsheet

— 05:11:00
Suppose you have a number between 1 and 26 in cell A1, you can get the corresponding letter in the alphabet using the following trick: =mid("ABCDEFGHIJKLMNOPQRSTUVWXYZ";A1;1) Of course, you can... More

How to get WeekNumber function in Google Spreadsheets

— 05:11:00
Sometimes you want to have the week number of a certain date in your spreadsheet. In Excel you can use the WEEKNUM() function for this purpose, however in Google Spreadsheets there is no such function... More

Removing the first X number of characters from a string in Excel and Google Spreadsheets

— 05:10:00
Occasionally you need to convert a specific string to remove some x number of characters at the beginning of the string. There is a very nifty function you can use for this: RIGHT() RIGHT() returns... More

Number of weekdays between two dates in Excel and Google Spreadsheets

— 05:10:00
Normally just getting the amount of days between to dates in Excel isn’t enough. At times, you need to get the number of weekdays specifically. For this, there’s a very useful function in both... More

User INDIRECTO para dinamicamente referir a hojas de trabajo en Excel y Google Sheets

— 05:09:00
A veces quieres hacer referencia a ciertas hojas de trabajo (worksheets) dinámicamente. Por ejemplo si tienes datos en el mismo formato dividido o repartido en multiples worksheets y quieres seleccionar... More

Workbook in Excel

— 05:07:00
When people say Excel workbook they basically just mean to say Excel file. When you open Excel, automatically it will open up an empty workbook for you. A workbook consists of multiple... More

Excel Worksheet

— 05:07:00
An Excel worksheet is the sheet with cells on which you make all your work. Using different worksheets you can easily separate different types of analyses in different places so you can easily... More

Cells and Ranges

— 05:04:00
Cells are the basic building blocks of your Excel work – everything you do in Excel you do in your cells. In this tutorial I’ll teach you all the basics about cells and ranges in Excel. Selecting... More
Subscribe to: Posts (Atom)

Total Pageviews

2016 © BiztechCS
Planer theme by biztechexcel.blogspot