Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to use array constants with VLOOKUP in Excel and Google Sheets. Enjoy the video.
Continue readingCalculator in Excel VBA Coding Part 2
Welcome to Excel Jet Consult blog post. In Part 2 of creating Calculator in Excel VBA, I walked us through the journey of how to write lines of codes that enables the calculator to be fully functional. Enjoy the video, subscribe, share and like
Continue readingCalculator in Excel VBA Coding Part 2
Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to write codes that enables our calculator built in Excel VBA to work. Enjoy the video below
Continue readingHow to Create Animated GIF in PowerPoint (Covid-19 Slides)
Welcome to Excel Jet Consult vlog post. In this PowerPoint video tutorial, we learn how to create animated GIF with Covid-19 PPT Template. Enjoy
Continue readingCreate Animated GIF in PowerPoint
Welcome to Excel Jet Consult blog post. In this PowerPoint video, we learn how to create an Aminated GIF using Covid-19 template slides.
Continue readingExcel Hash Challenge 2021
Welcome to Excel Jet Consult blog post. In this video, 17 Excel MVP’s joined to create Excel Hash Challenge 2021. Do watch the video for my presentation below
Continue readingCalculator in Excel VBA (User Interface Design) Part One
Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we learn how to design user interface of calculation in the VBA development area. In part 2, I will walk you through the lines of codes that enables this calculator to work! Remember to subscribe, hit the bell icon, share and give thumps up. See you in the […]
Continue readingLinear Equation Computation and Graph in Excel
Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to create Linear Equation computation and graph in Excel. Enjoy
Continue readingGet & Append Data From GOOGLE SHEETS and MICROSOFT ACCESS to Create Excel PivotTable Report
Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we learn how to connect to data stored in Google Sheets and Microsoft Access to create a refreshable PivotTable Report! If you like this video, subscribe to the Channel, Share with friends and give thumps up because there is more to come!
Continue readingMerry Christmas in Random Font Colors
Welcome to Excel Jet Consult blog post. In this last tutorial of 2020, I show you how to apply random font colors using Word VBA. There is so much more to come in 2021. See you there
Continue reading