MAGO-NOTE

In this article, I will show you how to hide only the summary row after joining multiple Excel books with summary rows in a power query. If you have not read the following article, please read it first. How to combine multiple excel books into one using Power Query and split it again using VBAIf you are sick and tired of wasting time with cut-and-paste to merge or split excel data, this article is for you.mago-note Data for the tutorial The data used in this article are three Excel books ...

This section explains how to replace, add, or delete Excel books that are the source of the combination after Excel books have been combined using Power Query. We will use the Excel book created in the tutorial of the following article. If you have not read the following article, please read it first. How to combine multiple excel books into one using Power Query and split it again using VBAIf you are sick and tired of wasting time with cut-and-paste to merge or split excel data, this article ...

The following article shows how to combine Excel books using Power Query, and one of the prerequisites was that all sheets must have the same name. How to combine multiple excel books into one using Power Query and split it again using VBAIf you are sick and tired of wasting time with cut-and-paste to merge or split excel data, this article is for you.mago-note This article gives an overview of the error when the sheet names are different and how to deal with it. First, let’s check where the ...

This article will show you how to use Power Query to combine data stored in multiple Excel books into a single Excel book. In addition, VBA code for re-splitting the combined Excel book will also be presented. Who should read this articleIf you work at the head office and are following the steps below to receive budget requests from the various branches and respond with the allocated amounts, you should read this article. Cut and paste data from each Excel book into one (Combine) Enter the al ...

Amadine has a feature called “Sheets”, which is the same function as Adobe Illustrator’s artboards. In this article, I would like to show how to use the sheet. Overview of the Sheets ToolYou can regard a sheet as a range of output. Objects that are out of the sheet are not in the output image. The star figure sticks out the square sheet. Let's output this in PNG format. You can see that the protruding part is not output. A single document in Amadine can have multiple sheets ...

Learn how to draw a box in trimetric projection using the vector graphics application Amadine. It is a way to write an object whose shape, color, and angle can be easily modified as you want. We will draw a box shown below. How to write a box in trimetric projection Launch Amadine, select "Create Document" and create a canvas with Width "600px" and Height "600px". Tap the Rectangle Tool in the Tools panel. Draw a rectangle on the canvas. Set Dimension to 200px ...

We will show you how to use the Inner Glow Effect and Outer Glow Effect to create a neon sign-like logo, as used on a store sign. Let's learn how to use the three raster effects: Inner Glow, Outer Glow, and Shadow. The completed drawing looks like this. Creating Text and Backgrounds Create a canvas with a width of 600px and a height of 600px, and use the Rectangle Tool to create a square of the same size. Select a background image in Image Fill, ...

Learn about the Boolean Operations that merge and break apart overlapping objects. Amadine has five boolean operations: Union, Subtract, Intersect, Exclude, and Divide. Let's pay attention to which object's appearance (fill color, etc.) remains for each operation. As of writing this article, Amadine for iOS was version 1.2.8. UnionFirst of all, let’s try the most commonly used Union. A yellow circle overlaps the green square. Selec ...

Learn about the Fusion tool for merging or partially deleting objects. The Fusion tool allows you to merge or partially delete objects on the canvas intuitively as an alternative to Boolean operations. As of writing this article, Amadine for iOS was version 1.2.8. Take a quick look at how the Fusion tool works Select the two overlapping circles and tap the Fusion tool in the Tools panel. Swipe to include all three areas from the top circle to the bottom circle. As you swipe, the ...

Learn how to use the Recolor function to change the color of some objects at the same time. It is indispensable for creating the same shapes with different colors. What is the Recolor?You use the Recolor function when you want to change the colors of Strokes and Fills that were determined when creating the objects. Here is an example of using the Recolor. Select objects you want to recolor. In this figure, select the group on the left of the gems. ...