Microsoft Excel 2007 Essential Training

erobcMeLIgeday hn elakGñkGacTajykÉksarTaMgGs;edayesrI BICnCatiExµr

Chapter 01 | Getting Started | Lesson 01 | (Why use a spreadsheet?)

Chapter 01 | Getting Started | Lesson 02 | (What's changed in Excel 2007?)

| Chapter 01 | Getting Started | Lesson 03 | (The Ribbon) |

| Chapter 01 | Getting Started | Lesson 04 | (The Microsoft Office Button) |

| Chapter 02 | Setting up Excel 2007 | Lesson 01 | (What's on the Ribbon?) |

| Chapter 02 | Setting up Excel 2007 | Lesson 02 | (Making your way around the Ribbon) |

| Chapter 02 | Setting up Excel 2007 | Lesson 03 | (Customizing the Ribbon) |

| Chapter 02 | Setting up Excel 2007 | Lesson 04 | (Customizing the Microsoft Office Butto

n) |

| Chapter 03 | Modifying Worksheets | Lesson 01 | (Opening old worksheets) |

| Chapter 03 | Modifying Worksheets | Lesson 02 | (Adding and deleting worksheets) |by Ammar873

| Chapter 03 | Modifying Worksheets | Lesson 03 | (Inserting and deleting cells) |

Chapter 03 | Modifying Worksheets | Lesson 04 | (Freezing areas of a worksheet)

Chapter 04 | Basic Formatting | Lesson 01 | (Width and height) |

| Chapter 04 | Basic Formatting | Lesson 02 | (Numeric formats) |

| Chapter 04 | Basic Formatting | Lesson 06 | (Formatting as a table) |by Ammar873

| Chapter 04 | Basic Formatting | Lesson 04 | (Playing with Fonts) |by Ammar873

Chapter 04 | Basic Formatting | Lesson 05 | (AutoFilter) |by Ammar873

Chapter 04 | Basic Formatting | Lesson 06 | (Formatting as a table) |by Ammar873

| Chapter 05 | Advanced Formatting | Lesson 01 | (Removing Duplicates) |by Ammar873

| Chapter 05 | Advanced Formatting | Lesson 02 | (What is Conditional Formatting?) |by Ammar873

| Chapter 05 | Advanced Formatting | Lesson 03 | (Working with Conditional Formatting) |by Ammar873

| Chapter 05 | Advanced Formatting | Lesson 04 | (Managing Conditional Formatting) |

| Chapter 05 | Advanced Formatting | Lesson 05 | (Converting text to columns) |by Ammar873

 

| Chapter 05 | Advanced Formatting | Lesson 06 | (Data Validation) |by Ammar873

| Chapter 06 | Using Templates, Styles and AutoFormat | Lesson 01 | (Templates) |by Ammar873

| Chapter 06 | Using Templates, Styles and AutoFormat | Lesson 02 | (Styles) |by Ammar873

| Chapter 06 | Using Templates, Styles and AutoFormat | Lesson 03 | (AutoFormat) |by Ammar873

| Chapter 07 | Managing Lists in Excel | Lesson 01 | (List and Tables) |by Ammar873

| Chapter 08 | Reviewing Worksheets | Lesson 01 | (Proofing your Work) |by Ammar873

| Chapter 08 | Reviewing Worksheets | Lesson 02 | (Providing Comments) |

| Chapter 09 | Sharing Worksheets | Lesson 01 | (Protecting and Sharing Worksheets) |

| Chapter 09 | Sharing Worksheets | Lesson 02 | (Allowing others to edit ranges) |by Ammar873

| Chapter 09 | Sharing Worksheets | Lesson 03 | (Track Changes) |

| Chapter 10 | Printing Workbooks | Lesson 01 | (Preparing to Print) |

| Chapter 10 | Printing Workbooks | Lesson 02 | (Print Preview) |

Chapter 10 | Printing Workbooks | Lesson 03 | (Page Layout Tab) |

| Chapter 10 | Printing Workbooks | Lesson 04 | (Page Breaks) |by Ammar873

 

| Chapter 10 | Printing Workbooks | Lesson 05 | (Page Layout View) |by Ammar873

 

 

| Chapter 10 | Printing Workbooks | Lesson 01 | (Headers and Footers) |by Ammar873

 

| Chapter 11 | Enhancing Worksheets | Lesson 01 | (Adding Themes) |by Ammar873

 

| Chapter 11 | Enhancing Worksheets | Lesson 02 | (Page Setup Options) |by Ammar873

 

| Chapter 11 | Enhancing Worksheets | Lesson 03 | (Scale to Fit) |

 

| Chapter 11 | Enhancing Worksheets | Lesson 04 | (Worksheets Options) |

 

| Chapter 11 | Enhancing Worksheets | Lesson 05 | (Inserting Images) |

 

| Chapter 12 | Using Templates | Lesson 01 | (Using Templates) |

13 01 Workbook Views

 

13 02 Hiding and Zooming

13 03 Window Panes

 

13 04 More Screen Option

 

14 01 Import Access

 

 

14 02 Import Text 

15 01 Find and Select

 

15 02 Find and Replace

15 03 Removing Duplicate

16 01 What are Formulas

16 02 Order Operations

16 03 Relative Absolute

16 04 Formula Tab

17 01 What are functions

17 02 Adding by Ammar873

17 03 Min by Ammar873

17 04 Trimby Ammar873 

17 05 Leftby Ammar873

18 01 Concatby Ammar873

18 02 SumIf

18 03 VLookup

18 04 What Ifby Ammar873

19 01 Why Chartsby Ammar873

19 02 Creating Chart by Ammar873

19 04 Chart Layoutby Ammar873

20 01 Why Pivot Tablesby Ammar873

20 02 Creating Pivot Tabby Ammar873

20 03 Pivot Table Layoutby Ammar873

20 04 Pivot Table Design by Ammar873

20 05 Pivot Chartsby Ammar873

 

21 01 Why Macrosby Ammar873

21 02 Record Macrosby Ammar873

21 03 Macro Security by Ammar873

| Chapter 22 | Workflow in Excel 2007 | Lesson 01 | (Reviewing a Workflow in Excel) |by Ammar873

សូមលោកអ្នកទាញយកវីដេអូទាំងអស់នេះដោយសេរី

ដកស្រង់ចេញពី​​      youtube   នឹងរៀបចំដោយឡើងដោយហន

បង្រៀនដោយ​   Ammar873