HOME
INTRO & WINDOWS
INTRODUCTION
>
FUNDAMENTAL OF IT
TYPE OF COMPUTER DEVICES
COMPUTER GENERATION
SYSTEM COMPUTER
TYPE OF COMPUTERS
NUMBERING SYSTEM
TYPE OF MOUSE
KEYBOARD
DATA PROCESSING
OPERATING SYSTEM
HISTORY OF COMPUTER
MS WINDOWS
>
ABOUT MS WINDOWS
WINDOWS DESKTOP
Win Control Activation
MS OFFICE
ABOUT MS-OFFICE
MS WORD
>
INTRO TO MS-WORD
FILE
>
INFO, NEW, OPEN
SAVE AND SAVE AS, PRINT
SHARE, EXPORT, CLOSE
HOME
>
CUT, COPY, PASTE, FORMAT PAI
FONT
STYLES
FIND, GO TO, REPLACE
INSERT
>
PAGES -COVER, BLANK, BREAK
TABLES
ILLUSTRATIONS
>
PICTURES, ONLINE PICTURE
SHAPES, ICONS, 3D MODELS
SmartArt
CHART, SCREENSHOT
LINK, BOOKMARK, CROSS-REF
COMMENT, HEADER/FOOTER
TEXTS
>
TEXT BOX, WORDART, DROP CAP, OBJECT
SYMBOL
DRAW
>
PENS
DESIGN
>
DOC STYLES, WATERMARK
PHARAGRAPH
PAGE COLOR, BORDERS
LAYOUT
>
PAGE SETUP, SPACING
ARRANGE OBJECTS
REFERENCES
>
TABLE OF CONTENTS
MAILINGS
>
ENVELOPES
REVIEW
>
DOC REVIEWS
VIEW
>
WEB LAYOUT, NEW WIN, SPLIT
SWITCH WINDOWS, MACROS
MS EXCEL
>
INTRO TO MS-EXCEL
FILE
>
INFO, NEW, OPEN
SAVE/SAVE AS, PRINT
SHARE, EXPORT
HOME
>
ALIGNMENT
>
CELL ALIGN, ORIENTATION
INDENTS, MERGE & CENTER
NUMBER, COND FORMAT
TABLE, INSERT, DELETE
FORMAT
>
ROW HEIGHT, COLUMN WIDTH
HIDE, RENAME, MOVE OR COPY
PROTECT SHEET, FILL
SORT & FILTER, AUTOSUM
FORMULAS
>
INTRO TO FORMULAS
MATH & TRIM
>
ABS( ), COMBIN( )
SUM FUNCTIONS( )
COS( ), SIN( )
BASE( )
STATISTICAL
>
AVERAGE FUNCTIONS( )
MAX FUNCTIONS( )
MIN FUNCTIONS( )
COUNT FUNCTIONS( )
MODE FUNCTIONS( )
ENGINEERING
>
BIN2DEC
CONVERT
TEXT FUNCTIONS
>
LEFT( ) RIGHT( ) MID( )
FIND( ) LEN( ) PROPER( )
TRIM( ) EXACT( ) FIXED( )
REPLACE, UNICHAR, UNICODE
CODE( ) CHAR( ) REPT( )
DATE & TIME FUNCTIONS
>
TODAY( ) YEAR( ) DAYS( )
LOGICAL
>
IF( ), IFERROR( )
IFS( ), SWITCH( )
AND( ), OR( )
IFNA( ), XOR( )
INSERT
>
CHARTS, SPARKLINES
PAGE LAYOUT
>
PRINT TITLES, SHEET OPTION
DATA
>
GET DATA, DATA VALIDATION
CONSOLIDATE
VIEW
>
WORKBOOK VIEWS
Excel Functions Exercises
>
Exercises 1 and 2
Exercises 3 and 4
MS POWER POINT
>
INTRO TO MS-POWERPOINT
FILE
>
INFO, NEW, OPEN
SAVE AND SAVE AS, PRINT
SHARE, EXPORT, CLOSE
HOME
>
NEW SLIDE, STYLES, FILL
INSERT
>
PHOTO ALBUM, VIDEO, AUDIO
SCREEN REC, SHOT, SLIDE NUM
DESIGN
>
THEMES, SLIDESIZE, FORMAT
TRANSITION
>
TRANSITION, SOUND
MS ACCESS
>
INTRO TO MS-ACCESS
FILE
>
HOME, NEW, OPEN
OFFICE QUESTION & ANSWER
VISUAL STUDIO
VISUAL BASIC .NET
>
INTRODUCTION
.NET FRAMEWORK
OPERATORS IN VB.NET
DATAYPES IN VB.NET
VB.NET KEYWORDS
VARIABLE AND CONST
INTRO TO VB.NET PLATFORM
INTRO TO PROGRAMMING
OBJECTS USAGE IN WIN-FORM
Python
>
Introduction
C++
GOOGLE TIPS
GMAIL ACCOUNT
>
Email Forwarding
Setting up Authenticator App
SIGNATURE SET UP
GOOGLE WORKSPACE
INVENTS
NEW INVENTS
ABOUT ME
HOME
INTRO & WINDOWS
INTRODUCTION
>
FUNDAMENTAL OF IT
TYPE OF COMPUTER DEVICES
COMPUTER GENERATION
SYSTEM COMPUTER
TYPE OF COMPUTERS
NUMBERING SYSTEM
TYPE OF MOUSE
KEYBOARD
DATA PROCESSING
OPERATING SYSTEM
HISTORY OF COMPUTER
MS WINDOWS
>
ABOUT MS WINDOWS
WINDOWS DESKTOP
Win Control Activation
MS OFFICE
ABOUT MS-OFFICE
MS WORD
>
INTRO TO MS-WORD
FILE
>
INFO, NEW, OPEN
SAVE AND SAVE AS, PRINT
SHARE, EXPORT, CLOSE
HOME
>
CUT, COPY, PASTE, FORMAT PAI
FONT
STYLES
FIND, GO TO, REPLACE
INSERT
>
PAGES -COVER, BLANK, BREAK
TABLES
ILLUSTRATIONS
>
PICTURES, ONLINE PICTURE
SHAPES, ICONS, 3D MODELS
SmartArt
CHART, SCREENSHOT
LINK, BOOKMARK, CROSS-REF
COMMENT, HEADER/FOOTER
TEXTS
>
TEXT BOX, WORDART, DROP CAP, OBJECT
SYMBOL
DRAW
>
PENS
DESIGN
>
DOC STYLES, WATERMARK
PHARAGRAPH
PAGE COLOR, BORDERS
LAYOUT
>
PAGE SETUP, SPACING
ARRANGE OBJECTS
REFERENCES
>
TABLE OF CONTENTS
MAILINGS
>
ENVELOPES
REVIEW
>
DOC REVIEWS
VIEW
>
WEB LAYOUT, NEW WIN, SPLIT
SWITCH WINDOWS, MACROS
MS EXCEL
>
INTRO TO MS-EXCEL
FILE
>
INFO, NEW, OPEN
SAVE/SAVE AS, PRINT
SHARE, EXPORT
HOME
>
ALIGNMENT
>
CELL ALIGN, ORIENTATION
INDENTS, MERGE & CENTER
NUMBER, COND FORMAT
TABLE, INSERT, DELETE
FORMAT
>
ROW HEIGHT, COLUMN WIDTH
HIDE, RENAME, MOVE OR COPY
PROTECT SHEET, FILL
SORT & FILTER, AUTOSUM
FORMULAS
>
INTRO TO FORMULAS
MATH & TRIM
>
ABS( ), COMBIN( )
SUM FUNCTIONS( )
COS( ), SIN( )
BASE( )
STATISTICAL
>
AVERAGE FUNCTIONS( )
MAX FUNCTIONS( )
MIN FUNCTIONS( )
COUNT FUNCTIONS( )
MODE FUNCTIONS( )
ENGINEERING
>
BIN2DEC
CONVERT
TEXT FUNCTIONS
>
LEFT( ) RIGHT( ) MID( )
FIND( ) LEN( ) PROPER( )
TRIM( ) EXACT( ) FIXED( )
REPLACE, UNICHAR, UNICODE
CODE( ) CHAR( ) REPT( )
DATE & TIME FUNCTIONS
>
TODAY( ) YEAR( ) DAYS( )
LOGICAL
>
IF( ), IFERROR( )
IFS( ), SWITCH( )
AND( ), OR( )
IFNA( ), XOR( )
INSERT
>
CHARTS, SPARKLINES
PAGE LAYOUT
>
PRINT TITLES, SHEET OPTION
DATA
>
GET DATA, DATA VALIDATION
CONSOLIDATE
VIEW
>
WORKBOOK VIEWS
Excel Functions Exercises
>
Exercises 1 and 2
Exercises 3 and 4
MS POWER POINT
>
INTRO TO MS-POWERPOINT
FILE
>
INFO, NEW, OPEN
SAVE AND SAVE AS, PRINT
SHARE, EXPORT, CLOSE
HOME
>
NEW SLIDE, STYLES, FILL
INSERT
>
PHOTO ALBUM, VIDEO, AUDIO
SCREEN REC, SHOT, SLIDE NUM
DESIGN
>
THEMES, SLIDESIZE, FORMAT
TRANSITION
>
TRANSITION, SOUND
MS ACCESS
>
INTRO TO MS-ACCESS
FILE
>
HOME, NEW, OPEN
OFFICE QUESTION & ANSWER
VISUAL STUDIO
VISUAL BASIC .NET
>
INTRODUCTION
.NET FRAMEWORK
OPERATORS IN VB.NET
DATAYPES IN VB.NET
VB.NET KEYWORDS
VARIABLE AND CONST
INTRO TO VB.NET PLATFORM
INTRO TO PROGRAMMING
OBJECTS USAGE IN WIN-FORM
Python
>
Introduction
C++
GOOGLE TIPS
GMAIL ACCOUNT
>
Email Forwarding
Setting up Authenticator App
SIGNATURE SET UP
GOOGLE WORKSPACE
INVENTS
NEW INVENTS
ABOUT ME