_ask-an-expert-excelling-at-excel.jpg "Ask An Expert: Excelling at Excel from excel formulas list Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 49 min 52 sec
✓ Published: 11-Sep-2020
✓ Published: 11-Sep-2020
Description:
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
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
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_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
_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)")
_excel-video-371-using-arrays-to-see-if-a-list-is-unique.jpg)
_slidefab-2-how-to-create-one-output-file-per-loop-candidate-when-automating-powerpoint-slides.jpg)
_how-to-generate-excel-month-names.jpg)
_google-calendar-how-we-connect-recruiter-candidate-and-elakshya-for-all-kinds-of-resumes-and-also-interview-schedules.jpg)
_excel-video-90-get-a-drop-down-box-without-programming.jpg)
_excel-video-196-ranking.jpg)
_human-vs-machine-competition-who-can-create-powerpoint-slides-based-on-excel-data-faster.jpg)
_excel-training-intermediate.jpg)
![[+]](/images/menu.gif){kind=small}