REPORT GENERATION WITH MS EXCEL COURSE

REPORT GENERATION WITH MS EXCEL COURSE

WANT TO DEVELOP YOUR OWN SCHOOL REPORT GENERATOR TEMPLATE WITH EXCEL??

COME WITH ME AS I TAKE YOU ON A STEP BY STEP JOURNEY HOW TO DEVELOP ONE FROM SCRATCH

WE KNOW WHAT YOU WANT TO SEE IN THE COURSE AND WHAT YOU VALUE SO WE'VE ADDED THEM ALL

STAGES OF DEVELOPMENT

STAGE 1. INTRODUCTION TO EXCEL (FUNCTIONS, FORMULARS AND TOOLS)

STAGE 2. SCORE/MARK SHEET

S/N, NAME (x30 Class Size)

CA1, CA2, EXAM, TOTAL, SUBJECT POSITION (x15 SUBJECTS)

OVERALL TOTAL, TOTAL SUBJECT OFFERED, STUDENT AVERAGE, OVERALL CLASS POSITION

TEACHER COMMENT, HEADTEACHER COMMENT

STUDENT ATTENDANCE REGISTER

AFFECTIVE & PSYCHOMOTOR DOMAIN

SCHOOL DATES: RESUMPTION, VACATION, NEXT TERM RESUMPTION

TIMES SCHOOL OPENED

STAGE 3. REPORT PAGE

SETTING COLUMNS AND ROWS SIZE

REPORT PAGE HEADING

STUDENT PROFILE DATA AREA

COGNITIVE DOMAIN TABLE

ATTENDANCE DATA TABLE

AFFECTIVE & PSYCHOMOTOR DOMAIN TABLE

REPORT SUMMARY TABLE

GRADE SCALE TABLE

TEACHER/HEADTEACHER COMMENT SECTION

REPORT PAGE IMAGE (AUTO SELECTION UPDATE)

STAGE 4. IMAGE PAGE SETUP AND AUTOMATIC IMAGE SELECTION UPDATE (New)

STAGE 5. FORMATTING (FINALIZING)

STAGE 6. DUPLICATE FOR ALL THREE TERMS

STAGE 7. VBA AUTOMATED REPORT PRINTING COMPLETE WITH CODE INSIDE (New)

S/N, NAME (x30 Class Size)

1ST TERM, 2ND TERM, 3RD TERM, YEAR TOTAL, SUBJECT POSITION (x15 SUBJECTS)

OVERALL SESSION TOTAL, SESSION TOTAL SUBJECT OFFERED, SESSION STUDENT AVERAGE, SESSION OVERALL CLASS POSITION

STAGE 8. PROJECT WRAP UP AND CONCLUSION

DOWNLOAD ALL VIDEOS TO YOUR COMPUTER OR MOBILE. HAPPY LEARNING, HAPPY DEVELOPMENT

LIMITED BONUS LESSONS

HOW TO SEND PDF REPORTS AS

1. WHATSAPP MESSAGE (USING FREE BULK MESSAGE SENDER TOOL)

2. EMAIL MESSAGE (USING FREE GMAIL ACCOUNT)

3. SMS MESSAGE (USING BULK SMS SENDER)