~Get Your Files Here !

  01 - Introduction

   001 Introduction_en.srt

  02 - Microsoft soft excel fundamental

   001 Start of Microsoft excel_en.srt

   002 Customizing the Excel Quick Access Toolbar_en.srt

   003 Explain of excel ribbons_en.srt

   004 Saving an Excel Document_en.srt

   005 Opening an Existing Excel Document_en.srt

   006 100 Excel shortcuts & it's smart usage to reduce work time_en.srt

  03 - Excel working and basic of formulas

   001 Entering Text to Create Spreadsheet Titles & entering the data to spread sheet_en.srt

   002 Entering and formatting of numeric data in excel_en.srt

   003 Entering Date values & different formatting in Excel_en.srt

   004 Working with Cell References_en.srt

   005 Basic Formulas in Excel_en.srt

   006 What is PEMDAS_en.srt

   007 Relative versus Absolute Cell References in Formulas_en.srt

  04 - How does Function works

   001 SUM() & different types of Sum() Function working_en.srt

   002 MIN() , MAX() , Small(), Large() Functions working_en.srt

   003 Rand() function working_en.srt

   004 AVERAGE() Function Working_en.srt

   005 Sumproduct() function working & it’s uses_en.srt

  05 - Inserting imagesPicture , Shapes & Smartart

   001 Inserting Images_en.srt

   002 Inserting & Formatting Excel Shapes_en.srt

   003 How to work with Smartart_en.srt

  06 - How to modify Worksheets

   001 Copying & multiple Paste options for Data_en.srt

   002 Inserting and Deleting Rows and Columns_en.srt

   003 Copy & pasting Rows and Columns with Data_en.srt

   004 Changing the Width and Height of Cells_en.srt

   005 Hiding and Unhiding Rows and Columns_en.srt

   006 Aligning and merging of content of cells_en.srt

  07 - Excel Formatting & Formatting options

   001 How change font & Background of a cell_en.srt

   002 Border a table_en.srt

   003 Changing the format of cell as Currency, Number or percentage_en.srt

   004 Excel's Format Painter_en.srt

   005 Using Conditional Formatting_en.srt

  08 - Working with charts in excel

   001 Creating an Excel Column Chart_en.srt

   002 Working more in Column chart_en.srt

   003 Adding and Modifying Data on an Excel Chart_en.srt

   004 Working with Excel Pie Charts_en.srt

   005 Working with Line charts_en.srt

   006 Working with combination of chart in 1 chart_en.srt

  09 - Printing an excel worksheet

   001 Viewing your Document in Print Preview_en.srt

   002 Margins, Scaling & many customization option_en.srt

   003 Adding Header and Footer Content_en.srt

  10 - Filtering & Sorting

   001 Apply & remove Filter a data & time saving short cuts_en.srt

   002 Color filtering & multiple select filter_en.srt

   003 Logical & custom Filtering_en.srt

   004 Sorting a data & Time saving short cuts_en.srt

  11 - Additional content

   001 Using of Power Full IF statement_en.srt

  Bonus Resources.txt