Tags » Excel

Bỏ Password của VBA Project trong EXCEL

  • Với dạng file XLSM:

Mở XLSM file bằng 7-Zip (chuột phải lên file XLSM-> Open with.. > 7-Zip).
Copy file vbaProject.bas (hoặc file vbaProject.bin) trong thư mục… 334 more words


101 Ready to Use Excel Formulas

101 Ready to Use Excel Formulas

A collection of useful Excel formulas for sums and counts, dates and times, text manipularion, conditional formatting, percentages, lookups, and more! 36 more words


May 2016 Meeting


Beginning BI with Microsoft Tools

First we’ll take a look at OLAP versus OLTP and then we’ll move into using Microsoft’s tools to implement beginner level business intelligence solutions. 18 more words


Excel: Sorting and Filtering

Download Exercise File Here: ExcelTable

Sorting and Filtering are two basic functions you will perform quite often in Excel. When dealing with large data sets, it can be difficult to see what you are looking for, especially if the records appear in random order. 192 more words


Two Events: Advanced Excel for Analytics and Mapping for Earthquake Relief

Last Tuesday we hosted a second session by Prof Bill Gerrard, specialist in sports analytics at LUBS, for a working session on how to use Excel for data analytics. 335 more words

Data Science

Excel: Indexing a Column after a set number

Here’s a simple usefull method for indexing a column after a given number

The loopmf() is linked to a button in an Excel Sheet. fat mesures the range of column A1:A4124 (the second value is of choise up to 65536). 112 more words


Telling the Story with Numbers.

“You better cut the pizza in four pieces, because I’m not hungry enough to eat six.” ~ Yogi Berra

“There are lies, damned lies, and statistics.” 258 more words