Excel and Google Sheets Automation Consultant

Excel and Google Sheets Automation Consultant

Does it take too much time for your desk jobs like data entry, calculation, preparing presentation, searching required information and preparing reports, sending emails, status and notifications etc? Why don’t we automate most of those tasks and save our time?

You can do things in minutes instead of days using proper automations. Even you can do many things without spending a single second! Yes, you heard it right. Let’s have a consultation session and find out the opportunities for automation with all Microsoft office and google products in your organization.

Md. Jahurul Islam
Excel Automation Consultant (3rd percentile in international test)
[email protected]
10 years experience in Planning and IE
B.Sc. (BUET)

Website Application Development and Management Cost for RMG

Website Application Cost for RMG

SlWebsiteSpeed
Backup
Restore &
Maintenance
Content
Writing
SEO for Digital
Marketing
SSL
CDN &
Security
VPS
WHM
cPanel
CDN
Total
Cost
1Corporate500005000050000500020001,07,000
2eCommerce500005000050000500020001,07,000
3Agro Dairy500005000050000500020001,07,000
4Buying House500005000050000500020001,70,000
5Accessories500005000050000500020001,07,000
6Logistics500005000050000500020001,07,000
7Design Studio500005000050000500020001,07,000
8Magazine
/Blog
500005000050000500020001,07,000
9HelpDesk50000XXX200050,200
10CRMS50000XXX200050,200
11Production
Tracking
50000XXXX50,000
11All550K400K40k20K1010K

Website Application Development and Management Cost for RMG

Social MediaMaintenance
/Year
Group Facebook10000
Group YouTube10000
Group Twitter10000
eCommerce Facebook50000
Trims Facebook10000
Sister Concern10000
Total1K

Digital Marketing Job for Md Rafiqul Islam

Digital Marketing Job for Hadisquran

SlJob ListStatusPaymentPenalty
1https://www.wafilife.com/mukhtasar-kitabut-tawhid/dp/403497?fbclid=IwAR03gKTg84kKjqmSN7Hja1Jiy6eZfq_BixjyzimKpVhEIuvCs2dBqwksHQ4
উপড়ের লিঙ্ক এর মোট করে নিচের লিঙ্ক টা ফরমেট করতে হবে
https://hadisquran.com/sahih-ibn-khuzaymah/
2https://hadisquran.com/সহীহ-ইবনে-খুজাইমা-pdf/ এই লিঙ্ক এর টেক্সট ঠিক করতে হবে
3সহিহ মুসলিম সকল লিঙ্কের ইন্টারনাল লিঙ্ক ঠিক আছে কি না দেখতে হবে। এবং ইন্টারনাল লিঙ্ক করতে হবে
4https://hadisquran.com/jakat/ শেষ করতে হবে
5মুসাফিরদের সালাত ও তার কসর3030Ok
6মসজিদ ও সালাতের স্থানসমূহ (১০৭৮-১১৩৪ and ১৪০৭-১৪৫৪ nai)4040Ok
7কোরআনের মর্যাদাসমূহ252512 link not done
8ক্রয়-বিক্রয়2121Ok
9মুসাকাহ (পানি সেচের বিনিময়) (ei tabel ta update korte hobe, onno gulor moton)Ok
10শিকার ও যবেহকৃত জন্তু এবং যেসব পশুর গোশত খাওয়া হালাল1212Ok
11https://hadisquran.com/কিতাবুল-ফিতনা/ হাদিস ফরমেট করতে হবে131131
12 https://hadisquran.com/sunan-ad-darimi/ দারিমি শরিফ কপি করতে হবে unicode copy and suchipotro scan korte hobe boibazar.com/book/sunan-aad-daremi-hadish-shorif
13https://hadisquran.com/musnad-imam-ahmad/ কপি করতে হবে
14https://hadisquran.com/fiqh-al-akbar/ = wafilife.com/al-fikhul-akbar/dp/19469 = এখান থেকে সুচি টেক্সট গুলো কপি করতে হবে
15Quran Shrarif er 5000 internal link korte hobe
16Quran Sharif er 114 tu sura pdf to unicode korte hobe
17Quran Sharif er Bangla numbering
17
18

Quran Project

