course details
অ্যাডভান্স এক্সেল
Course Description
MS Excel প্রতিদিনের কাজে ব্যবহৃত একটি গুরুত্বপূর্ণ এপ্লিকেশন। বিশ্বে এমন কোন কম্পিউটার নেই মাইক্রোসফট এক্সেল Install করা হয়নি! বিশ্বব্যাপী ৭৫০ মিলিয়নেরও বেশি মানুষ তাদের প্রতিদিনের Data Presentation ও Analysis সহ বিভিন্ন কাজে MS Excel ব্যবহার করে। শিক্ষার্থী কিংবা চাকরিজীবী সবার জন্যই MS Excel একটি অতি প্রয়োজনীয় এপ্লিকেশন সফটওয়্যার। যেকোনো প্রতিষ্ঠানের মূলধন, খরচ, মুনাফা, উৎপাদন, বিতরণ, বেতন-ভাতা, এমপ্লয়ী সংখ্যা সব কিছুর হিসাব MS Excel এ খুব সহজে জমা রাখা যায়। এই এপ্লিকেশনটি এতটাই প্রয়োজনীয় যে, বর্তমানে প্রায় প্রতিটি জব সার্কুলারে Microsoft Excel এ দক্ষতা চাওয়া হয়। এপ্লিকেশনটির একটি বিশেষ সুবিধা হলো- ম্যাথমেটিক্স প্লাগ, অটোমেটিক এবং নির্ভুলভাবে যেটা যোগ-বিয়োগ করে দেয়। এই সফটওয়্যারটির মাধ্যমে যেকোনো জটিল হিসাব-নিকাশের কাজ খুব সহজে গুছিয়ে করা সম্ভব।
Lessons
Setting Excel Options
Understanding Excel Options
Setting Excel Options
Setting Excel Options
Personalising Excel
Setting Excel Options
Setting the Default Font
Setting Excel Options
Setting Formula Options
Setting Excel Options
Understanding Save Options
Setting Excel Options
Setting Save Options
Setting Excel Options
Setting the Default File Location
Setting Excel Options
Setting Advanced Options
Importing and Exporting
Understanding Data Importing
Importing and Exporting
Importing From an Earlier Version
Importing and Exporting
Understanding Text File Formats
Importing and Exporting
Importing Tab Delimited Text
Importing and Exporting
Importing Comma Delimited Text
Importing and Exporting
Importing Space Delimited Text
Importing and Exporting
Importing Access Data
Importing and Exporting
Working With Connected Data
Importing and Exporting
Unlinking Connections
Data Linking
Understanding Data Linking
Data Linking
Linking Between Worksheets
Data Linking
Linking Between Workbooks
Data Linking
Updating Links Between Workbooks
Grouping and Outlining
Understanding Grouping and Outlining
Grouping and Outlining
Creating an Automatic Outline
Grouping and Outlining
Working With an Outline
Grouping and Outlining
Creating a Manual Group
Grouping and Outlining
Grouping by Columns
Summarising and Subtotalling
Creating Subtotals
Summarising and Subtotalling
Using a Subtotalled Worksheet
Summarising and Subtotalling
Creating Nested Subtotals
Summarising and Subtotalling
Copying Subtotals
Summarising and Subtotalling
Using Subtotals With AutoFilter
Summarising and Subtotalling
Creating Relative Names for Subtotals
Summarising and Subtotalling
Using Relative Names for Subtotals
Lookup Functions
Understanding Data Lookup Functions
Lookup Functions
Using INDEX
Lookup Functions
Using Match
Lookup Functions
Using INDIRECT
Lookup Functions
Using XLookup
Data Consolidation
Understanding Data Consolidation
Data Consolidation
Consolidating With Identical layouts
Data Consolidation
Creating a Linked Consolidation
Data Consolidation
Consolidating From Different Layouts
Data Consolidation
Consolidating Data Using the SUM Function
Data Tables
Understanding Data Tables and What-If Models
Data Tables
Using a Simple What-If Model
Data Tables
Creating a One-Variable Table
Data Tables
Using One-Variable Data Tables
Data Tables
Creating a Two-Variable Data Table
Scenarios
Understanding Scenarios
Scenarios
Creating a Default Scenario
Scenarios
Creating Scenarios
Scenarios
Using Names in Scenarios
Scenarios
Displaying Scenarios
Scenarios
Creating a Scenario Summary Report
Scenarios
Merging Scenarios
PivotTable Features
Understanding Slicers
PivotTable Features
Creating Slicers
PivotTable Features
Inserting a Timeline Filter
PivotTable Features
Using Compound Fields
PivotTable Features
Counting in a PivotTable
PivotTable Features
Formatting PivotTable Values
PivotTable Features
Working With PivotTable Grand Totals
PivotTable Features
Working With PivotTable Subtotals
PivotTable Features
Finding the Percentage of Total
PivotTable Features
Finding the Difference From
PivotTable Features
Grouping in PivotTable Reports
PivotTable Features
Creating Running Totals
PivotTable Features
Creating Calculated Fields
PivotTable Features
Providing Custom Names
PivotTable Features
Creating Calculated Items
PivotTable Features
PivotTable Options
PivotTable Features
Sorting in a PivotTable
PivotCharts
Inserting a PivotChart
PivotCharts
Defining the PivotChart Structure
PivotCharts
Changing the PivotChart Type
PivotCharts
Using the PivotChart Filter Field Buttons
PivotCharts
Moving PivotCharts to Chart Sheets
Validating Data
Understanding Data Validation
Validating Data
Creating a Number Range Validation
Validating Data
Testing a Validation
Validating Data
Creating an Input Message
Validating Data
Creating an Error Message
Validating Data
Creating a Drop Down List
Validating Data
Using Formulas as Validation Criteria
Validating Data
Circling Invalid Data
Validating Data
Removing Invalid Circles
Validating Data
Copying Validation Settings
Practical Class
A-Z
Practical Class
A-Z
Practical Class
A-Z
Practical Class
A-Z
Controls
Understanding Types of Controls
Controls
Understanding How Controls Work
Controls
Preparing a Worksheet for Controls
Controls
Adding a Combo Box Control
Controls
Changing Control Properties
Controls
Using the Cell Link to Display the Selection
Controls
Adding a List Box Control
Controls
Adding a Scroll Bar Control
Controls
Adding a Spin Button Control
Controls
Adding Option Button Controls
Controls
Adding a Group Box Control
Controls
Adding a Check Box Control
Controls
Protecting a Worksheet With Controls
Recorded Macros
Understanding Excel Macros
Recorded Macros
Setting Macro Security
Recorded Macros
Saving a Document as Macro Enabled
Recorded Macros
Recording a Simple Macro
Recorded Macros
Running a Recorded Macro
Recorded Macros
Relative Cell References
Recorded Macros
Running a Macro With Relative References
Recorded Macros
Viewing a Macro
Recorded Macros
Editing a Macro
Recorded Macros
Assigning a Macro to the Toolbar
Recorded Macros
Running a Macro from the Toolbar
Recorded Macros
Assigning a Macro to the Ribbon
Recorded Macros
Assigning a Keyboard Shortcut to a Macro
Recorded Macros
Deleting a Macro
Recorded Macros
Copying a Macro
Leave a Review
Student Reviews
No reviews yet for this course.