Knowledge Center

Macabacus and Brandfetch Partner to Launch Logo Library, Delivering Instant Access to 22M+ Logos in PowerPoint

Macabacus partners with Brandfetch to launch Logo Library—giving finance teams real-time access to 22M+ brand logos directly in PowerPoint.

Sign up for email updates

Product news, tips, newsletters, and more – delivered straight to your inbox.

By submitting your email address, you consent to receive email messages (including discounts and newsletters) regarding Macabacus’ products and services. You may withdraw your consent and unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

How to Use HLOOKUP or VLOOKUP for Columns

Find out how HLOOKUP & VLOOKUP functions transform financial analysis with practical examples & a free template. Learn to efficiently…

Merge Data Using CONCATENATE or TEXTJOIN

Transform messy data into clean reports with Excel's CONCATENATE and TEXTJOIN functions. Learn how to efficiently merge data from multiple…

Steps to Summarize Data with SUMIF/SUMIFS

Discover how to wield Excel's SUMIF/SUMIFS functions like an investment banker to rapidly extract insights from complex data sets. Perfect…

How to Use INDEX-MATCH for Data Retrieval

Master the INDEX and MATCH functions for efficient data retrieval in Excel. Tailored for investment bankers, this guide covers financial…

Step-by-Step Guide to Using Data Validation in Excel

Create foolproof Excel data input with validation rules to prevent costly banking errors. Learn essential techniques for financial models and…

Formula & Function: How to Calculate Standard Deviation in Excel

Learn how to calculate standard deviation in Excel. Understand how to use formulas, interpret results, and generate powerful data insights…

How to Find the Running Total in Excel

Master Excel running totals for sales, expenses, and more with our concise guide and examples. Optimize your financial analysis process…

Steps to Using Flash Fill to Recognize Column Patterns

Learn how Excel Flash Fill automatically detects & fills column patterns to speed up your financial data processing - plus…

Venture Capital Fund Modeling: A Guide for Finance Professionals

Master VC fund modeling with our expert guide for finance professionals. Discover essential strategies and exit plans for optimal venture…

How to Find and Remove Blank Rows in Excel

Transform Excel data with powerful find & replace tools: regex patterns, date formatting, formula updates & cell styling - save…

Error Trapping in Excel Through Flagging and Custom-Built Error Checks

Have confidence in your Excel financial models with error tracking formulas. Prevent costly mistakes and streamline your workflow with our…

Using Passwords to Protect Your Excel Workbook

Discover foolproof steps to safeguard sensitive financial data in Excel with password protection. Perfect for investment bankers & finance pros…