Blog

Harry Potter Studio Tour at Warner Bros. London UK

Posted on by DevPaulC
What is the Harry Potter Studio Tour As the name says, you'll visit the studios where the 8 Harry Potter movies were filmed. You'll see most of the props used in the movie, some of the great sets like the Great Hall, and Gringotts Banks and some of the smaller sets (see the detailed walkthrough below). You'll learn about some of the techniques used during the production for make-up, technical gadgets and props and some of the computer-generated magic. How to get last-minute tickets to Harry Potter Studio Tour Buy tickets in advance. But if you didn't, don't worry,...read more

Basilica of Sainte-Anne-de-Beaupré

Posted on by DevPaulC
The Basilica of Sainte-Anne-de-Beaupré is a Roman Catholic basilica in the city of Sainte-Anne-de-Beaupré, Quebec, Canada. It is known for its religious significance and its historical and architectural importance. The basilica is a popular pilgrimage site for Catholics, who come to pray and seek healing. The basilica was built in the late 19th and early 20th centuries and is known for its ornate interior, which features intricate stained glass windows and beautiful frescoes. The History of the Basilica Sainte Anne de Beaupre The history of the Basilica of Sainte-Anne-de-Beaupré dates back to the early 17th century when the first...read more

Best Barcelona Day Trip – Montserrat Monastery

Posted on by DevPaulC
Montserrat is a stunning mountain range located about an hour's train ride from Barcelona. It is home to a beautiful monastery that attracts thousands of visitors every year. If you're looking for a day trip from Barcelona that combines natural beauty, history, and culture, Montserrat Monastery is a must-visit destination. In this blog post, we'll show you how to get there, the history of the monastery, the elevation, activities on site, popular hikes, if you can hike to Montserrat on foot, and what dining options are available on site. How to Get There To get to Montserrat by train,...read more

How to open Excel Files downloaded from the Internet

Posted on by DevPaulC
You may have reached here because you purchased and Excel template from one of our Online Stores on Etsy, TeachersPayTeachers or Gumroad. Or maybe you downloaded a file from somewhere else and you want to open it. First of all, make sure you trust the source. We scan all our files with the latest anti-virus programs. It is also good, as an additional precaution to have your own antivirus and to scan any file that you may have received. The warnings below are usually showing when opening Excel files with macros. Here are some of the warnings you may...read more

How to Calculate BMI in Excel

Posted on by DevPaulC
The BMI calculation formula is =weight(kg)/height(m)^2. In this example, we'll apply this formula in Excel. The formula works for the metric measurements. If you have your measurements for height and weight in imperial units, you'll first have to convert them to metric. Step 1: Calculate BMI in Excel in the metric system. The weight is listed in cell A2, the height is listed in cell B2 and the BMI is calculated in cell C2. The calculation here is =A2/(B2*B2). Make sure you isolate the (B2*B2) to ensure the order of operations. Another way to write the formula would be...read more

How to use multiple conditions in the Excel IF function

Posted on by DevPaulC
If you want to use multiple conditions in an IF function in Excel, you have to use the AND or the OR function to evaluate all the conditions (two or more conditions). All conditions evaluated have to be TRUE to make the output of the AND function TRUE. Only one condition have to be TRUE to make the output of the OR function TRUE Example: =IF(AND(condition1,condition2,condition3), ValueIfTrue,ValueIfFalse) =IF(OR(condition1,condition2,condition3), ValueIfTrue,ValueIfFalse) AND and OR functions AND and OR are the logical function used in all programming languages. Here is how these functions work. The AND function AND (TRUE, TRUE) = TRUE...read more

COUNT functions in Excel

Posted on by DevPaulC
There are a number of COUNT functions in Excel that you can use to count your records. Here are the most used ones: COUNT - count the number of cells in a range that contain numbers COUNTA - counts the number of cells in a range that are not empty COUNTBLANK - counts the number of cells in a range that are empty COUNTIF - counts the number of cells in a range that meet a condition COUNTIFS - counts the number of cells in a range that meet a set of conditions Let's get into the details COUNT...read more

How to start a macro when a worksheet changes

Posted on by DevPaulC
In this tutorial you will learn how to start a macro when a worksheet changes. This is a follow up tutorial from the creating a macro tutorial. In that tutorial, the goal was to have a macro that would sort records automatically when a new line was added. In order to run this macro automatically when the worksheet changes, you need to add the macro code in the "worksheet change" function. Excel has many automated functions that run based on events like before saving the workbook, when the workbook changes, etc. More details about these functions here in the...read more

How to start a macro with a button

Posted on by DevPaulC
In this tutorial you will learn how to create an Excel Macro Button. This is a follow up from creating a a macro tutorial. If you want to learn how to record a macro and have Excel write the code for you, click here. In the previous Case Study, we created a macro that sorts a list of names alphabetically. In order to start this macro, you can add a Macro Button. A button is just a shape. To start creating a button, start by creating a shape. Go to Insert - Shapes and choose a shape. As an...read more

How to create an Excel macro without coding – Excel macro tutorial

Posted on by DevPaulC
Excel macros sound scary but they don't have to be. You don't have to be a programmer to start with Excel macros. If you are not a programmer or don't even intend to be, this short and simple Excel macro tutorial is for you. You'll learn: how to get Excel to write some code for you how to review the written code how to launch a macro with a keyboard shortcut or a button how to launch a macro automatically when you need it (when the data changes) What are Excel macros Macros are programs that you can use...read more