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 →Atul Vij
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 →Busy Accounting Software: GST Billing and Reports for Small Businesses
Busy Accounting Software: GST Billing and Reports for Small Businesses
How to set up Busy for GST billing: company creation, masters, sale vouchers with CGST/SGST/IGST, and the reports small businesses use every month.
Read article →Busy Accounting Software: Setting Up a New Company for GST in Your First Week
Busy Accounting Software: Setting Up a New Company for GST in Your First Week
A day-by-day plan for starting a company in Busy: company creation, GST details, masters, opening balances, the first invoices, and the reports to check…
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 →