

Keyboard Shortcuts
· ALT+=
· CTRL+TAB
· CTRL+A
· CTRL+1
· CTRL+SHIFT+”
· F4
· CTRL+Z
· CTRL+’
· CTRL+K
· CTRL+F
· CTRL+H
· CTRL+N
· CTRL+O
· F2
· F7
· CTRL+SHIFT+F3
· CTRL+P
· CTRL+S
· CTRL+C
· CTRL+X
· CTRL+V
· END key then Up or Down, or Left or Right Arrows
· CTRL+HOME
· CTRL + Page Up or CTRL + Page Down
· CTRL+~
· CTRL+D
Tips & Tricks
· Transpose Data
· Increase Numbers by Set Amount
· AutoFill a Series or Formulas
· Force a carriage return in a cell instead of wrapping the text
· Use Format Painter more than once
· Format Sheet Tab Colors
· Combine Text from Multiple Cells
· Select blank cells in a row or column
· Fill blank cells in a row or column
· Copy & Paste visible cells only
· Insert custom cell formats
· Use Named Ranges in your formulas
· Apply different formats within one cell
· Move column, row or cells
· Move and insert column, row or cells
· Copy and paste a column, row or cells
· Copy and insert a column, row or cells
· Quickly enter links to a range of cells
· Convert formulas to values
· Copy formulas only
· Freeze rows and or columns
· Synchronous Scrolling
· Hide worksheet tabs
· Hide row and column headers
· Hide the formula bar
· Add non-contiguous print areas
· Pick from a list of existing values
· Print titles on each page automatically
· Absolute References
· Quickly SUM a range of cells
· Generate a unique list of values from a range
· Use the Auto Calculate Menu
· You don’t have to start your formulas with =
· Use Text to Columns to separate a column of data containing first names and last names
· Center Across Selection
· Find the number of days between two dates
· Move quickly to the end of a range of cells
· Fill Handle Cool Tricks
Must Know Formulas
· IF
· Nested IF Statements
· IF, OR and AND
· VLOOKUP Exact Match
· VLOOKUP Sorted List
· HLOOKUP
· SUMIF and SUMIFS
· COUNTIF and COUNTIFS
· COUNTA
· SUBTOTAL
· ROUND, ROUNDUP, ROUNDDOWN
· IFERROR
· MIN, MAX, SMALL and LARGE
· UPPER, LOWER and PROPER
· TRIM, CHAR and SUBSTITUTE
· Time Calculations
· NOW
· TODAY
· Left
· Right
· Mid
· Char
· Code
Power Formulas
· INDEX and MATCH
· CHOOSE
· VLOOKUP with CHOOSE
· OFFSET
· FLOOR and CEILING
· RAND and RANDBETWEEN
· SUMPRODUCT
· Array Formulas
Cool Tools
· Shapes and SmartArt
· Camera Tool
· Conditional Formatting
· Filters
· Drop Down Lists
· Insert Subtotals
· Outlines
· Importing Data Into Excel
· Excel Tables
· PivotTables
· Flash Fill
· …
پکیج طراحی کاور پست با فتوشاپ | Post Cover Design With Photoshop بخش اول – معرفی محصول 1. معرفی دوره […]
سلام دوستان احتمالا پیج آقای حاجی محمدی بنیان گذار وردپرس فارسی و ژاکت رو دارین. چند وقته که با استوری […]
پکیج ویدیویی آموزش نرم افزار اکسل از سطح پایه تا سطح فوق حرفه ای
مدرس: علی غفاریان صالحی نژاد 09129475964
نقد و بررسیها
هیچ دیدگاهی برای این محصول نوشته نشده است.