وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Microsoft Excel – Sweet and Short

سرفصل های دوره

Excel Mastery Made Simple: Unleashing Efficiency in Every Cell


1. Excel Essentials
  • 1.1 Double click to open.xlsx
  • 1. Opening a Workbook
  • 2.1 Saving workbooks.xlsx
  • 2. Saving a workbook
  • 3. Managing the Backstage View
  • 4.1 Comma Separated Values.csv
  • 4. Familiarity with file formats
  • 5.1 Comprehensive knowledge of the ribbon tabs.xlsx
  • 5. Comprehensive knowledge of the ribbon tabs
  • 6.1 Customize the Quick Access Tool Bar.xlsx
  • 6. Customize the Quick Access Tool Bar
  • 7.1 Excel Interface Overview.xlsx
  • 7. Excel Interface Overview
  • 8.1 Data Entry and Editing Techniques.xlsx
  • 8. Data entry and editing techniques
  • 9.1 Data Autofill.xlsx
  • 9. Data Autofill
  • 10.1 Working with Dates & Times.xlsx
  • 10. Working with Dates & Times
  • 11.1 adding comments2.zip
  • 11. Adding notes and comments
  • 12.1 simple formulas (totals and averages).zip
  • 12. Simple Formulas (Totals & Averages)
  • 13.1 Formatting Rows & Columns - Worksheet.xlsx
  • 13. Formatting Rows & Columns
  • 14.1 Inserting pictures and shapes into Excel.xlsx
  • 14.2 your logo.zip
  • 14. Inserting pictures and shapes into Excel
  • 15.1 Working with Themes.xlsx
  • 15. Working with Themes
  • 16.1 Freeze Panes.xlsx
  • 16. Freeze Panes
  • 17.1 Getting your sheet ready for printing.xlsx
  • 17. Getting your sheet ready for printing
  • 18.1 Page break preview.xlsx
  • 18. Page break preview
  • 19.1 Spell Checker.docx
  • 19.2 Spell Checker.xlsx
  • 19. Spell checker
  • 20.1 Clear All Button.xlsx
  • 20. Clear all Button
  • 21.1 Find and Replace.xlsx
  • 21. Find and Replace
  • 22.1 Merge Cells.xlsx
  • 22. Merge Cells
  • 23.1 Microsoft Template.xlsx
  • 23. Microsoft Templates
  • 24. Excel Essential Quiz.html

  • 2. Working with tables
  • 1.1 Why use a table.xlsx
  • 1. Why use a table
  • 2.1 The components of a table.xlsx
  • 2. The components of a table
  • 3.1 Formatting of a table.xlsx
  • 3. Formatting of a Table
  • 4.1 Using Autofilter.xlsx
  • 4. Using autofilter
  • 5.1 Slicers with Tables.xlsx
  • 5. Slicers with tables
  • 6.1 Advanced Sorting.xlsx
  • 6. Advanced Sorting
  • 7.1 Calculating totals on a table.xlsx
  • 7. Calculating totals on a table
  • 8.1 Referencing within a table.xlsx
  • 8. Referencing within a table
  • 9. Working with Tables - Quiz.html

  • 3. Formatting
  • 1.1 What data really looks like.xlsx
  • 1. What data really looks like
  • 2.1 Applying formatting to a cell.xlsx
  • 2. Applying formatting to a cell
  • 3.1 Text vs Numerical Data.xlsx
  • 3. Text vs Numerical Data
  • 4.1 Formatting Dates.xlsx
  • 4. Formatting Dates
  • 5.1 Working with Currencies.xlsx
  • 5. Working with Currencies
  • 6.1 Formatting Percentages.xlsx
  • 6. Formatting Percentages
  • 7.1 Format Painter.xlsx
  • 7. Format Painter
  • 8.1 Conditional Formatting with a formula.xlsx
  • 8. Conditional Formatting with a formula
  • 9.1 Insert a screenshot - destination.xlsx
  • 9.2 Insert a screenshot.xlsx
  • 9. Insert a screenshot
  • 10.1 Insert a shape of any type.xlsx
  • 10. Insert a shape of any type
  • 11.1 SmartArt.xlsx
  • 11. Advanced Manipulation of SmartArt
  • 12.1 Insert Symbols and Equations.xlsx
  • 12. Insert symbols and equations
  • 13.1 Formatting a graphic object.xlsx
  • 13. Formatting a graphic object
  • 14.1 Change the shape of a graphic object.xlsx
  • 14. Change the shape of a graphic object
  • 15.1 Selection pane.xlsx
  • 15. Selection pane
  • 16.1 Object Arrangement.xlsx
  • 16. Object Arrangement
  • 17.1 Perform multi-criteria sorts.xlsx
  • 17. Perform multi-criteria sorts and customized sorts
  • 18.1 Inputting in multiple cells.xlsx
  • 18. Inputting in multiple cells
  • 19.1 Advanced knowledge of custom lists.xlsx
  • 19. Advanced knowledge of custom lists
  • 20.1 Advanced knowledge of Hypertext links.xlsx
  • 20.2 How to link an external document into your excel sheet.pdf
  • 20.3 Word document.docx
  • 20. Advanced knowledge of Hypertext links
  • 21.1 create and edit a form.zip
  • 21. Create and edit a form - Part 1
  • 22.1 create and edit a form.zip
  • 22. Create and edit a form - Part 2
  • 23. Formatting Quiz.html

  • 4. Core Functions
  • 1.1 Equals and Targeting cells.xlsx
  • 1. Equals and Targeting cells
  • 2.1 Functions vs Formulas.xlsx
  • 2. Functions vs Formulas
  • 3.1 Adding, subtracting, Multiplication and Division.xlsx
  • 3. Adding, subtracting, multiplication and division
  • 4.1 Components of a Function.xlsx
  • 4. Components of a Function
  • 5.1 Sum and Average Function.xlsx
  • 5. Sum and Average Function
  • 6.1 More than one function in a cell.xlsx
  • 6. More than one function in a cell
  • 7.1 Absolute references.xlsx
  • 7. Absolute References ($ signs)
  • 8.1 Look for and help with Functions.xlsx
  • 8. Look for - Help with Functions
  • 9.1 COUNT Function.xlsx
  • 9. COUNT Function
  • 10.1 ROUND, ROUNDUP and ROUNDDOWN Functions.xlsx
  • 10. ROUND, ROUNDUP and ROUNDDOWN Functions
  • 11.1 LEFT and RIGHT Functions.xlsx
  • 11. LEFT and RIGHT functions
  • 12.1 MID Function.xlsx
  • 12. MID function
  • 13.1 Errors in Functions.xlsx
  • 13. Errors in Functions
  • 14.1 Concatenate Function.xlsx
  • 14. CONCATENATE Function
  • 15.1 UPPER, LOWER and PROPER Functions.xlsx
  • 15. UPPER, LOWER and PROPER Functions
  • 16. Core Functions - Quiz.html

  • 5. VLOOKUPS
  • 1.1 What you can do with a VLOOKUP.xlsx
  • 1. What you can do with a VLOOKUP
  • 2.1 The correct dataset structure.xlsx
  • 2. The correct dataset structure
  • 3.1 Doing a VLOOKUP.xlsx
  • 3. Doing a VLOOKUP
  • 4.1 Common problems with a VLOOKUP.xlsx
  • 4. Common problems with VLOOKUP
  • 5.1 Exact or Approximate match.xlsx
  • 5. Exact or Approximate match
  • 6.1 Comparing two sheets with a VLOOKUP.xlsx
  • 6. Comparing two sheets with a VLOOKUP
  • 7.1 Matching on more than one criteria.xlsx
  • 7. Matching on more than one criteria
  • 8.1 HLOOKUP Function.xlsx
  • 8. HLOOKUP function
  • 9.1 Error handling - IFERROR function.xlsx
  • 9. Error Handling - IFERROR function
  • 10. VLOOKUP - Quiz.html
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 19173
    حجم: 1065 مگابایت
    مدت زمان: 136 دقیقه
    تاریخ انتشار: 20 شهریور 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید