Did you mean?
Search Results - Showing 48 - 60 Of 65
_excel-video-157-mid.webp "Excel Video 157 uses MID to extract the first name from our list of patients.LEFT helped us retrieve the patients’ last names and RIGHT got the patients’ first names and middle initials.Now we’ll use MID to just get the patients’ first names.MID requires three parameters,a reference to some text, the starting postion, and the number of characters to extract.The text is easy.We’ll just reference the cell with the patient’s name.The starting position is two characters aft")
_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
_excel-video-371-using-arrays-to-see-if-a-list-is-unique.webp "I have one more array trick in Excel Video 371 before we move on to a new topic.Today we’ll use a COUNTIF function inside a MAX function inside an IF function to determine if a list is unique.It’s really not quite as bad as that sounds.We’ll set up a COUNTIF function first to determine the number of times a doctor’s name appears in a list.Then we’ll use the MAX function to determine the maximum number of times a doctor’s name is on the list.Finally, the IF function will pri")
_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
_how-to-generate-excel-month-names.webp "This article shows you how to generate month list by formulas and how to display Excel month names instead of actual date values. We will use DATE, YEAR and MONTH formulas as well as Number Formatting.nRead the full article here: https://www.spreadsheetweb.com/excel-month-names/")
_google-calendar-how-we-connect-recruiter-candidate-and-elakshya-for-all-kinds-of-resumes-and-also-interview-schedules.webp "google calendar - we can nickname it as google mobile - all entries on excel file can be sent up to mobile either by time-driven or event-driven. configure ur mobile for same automatically - we can use this to send reminder sms to customers.nnsteps:1-go to google calendar-mobile configuration, and verify mobile 2-click on notifications by sms 3-set up sms reminder 1 min, 4-in calendar-change the")
⏲ 37 min 24 sec ✓ 30-Nov-2010
_ask-an-expert-excelling-at-excel.webp "While Excel has been around for a long time, its usage continues to evolve and change.Like many of our colleagues across the nonprofit sector, you may have used it but lack confidence and believe you are missing some of the advantages of having more advanced knowledge of what Excel can do to make your work life more organized and efficient. And when it comes to your personal life, you may have wondered if you can use it to organize your holiday card list or facilitate event planning.nnJoan Hub")
_excel-video-90-get-a-drop-down-box-without-programming.webp "Excel Video 90 takes a quick break from OFFSET to show you how to create a drop-down box like the one in Excel Video 89.Hopefully you saw the drop-down box I created as part of Excel Video 89 to show the components of the OFFSET function for Year, SanDiego, and LosAngeles.There are three tricks I used in creating the drop-down box.nnFirst, select the cell you want the drop-down box in, then go to the Data tab and choose Data Validation.In the drop down box labeled Allow, choose List.Then")
_excel-video-196-ranking.webp "Want to RANK higher in your Excel knowledge?Watch Excel Video 196.Excel uses RANK functions to show how items rank in a list.You can rank either descending (highest to lowest) or ascending (lowest to highest) and descending is the default for both functions.nnWatch Excel Video 196 to see the two versions of RANK, RANK.EQ and RANK.AVG.Both functions do exactly the same thing and have the same syntax.The only difference between RANK.EQ and RANK.AVG is the way they handle ties.RANK.EQ a")
_human-vs-machine-competition-who-can-create-powerpoint-slides-based-on-excel-data-faster.webp "In this video Alice competes against Bob. Alice uses SlideFab 2 whereas Bob uses his brute force and copy_paste skill. The task is to create 100 dashboard slides in PowerPoint based on an Excel model containing the calculation.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")
⏲ 1 min 50 sec ✓ 18-Dec-2018
_excel-training-intermediate.webp "This is the second session of three Excel training sessions. It covers:nnRecap on formulas, lists and filters from BeginnernRecap on removing duplicatesnMaking a list and filternIf formulas (Sumifs, Averageifs, and countifs)")
_slidefab-2-installation.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video shows how SlideFab can be installed.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 skills everybody can create hundreds of presentations or slides automatica")
![[+]](/images/menu.gif){kind=small}