How To Apply Icon Sets New Rule Conditional Formatting In Power BI

Conditional Formatting allows users to highlight values using colours, bar, icons and scales. Using Conditional Formatting adds the touch of professionalism to reports. Over in Excel, Conditional Formatting is located in the Styles group of the Home tab. However, in Power BI, it is located Format. In this exercise, we have a report that we wants to add Icon Sets […]

Continue reading

How To Magnify Values in Power BI

By default, when user drag any field into the white canvas of the Power BI Report view, the field automatically display the values using 8 pt Text Size which, more often than not, is not readable. See below Therefore, to increase the Text size to something more readable: Select the visualization Under Format, locate Values Scroll down and locate Text Size Increase […]

Continue reading

How To Use REPLACE, SEARCH, LEFT & CONCAT Functions To Transpose Values in Structured Referencing

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to user REPLACE, SEARCH, LEFT & CONCAT functions to transpose values located from middle to the left, right to the middle and left to the right (i.e. Larry, Gill Taylor to Gill Taylor Larry) . This operation can be performed easily by using the Flash […]

Continue reading

How To Create Custom List In Excel 2019 Version – US States As An Example

Microsoft Excel enables users to create desired custom list that can be auto filtered. In this blog tutorial, we have 50 States in the United States that we want to use as the criteria to create custom list. After creating the custom list, we will test whether its working or not. Let’s get started! In the caption below, we have […]

Continue reading

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (4th Session)

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (4th Session) Date: June 28th, 2019 Time: 1pm – 5pm Topics covered Understanding how to use named ranges How to use Data Validation How to use Text-to-column How to use SUMIFS, AVERAGEIFS, MAXIFS & MINIFS Functions Data […]

Continue reading

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (3rd Session)

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (3rd Session) Date: June 28th, 2019 Time: 9am – 12pm Topics covered Create Pivot Table Working with Pivot Tables Field List Tabular Pivot Table Report How to Report Pivot Table Filter Pages Pivot Charts Working with Pivot […]

Continue reading

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (1st Session)

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (1st Session) Date: June 27th, 2019 Time: 9am – 12pm Topics covered Introduction to Excel General Excel Formatting Freezing Panes and Splitting windows Using Arithmetic Operators in formulas Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions How to […]

Continue reading