MrExcel Excel Videos

Today in Episode #1547, Bill creates a special section in the worksheet to set up a means to move through the individual records in the Database more effectively. Part II of IV. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Today -in the concluding edition of the 'Print Form from Database' series- Bill introduces a Visual Basic for Applications Macro that handles the work necessary for Mike to print each record in a Data Set [that is pulled from an Excel Database]. Follow along with Bill, in Episode #1549, to learn how to implement the code and find out just how easy it is! ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of...

Today Bill looks at using Data -from another Worksheet in the Current Workbook- using the =OFFSET Function to locate and retrieve the Data. Setting a starting point, each individual record in the Database can be printed - all without the use of a Macro. Follow along with Episode #1548 to see how it's done. This is Part III of IV. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

From Mike: Each work day, Mike gets a data set -from a database- and from that data set he needs to print a one page report for each record in the data set. Today, in Episode #1546, Bill begins the 'Print Form from Database' series with going over the data, how it is delivered and what the expectations for utilizing the data are. This is Part I or IV. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of...

Today, Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen are faced with taking the Data from a 'Data Dump' file and Counting - by category - to find the totals. Follow along with Mike and Bill for Formulas, Shortcuts and more! Dueling Excel Podcast #103...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] Slaying Excel Dragons and "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's...

Today, in the last installment of the Sakai Grade Book series, Bill looks at converting the Percentage Score in the Grade Book to a Letter Grade. Using a baseline, a Named Range and a Formula - which Bill shares with us today - your Dynamic Grade Book Project will be complete. Follow along with Bill in Episode #1544 to learn how to implement the finishing touches! 'Livening' up your Grade Book. This is Part IV of IV. Formulas for the 'Grade Book Application' that Bill Jelen has created are from the book, "Excel For Teachers" [ Excel for Teachers ] published by Holy Macro! Books. Learn more about the book "Excel For Teachers" by clicking here [ Excel for Teachers ] to go to the "Excel For Teachers" information page. ...This blog...

Still working with the CSV Data from the Sakai Grade Book, Bill looks at Calculating the Total Possible Points from Non-Blank Cells. Do you need just the percentage scoring? Cannot figure out why your figures are so far off from the Sakai Total? In Episode #1543, Bill examines why this is happening and what you can do to quickly and effectively correct that issue. 'Livening' up your Grade Book. This is Part III of IV. Formulas for the 'Grade Book Application' that Bill Jelen has created are from the book, "Excel For Teachers" [ Excel for Teachers ] published by Holy Macro! Books. Learn more about the book "Excel For Teachers" by clicking here [ Excel for Teachers ] to go to the "Excel For Teachers" information page. ...This blog...

An alternate method to Extract the Heading Values of your Sakai Grade Book - a method that does not use VBA Macros. Follow along with Bill Jelen as he provides a Formula solution to extracting those bracketed Values in Episode #1542. 'Livening' up your Grade Book. This is Part II of IV. Formulas for the 'Grade Book Application' that Bill Jelen has created are from the book, "Excel For Teachers" [ Excel for Teachers ] published by Holy Macro! Books. Learn more about the book "Excel For Teachers" by clicking here [ Excel for Teachers ] to go to the "Excel For Teachers" information page. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every...

In Part I, Bill looks at the 'Sakai Grade Book System and how to take the .CSV data file that it provides for teachers and turn it into a 'Live Grade Book' - so that scores can be updated and the proper grade reflected. Since formulas are not used in .CSV, Bill has produced a series of Podcasts and a 'Grade Book App'. Starting today, with Episode #1541, lets look into 'Sakai', how the core data appears and where to start 'Livening' up your Grade Book. This is Part I of IV. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book...