Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
Power BI Lesson 1: Desktop Tour and Loading Data

20 Oct 2021 · Power BI & DAX · 2 min read

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 .pbix file.

Read article →
Power BI Desktop: Build Your First Report From an Excel File

10 Oct 2021 · Charts & Dashboards · 4 min read

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 slicer, a first DAX measure, format, and publish or export — with a data file and the numbers your visuals should show.

Read article →
HEX2BIN Function in Excel: Hexadecimal to Binary

8 Oct 2021 · Engineering · 1 min read

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

6 Oct 2021 · Power BI & DAX · 2 min read

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 and FY sorting.

Read article →
BITRSHIFT Function in Excel: Shift Bits to the Right

6 Oct 2021 · Engineering · 1 min read

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

28 Sep 2021 · Excel Functions A–Z · 1 min read

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 coupons.

Read article →
BITLSHIFT Function in Excel: Shift Bits Left

28 Sep 2021 · Engineering · 1 min read

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

27 Sep 2021 · Tally & Busy · 2 min read

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

24 Sep 2021 · Tally & Busy · 5 min read

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 before you file anything.

Read article →
BITXOR Function in Excel: Bitwise Exclusive OR

23 Sep 2021 · Engineering · 1 min read

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)

21 Sep 2021 · Power BI & DAX · 3 min read

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 quarters, month sorting from April, and same-period comparisons.

Read article →
BITOR Function in Excel: Bitwise OR

18 Sep 2021 · Engineering · 1 min read

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 →
Older posts
Newer posts
← Previous Page1 … Page74 Page75 Page76 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →