122,314 views
CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- Subscribe to our channel: https://www.youtube.com/hashtagtreina... Instagram: / hashtagtreinamentos Facebook: / hashtagtreinamentos Also watch the videos: Text to Columns - How to separate text into multiple columns in Excel? • Text to Columns - How to separate text... Text Formulas - LEFT and SEARCH - Applying text functions in Excel • Text Formulas - LEFT and SEARCH... How to use the SUMIF and SUMIFS function with multiple criteria in Excel • How to use the SUMIF and SUMIFS function with... To download the spreadsheet used in class, access the link: https://pages.hashtagtreinamentos.com... Learn how to use the Indirect function, an Excel wildcard function that makes analysis much more dynamic! In this video, I will show you how to use the indirect formula in Excel, also explaining what the Indirect function is for. The Indirect function is used to turn text into a cell or range reference, that is, with this formula, you can use ranges that contain the content of a cell in their composition. This Excel function, Indirect, is very useful because it allows for greater dynamism when you search for data in other tabs or spreadsheets. In the video, this function was used to use the month selected in a cell as a reference for the range used in the SUMIFS formula. By discovering how to use the Indirect function, you will be able to search for data dynamically!