" Top 21 Excel Formulas" 10x your productivity with these 21 Excel must known formulas

MrWhite — Sun, 28 Jul 2024 22:17:48 +0000

Top 21 Excel Formulas

👇 👇 👇

👉 Download the High Resolution PDF: https://lnkd.in/dkrCMWaq

10x your productivity with these 21 Excel must known formulas:

SUM Adds all numbers in a range

Example: =SUM(A1:A9)
Add values from cell A1 to A9

AVERAGE Calculates the average of numbers in a range

Example : =AVERAGE(B1:B9)
Average of B1 to B9

ROUND Rounds a number to a specified number of digits

Example: =ROUND(C1;2)
Round C1 to 2 decimal places

MIN Identifies the lowest number in a range

Example: =MIN(D1:D9)
Find the minimum in D1 to D9

MAX Finds the highest number in a range

Example: =MAX(D1:D9)
Get the maximum value in D1 to D9

COUNT Counts the number of cells that contain numbers

Example: =COUNT(F1:F9)
Count numeric cells in F1 to F9

INDEX Returns a value in table based on row & column number

Example: =INDEX(K1:L10,2,3)

MATCH Searches for a value and returns its relative position

Example: =MATCH(L1,M1:M9,0)
To find L1's position from the range M1:M9

VLOOKUP Searches for a value in the first column of a range

Example: =VLOOKUP (G1,H1:H10,2,FALSE)
To find G1 in H1:H10

HLOOKUP Searches for a value in the top row of a table

Example: =HLOOKUP(I1,J1:S2,2,FALSE)
To find I1 in the top row J1:S2

COUNTIF/COUNTIFS Counts cells that meet a condition

Example: =COUNTIF (N1:N9;">5")
To count cells greater than 5

COUNTA Counts non-empty cells

Example: =COUNTA(O1:O9)
To count all non-empty cells in a range

SUMIF / SUMIFS Counts non-empty cells

Example: =SUMIF(P1:P9,">5")
Add cells that meet a condition

IF / NESTED IFS Performs conditional tests

Example: =IF(R1>5;"Yes";"No")
For simple conditions

Note:

IF: 1 variable
IFS: multiple variables

=IF(test, true, false)

=IF(test1, true, IF(test2, true, false)) Nested IF

=IFS(test1, true, test2, true, test3, true)

AVERAGEIF / AVERAGEIFS Calculates the average for cells that meet criteria

=AVERAGEIF(Q1:Q9;">5")
Average of values over 5

Logical Operators (AND, OR) Combines multiple conditions

Examples:
=AND(S1>5;S2<2)
Both conditions are true => Output is true

CONCATENATE Joins two or more text strings

Example: =CONCATENATE(T1," ",T2)
Combine first name and last name in one cell

LEFT/RIGTH Extracts characters from the start/end of a text string

Examples:
=LEFT(U1;5)
Excel

=RIGHT(U1;5)
Class

MID Extracts characters from the middle of a text string

Example: =MID(V1;7;7)
7 characters starting from the 7th => Mastery

TEXT Converts a value to text in a specific number format

Ex: =TEXT(V1;”MMM-YY")
7/02/2024 => Feb-24

IFERRROR Returns a custom result if a formula errors out

Ex: =IFERROR(W1,"0")
Give 0 as output, instead of "# div" error"

💢 How do you make your own WordPress Plugin ? in 2024

MrWhite — Wed, 17 Jan 2024 06:35:25 +0000

💥💥 Let's spoil you a little 💥

💢 How do you make your own WordPress Plugin ?

let give you example with one page script.

To schedule the publication of posts on WordPress.
In addition to a control interface in the Dashboard that allows you to add and schedule posts easily.

First, create a folder with the name of the new plugin, which I am a writer called “daily-posts-plugin”.
Second, create a new PHP file named “daily_posts_plugin.php” and put the following code in it:

<?php
/*
Plugin Name: Daily Posts Plugin
Description: A plugin to publish daily posts with scheduling feature.
Version: 1.0
Author: Your Name
*/
// Add a new menu in the control panel
function daily_posts_menu() {
     add_menu_page(
         'Daily Posts',
         'Daily Posts',
         'manage_options',
         'daily-posts',
         'daily_posts_page',
         'dashicons-megaphone',
         20
     );
}
// Create a control interface page
function daily_posts_page() {
     // Check user permissions
     if (!current_user_can('manage_options')) {
         wp_die('You do not have sufficient permissions to access this page.');
     }
     // if the "Save" button is clicked
     if (isset($_POST['submit'])) {
         $post_content = sanitize_text_field($_POST['post_content']);
         $post_date = sanitize_text_field($_POST['post_date']);
         //Create the post
         $post_id = wp_insert_post(array(
             'post_title' => 'Daily Post',
             'post_content' => $post_content,
             'post_status' => 'future',
             'post_date' => $post_date
         ));
         if ($post_id) {
             echo '<div class="notice notice-success"><p>Post was saved successfully!</p></div>';
         } else {
             echo '<div class="notice notice-error"><p>An error occurred while saving the post. Please try again.</p></div>';
         }
     }
     ?>
     <div class="wrap">
         <h1>Add a daily post</h1>
         <form method="post" action="">
             <table class="form-table">
                 <tr>
                     <th scope="row"><label for="post_content">Post content</label></th>
                     <td><textarea id="post_content" name="post_content" rows="5" cols="50"></textarea></td>
                 </tr>
                 <tr>
                     <th scope="row"><label for="post_date">Published date</label></th>
                     <td><input type="date" id="post_date" name="post_date"></td>
                 </tr>
             </table>
             <p class="submit"><input type="submit" name="submit" id="submit" class="button button-primary" value="Save"></p>
         </form>
     </div>
     <?php
}
// Register the list and add the page to the control panel
add_action('admin_menu', 'daily_posts_menu');

We will compress the file with the extension . Zip We download it like any regular plugin from the WordPress panel.
After that, we will activate our plugins from the WordPress control panel. After activating the add-on, the “Daily Posts” list will appear in the control panel. You can use it for your daily posts, You will be able to write the content of the post and specify the publication date. Then click the “Save” button to save the post and schedule it for publication on the specified date. Please note that you can customize the plugin according to your own needs, such as changing the plugin name and customizing the control panel. Or add other jobs... I hope any questions stay here and don't private anything unless necessary.

DEV Community: MrWhite

" Top 21 Excel Formulas" 10x your productivity with these 21 Excel must known formulas

💢 How do you make your own WordPress Plugin ? in 2024

DesignWordPressPlugin

WordPressPlugin

100MillionDEV #100MillionCC

100MillionCC