How to
Articles that explain How to do specific tasks in Excel in general. Applies to all templates.
We use Excel’s Table feature extensively in all templates on indzara.com. This article will cover the basics of Tables that one needs to know before using t...
Tue, 9 Jun, 2020 at 11:44 AM
When copying data from somewhere and pasting, always use Paste Special as Values. Excel – Paste Special as Values When you right click inside the table (...
Wed, 15 Apr, 2020 at 11:23 PM
In the templates, the typical date format we use for display is DD-MMM-YYYY. The format you enter may differ on region and language of your Windows and...
Fri, 29 May, 2020 at 7:45 PM
This is a common issue faced by users who use Microsoft Edge browser with Windows defender. Solution / Alternate approaches to download the file ...
Tue, 9 Jun, 2020 at 5:33 PM
1. Open your Power BI file in Power BI Desktop 2. View menu --> Choose Customize Current theme 3. Modify theme colors & also choose specific...
Fri, 21 Oct, 2022 at 5:20 AM
1. Please click on a visual (chart or a table) 2. Click on the Visualization pane on the right side 3. Choose the second icon (Format) Now you ...
Fri, 21 Oct, 2022 at 5:26 AM
In Power BI desktop click on File. Click on 'Options and Settings' Under Preview features, enable Field parameters by checking the bo...
Fri, 11 Nov, 2022 at 9:46 PM
In the Power BI reports page there are a lot of slicers in use. These slicers can be made to interact (or) not interact with certain visuals using "Edi...
Thu, 1 Jun, 2023 at 5:49 PM
To publish your Power BI report online, you need to hard code the file's location for each table in Power Query to avoid dynamic data source error. ...
Mon, 12 Jun, 2023 at 4:32 PM
Following is the procedure to provide access to your excel file present in your OneDrive account in Power BI services: Step 1: Set up parameters and co...
Thu, 1 Jun, 2023 at 6:24 PM