Power BI Lesson 1: Desktop Tour and Loading Data
Install Power BI Desktop, learn the Report, Table and Model views, load several Excel tables through Power Query, check data types, and save a…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Power BI Desktop: Build Your First Report From an Excel File
Power BI Desktop: Build Your First Report From an Excel File
Step-by-step first Power BI report from an Excel table: install, Get data, check types in Power Query, build cards, bar and line charts, a…
Read article →HEX2BIN Function in Excel: Hexadecimal to Binary
HEX2BIN Function in Excel: Hexadecimal to Binary
EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2BIN converts hex to binary text — each hex digit becomes four bits.Syntax=HEX2BIN(number.
Read article →Power BI Lesson 7: Time Intelligence for the Indian Financial Year
Power BI Lesson 7: Time Intelligence for the Indian Financial Year
Year-to-date, previous year and year-on-year growth for an April–March financial year: mark the date table, TOTALYTD with a 31 March year end, SAMEPERIODLASTYEAR, DATEADD…
Read article →BITRSHIFT Function in Excel: Shift Bits to the Right
BITRSHIFT Function in Excel: Shift Bits to the Right
BITRSHIFT shifts a number's bits right, the same as integer division by a power of 2. Used to read packed flags and bit fields.
Read article →COUPDAYBS Function in Excel: Days From Last Coupon to Settlement
COUPDAYBS Function in Excel: Days From Last Coupon to Settlement
COUPDAYBS counts days from the last coupon date to the settlement date: the accrued-interest days. Used for bond pricing and accrued interest on half-yearly…
Read article →BITLSHIFT Function in Excel: Shift Bits Left
BITLSHIFT Function in Excel: Shift Bits Left
EngineeringLevel: ExpertAvailable in: Excel 2013+BITLSHIFT shifts bits left, multiplying by powers of two.Syntax=BITLSHIFT(number.
Read article →BITXOR Function in Excel: Bitwise Exclusive OR
BITXOR Function in Excel: Bitwise Exclusive OR
EngineeringLevel: ExpertAvailable in: Excel 2013+BITXOR flips bits — on where exactly one input has them on.Syntax=BITXOR(number1, number2)ArgumentWhat it.
Read article →Power BI Time Intelligence for the Indian Financial Year (April–March)
Power BI Time Intelligence for the Indian Financial Year (April–March)
Build FY-aware Power BI reports: a marked Calendar table with FY columns, FYTD with a 31 March year end, previous year and growth, FY…
Read article →BITOR Function in Excel: Bitwise OR
BITOR Function in Excel: Bitwise OR
EngineeringLevel: ExpertAvailable in: Excel 2013+BITOR combines flag numbers: a bit is on if it is on in either input.Syntax=BITOR(number1.
Read article →GST Reconciliation in Excel: Match GSTR-2B With Your Purchase Register
GST Reconciliation in Excel: Match GSTR-2B With Your Purchase Register
Step-by-step GSTR-2B vs purchase-register reconciliation in Excel: clean GSTINs and invoice numbers, build a match key, find missing and mismatched invoices, and prepare the…
Read article →AMORLINC Function in Excel: Depreciation With Part-Year Start
AMORLINC Function in Excel: Depreciation With Part-Year Start
AMORLINC returns straight-line depreciation for an accounting period, prorating the first period by purchase date (French accounting system).
Read article →