ADVANCED COURSE ON MICROSOFT EXCEL & PPT
Seats Available: 10 only (First come first serve)
Admission Deadline:
Duration:
Class Time:
Course Fees – 6,000/- Tk.
MICROSOFT EXCEL OUTLINE
- Quick Access Toolbar
- Tabs
- Ribbon
- Name Box
- Formula Bar
- Rows, Columns, Cells
- Sheets
- Zoom
- Work book VS Work Sheet
- Cell VS Range
- Simple Data Entry
- Selecting Ranges
- Saving workbook formats
- Find & Replace
- Protection
- Font
- Alignment
- Number
- Sum
- Auto sum
- Shortcut
- Relative Reference
- Absolute Reference
- Mixed Reference
- Concatenate
- TRIM
- PROPER
- UPPER
- LOWER
- Sumif
- Sumifs
- Countif
- Countifs
- AVERAGEIF
- AVERAGEIFS
- Minifs
- Maxifs
- Large
- Small
- Data Validation
- Whole Numbers
- Text Length
- Date
- Drop Down List
- Input Messages
- Error Messages
- Stop
- Warning
- Information
- VLOOKUP
- VLOOKUP ( EM)
- VLOOKUP (AM)
- Quiz
- Vlookup Advanced – 1
- Vlookup Advanced – 2
- Vlookup Advanced – 3
- Match
- Vlookup + Match
- Vlookup + Match Advanced
- Vlookup + Match Advanced 2
- Hlookup + Match Advanced 1
- Nested Vlookup
- Nested Vlookup Advanced
- Index Function
- Index Function 2
- Index Function 3
- Paste Special
- Values
- Values 123 + Number formatting
- Picture
- Picture linked
- Linked source
- Transpose
- Formatting
- Conditional Formatting
- Advanced Conditional
- IF
- If Case
- If and
- If or
- Nested IF
- Filter
- Chart
- Pie
- Bar
- Column
- Line Chart
- Map
- XY Scatter Chart
- Spark Line Chart
- Treemap
- Combo
- Dashboard
- Pivot Table
- Pivot Chart
- Advanced Pivot Table
- Slicer
- Pivot Table Dashboard
MICROSOFT POWERPOINT OUTLINE
- Getting Started with PowerPoint
- Navigate the PowerPoint Environment
- View and Navigate a Presentation
- Create and Save a PowerPoint Presentation
- Developing a PowerPoint Presentation
- Select a Presentation Type
- Edit Text
- Build a Presentation
- Performing Advanced Text Editing Operations
- Format Characters
- Format Paragraphs
- Format Text Boxes
- Adding Graphical Elements to Your Presentation
- Insert Images
- Insert Shapes
- Adding Tables to Your Presentation
- Create a Table
- Format a Table
- Insert a Table from Other Microsoft Office Applications
- Adding Charts to Your Presentation
- Create a Chart
- Format a Chart
- Customized Professional Slides
- Animation customization
- Designing Slides
Registration Process
To register your name inbox us for the following information;
Full Name:
Mobile Number:
E-mail ID:
Batch Number:
bKash Number / Trx ID: