1 |
Why Data Analytics? |
2 |
Introductory Courses |
3 |
Step-up Programming |
4 |
Whats is data Science? |
5 |
why learn VBA? |
6 |
Importance of Data Visualization |
7 |
How to apply TANH Function in Excel? |
8 |
How to use LOGNORM.DIST Function in Excel? |
9 |
How to use LOGEST Function in Excel? |
10 |
How to apply LINEST Function in Excel? |
11 |
How to implement LARGE Function in Excel? |
12 |
How to use KURT Function in Excel? |
13 |
How to use INTERCEPT Function in Excel? |
14 |
How to implement HYPGEOM.DIST Function in Excel? |
15 |
How to use HARMEAN Function in Excel? |
16 |
How to apply GROWTH Function in Excel? |
17 |
How to implement GAUSS Function in Excel? |
18 |
How to implement GAMMALN.PRECISE Function in Excel? |
19 |
How to use GAMMALN Function in Excel? |
20 |
How to use GAMMA.INV Function in Excel? |
21 |
How to apply GAMMA.DIST Function in Excel? |
22 |
How to apply GAMMA Function in Excel? |
23 |
How to use FORECAST.LINEAR Function in Excel? |
24 |
How to use FORECAST.ETS.STAT Function in Excel? |
25 |
How to implement FORECAST.ETS.SEASONALITY Function in Excel? |
26 |
How to implement FORECAST.ETS.CONFINT Function in Excel? |
27 |
How to use FORECAST.ETS Function in Excel? |
28 |
How to use FORECAST Function in Excel? |
29 |
How to implement FISHERINV Function in Excel? |
30 |
How to use FISHER Function in Excel? |
31 |
How to use FINV Function in Excel? |
32 |
How to use F.TEST Function in Excel? |
33 |
How to implement F.INV.RT Function in Excel? |
34 |
How to implement F.INV Function in Excel? |
35 |
How to use F.DIST.RT Function in Excel? |
36 |
How to apply F.DIST Function in Excel? |
37 |
How to implement EXPON.DIST Function in Excel? |
38 |
How to use DEVSQ Function in Excel? |
39 |
How to use COVARIANCE.S Function in Excel? |
40 |
How to apply COVARIANCE.P Function in Excel? |
41 |
How to implement COUNTIFS Function in Excel? |
42 |
How to apply COUNTIF Function in Excel? |
43 |
How to use COUNTBLANK Function in Excel? |
44 |
How to implement COUNTA Function in Excel? |
45 |
How to implement COUNT Function in Excel? |
46 |
How to implement CORREL Function in Excel? |
47 |
How to apply CONFIDENCE.T Function in Excel? |
48 |
How to use CONFIDENCE.NORM Function in Excel? |
49 |
How to use CHISQ.TEST Function in Excel? |
50 |
How to implement CHISQ.INV.RT Function in Excel? |
51 |
How to use CHISQ.INV Function in Excel? |
52 |
How to use CHISQ.DIST.RT Function in Excel? |
53 |
How to implement CHISQ.DIST Function in Excel? |
54 |
How to use BINOM.INV Function in Excel? |
55 |
How to apply BINOM.DIST.RANGE Function in Excel? |
56 |
How to implement BINOM.DIST Function in Excel? |
57 |
How to apply BETA.INV Function in Excel? |
58 |
How to implement BETA.DIST Function in Excel? |
59 |
How to implement AVERAGEIFS Function in Excel? |
60 |
How to use AVERAGEIF Function in Excel? |
61 |
How to implement AVERAGEA Function in Excel? |
62 |
How to apply AVERAGE Function in Excel? |
63 |
How to apply AVEDEV Function in Excel? |
64 |
How to apply YEARFRAC Function in Excel? |
65 |
How to use YEAR Function in Excel? |
66 |
How to implement WORKDAY.INTL Function in Excel? |
67 |
How to implement WORKDAY Function in Excel? |
68 |
How to implement WEEKNUM Function in Excel? |
69 |
How to apply WEEKDAY Function in Excel? |
70 |
How to use TODAY Function in Excel? |
71 |
How to use TIMEVALUE Function in Excel? |
72 |
How to apply TIME Function in Excel? |
73 |
How to apply SECOND Function in Excel? |
74 |
How to implement NOW Function in Excel? |
75 |
How to apply NETWORKDAYS.INTL Function in Excel? |
76 |
How to use NETWORKDAYS Function in Excel? |
77 |
How to apply MONTH Function in Excel? |
78 |
How to use MINUTE Function in Excel? |
79 |
How to implement ISOWEEKNUM Function in Excel? |
80 |
How to apply HOUR Function in Excel? |
81 |
How to use EOMONTH Function in Excel? |
82 |
How to implement EDATE Function in Excel? |
83 |
How to implement DAYS360 Function in Excel? |
84 |
How to use DAYS Function in Excel? |
85 |
How to implement DAY Function in Excel? |
86 |
How to use DATEVALUE Function in Excel? |
87 |
How to use DATEDIF Function in Excel? |
88 |
How to apply DATE Function in Excel? |
89 |
How to apply WEBSERVICE Function in Excel? |
90 |
How to use FILTERXML Function in Excel? |
91 |
How to implement ENCODEURL Function in Excel? |
92 |
How to apply VALUE Function in Excel? |
93 |
How to apply UPPER Function in Excel? |
94 |
How to apply UNICODE Function in Excel? |
95 |
How to implement UNICHAR Function in Excel? |
96 |
How to use TRIM Function in Excel? |
97 |
How to use TEXTJOIN Function in Excel? |
98 |
How to apply TEXT Function in Excel? |
99 |
How to use SUBSTITUTE Function in Excel? |
100 |
How to apply SEARCH Function in Excel? |
101 |
How to implement RIGHT Function in Excel? |
102 |
How to implement REPT Function in Excel? |
103 |
How to implement REPLACE Function in Excel? |
104 |
How to use PROPER Function in Excel? |
105 |
How to implement PHONETIC Function in Excel? |
106 |
How to use NUMBERVALUE Function in Excel? |
107 |
How to implement MID Function in Excel? |
108 |
How to implement LOWER Function in Excel? |
109 |
How to apply LEN Function in Excel? |
110 |
How to implement LEFT Function in Excel? |
111 |
How to implement JIS Function in Excel? |
112 |
How to implement FIXED Function in Excel? |
113 |
How to apply FIND Function in Excel? |
114 |
How to use EXACT Function in Excel? |
115 |
How to use DOLLAR Function in Excel? |
116 |
How to implement DBCS Function in Excel? |
117 |
How to implement CONCATENATE Function in Excel? |
118 |
How to implement CONCAT Function in Excel? |
119 |
How to implement CODE Function in Excel? |
120 |
How to apply CLEAN Function in Excel? |
121 |
How to apply CHAR Function in Excel? |
122 |
How to apply BAHTTEXT Function in Excel? |
123 |
How to apply ASC Function in Excel? |
124 |
How to apply VLOOKUP Function in Excel? |
125 |
How to apply UNIQUE Function in Excel? |
126 |
How to apply TRANSPOSE Function in Excel? |
127 |
How to apply SORTBY Function in Excel? |
128 |
How to apply SORT Function in Excel? |
129 |
How to apply SINGLE Function in Excel? |
130 |
How to apply RTD Function in Excel? |
131 |
How to implement ROWS Function in Excel? |
132 |
How to implement ROW Function in Excel? |
133 |
How to implement OFFSET Function in Excel? |
134 |
How to implement MATCH Function in Excel? |
135 |
How to implement LOOKUP Function in Excel? |
136 |
How to implement INDIRECT Function in Excel? |
137 |
How to implement INDEX Function in Excel? |
138 |
How to implement HYPERLINK Function in Excel? |
139 |
How to implement HLOOKUP Function in Excel? |
140 |
How to use GETPIVOTDATA Function in Excel? |
141 |
How to use FORMULATEXT Function in Excel? |
142 |
How to use FILTER Function in Excel? |
143 |
How to use COLUMNS Function in Excel? |
144 |
How to use COLUMN Function in Excel? |
145 |
How to use CHOOSE Function in Excel? |
146 |
How to use AREAS Function in Excel? |
147 |
How to use ADDRESS Function in Excel? |
148 |
How to use XOR Function in Excel? |
149 |
How to use TRUE Function in Excel? |
150 |
How to use SWITCH Function in Excel? |
151 |
How to apply OR Function in Excel? |
152 |
How to apply NOT Function in Excel? |
153 |
How to apply IFS Function in Excel? |
154 |
How to apply IFNA Function in Excel? |
155 |
How to apply IFERROR Function in Excel? |
156 |
How to apply IF Function in Excel? |
157 |
How to apply FALSE Function in Excel? |
158 |
How to apply AND Function in Excel? |
159 |
How to implement SHEETS Function in Excel? |
160 |
How to apply SHEET Function in Excel? |
161 |
How to apply NA Function in Excel? |
162 |
How to apply ISTEXT Function in Excel? |
163 |
How to apply ISREF Function in Excel? |
164 |
How to apply ISODD Function in Excel? |
165 |
how to use pivot table in microsoft excel? |
166 |
how to create manipulate and change VBA Array ? |
167 |
VBA Operators |
168 |
How to create vba function |
169 |
How to automate excel with help of VBA |
170 |
How to Access MongoDB via GUI |
171 |
How to use ranges in Excel VBA |
172 |
Regex Code Syntax Guide |
173 |
Probability Data Science : Step by step week2-3 |
174 |
Descriptive statistics Data Science : Step by step week1 |
175 |
Data Science : Step by step plan | Learn along |
176 |
Human being a machine learning experience |
177 |
data preparation dbms |
178 |
vba codes practise sub commandnametoday |
179 |
Challenges in Data Analytics |
180 |
Probability short course for data analyst |
181 |
How to become Data Driven organization |
182 |
Category of Analytics Methods |
183 |
How to become Data Scientist |
184 |
Why Monkidea Blog Post |
185 |
Free books data Analytics |
186 |
10 Fun Facts About Analytics |
187 |
summary of monkidea.com till this post |
188 |
Data visualization: summary table & Mosaic chart |
189 |
observational and second experimental studies |
190 |
Relative standard deviation.& Coefficient of variation |
191 |
Sampling types: Statistics |
192 |
population and sample : statistics |
193 |
Data transformation : statistics |
194 |
Variability Vs diversity : Statistical Spread |
195 |
Data Visualization : Box plot |
196 |
Data Visualization : Histogram |
197 |
Data visualization : Bar & Pie chart |
198 |
Data visualization : Scatter plot |
199 |
Data Exploration Introduction & Bias types |
200 |
SQL queries for practice : Oracle 11g |
201 |
Creating your own schema : Oracle 11g XE |
202 |
DML : Insert , Update, Delete in SQL |
203 |
Creating the Other schema Objects: Oracle 11g SQL |
204 |
Learning Constraints :SQL |
205 |
DDL data defination language – A note |
206 |
SQL as a Set Oriented Language (Union, union all, minus, intersect) |
207 |
Subqueries SQL |
208 |
PL/SQL Basics – an introduction |
209 |
An introduction to SQL Functions with examples |
210 |
SQL Select statement – An introduction |
211 |
SQL Operators |
212 |
Schema ,datatypes & constraints |
213 |
First step toward Oracle Database XE |
214 |
SQL Introduction & DBMS interfaces |
215 |
1st post on Oracle 11g SQL : Monkidea |
216 |
RDBMS components |
217 |
Indexing : (Yet to be updated) |
218 |
Naming conventions & Data integrity – RDBMS |
219 |
Normalization: RDBMS |
220 |
Data Model & design – RDBMS |
221 |
Removing Inconsistencies in designing RDBMS |
222 |
DDLC (Database Development Life Cycle) |
223 |
RDBMS – An Introduction |
224 |
Data in a Dataset – Set theory |
225 |
Origin or sources or top generators of data for analytics |
226 |
Data Definition (Label DBMS) |
227 |
BIG DATA Analytics : An Introduction |
228 |
Statistics tests a summary |
229 |
Why every business analyst needs to learn R |
230 |
TOOLS FOR ANALYTICS |
231 |
Use of Analytics w.r.t Industry Domains |
232 |
Analytics as a process |
233 |
Top view of analytics BIG PICTURE |
234 |
Emergence / evolution of Analytics |
235 |
Terms and definition used in analytics |
236 |
why do we need analytics |
237 |
Analytics Overview |
238 |
Data Analytics Courses |
239 |
Projects WhitePapers |
240 |
Become a specialist with Data Science!. Click to know whats fits your requirement!!! |