Bcc Info
 
Excel 2013 Intermediate

Excel 2013 Intermediate Training Materials 12Hrs.


Excel 2013 setup & printing issues
•    Worksheet margins
•    Worksheet orientation
•    Worksheet page size
•    Headers and footers
•    Header and footer fields
•    Scaling your worksheet to fit a page(s)
•    Visually checking your calculations
•    Displaying gridlines when printing
•    Printing titles on every page when printing
•    Printing the Excel row and column headings
•    Spell checking
•    Previewing a worksheet
•    Viewing workbooks side by side
•    Zooming the view
•    Printing options
•    Setting the number of copies to print
•    Selecting a printer
•    Selecting individual worksheets or the entire workbook
•    Selecting which pages to print
•    Single or double sided printing
•    Collation options
•    Page orientation
•    Paper size
•    Margins
•    Scaling
•    Printing
Functions and formulas
•    Getting help with functions
•    Nested functions
•    Consolidating data using a 3-D reference sum function
•    Mixed references within formulas
Time & date functions
•    Inserting the current time and date
•    Today function
•    Now function
•    Day function
•    Month function
•    Year function
Mathematical functions
•    Round function
•    Rounddown function
•    Roundup function
Logical functions
•    If function
•    And function
•    Or function
Mathematical functions
•    Sumif function
Statistical functions
•    Count function
•    Counta function
•    Countif function
•    Countblank function
•    Rank function
Text functions
•    Left function
•    Right function
•    Mid function
•    Trim function
•    Concatenate function
Financial functions
•    Fv function
•    Pv function
•    Npv function
•    Rate function
•    Pmt function
Lookup functions
•    Vlookup function
•    Hlookup function
Database functions
•    Dsum function
•    Dmin function
•    Dmax function
•    Dcount function
•    Daverage function
Excel 2013 named ranges
•    Naming cell ranges
•    Removing a named range
•    Named cell ranges and functions
Excel 2013 cell formatting
•    Applying styles to a range
•    Conditional formatting
•    Custom number formats
Manipulating worksheets within Excel 2013
•    Copying or moving worksheets between workbooks
•    Splitting a window
•    Hiding rows
•    Hiding columns
•    Hiding worksheets
•    Un-hiding rows
•    Un-hiding columns
•    Un-hiding worksheets
Excel 2013 templates
•    Using templates
•    Creating Excel templates
•    Editing Excel templates
Paste special options within Excel 2013
•    Using paste special to add, subtract, multiply & divide
•    Using paste special ‘values’
•    Using paste special transpose option

 
Advertisement

Mambo is Free Software released under the GNU/GPL License.
เว็บนี้ขับเคลื่อนด้วย แมมโบ้ลายไทย
Mambo LaiThai base on MamLang