No.BanglaIn WordsAyat/
Ruku
PDFRukuPara/
Sezda
1.ফাতিহাFatiha711
2.বাকারাBaqara286401,2,3
3.ইমরানImran200203,4
4.সুরা নিসাNisa176244,5,6
5মায়েদাMaida120166,7
6আনয়ামAnam165207,8
7আরাফAraf206248,9
8আনফালAnfal75109,10
9তাওবাTawba1291610,11
10ইউনুসYunus1091111
11হুদHud1231011,12
12ইউসুফYusus1111212,13
13রা’দRa’d43613
14ইবরাহীমIbrahim52713
15হিজরHijr99614
16সুরা নাহলNahl1281614
17বনী ইসরাঈলIsra1111215
18কা’হফKahf1101215,16
19মারঈয়ামMaryam98616
20ত্বা-হাTaha135816
21আম্বিয়াAnbia112717
22হাজ্জ্বHajj781017
23মু’মিনুনMiminun118618
24নুরNur64918
25ফুরকানFurkan77618,19
26শুয়ারাShuara2271119
27নাম’লNaml93719,20
28কাসাসQasas88920
29আনকাবুতAnkabut69720
30রূমRum60621
31লুকমানLuqman34421
32সাজদাSajda30321
33আহযাবAhzab73921,22
34সা’বাSaba54622
35ফাতিরFatir45522
36..ইয়াসীনYasin83522,23
37..সাফফাতSaffat182523
38..সা’দSad88523
39.যুমারZumar75823,24
40.মুমিনGhafir85924
41.হা-মীমFussilat54624,25
42.শূরাShura53525
43.যূখরুফZukhruf89725
44দুখানDukhan59325
45যাসিয়াJathiya37425
46..আহক্বাফAhqaf35426
47..মুহাম্মাদMuhammad38426
48..ফাতাহFath29426
49..হুজুরাতHujurat18226
50..ক্বাফQaf45326
51.যারিয়াতDhariyat60327
52..তুরTur49227
53.নাজমNajm62327
54..ক্বামারQamar55327
55.রহমানRahman78327
56.ওয়াক্বিয়াWaqia96327
57.হাদীদHadid29427
58.মুজাদালাহMijadila22328
59.হাশরHashr24328
60.মুমতাহিনাMumtahina13228
61.সফSaff14228
62.জুম’য়াJumua11228
63.মুনাফিক্বুনMunafiqun11228
64.তাগাবুনTaghabun18228
65.তালাকTalaq12228
66.তাহরীমTahrim12228
67.মুলকMulk30229
68.কালামQalam52229
69.হাক্বকাহHaqqa52229
70.মা’য়ারিজMaarij44229
71.নূহNuh28229
72.জ্বীনJinn28229
73.মুযযাম্মিলMuzammil20229
74.মুদ্দাসসিরMuddathir56229
75.কিয়ামাতQiyamat40229
76.দা’হরInsan31229
77.মুরসালাতMursalat50229
78.নাবাNaba40230
79নাজিয়াতNaziat46230
80.আ’বাসাAbasa42130
81.তাকভীরTakwir29130
82.ইনফিতারInfitar19130
83.মুতাফফিফীনMutaffifin36130
84.ইনশিকাকInshiqaq25130
85.বুরূজBuruj22130
86.তারিকTariq17130
87আ’লাAla19130
88.গাশিয়াহGhashiya26130
89.ফাজরFajr30130
90.বা’লাদBalad20130
91শামসShams15130
92.লাইলLail21130
93.দুহাDhuha11130
94.ইনশিরাহSharh8130
95.তীনTin8130
96আলাকAlaq19130
97.ক্বদরQadr5130
98.বাইয়্যেনাহBayyina 8130
99.যিলযালZalzala8130
100.আদিয়্যাতAdiyat11130
101.ক্বারিয়াQaria11130
102.তাকাসুরTakathur8130
103.আসরAsr3130
104.হুমাযাHumaza9130
105.ফীলFil5130
106.কুরাইশQuraysh4130
107.মাউনMaun7130
108.কাউসারKawthar3130
109.কাফিরূনKafirun6130
110.নসরNasr3130
111.লাহাবMasad5130
112ইখলাসIkhlas4130
113.ফালাকFalaq5130
114.নাসNas6130
1247
Taka
1247
Taka
200Tk558
Taka

Customer Relationship Management CRM – Open Source

Customer Relationship Management CRM – Open Source

Are you getting leads each day? That’s a great start. But are you following up?
You could be missing out on sales. CRM helps you to keep those relationships managed, increasing your revenues.

CRM Overview

Contacts: Every interaction you have with your customers, leads and other stakeholders

Companies: If you are selling to lot of companies you may have multiple contacts on that Company. See all your contacts under a company and never lose track again.

Segments: Segments are powerful way to split groups of contacts from your contact list

Quote: In Quote user can fill in the key details like contact name and quote value, you can then choose which template it should populate.

Tag: When your contact list is big, tags really help you filter your communication. Send an email to everyone based on tag

Feature of CRM

  • 100% Web Version
  • CRM Integration with Business Website
  • CRM Integration with Mobile Apps
  • Download apps from Google Play store and App Store

