Did you mean?
Search Results - Showing 48 - 60 Of 69
_slidefab-2-how-to-create-a-basic-92.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video demonstrates how to set up a simple Hello World workbook and presentation with SlideFab 2. It contains the most simple case where a formula-based text from Excel is multiple times written to a shape in a Powerpoint presentation.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) a")
_automatically-creating-powerpoint-presentation-category-trees-from-excel-with-slidefab-2.webp "This SlideFab 2 video shows how to create category trees automatically. It features various advanced SlideFab 2 features such as slide loops, sort order and VBA code calls. This example visualizes category spend and puts each category on one or more tree slides where the branches resemble sub category spend. For each sub category the top 3 suppliers and top 3 countries by spend are shown. The Powerpoint to Excel automation then creates the slides automatically within minutes. This helps to speed")
⏲ 1 min 80 sec ✓ 24-Jul-2018
_fractal-energy-storage-model-v-21-12-updates.webp "View the latest updates and new features of version 21.12 Fractal Model (released December 2021). The Fractal Model™ is a powerful technoeconomic energy storage and hybrid system modeling tool that provides investment grade analysis while simulating performance, degradation, warranty, costs and revenue to optimize the economics of your project. This tool is an excel package interface with an additional JavaScript calculation engine through a Microsoft 365 Add-In. nnThe tool is intended for pro")
_excel-video-410-watching-the-macro-recorded-work-in-vba.webp "Excel Video 410 gives you a behind the scenes look at what the Macro Recorder is doing in Visual Basic for Applications when it records a macro.Watch how I use Alt+F11 to open the Visual Basic Editor and follow along as I record a macro in Excel.If you want to learn how to write code in VBA, this is a great way to do it.You can always look up how to write specific code and it may help to read the help file to understand specific options for an Excel feature, but watching the Macro Recorder")
_run-64bit-shellcode-shad0w-beacon-from-32bit-office-with-macropack-pro.webp "In this video, we demonstrate how MacroPack Pro can generate a payload to run a 64bit shellcode from a 32bit Microsoft Word.nFor that, the Word payload will inject the 64bit shellcode in another 64bit process (explorer.exe here).nIn this video the shellcode is a shad0w beacon and Windows Defender is bypassed during the operation.nnThe shad0w beacon was generated with:nshad0w beacon -H 192.168.5.43 -f raw -p x64/windows/secure-o beacon.binnnnHere is the command line used to generate the Word pa"){kind=tracking}
⏲ 1 min 30 sec ✓ 22-Nov-2021
_using-slidefab-2-lite-for-automatically-creating-hundreds-of-slides-in-powerpoint-with-dynamic-title-and-chart-based-on.webp "This video shows how easy it is to automatically create a few hundred slides with title and chart automatically using SlideFab 2. With the new SlideFab 2 v1.5 it is possible to automate linked charts which make the setup process even faster. Creating more than 200 slides in this video took in real-time less than 5 minutes. As SlideFab 2 lite edition was used this solutions comes for free.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to em")
⏲ 1 min 46 sec ✓ 17-Oct-2018
_excel-video-439-custom-functions-part-1.webp "Excel Video 439 puts several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA.The custom function is a response to a question a while back in MGMA’s Excel Users group asking for a way to compare the fill color of cells.nnNotice a few things that are different about custom functions.Instead of starting the code like a subroutine with Sub and End Sub, we change to Function and End Function.Our function takes two parameters, the two cells w")
_slidefab-2-writing-an-excel-formula-as-loop-condition-when-automatically-creating-powerpoint-slides.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video explains how a loop condition can be used to leave out loop candidates based on a calculated condition. In this example the modulo operator is used as condition to only create every second slide.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) are required to create PowerPoint")
SlideFab 2. Writing an Excel formula as Loop Condition when automatically creating Powerpoint slides
⏲ 1 min 5 sec ✓ 07-Mar-2018
_slidefab-2-how-to-create-one-output-file-per-loop-candidate-when-automating-powerpoint-slides.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video shows how SlideFab can decompose the output presentation into separate files, 1 presentation file per loop.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) are required to create PowerPoint presentations automatically. This is not the case with SlideFab 2. With decent Excel ski")
⏲ 1 min 4 sec ✓ 07-Mar-2018
_excel-video-422-looping-to-dynamically-define-a-range.webp "There’s a way to programmatically define a range of cells to work with in Excel Video 422.I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422.I’m also adding a few new functions as well, so I hope this isn’t too much for one video.Hopefully the idea of being able to use code to dynamically define a range makes sense and will be helpful for you in your macros and VBA.nnWatch for the code that tells Excel how many rows to work with in our example.T")
_peter-bryant-json-services-natively-access-vba-preview.webp "Access can talk to HTTP services, but doesn't provide built-in abilities to deal with the data from JSON or XML API calls. Whilst there are third party tools and libraries out there, they have their limitations and might not be permitted or welcome on a project (which is how this came about). We show how to do it in Access VBA with a few standard references and no other external dependencies.nn•An introduction to JSON and API web services that use itn•Why do it internally in Access, and")
_excel-vba-beginner-tutorial-series-2-record-a-vba-macro-vba-cell-reference-copy-paste-in-vba.webp "In this second video of the Excel VBA Beginner Tutorial Series, we will cover four main topics in VBA :nn1) Recording a simple basic macron2) How to save the recorded macro filen3) How to use VBA cell referencingn4) How to copy-paste data in VBAnnI would like to recommend you watch my entire Excel VBA Beginner Tutorial Series from Beginning for better understandingnnRecord a macro:nRecording a macro will record all the actions you do on this sheet. If you try to make it Bold, Italic, Underline,")
Excel VBA Beginner Tutorial (Series 2) - Record a VBA Macro - VBA Cell Reference - Copy Paste in VBA
⏲ 12 min 17 sec ✓ 03-Sep-2020
![[+]](/images/menu.gif){kind=small}