Excel and Financial Modeling
146 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by jorgeluis500
Scoop.it!

Fill and Justify in Excel

Fill and Justify in Excel | Excel and Financial Modeling | Scoop.it
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
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

How to Use Excel INDEX Function (Examples + Video)

How to Use Excel INDEX Function (Examples + Video) | Excel and Financial Modeling | Scoop.it
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
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Two-column Lookup in Excel

Two-column Lookup in Excel | Excel and Financial Modeling | Scoop.it
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.
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Create Dynamic Calendar Table or Date Dimension

Create Dynamic Calendar Table or Date Dimension | Excel and Financial Modeling | Scoop.it
Create a Dynamic Calendar Table or Date Dimension table with Power Query - Power Query Training
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Macro Toolbox

Macro Toolbox | Excel and Financial Modeling | Scoop.it
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
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Create a Custom Calendar in Power Query - PowerPivotPro

Create a Custom Calendar in Power Query - PowerPivotPro | Excel and Financial Modeling | Scoop.it
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…
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Convert a text value into a date in Excel

Convert a text value into a date in Excel | Excel and Financial Modeling | Scoop.it
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.
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Formula puzzle - how long was the truck stopped? | Exceljet Puzzle

Formula puzzle - how long was the truck stopped? | Exceljet Puzzle | Excel and Financial Modeling | Scoop.it
A couple weeks ago, a reader sent me an interesting question about tracking the "stopped time" for a fleet of trucks. The trucks are tracked by GPS so a location recorded at each hour of the day for each truck. The data looks something like this:
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

The Way to Array - Are you King of Array Formulas in Microsoft Excel? (Part 1) | ModelOff 2015

The Way to Array - Are you King of Array Formulas in Microsoft Excel? (Part 1) | ModelOff 2015 | Excel and Financial Modeling | Scoop.it
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

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

3 Practical Methods to Move around a Worksheet in Your Excel - Data Recovery Blog | Excel and Financial Modeling | Scoop.it
Some basic manipulations in Excel are very clever. And in this article, we will introduce 3 methods to move around a worksheet.
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Excel VBA Events: Tutorial And Complete List With 115 Events

Excel VBA Events: Tutorial And Complete List With 115 Events | Excel and Financial Modeling | Scoop.it
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.
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Excel formula: Get nth day of year | Exceljet

Excel formula: Get nth day of year | Exceljet | Excel and Financial Modeling | Scoop.it
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.
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

How to Rank within Groups in Excel

How to Rank within Groups in Excel | Excel and Financial Modeling | Scoop.it
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.
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

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

10 great examples to master date functions in Excel (Part 1) | Excel and Financial Modeling | Scoop.it
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 …
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

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

Grouping Dates in a Pivot Table VERSUS Grouping Dates in the Source Data - Excel Campus | Excel and Financial Modeling | Scoop.it
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

Count Unique in Excel Pivot Table - Contextures Blog

Count Unique in Excel Pivot Table - Contextures Blog | Excel and Financial Modeling | Scoop.it
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
more...
No comment yet.
Scooped by jorgeluis500
Scoop.it!

29 ways to save time with Excel formulas | Exceljet

29 ways to save time with Excel formulas | Exceljet | Excel and Financial Modeling | Scoop.it
Working with formulas takes time, and too often a problem that seems simple ends up taking far too long. In this article, I share tips that will save you time when working with formulas in Excel.
more...
No comment yet.