Posts

Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment
Read more

What is IoT (Internet of Things)?

Image
  What is IoT (Internet of Things)? The Internet of Things (IoT) refers to a network of physical objects—devices, vehicles, appliances, and other "things" embedded with sensors, software, and connectivity—that collect and exchange data over the internet. IoT enables these devices to interact with each other, systems, and users, creating a smarter and more interconnected world. How Does IoT Work? Device Integration IoT-enabled devices come with embedded sensors, actuators, and connectivity hardware (e.g., Wi-Fi, Bluetooth, 5G). Data Collection Sensors within the devices collect real-time data about the environment or device-specific metrics (e.g., temperature, motion, location). Data Transmission The collected data is transmitted to a central hub or cloud server using communication protocols like Wi-Fi, Zigbee, or cellular networks. Data Processing and Analysis On the Edge : Simple data processing happens locally...
Post a Comment
Read more

EXCEL TIPS AND TRICKS YOUR SHORTCUT CHEAT SHEET

Image
 F1 Displays the Office Assistant or (Help > Microsoft Excel Help)  F2 Edits the active cell, putting the cursor at the end  F3 Displays the (Insert > Name > Paste) dialog box  F4 Repeats the last worksheet action (Edit > Repeat)  F5 Displays the (Edit > GoTo) dialog box  F6 Moves to the next pane in a workbook (if the window is split)  F7 Displays the (Tools > Spelling) dialog box  F8 Toggles whether to extend a selection with the arrow keys  F9 Calculates All the worksheets in All the open workbooks  F10 Toggles the activation of the Menu Bar  F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range  F12 Displays the (File > Save As) dialog box  Shift + F2 Inserts or edits a cell comment (Insert > Comment)  Shift + F3 Displays the (Insert > Function) dialog box  Shift + F4 Repeats the last Find, the same as (Edit > Find Next)  Shift + F5 Displays the (Edit > Fin...
Post a Comment
Read more