Customized Remote Work Solutions From the World’s Largest Fully Remote CompanyCustomized Remote Work SolutionsLearn More

Excel Experts

Showing 1-4 of 4 results
FinanceIcon ChevronFinance Processes

Google Apps Script Tutorial for Mastering Macros

by Stefan Thelin

Google Apps Script may appear familiar to those with knowledge of Microsoft’s Visual Basic for Applications (VBA) language. However, Google’s coding offers more integrations and the ability to harness workflows seamlessly across spreadsheets, documents, and presentations.

11 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Why You Should Move to Google Sheets

by Stefan Thelin

Google Sheets offers a more collaborative and expansive approach towards spreadsheet management for finance professionals.

9 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Exploring Excel's Get & Transform Functionality

by Ellen Su

Hidden in Excel and Power BI is a powerful data analysis pack named Get and Transform (previously known as Power Query). It is an ETL pack for cleaning and sorting raw data from a range of input sources, such as CSV and text files. This tutorial demonstrates how Get & Transform can help the data analyst both save time and uncover more insight.

10 minute readContinue Reading
FinanceIcon ChevronFinance Processes

Power Pivot for Excel Tutorial: Top Use Cases and Examples

by Ellen Su

With the arrival and growing ubiquity of big data, Excel, as a data-mining and processing tool has been pushed to its limits—reflected in its dated 1,048,576 row hard limit and the application’s processing speed slowing to a crawl. As of 2010, Microsoft released a Power Pivot function that transformed the scope and usefulness of Excel where the extraction, combination, and analysis of large datasets are concerned. Using live cases, Finance Expert Ellen Su explores in detail how to master Power Pivot and explores its hidden advantages as a big data tool.

17 minute readContinue Reading

Join the Toptal® community.