This is the Course Details

Undernoted courses basic learning have been illustrated in the undernoted link to learn the basic of the the all courses  tutorials.  After Buying the exam voucher , you will get 40hrs courses extra to complete the project base tutorials  through office 365 / shere point platform . for that you required to learn oneNote

You have selected  the  Microsoft Corporation  for the  Microsoft Office Specialist (MOS)  course in  77-420: Excel 2013 Core  

181Create and manage worksheets and workbooks
1646181Create worksheets and workbooks •Creating new blank workbooks; creating new workbooks using templates; importing files; opening non-native files directly in Excel; adding worksheets to existing workbooks; copying and moving worksheets Learn   
1647181Navigate through worksheets and workbooks •Searching for data within a workbook; inserting hyperlinks; changing worksheet order; using Go To; using Name Box Learn   
1648181Format worksheets and workbooks •Changing worksheet tab color; modifying page setup; inserting and deleting columns and rows; changing workbook themes; adjusting row height and column width; inserting watermarks; inserting headers and footers; setting data validation Learn   
1649181Customize options and views for worksheets and workbooks •Hiding worksheets; hiding columns and rows; customizing the Quick Access toolbar; customizing the Ribbon; managing macro security; changing workbook views; recording simple macros; adding values to workbook properties; using zoom; displaying formulas; freezing panes; assigning shortcut keys; splitting the window Learn   
1650181Configure worksheets and workbooks to print or save •Setting a print area; saving workbooks in alternate file formats; printing individual worksheets; setting print scaling; repeating headers and footers; maintaining backward compatibility; configuring workbooks to print; saving files to remote locations Learn   
182Create cells and ranges
1651182Insert data in cells and ranges •Appending data to worksheets; finding and replacing data; copying and pasting data; using AutoFill tool; expanding data across columns; inserting and deleting cells Learn   
1652182Format cells and ranges •Merging cells; modifying cell alignment and indentation; changing font and font styles; using Format Painter; wrapping text within cells; applying Number format; applying highlighting; applying cell styles; changing text to WordArt Learn   
1653182Order and group cells and ranges •Applying conditional formatting; inserting sparklines; transposing columns and rows; creating named ranges; creating outline; collapsing groups of data in outlines; inserting subtotals Learn   
183Create tables
1654183Create a table •Moving between tables and ranges; adding and removing cells within tables; defining titles Learn   
1655183Modify a table •Applying styles to tables; banding rows and columns; inserting total rows; removing styles from tables Learn   
1656183Filter and sort a table •Filtering records; sorting data on multiple columns; changing sort order; removing duplicates Learn   
184Apply formulas and functions
1657184Utilize cell ranges and references in formulas and functions •Utilizing references (relative, mixed, absolute); defining order of operations; referencing cell ranges in formulas Learn   
1658184Summarize data with functions •Utilizing the SUM function; utilizing the MIN and MAX functions; utilizing the COUNT function; utilizing the AVERAGE function Learn   
1659184Utilize conditional logic in functions •Utilizing the SUMIF function; utilizing the AVERAGEIF function; utilizing the COUNTIF function Learn   
1660184Format and modify text with functions •Utilizing the RIGHT, LEFT and MID functions; utilizing the TRIM function; utilizing the UPPER and LOWER functions; utilizing the CONCATENATE function Learn   
185Create charts and objects
1661185Create a chart •Creating charts and graphs; adding additional data series; switching between rows and columns in source data; using Quick Analysis Learn   
1662185Format a chart •Adding legends; resizing charts and graphs; modifying chart and graph parameters; applying chart layouts and styles; positioning charts and graphs Learn   
1663185Insert and format an object •Inserting text boxes; inserting SmartArt; inserting images; adding borders to objects; adding styles and effects to objects; changing object colors; modifying object properties; positioning objects Learn   


© 2024 - CodeHub India 2015   

data-share="true" data-width="450" data-show-faces="true">