Benefits of CRM

  • All contacts in one place owned by company as well as employee
  • See your latest/oldest contacts at a glance
  • Contact them and work them towards becoming a customer/dealer/buyer
  • Never lose lead and customer list.
  • Easy to manage
  • Easy to action e.g. Closed, Reject etc.
  • Protect duplicate data entries

Service and Maintenance

Sales Funnel

CRM

RoleCRM Admin (Full CRM Permission)CRM Mail ManagerCRM ContactCRM Contact
Manager
CRM Transaction ManagerInvoice ManagerCRM Quote Manager
ContactsYYYY
CompaniesYYY
QuotesYYY
Quote
Templates
YYY
InvoiceYY  N
TransactionYY  N
Task SchedulerY Y  Y
SegmentYYYYY
Core ModuleYNNNN
FormsYNNNNNN
ExtensionsYNNNNNN
System AssistantYNNNNNN
CRM SettingYNNNNNN
ResourceYNNNNNN

Jetpack CRM Admin (Full CRM Permission)

RoleC
r
m
A
d
m
i
n
M
a
i
l
M
a
n
a
g
e
r
Q
u
o
t
e
M
a
n
a
g
e
r
C
o
n
t
a
c
t
M
a
n
a
g
e
r
T
r
a
n
s
a
c
t
i
o
n
Ma
na
ger
I
n
v
o
i
c
e
M
a
n
a
g
e
r
C
o
n
t
a
c
t
Contact ViewYYYYY Yx
Contact EntryYYYYY Yx
Contact Edit (Other)YYY
Contact DeleteYYYYY Yx
Company EntryYYYYYx
Company ViewYYYYY x
Company Edit (Other)X
Company DeleteYYYYYx
Add TagYYYY  Yx
Delete TagYY Y  Yx
Assign ToYxxx  x
Assign CompanyYNYx
Add QuoteYYYY  x
Delete QuoteYYY Y x
Add TaskYYYYx
Update Own TaskYYxYx
Update Other TaskYxxYx
Delete Own TaskYxYYx
Add SegmentYYYYx
Delete SegmentYYYYx
Add AliasYYYx
Add Logs ContactYYYx
Update Logs Own ContactYYx
Add FormYxxx
Add InvoiceYYYx
Delete InvoiceYYYx
Contact ImportYxxx
Contact ExportYxxxx
Transaction ExportYx

Help Topics Links

Help TopicsLinks
Jetpack Shortcodesjetpack.com/support/shortcode-embeds

Jetpack Contact Form

After Installing and configuring Jetpack Contact Form you can add contact from by clicking + Add Block option. Now a in Block of right sidebar you will be asked to connect “CRM Integration” by installing “Jetpack CRM Plugin”. In addition you will also asked to add “Newsletter Connection” in same place by “Add email permission request”. You also asked to install “Creative Mail Plugin” for email campaign.

Development Cost

SlModulesPricing
1Developing eye caching website2,00,000
2CRM Develpment2,00,000
3SEO – Search Engine Optimization1,00,000
3Total5,00,000

Maintenance Cost

SlModulePricing
1Hosting Server Rent and Management20,000
2Software Maintenance50,000
3SEO – Search Engine Optimization50,000
4Content Writing and Design 50,000
4Total1,70,000

Help Line

TopicsLink
Role Managementkb.jetpackcrm.com/knowledge-base/setting-up-your-team/
Restriction Managementkb.jetpackcrm.com/knowledge-base/how-do-i-restrict-leads-to-crm-team-members/
Segment & Tagyoutube.com/watch?v=KwGh-Br_exc

How to Customize WordPress Block with ADDITIONAL CSS CLASS(ES)

At first make a class

.lineheight_p { line-height: 2.2em;
font-size: 40px; }

Finally paste lineheight_p in ADDITIONAL CSS CLASS(ES)

How to Change Font Size, Color, Background of a specific letter

In WordPress, if you want to change the font size of a specific letter, you would typically use a combination of HTML and CSS.

Here’s a step-by-step process:

Identify the Letter in the Content:

Wrap the specific letter in a span tag.

<span class="special-letter">A</span>pple

This would target the letter “A” in the word “Apple”.

Styling the Letter:

Add custom CSS to style the wrapped letter.
There are several ways to add custom CSS in WordPress, one of the most common methods is via the Customizer.
Go to Appearance > Customize > Additional CSS and add:

.special-letter {
    font-size: 30px;            /* Adjust to your desired size */
    color: red;                /* Adjust to your desired font color */
    font-weight: bold;         /* Makes the letter bold */
    background-color: yellow;  /* Adjust to your desired background color */
    padding: 2px;              /* Optional: add some space around the letter */
}

The padding property is optional, but it can give some space around the letter, making the background color more evident.

TopicsLink
ADDITIONAL CSS CLASS(ES)youtube.com/watch?v=rKiwCj9wMTs