logo
Find a Training Center x

CERTIFICATE IN EXCEL - MARKETING

  • No Rating
  • (0 Reviews)
  • 0 User Enrolled

CERTIFICATE IN EXCEL - MARKETING

EXCEL FOR MARKETING HAS A TOTAL OF 5 MODULES AND DETAILED EXPLANATION OF ALL THE TOPICS OF MARKETING LIKE SALES REPORT, CHART & ANALYSIS , FORMATTING, PIVOT CHART, AND TABLE ETC.

  • No Rating
  • (0 Reviews)
  • 0 User Enrolled
  • 349
  • 999
  • Course Includes
  • Valuable demand videos
  • Access on PC & Mobile
  • Downloadable Resources
  • Certificate


Course Content

5 sections • 28 lectures • 03h 59m total length
VIDEO 1: FONT A-Z
25:53min
M-1: Assignment Hint | FONT(A-Z)
04:52min
M-1: BASIC FORMATTING (V2) ALIGNMENT (A-Z)
16:53min
M-1: Assignment Hint | ALIGNMENT (A-Z)
05:53min
M-1: BASIC FORMATTING (V3) CLIPBOARD(A-Z)
12:13min
M-1: Assignment Hint | ClipBoard (A-Z)
04:37min
M-1: BASIC FORMATTING (V4) NUMBER(A-Z)
11:19min
M-1: Assignment Hint | NUMBER (A-Z)
6:39min
M-2: PLAYING WITH SHEET (V1) ADJUSTMENT A-Z
14:44min
M-2: ASSIGNMENT HINT (V1) ADJUSTMENT A-Z
03:08min
M-2: PLAYING WITH SHEET (V2) VIEW
10:49min
M-2: ASSIGNMENT HINT (V2) VIEW
01:24min
M-2: PLAYING WITH SHEET (V3) PROTECTION
07:19min
M-2: ASSIGNMENT HINT (V3) PROTECTION
03:05min
M-2: PLAYING WITH SHEET (V4) FORMATTING & FINDING
07:10min
M-2: ASSIGNMENT HINT (V4) FORMATTING & FINDING
02:21min
M-3: BASIC FORMULA FOR MARKETING (V1) SUM() | AVERAGE() | SUMPRODUCT()
10:15min
M-3:BASIC FORMULA FOR MARKETING(V2) MAX() | MIN() | LARGE()
05:59min
M-3:BASIC FORMULA FOR MARKETING(V3) LEFT() | MID() | RIGHT()
04:47min
M-3:BASIC FORMULA FOR MARKETING(V4) IF() | IF(AND()) | IF(OR())
16:31min
M-4: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-I(V1) SUMIF()
9:27min
M-4: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-I(V2) SHORT & FILTER
7:46min
M-4: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-I(V3) DATA TABLE
8:45min
M-4: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-I(V4) CONDITIONAL FORMATTING
9:29min
M-5: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-II (V1) LOOKUP & HLOOKUP
7:13min
M-5: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-II (V2) VLOOKUP & MATCH
9:38min
M-5: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-II (V3) CHART & GRAPH
11:59min
M-5: ADVANCE FORMULA & FUNCTIONS FOR MARKETING-II (V4) PIVOT TABLE
14:50min

Requirements

  • EXCEL SOFTWARE

Description

MODULE 1: BASIC FORMATTING

VIDEO 1: FONT A-Z

VIDEO 2: ALIGNMENT A-Z

VIDEO 3: CLIPBOARD A-Z

VIDEO 4: NUMBER A-Z

MODULE 2: PLAYING -WITH SHEET

VIDEO 1: ADJUSTMENT A-Z

VIDEO 2: VIEW

VIDEO 3: PROTECTION

VIDEO 4: FORMATTING & FINDING

MODULE 3: BASIC FORMATTING

VIDEO 1: SUM() | SUMPRODUCT() | AVERAGE()

VIDEO 2: MAX() | MIN() | LARGE() | SMALL()

VIDEO 3: LEFT() | MID() | RIGHT()

 

VIDEO 4: IF() | IF(AND()) | IF(OR())

MODULE 4: ADVANCED FORMULA & FUNCTIONS FOR MARKETING -I

VIDEO 1: SUMIF()

VIDEO 2: SORT & FILTER

VIDEO 3: DATA TABLE

VIDEO 4: CONDITIONAL FORMATTING

MODULE 5: ADVANCED FORMULA & FUNCTIONS FOR MARKETING -II

VIDEO 1: LOOKUP() | HLOOKUP()

VIDEO 2: VLOOKUP() | MATCH()

VIDEO 3: CHART

VIDEO 4: PIVOT TABLE

 

 

 

Recently Added Courses

blog
Last Updated 19th January 2022
  • 29
  • 6000
  • 12000
blog
Last Updated 6th November 2020
  • 8
  • Free
blog
Last Updated 31st August 2020
  • 0
  • 349
  • 999
blog
Last Updated 31st August 2020
  • 0
  • 349
  • 999
blog
Last Updated 31st August 2020
  • 0
  • 349
  • 999

About the Instructor

instructor
About the Instructor

5+ YEARS OF EXPERIENCE

MS-OFFICE 2003/2007/2010/2013/2016/2019 | ADVANCE EXCEL | ADVANCE PRESENTATION MASTERY WITH POWERPOINT | GRAPHICS DESIGNER | WEB DESIGNER | LOGO DESIGNER | FREELANCER | MOTIVATOR | TIME MANAGEMENT | MICROSOFT OFFICE SUITE CONSULTANT | CORAL DRAW MASTERY COURSE | PHOTOSHOP CC MASTERY COURSE | ADOBE ILLUSTRATOR MASTERY | ONLINE TOOLS MASTERY | MINDTREE | HARDWARE & SOFTWARE TROUBLESHOOTING AND MANY MORE……….

 

 

YOU’LL LEARN HOW TO STREAMLINE YOUR EXCEL FOR EFFICIENCY FROM THE BEGINNING. I  TEACH YOU MY STEP-BY-STEP PROCESS, THE ACTUAL METHODS I USE TO BUILD POWERFUL SOLUTIONS EASILY AND QUICKLY. I AM SURE THAT SOME PART CAN BE DIFFICULT, BUT NOT THE WAY I DO IT! WE WILL GO BEYOND THE BASICS AND COVER IN DEPTH THE MISSING BITS.

 

ALWAYS REMEMBER “EVERYTHING IS EASY, ONCE YOU KNOW HOW?”

 

SINCE 2014, WE HAVE BEEN PROVIDING HANDS-ON MICROSOFT EXCEL ONLINE & OFFLINE TRAINING AND OTHER COMPUTER COURSES TRAINING FOR CUSTOMERS LIKE SAIL EMPLOYEES, L&T EMPLOYEES, TATA STEEL EMPLOYEES, ELECTRO STEEL EMPLOYEES JHARKHAND POLICE, CISF/BSF/ARMY JAWANS, SCHOOL STUDENTS, COLLEGE STUDENTS, FACULTIES, BANK EMPLOYEE AND MANY MORE. WE KNOW HOW TO TRAIN YOU AND INTERACT WITH YOU JUST LIKE SITTING IN FRONT OF YOU.