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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

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

    139,000 تومان
    افزودن به سبد خرید