Excel and Financial Modeling
212 views | +0 today

# Excel and Financial Modeling

Curated by jorgeluis500
 Scooped by jorgeluis500

## Excel video: How to build a simple dynamic chart | Exceljet

In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart for dashboards and other reports.
No comment yet.
 Scooped by jorgeluis500

## Product Sales Rank by Category - Record, List, & Table Expansions - Power Query Jumpstarter

jorgeluis500's insight:
Nested Ranking inside Power Query
No comment yet.
 Scooped by jorgeluis500

## Fill and Justify in Excel

In my work as a trainer I’m usually the one serving the Excel goodies to the audience. But every so often I’m the one getting served. Whereas sometimes when I’m done so on an Exce…
jorgeluis500's insight:
Great trick
No comment yet.
 Scooped by jorgeluis500

## How to Use Excel INDEX Function (Examples + Video)

In this tutorial, learn how to use Excel INDEX Function. INDEX function returns the value from a table, based on the specified row and column number
jorgeluis500's insight:
Good explanations and how to get Min, Max and sums from tables and arrays
No comment yet.
 Scooped by jorgeluis500

## Tweet from @jorgeluis500

No comment yet.
 Scooped by jorgeluis500

## Two-column Lookup in Excel

This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark, not James Smith, not James Anderson.
No comment yet.
 Scooped by jorgeluis500

## Don't get caught by this Power Query trap

No comment yet.
 Scooped by jorgeluis500

## Create Dynamic Calendar Table or Date Dimension

Create a Dynamic Calendar Table or Date Dimension table with Power Query - Power Query Training
No comment yet.
 Scooped by jorgeluis500

## Intro to VBA: Macros Explained in the Kitchen (Part 1 of 3) - Excel Campus

No comment yet.
 Scooped by jorgeluis500

## Macro Toolbox

When storing utility macros, Excel users often elect to save them in the Personal Macro Workbook. The advantage is that the macros are available whenever Excel is running.
jorgeluis500's insight:
Create a mobile personal Macro worksheet
No comment yet.
 Scooped by jorgeluis500

## Create a Custom Calendar in Power Query - PowerPivotPro

by Matt Allington In this post, I am going to show you how simple it is to create a custom calendar using Power Query.  If you follow the steps below, you will get a good sense of how capable Power…
No comment yet.
 Scooped by jorgeluis500

## 3 Ways to Group Times in Excel - Excel Campus

No comment yet.
 Scooped by jorgeluis500

## Convert a text value into a date in Excel

Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.
No comment yet.
 Scooped by jorgeluis500

## Fix date errors when importing data in Power Query

When you import data from different sources, Power Query occasionally messes up your dates. This post covers how to fix date errors when importing data.
jorgeluis500's insight:
How to solve date error when importing data from different countries (or with different formats)
No comment yet.
 Scooped by jorgeluis500

## Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks

Download Files: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query to easily import multiple sheets of data from multiple Exce
No comment yet.
 Scooped by jorgeluis500

## 3 Practical Methods to Move around a Worksheet in Your Excel - Data Recovery Blog

Some basic manipulations in Excel are very clever. And in this article, we will introduce 3 methods to move around a worksheet.
No comment yet.
 Scooped by jorgeluis500

## Excel VBA Events: Tutorial And Complete List With 115 Events

How you can start using Excel VBA events now. Step-by-step guide to create your event-handler procedures. Get free cheat sheet with list of VBA events.
No comment yet.
 Scooped by jorgeluis500

## Excel formula: Get nth day of year | Exceljet

If you want to get the day of year from a date (i.e. the nth day of year), you can use a formula that uses the DATE and YEAR functions together. For example, with the date "June 1st, 2016" in cell B4, the following formula will return 153: =B4-DATE(YEAR(B4),1,0) That is, June 1st, 2016 is the 153th day of that year.
No comment yet.
 Scooped by jorgeluis500

## How to Rank within Groups in Excel

In this tutorial, you'll learn how to rank within groups in Excel. While the RANK function is great to find overall ranks, this technique uses SUMPRODUCT.
No comment yet.
 Scooped by jorgeluis500

## 10 great examples to master date functions in Excel (Part 1)

There are many ways of working with dates in Excel. In this first part I’ll cover 5 out of 10 great examples to help you master date functions in Excel. Before getting started we need to understand how Excel deals with dates. If you type any date in Excel, for example 06/12/2015, and change the …
No comment yet.
 Scooped by jorgeluis500

## Grouping Dates in a Pivot Table VERSUS Grouping Dates in the Source Data - Excel Campus

No comment yet.
 Scooped by jorgeluis500

## Count Unique in Excel Pivot Table - Contextures Blog

In a previous article,  Roger Govier showed us a couple of different ways to get a Unique count with a Pivot Table. Create a Pivot of a Pivot Tables results (fast) Add a calculated column to the source data (much slower) Now Roger has added another technique that you can use, in Excel 2013 and later. I'll hand things over to Roger, so he can describe the steps. Add to Data Model With the advances made by Microsoft with Power Pivot, and DAX (Data Expressions) formulae, which are more powerful than the inbuilt Excel functions, there is a Continue reading Count Unique in Excel Pivot Table
No comment yet.
 Scooped by jorgeluis500

## How Dates Work in Excel - The Calendar System Explained - Excel Campus

No comment yet.
 Scooped by jorgeluis500

## Toms Tutorials for Excel: Select a Current Region

No comment yet.
 Scooped by jorgeluis500

No comment yet.