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

Excel: Core Data Analysis, and Workbook Customization

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

Customizing the User Interface, Functions, Custom Formatting, Data Validation, PivotTables, Charts, Macros, Printing , +


1 - Latest Excel Time Savers Quick Tip
  • 1 - Quick Keys Selecting Columns Rows.html

  • 2 - Welcome to Excel Core Data Analysis and Workbook Customization
  • 2 - So many questions
  • 3 - Excel-Exercise-Files.zip
  • 3 - The Exercise Files.html

  • 3 - Excel Navigation Workbook Environment Worksheet Skills
  • 4 - Customizing the Ribbon
  • 5 - Customizing the Quick Access Toolbar
  • 6 - SelectingCellsand-Ranges.xlsx
  • 6 - Selecting Cells Ranges
  • 7 - MovingandCopyingCells.xlsx
  • 7 - Moving Copying Cells
  • 8 - CopyingMultipleItems.xlsx
  • 8 - Copying Multiple Items to Office Clipboard
  • 9 - QuicklyNavigate.xlsx
  • 9 - Quickly Navigate to Worksheets
  • 10 - Formatting-No-Macros.xlsx
  • 10 - Named Ranges for Navigation
  • 11 - Fill Series Quickly Copy Formulas Text and Create Series Patterns
  • 13 - Make Sure Your Headings Stay Put with Freeze Panes
  • 13 - Shipping.xlsx
  • 14 - Formatting-No-Macros.xlsx
  • 14 - Splitting Data Into Multiple Columns
  • 15 - Formatting-No-Macros.xlsx
  • 15 - Track Accept and Reject Changes Made to Your Workbooks
  • 16 - Formatting-No-Macros.xlsx
  • 16 - Grouping Worksheets to Quickly Add Data
  • 17 - Copying and Renaming a Worksheet
  • 17 - Shipping.xlsx
  • 18 - Changing a Worksheet Tab Color to Help You Organize Your Workbook
  • 18 - Formatting-No-Macros.xlsx
  • 19 - Entering the Current Date and Time
  • 22 - Useful Keyboard Shortcuts ALT keys KeyTips
  • 23 - AutoCorrect Its More Than Just For Misspelled Words
  • 24 - Creating Forms Using the Form Command
  • 24 - Shipping.xlsx
  • 25 - CameraTool.xlsx
  • 25 - The Camera Tool Take a Picture of the Data You Need to Track
  • 26 - Changing the Shapes of Comments Make Your Notes Stand Out
  • 26 - Shipping.xlsx

  • 4 - Useful Tips on Excel Formulas Functions
  • 27 - 3D Formulas Calculate Across Multiple Worksheets
  • 27 - Formulas.xlsx
  • 28 - Absolute Reference Why You Absolutely Need to Know It
  • 29 - Named Ranges in Formulas
  • 30 - SumIf Sum Your Data Only If It Meets a Condition
  • 31 - SumIfs Sum Your Data If It Meets Multiple Conditions
  • 32 - DSum Sum Your Data with a Database Dashboard
  • 33 - VLookup Learn the Lookup Everyone Is Talking About
  • 34 - IfError
  • 35 - Left Right Mid Use Information From Just Certain Parts of Strings
  • 36 - Find Quickly Locate Characters
  • 37 - Rank Find the Ranked Values of Your Data
  • 38 - Showing and Printing Formulas

  • 5 - Using Data Validation for Data Entry in Excel
  • 39 - Creating DropDown Lists
  • 40 - Dependent DropDown Lists
  • 41 - Character Limits for Cells
  • 42 - Creating Custom Input Messages and Error Alerts

  • 6 - Special Custom and Conditional Formatting in Excel
  • 44 - Special Number Formats Phone Numbers Social Security Numbers and Zip Codes
  • 45 - Custom Number Formatting Explained
  • 46 - Custom Number Formatting Examples
  • 46 - Number-Formatting.pdf
  • 48 - Conditional Formatting
  • 48 - Formatting.xlsx
  • 49 - Conditional Formatting with Quick Analysis
  • 49 - Formatting.xlsx
  • 50 - Conditional Formatting to Just Show Icons or Bars
  • 50 - Formatting.xlsx
  • 51 - Find Replace with Formatting
  • 51 - Formatting.xlsx

  • 7 - Excel Tables Lists
  • 52 - Creating Tables
  • 52 - Shipping.xlsx
  • 53 - Shipping.xlsx
  • 53 - Slicers The UserFriendly Way to Filter Your Tables
  • 54 - Shipping.xlsx
  • 54 - Sorting by Custom Lists
  • 55 - TransposingData.xlsx
  • 55 - Transposing Data
  • 56 - Quickly Create Subtotals for Your Lists
  • 56 - Subtotals.xlsx

  • 8 - Excel Charts
  • 57 - Keyboard Shortcut Quick Analysis
  • 57 - Shortcutsand-QuickAnalysis.xlsx
  • 58 - QuickFormatting.xlsx
  • 58 - Quick Formatting
  • 59 - Exploding Pie Charts
  • 59 - QuickFormatting.xlsx
  • 60 - Sparklines.xlsx
  • 60 - Sparklines Single Cell Charts
  • 61 - CombinationChart.xlsx
  • 61 - Combination Charts Secondary Axis
  • 61 - creating-secondary-axis-in-excel-2010.zip
  • 62 - Copy a Chart to Word or PowerPoint
  • 62 - QuickFormatting.xlsx

  • 9 - Excel PivotTables PivotCharts
  • 63 - PivotTables PivotCharts Overview
  • 63 - Shipping.xlsx
  • 64 - Creating PivotTables
  • 64 - Shipping.xlsx
  • 65 - Creating PivotCharts
  • 65 - Pivot-Chart.xlsx
  • 66 - Slicers
  • 66 - Slicers.xlsx
  • 67 - Timelines.xlsx
  • 67 - Timelines Dashboard Filters for Your Date Field

  • 10 - Printing Excel Data
  • 68 - Print Titles Repeat Headings on Each Page
  • 68 - Shipping.xlsx
  • 69 - Formatting.xlsx
  • 69 - Setting a Print Area
  • 70 - Fitting Everything On One Page
  • 70 - QuickFormatting.xlsx
  • 71 - PageBreaks.xlsx
  • 71 - Page Breaks
  • 72 - HidingErrors.xlsx
  • 72 - Hiding Errors
  • 73 - Watermarks

  • 11 - Protecting Excel Files
  • 74 - ProtectingCells.xlsx
  • 74 - Protecting Formula and Function Cells
  • 75 - Allowing Users to Edit Only Portions of the Spreadsheet
  • 75 - ProtectingCells.xlsx
  • 76 - Protect a Workbooks Structure
  • 77 - Password Protecting a Workbook

  • 12 - Excel Macros
  • 78 - Creating a macro
  • 78 - RecordMacro.xlsx
  • 79 - Assigning the macro to a button
  • 79 - RecordMacro.xlsx
  • 80 - Assigning the Macro to the Quick Access Toolbar
  • 80 - RecordMacro.xlsx
  • 81 - Formatting-No-Macros.xlsx
  • 81 - Macro Example Creating Buttons to Navigate Between Worksheets
  • 82 - Formatting-No-Macros.xlsx
  • 82 - Simple Macro Maintenance

  • 13 - Wrap Up
  • 83 - Thank you
  • 85 - Excel 2013 Quick Start Guide.html
  • 86 - Excel 2016 Quick Start Guide UPDATED.html

  • 14 - Course Coupons
  • 87 - BONUS LECTURE How to Save Money While You Learn.html
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 7193
    حجم: 2735 مگابایت
    مدت زمان: 271 دقیقه
    تاریخ انتشار: 9 اسفند 1401
    طراحی سایت و خدمات سئو

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