Java Lesson 5: Classes and Objects
Model real things with classes: fields, constructors, methods, private data with public methods, and records for simple data.
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
Model real things with classes: fields, constructors, methods, private data with public methods, and records for simple data.
Read article →Write static methods with parameters and return types, overloading, and keeping methods small and testable.
Read article →Use if/else, switch expressions, comparison and logical operators, for, enhanced for and while loops in Java.
Read article →Java’s static types: int, double, boolean, char and String, declaring variables, var, arithmetic and integer division, casting and printf formatting.
Read article →Install a JDK (Temurin or Oracle), check java -version, write and run Hello.java from the terminal and in VS Code or IntelliJ IDEA.
Read article →QUARTILE returns the quartile of a data set. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →Use the Scripting.Dictionary in Excel VBA: create one, add and update keys, count and total by key, get unique lists, compare text case-insensitively, early…
Read article →QUARTILE.INC returns the minimum, the 25th, 50th or 75th percentile, or the maximum. It is the fastest way to see whether a salary band…
Read article →Finish and share the course project: build a one-page sales dashboard, publish to the Power BI service, schedule refresh with a gateway, share via…
Read article →Make reports interactive: slicers and sync across pages, cross-filtering and edit interactions, drill-down hierarchies, drill-through detail pages, report-page tooltips and bookmarks for saved views.
Read article →Choose and format Power BI visuals: cards and KPIs, bar vs column vs line, tables and matrices, maps, conditional formatting, consistent themes and page…
Read article →Write the core measures every report needs: total sales with SUMX, cost and margin, order counts with COUNTROWS, distinct counts, averages, and safe ratios…
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.