دسته بندی

در حال حاضر محصولی در سبد خرید شما وجود ندارد.

پنل کاربری

رمز خود را فراموش کرده اید؟ اگر اولین بار است از سایت جدید استفاده میکنید باید پسورد خود را ریست نمایید.

دوره هفتگی نکات و ترفندهای Excel

دانلود lynda Excel Tips Weekly

14,900 تومان
بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
افزودن به سبد خرید
خرید دانلودی فوری

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

ویدئو معرفی این محصول

با مشاهده این کورس آموزشی از طریق انجام پروژه های واقعی و به زبانی بسیار ساده مطالب فراوانی را در رابطه با اکسل یاد می گیرید.

عنوان اصلی : Excel Tips Weekly

این مجموعه آموزش ویدیویی محصول موسسه آموزشی lynda است که بر روی 2 حلقه دیسک به همراه فایلهای تمرینی ارائه شده و به مدت زمان 32 ساعت و 33 دقیقه در اختیار علاقه مندان قرار می گیرد.

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش آشنا می شویم :


Excel Tips - New This Week:
Fonts such as Arial and Calibri and a rundown of various available fonts in Excel

Previous Episodes:
Hide and unhide worksheets securely
Resizing, moving, copying, and manipulating charts and other objects
Using list boxes and combo boxes to facilitate forms creation
Using the FORMULATEXT and N functions for worksheet and formula documentation
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells
Summarizing data from diverse ranges with Data > Consolidate
Using check boxes and conditional formatting together for dynamic displays
Becoming more productive with these 10 tiny tips you'll use often
Transposing data and charts for a different perspective on your data
Applying conditional formatting across rows of data
Exploring various layouts for your PivotTable
Splitting and consolidating workbooks
Using date and time as metrics in a PivotTable
Adding illustrations to your workbook
Using a pick list, VLOOKUP, table, and chart together
Using formulas to calculate values across worksheets and workbooks
Dynamically presenting data via chart slicers
Parsing your data to create unique lists
Using the REPT function to represent data visually
Using source data from a table to make your PivotTable more dynamic
Accelerating Cut, Copy, Paste, and Insert tasks
Increasing your productivity with custom lists
Highlighting PivotTable results with conditional formatting
Customizing templates to fit your unique needs
Creating dynamic charts with in-cell conditional formatting
Enhancing table filtering with slicers
Converting charts into pictures
Custom grouping in PivotTables
Quick formatting tips
The top five unknown but useful keyboard shortcuts
Using the TREND and GROWTH functions for projecting future results
Using scroll bars and spin buttons to facilitate forms creation
Creating colorful 3D buttons for worksheet annotation and macro buttons
Calculating with hours, minutes, and times of day
Tracking down cell dependencies across multiple worksheets and workbooks
Discovering time-saving tools in the Go To Special feature
Adding, managing, and printing comments for worksheet documentation
Reducing data entry time by expanding AutoCorrect options
Setting up custom views for quick access to different worksheet displays
Using hyperlinks for rapidly switching worksheet locations and jumping to websites
Controlling worksheet security by allowing selected users to edit specific cell ranges
Using option buttons, group boxes, and checkboxes to facilitate forms creation
Exploring what-if scenarios using Goal Seek
Creating text, numerical, date, and time lists in a flash
Creating variable conditional formatting rules
Handling dates with unusual formats
Using wildcards (asterisk, tilde, and question mark)
Custom formats using asterisk, semicolon, and brackets
Meeting unusual filtering needs via Advanced Filter
Create an organization chart
Two-way lookup using the MATCH and INDEX functions
Using Excel error-checking functions
Custom formats, relative addressing, and conditional formatting
Auditing
Adding comments and shapes
Drawing borders and border grids
Building a flexible monthly table using functions
Adding pictures as worksheet backgrounds
ADDRESS, ROW, and COLUMN functions
Join data with new CONCAT and TEXTJOIN functions
Working with formulas in tables
Locating data validation rules and violations
Creating an Excel template
Restoring missing column titles
Creating a pick list dependent on another pick list
Using command shortcuts with the Alt key
Set up a macro for sorting dynamic data
Use random number functions for sorting and creating sample data
Use calcuated fields and calculated items in a PivotTable
Replace characters by position with the REPLACE function
Work with formulas in tables
Keystroke shortcuts from A to Z: Using the Ctrl key
Use special tricks for working with dates in charts
Use a data form for data entry and exploring data
Creating an Excel template to simplify updating a monthly file
Calculate dates efficiently using Excel's hidden function - DATEDIF
Create dynamic sheet name references with the INDIRECT function
Avoid errors and hidden data with the powerful AGGREGATE function
Hide worksheets, row, columns, cells and other Excel elements
Use slicers and charts together for dynamic presentations
Save a chart as a template: Use the template for current or new charts
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions
Adjust a chart's source data and adjust its series order
Use the OFFSET function for tabulating moving data
Alter numeric data without formulas
Use Flash Fill to rapidly combine or separate columnar data
Adjust banded-row formatting
Change the shape of comment boxes and other objects
How and when to use the 10 rounding functions in Excel
Calculate faster with the AutoSum button and AutoSum keystroke shortcut
How to use mixed cell references
Activate the Speak On Enter and Speak Cells features
Accelerate data entry with five special techniques
Insert a text box or shape and link a cell's content to it
Use Watch Window and other techniques to track changing cells
How to create time interval entries
How to create frequency tabulations and distributions
Create an expanded list from a summary using PivotTable techniques
Solve matching issues with matching phone numbers and SS numbers
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative
Use outlining tools to quickly expand and collapse data for dynamic presentations
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series
Create linkage formulas that refer to other worksheets and workbooks
Formula nesting: Using multiple functions in the same formula
Keyboard shortcuts for numeric formats
Use the Subtotal command to analyze data with single- or multiple-level subtotals
Work with MAX, MAXIFS, LARGE, and related functions
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations
Use the FIND, MID, LEFT, and RIGHT functions
Flip the left-to-right order of columns with the INDEX function or sort by columns
Working with hidden data when copying cells and creating charts
Use conditional formatting data bars to accentuate negative data
Creative use of sparklines in merged cells with axes
Copy formats quickly using dragging techniques and the Format Painter
Displaying multiple worksheets and workbooks together
Tips for creating and updating sample data
Use conditional formatting to overcome formatting limitations of the IF function
Use VLOOKUP, MATCH, and INDEX functions with array formulas
Summarize data from different worksheets with a PivotTable
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions
Use custom formulas in data validation to keep out bad data
Dealing with circular errors
Tips for creating charts quickly
Creating heat maps using conditional formatting
Using the INDEX function to extract data by row and column
Displaying tips when using Excel in presentations
The Wrap Text, Merge and Center, and Indent options
Using fill effects (gradients, patterns, styles) for colorful cell background variations
Working with multiple worksheets simultaneously
Exploring font choices not found on the Home tab
Using WordArt for special titles and headings
Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions
Borders and gridlines: Exploring variations, options, and differences
New Excel 2016 chart types: Tree map and sunburst
Freezing column and row titles
Use data validation to force entries to be uppercase or lowercase
Avoiding common chart distortions
Use the new funnel chart available in Excel 365
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!
Creating cross-totals with the SUMIFS function and mixed references
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker
Using the AND and OR functions independently or within IF functions
Vertical and horizontal alignment settings and orientation options
Sorting tips and shortcuts
A look at new chart types in Excel 2016: Waterfall
Work with formulas and formats: Decimals and fractions
Creating mixed reference formulas; converting to a table; applying conditional formatting
Control gridlines in charts and on worksheets
Use the INDIRECT function with intersection formulas and range names to extract data
Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes
Control phone number and postal code formats using built-in options or customized formats
Change the default Excel chart type; create and use chart templates
Create your own customized date and time formats
Create on-screen warnings and reminders with comments or data validation messages
Use REPLACE for formats only, for data only, or for both
Create numeric formats: Display in thousands or millions
Converting dates like 20102006 into usable date entries
Create custom lists for letter series like A to Z
Freeze Panes and Split
NETWORKDAYS.INTL and WORKDAY.INTL
Calculate % of change
Fill in all blank cells within a range with either formatting or data
Use the COUNT and COUNTA functions
Use workbook protection to prevent use of sheet commands
Rank data with the RANK and RANK.AVG functions
Use nonstandard fiscal years and quarters in PivotTables
Identify or extract unique entries in a list
Keyboard, mouse, and command techniques for viewing worksheets
Create artistic charts with random numbers
Extract day, month, and year from date fields
Compare data with EXACT, FIND, and SEARCH functions
How to covert ROMAN numberals
Use range names for more readable formulas
Customize your Quick Access Toolbar
Conditional formatting based on date proximity
How to adjust names
Differences and limitations of converting data to a table
Avoid the #DIV/0 error message
Explore formatting options not available on the Home tab
Control table formatting with custom formats
Use date functions for age and tenure calculations
Avoid unintentional entries when typing code numbers
Sorting by moving columns
Calculating cumulative totals
Using the CONVERT function for different numbering systems
Creating an automatically expanding chart by basing it on a table
Keystroke shortcuts using the Alt key
Using the Solver Add-in
Column widths, row heights, merging cells, and related formatting issues
Adjusting default layouts and date grouping in PivotTables
Auditing cell content with Watch Window and dependent cell formulas
Use the LEN and REPT functions for specialized cell testing and display options
Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters
Create double-spaced and triple-spaced printouts while repeating column headings
Helpful keystroke shortcuts
Identify weekdays and weekend days in data
Use chart and filter for presentations
Create picture links
How to use the error-checking rules in Excel
Protect worksheets and lock cells
Use mixed addresses in Excel formulas
Rapid filtering with Filter by Selection
Display large values
Tracking down conditional formatting and data validation rules
Transposing data and using the TRANSPOSE function
Displaying gridlines, borders, and column/row headings when printing
Exploring some of the 200-plus SmartArt graphic options
Using the CEILING and FLOOR functions for specialized rounding needs
Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners
Tabulating totals with the VLOOKUP function and array constants
Working with array formulas more easily
Using the new UNIQUE function to count and copy unique list entries
Creating and updating sample data
Format macros to make you a more efficient Excel user
Use the new SORT and SORTBY functions to extract sorted lists
Use themes to adjust worksheet colors, fonts, and effects
Calculate loan payments and investments with PMT and FV functions
Use the XLOOKUP function to replace VLOOKUP
Chart display options with blank cells in source data
Adjust Conditional Formatting rules by altering percentage breakpoints
Discover new formula capabilities with new functions and dynamic arrays
Sort or filter data based on color font or cell color background
Simplify the use of special characters and symbols
Select from over 800 icons to enliven worksheets
Use the new RANDARRAY function that replaces RAND and RANDBETWEEN
How and when to use an area chart
Insert colorful images with the People Graph Add-in
Use formulas to create interactive charts
Track variables using the Scenario Manager
Get totals quickly without creating formulas
Use column or row references to create dynamic formulas
Overcoming obstacles when working with dates in charts
Create map-type charts based on geographical locations
Techniques for creating date series
Extract filtered data with data validation and the FILTER function
Use Find and Replace to change cell contents and formats
Add formula tools and symbols to the Quick Access Toolbar
Change PivotTable settings for titles and summaries
Use the Excel filtering capability for dates
Use worksheet names in formulas
Use data validation rules with special phone and social security formats
Work with time calculations in formulas
Prevent and locate duplicate worksheet entries
Look forward and backward using EDATE and other date functions
Display and highlight worksheet formula cells
Split or join columnar data with Text to Columns or Flash Fill
Highlight milestone data with conditional formatting and cumulative formulas
Use the XMATCH function to replace MATCH
Create a powerful macro
Work with hidden and visible data in filtered and subtotaled lists
Use TODAY, NOW, YEARFRAC, and DATEDIF
Use data validation rules to prevent duplicate entries in a range
Use various techniques to hide cells, rows, columns, and worksheets
Align, arrange, and rotate shapes in worksheets
File documentation with the Workbook Statistics button
Avoid misleading visuals when rescaling
Use the Fill Justify feature to wrap long text
Create range names from Column and Row headings
Use the SUBSTITUTE and REPLACE functions
Accelerate Conditional Formatting with the Quick Access Toolbar
Use wildcard symbols in functions
Use wildcard symbols in filtering and commands
Condense lengthy nested IF functions with the newer IFS function
Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more
Control worksheet security by allowing selected users to edit specific cell ranges
Retrieve vital data based on location using the Geography tool
Use the new SEQUENCE function to quickly build numeric and date arrays
Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions
Create a list box to facilitate selection of data from a list
Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more
Enhance readability with banded rows via conditional formatting
Seven different ways to drag data using the Ctrl, Shift, and Alt keys
Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions
Adjust charts quickly with quick layout, change colors, and chart styles options
Analyze PivotTable data with 13 different Show Values As options
Expand/collapse or sort displayed results when using the SUBTOTAL command
Use the AGGREGATE function to circumvent errors and ignore hidden data
Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration
Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH
Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more
Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect
Using the LET function to simplify formulas via programming concepts
Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash
Create moving averages with formulas and chart trendlines
Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR
Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability
Work with cell colors, patterns, and effects to emphasize data and provide visual flair
Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells

مشخصات این مجموعه :
زبان آموزش ها انگلیسی روان و ساده
دارای آموزشهای ویدیویی و دسته بندی شده
ارائه شده بر روی 2 حلقه دیسک به همراه فایلهای تمرینی
مدت زمان آموزش 32 ساعت و 33 دقیقه !
محصول موسسه آموزشی lynda