By Muhammad Jahanzaib Khan
Rs. 10000
This course includes
V2 MS Word interface, Font Face and Font Size
V1 Introduction to MS Office
V3 MS Word Font group in Home Tab Complete
V4 MS Word Saving a File and Recover unsaved Files
V5 MS Word Home Tab Paragraph Group
V6 MS Word Clipboard Group
V7 MS Word Home Tab Style Group
V8 MS Word Home Tab Editing Group Final
V9 Rulers indentation page layout (Margin, orientaiton and size) Final
V10 Tab Stops ( Left Right Centre and Decimal Tabs) Final
V11 MS Word Insert Tab (insert Title, Blank Page, Picture, Shape Icon, 3 d Models)
V12 MS Word Insert Tab (Smart Art, Screenshots, Text box, symbols)
V14 Different headers for First, Even and Odd Pages
V16 Tables (Insert Edit Delete And Autofit)
V17 Table Styles And Sorting
V18 Formula In Word Tables And Merging The Table
V19 Ms Word Design Tab (Theme, Design, Watermark, Page Color And Border)
V20 Pagination Options
V21 Layout Tab (Column, Line Number Hyphenation, Drop Cap)
V22 Quick Access Toolbar (With Redo Undo Repeat)
V23 Footnote and Endnote
V24 Customizing The Ribbon
V26 Ms Word File Compatability Mode
V27 Citation and bilbliography
V28 Mail Merge
V30 Review tab track changes Final
V29 Proofing Spelling and grammar check with thesaurus
V31 review tab comments and compare Final
V33 Ms Word Backstage View
V32 Printing A Document
V1 Introduction To Excel Interface And How To Enter Data
V2 Data Entry Types Flash Fill, Auto Complete And Shortcuts
V1 Excel formula, Calculation order, name box, forumula bar
V2 References in a formula, Introduction to functions, AutoSum functions
V3 Relative Vs Absolute References Ex 3.1 to 3.5)
V4 Absolute References with Excercise 3.5 and 3.6
V2 Naming a Range and using in formula
V3 giving names to the ranges collectively and countblank function
V4 Counta and different count functions and their difference
V5 Zero Vs empty cell and the importance of tiny things in excel
V6 Formula Vs Functions, operators, Ampersnad and use
V7 A practical usage of ampersand operator
V6 Rounding Functions (Ceiling, Floor, Int, Mod, round, Trunc)
V8 Exercise 4.3 Budgeting model with 2 variation
V1 Some Functions on Text String(len, trim, upper, proper, lower, left, right and Mid)
V5 Find and concatinate function practice example
V2 Practice 1 of Left Right and mid function with a glimpse of text to column option
V3 Exercise 2 of Text Function (Trim, Len, left, right, mid and concatinate)
V4 Find Search and replace functions
V7 Exercise 4.2 A basic Budgeting model
V7 Fixing date issues in data imported from external sources Type 1 Data done
V2 Basic Functions for Date and time (today,now, year, month, day, date, Hour, Minute, Second
V5 Working days and enlisting these days ( days, networkdays, networkdays.intl , workday, wor
V3 Adding or subtracting datetime from a datetime Exercise 1
V1 Entring date and time in Excel, how Excel handles date and time and changing format of inp
V4 Adding or subtracting datetime from a datetime Exercise 2 and introduction to nested form
V8 Fixing date issues in data imported from external sources Type 2 Data (done)
V6 Working days and enlisting these days Exercise
V1 Formula auditing( show formula, trace precedents and dependents, remove arrows etc)
V2 Evaluate formula and calculation options
V3 Various errors in excle and how to solve them ( ####### , # Div0! #NAME #VALUE!, #REF!, #
V4 Name manager defining and using names of ranges in excel
V2 Concept interpretation and syntax of IRR
V1 Concept, Interpretation and syntax of NPV function
V1 V Lookup Function basics with naming cells and range
V2 Hlookup and keyboard selection tools
V3 Ture and false arguments of vlookup function
V1 introduction to conditional functions(condition operations)
V2 iserr, iserror isna isref islogical and complex logic operations (and, or, not)
V01 Your first If function and how it works
V02 applying IF function Practice 2 and intorduction to nested IF function practice 1
V03 Nested IF function complex example 2
V1 Conidtional Counts (Count, Counta, Countblank, countif and Countifs)
V2 Count, Countif, sum, sum if with complex condition and data dropdowns
V3 Recall practice of dropdowns, sumifs & reletive absolute references
V1 Pivot table part 1 basics, applying pivot making diffrent reports using row colum and values
V2 Pivot Table part 2 using filters and Variation in Value field setting
V3 Pivot Table part 3 using slicers and Timeline in data filter
V1 Pivot Charts Intorduction and Chart options
V2 Pivot Charts with slicers and timelines
V3 Multiple pivot charts and Excel Dashboard
V4 Editing and linking more components in Dashboard
Video 1 Power BI a brief introduction adding data and AI driven charts
Video 2 Adding Visual cards, Multi row cards with permanent Filter, Tables and text boxes with varia
Video 3 Ordering and presenting visual and charts to make a dashboard in BI
V1 Data selection shortcuts and basic single level sorting
V2 Custom sort lists sorting on basis of Cell colour and font colour
V3 Multiple level sorting(adding levels, Deleting levels and moving levels up and down)
V4 Filters and Multiple filters
V5 Subtotal Function with filters with criteria
V6 Filters relating to date (and pivot table for dates)
Video 1 Conditional Formatting Basics and multiple conditions
Video 2 Conditional formatting text based and top bottom rules
Video 3 Conditional Formatting on dates setting condition on the basis of another cell
Video 4 Finding Duplicate data, rand & randbetween, round to 100s and pivot table recap
Video 5 Databars, colour scales and icon sets
Video 6 Function based conditions (single and multiple)
Video 7 Goal Seek and some presentation techniques
V1 Subtotal Functionality
V2 Group and ungroup function
V1 Formula Auditing ( trace precedents,dependents,show formula, evaluate formula)
Video 2 Macros (an introduction)
Video 1 Text to column
Video 2 Remove Duplicates
Video 3 Data Validation
V1 Protection of Workbook(Mark as Final and Encrypt with password)
V2 Protection of Workbook (Protect current sheet and protect workbook structure)
V1 Sheet Views and zooming the screen
V2 page break preview and print dialog box
V3 windows, Screen splits, Freeze Pane, Workbook windows
Video 1 Google Sheets Basics and how to work on it
Video 1 Powerpoint interface, mode and methods
Video 2 Insterting images, objects ordering, arragement and grouping
Video 3 Slide Design (size background and Themes)
Video 4 Slide presentation(From begning, from current slide, and slideshow views)
Video 7 Animations advance
Video 6 Animations basics
Video 5 Transition and its variation
This course is offered in collaboration with approved RAET School of Business Intelligence (SBI). All Activities of the course including the progress tracking, assessments, final mocks and certificate issuance is managed by SBI. In case of any confusion students can contact SBI Liaison officer for Hands on Courses at following number via whatsapp 0311-4691849
Why choose this course
What you'll learn
1,298+ students are Recommending this Course