پیشنهاد فرادرس

آموزش نکات هفتگی مایکروسافت اکسل

دسته بندی ها: آموزش اکسل ، آموزش آفیس ، آموزش های لیندا (Lynda)
آیا این نوشته را دوست داشتید؟
Excel Tips Weekly Publisher:Lynda Author:Dennis Taylor Duration:21h 30m Level:Appropriate for all

Get a new productivity-boosting tip every Tuesday from Excel expert Dennis Taylor.
Updated: 2/6/2018
Released: 1/16/2015

This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel.Note: Because this is an ongoing series, viewers will not receive a certificate of completion.

Excel Tips - New This Week
Control gridlines in charts and on worksheets
New
7m 45s
Previous Episodes
Hide and unhide worksheets securely
6m 6s
Resizing, moving, copying, and manipulating charts and other objects
10m 17s
Using list boxes and combo boxes to facilitate forms creation
7m 36s
Using the FORMULATEXT and N functions for worksheet and formula documentation
5m 53s
Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells
7m 55s
Summarizing data from diverse ranges with Data > Consolidate
9m 33s
Using check boxes and Conditional Formatting together for dynamic displays
12m 39s
Becoming more productive with these 10 tiny tips you'll use often
8m
Transposing data and charts for a different perspective on your data
8m 57s
Applying conditional formatting across rows of data
6m 43s
Exploring various layouts for your PivotTable
4m 27s
Splitting and consolidating workbooks
6m 47s
Using date and time as metrics in a PivotTable
6m 53s
Adding illustrations to your workbook
12m 7s
Using Pick list, VLOOKUP, Table, and Chart together
8m 5s
Using formulas to calculate values across worksheets and workbooks
11m 12s
Dynamically presenting data via chart slicers
7m 15s
Parsing your data to create unique lists
3m 21s
Using the REPT function to represent data visually
3m 6s
Using source data from a table to make your PivotTable more dynamic
7m 8s
Accelerating Cut, Copy, Paste, and Insert tasks
7m 26s
Increasing your productivity with custom lists
5m 9s
Highlighting PivotTable results with conditional formatting
6m 10s
Customizing templates to fit your unique needs
6m 6s
Creating dynamic charts with in-cell conditional formatting
3m 26s
Enhancing table filtering with slicers
5m 23s
Converting charts into pictures
4m 51s
Custom grouping in PivotTables
4m 31s
Quick formatting tips
8m 9s
The top five unknown but useful keyboard shortcuts
6m 17s
Using the TREND and GROWTH functions for projecting future results
5m 54s
Using scroll bars and spin buttons to facilitate forms creation
10m 1s
Creating colorful 3D buttons for worksheet annotation and macro buttons
6m 52s
Calculating with hours, minutes, and times of day
11m 2s
Tracking down cell dependencies across multiple worksheets and workbooks
6m 24s
Discovering time-saving tools in the Go To Special feature
11m 22s
Adding, managing, and printing comments for worksheet documentation
11m 22s
Reducing data entry time by expanding AutoCorrect options
6m 10s
Setting up custom views for quick access to different worksheet displays
6m 30s
Using hyperlinks for rapidly switching worksheet locations and jumping to websites
7m 18s
Controlling worksheet security by allowing selected users to edit specific cell ranges
7m 22s
Using option buttons, group boxes, and checkboxes to facilitate forms creation
8m 7s
Exploring what-if scenarios using Goal Seek
9m 55s
Creating text, numerical, date, and time lists in a flash
6m 54s
Creating Variable Conditional Formatting Rules
8m 4s
Handling Dates with unusual formats
6m 5s
Using wildcards (asterisk, tilde, and question mark)
11m
Custom formats using asterisk, semicolon, and brackets
13m
Meeting unusual filtering needs via Advanced Filter
12m 38s
Create an Organization Chart
8m 56s
Two-way lookup using the MATCH and INDEX functions
11m 28s
Using Excel's error-checking functions
10m 37s
Custom formats, relative addressing, and conditional formatting
8m 26s
Auditing
9m 1s
Adding comments and shapes
7m 35s
Drawing borders and border grids
5m 45s
Building a flexible monthly table using functions
11m 44s
Adding pictures as worksheet backgrounds
4m 15s
ADDRESS, ROW, and COLUMN functions
8m 8s
Join data with new CONCAT and TEXTJOIN functions
6m 15s
Working with formulas in tables
13m 2s
Locating Data Validation rules and violations
7m 20s
Creating an Excel template
7m 57s
Restoring missing column titles
6m 41s
Creating a pick list dependent on another pick list
6m 59s
Pasting picture links
9m 26s
Using Command Shortcuts with the Alt key
5m 51s
Set up a macro for sorting dynamic data
8m 42s
Use random number functions for sorting and creating sample data
9m 57s
Use calcuated fields and calculated items in a PivotTable
8m 57s
Replace characters by position with the REPLACE function
5m 46s
Work with formulas in tables
9m 3s
Keystroke shortcuts from A to Z - using the Ctrl key
16m 16s
Use special tricks for working with dates in Charts
11m 36s
Use a data form for data entry and exploring data
6m 42s
Creating an Excel template to simplify updating a monthly file
7m 10s
Calculate dates efficiently using Excel's hidden function - DATEDIF
7m 36s
Create dynamic sheet name references with the INDIRECT function
6m 45s
How to use locked cells and sheet protection
10m 15s
Avoid errors and hidden data with the powerful AGGREGATE function
7m 8s
Hide worksheets, row, columns, cells and other Excel elements
7m 26s
Use slicers and charts together for dynamic presentations
9m 4s
Save a chart as a template - use the template for current or new charts
6m 2s
MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions
8m 12s
Adjust a chart's source data and adjust its series order
9m 7s
Use the OFFSET function for tabulating moving data
11m 23s
Alter numeric data without formulas
10m 19s
Use Flash Fill to rapidly combine or separate columnar data
10m 28s
Adjust banded-row formatting
14m 35s
Change the shape of comment boxes and other objects
6m 32s
How and when to use Excel's 10 rounding functions
13m 26s
Calculate faster with the AutoSum button and AutoSum keystroke shortcut
6m 54s
How to use mixed cell references
8m 25s
Adjust formatting to display large values in thousands, millions, etc.
6m 14s
Activate the Speak On Enter and Speak Cells features
5m 38s
Accelerate data entry with five special techniques
12m 8s
Insert a text box or shape and link a cell's content to it
6m 58s
Use Watch Window and other techniques to track changing cells
8m 21s
How to create time interval entries
11m 39s
How to create frequency tabulations and distributions
8m 10s
Create an expanded list from a summary using PivotTable techniques
7m 25s
Solve matching issues with matching phone numbers and SS numbers
10m
Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative
7m 27s
Use Outlining tools to quickly expand and collapse data for dynamic presentations
9m 19s
Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting
9m 59s
Create lists of all 2nd Tuesdays, last Tuesdays. and other date series
10m 44s
Create linkage formulas that refer to other worksheets and workbooks
11m 49s
Formula nesting: Using multiple functions in the same formula
13m 22s
Keyboard shortcuts for numeric formats
8m 18s
Use the Subtotal command to analyze data with single- or multiple-level subtotals
9m 15s
Work with MAX, MAXIFS, LARGE, and related functions
8m 14s
Use the dynamic TODAY and NOW functions for real-time up-to-date calculations
9m 24s
Use the FIND, MID, LEFT, and RIGHT functions
10m 38s
Flip the left-to-right order of columns with the INDEX function or sort by columns
8m 18s
Working with hidden data when copying cells and creating charts
10m 58s
Use conditional formatting data bars to accentuate negative data
4m 16s
Creative use of sparklines in merged cells with axes
7m 1s
Copy formats quickly using dragging techniques and the Format Painter
5m 33s
Displaying multiple worksheets and workbooks together
10m 13s
Tips for creating and updating sample data
11m 1s
Use conditional formatting to overcome formatting limitations of the IF function
8m 54s
Use VLOOKUP, MATCH and Index functions with array formulas
10m 38s
Summarize data from different worksheets with a PivotTable
7m 20s
AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas
6m 59s
Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions
8m 40s
Use custom formulas in data validation to keep out bad data
13m 18s
Dealing with circular errors
8m 20s
Tips for creating charts quickly
6m 56s
Creating heat maps using conditional formatting
8m 31s
Using the INDEX function to extract data by row and column
11m 1s
Displaying tips when using Excel in presentations
6m 23s
The Wrap Text, Merge and Center, and Indent options
9m 2s
Using fill effects (gradients, patterns, styles) for colorful cell background variations
5m 10s
Working with multiple worksheets simultaneously
8m 42s
Exploring font choices not found on the Home tab
4m 2s
Using WordArt for special titles and headings
4m 33s
Differentiating weekdays and weekends in Excel data
11m 16s
Creating a 2-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions
7m 34s
Borders and gridlines: Exploring variations, options, and differences
8m 24s
New Excel 2016 chart types: Tree map and sunburst
7m 29s
Freezing column and row titles
7m 48s
Use data validation to force entries to be uppercase or lowercase
10m 48s
Avoiding common chart distortions
11m 49s
Use the new Funnel chart available in Excel 365
4m 3s
Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character
6m 1s
Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME!
9m 39s
Creating cross-totals with the SUMIFS function and mixed references
5m 50s
New Excel 2016 chart types: Histogram, Pareto, and box, and whisker
10m 8s
Using the AND and OR functions independently or within IF functions
9m 58s
Vertical and horizontal alignment settings and orientation options
7m 12s
Sorting tips and shortcuts
8m 40s
A look at new chart types in Excel 2016: Waterfall
6m 57s
Work with formulas and formats: Decimals and fractions
5m 42s
Creating mixed reference formulas; converting to a table; applying conditional formatting
8m 6s

پیشنهاد فرادرس