Posted inPower of Microsoft Office
Count a Weekday between Two Dates in Excel
Building a custom function in Excel's Advanced Formula Environment to count a specific weekday between two dates.
Posted inPower of Microsoft Office
Excel Tip: Convert Numbers to Dates with Text to Columns
Using Text to Columns in Excel to convert a date represented in numbers into a formatted date.
Posted inPower of Microsoft Office
Excel Tip: Custom Cell Formatting
Using Custom Cell Formatting in Excel to make a numeric value more informative by attaching text to numeric cells.
Posted inPower of Microsoft Office
Excel Tip: Fill Blank Cells Using “Go To” Wizard
Use the "Go To" wizard in Excel to fill blank cells regardless of their count.
Posted inPower of Microsoft Office
VLOOKUP Using Tables in Excel
Tables in Excel could be leveraged to overcome VLOOKUP common mistakes and provide more accurate and reliable results.
Posted inR Programming
Arithmetic and Variable Assignment in R
Do you know how arithmetic operations are performed in R? Watch this video that shows how to perform basic arithmetic operations in R and how to assign values to variables.…
Posted inR Programming
R Data Structures – Vectors
Vectors are one dimensional arrays that can hold numeric, character, or logical data. Watch this video that shows how to create different types of vectors in R and how to…
Posted inR Programming
Data Types in R
Do you know what data types are used in R? Watch this video that explains the basic data types in R, how to check their classes, and how to convert…
Posted inR Programming
A Quick Tour of RStudio Interface
Now you have R and RStudio installed in your machine, get a quick tour on RStudio main screen. https://youtu.be/ObaxP2x-goQ Register for the "Learning R Programming for Data Science" course to…
Posted inR Programming
Installing R and RStudio
Ready to start your journey to be a Data Scientist? Start off by getting introduced to R Programming Language. Do you know what R Language is, anyways? Watch this video…