Jump to content
Bo0mB0om

77 727 Microsoft Excel: Core Data Analysis, Manipulation, and Presentation Certification Exam Crash Course

Recommended Posts


ab2063d3eb5fcff3392f82e519496f02.jpg
MP4 | Video: AVC 1018 x 572 | Audio: AAC 44 Khz 2ch | Duration: 01:50:59 | 377.96 MB
Genre: eLearning | Language: English

Apply the basics of Microsoft Excel data analysis, manipulation, and presentation, create workbooks and worksheets, manage data cells and ranges, design tables, use formulas and functions, and generate charts. Become prepared to take the 77-727 Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification Exam. These six topics will be covered:
Creating Worksheets and Workbooks in Microsoft Excel. In this first topic in the 77-727 Microsoft Excel series, create a new workbook and add a worksheet, copy worksheets and change their order in a workbook, and import data from a text delimited file.
Formatting and Navigating in Worksheets and Workbooks in Microsoft Excel. In this second topic in the 77-727 Microsoft Excel series, practice searching and navigating within worksheets. Also rename worksheets, change their order in a workbook, adjust rows and columns height and width, and insert and delete new rows and columns.
Customizing Options and Views for Worksheets and Workbooks in Microsoft Excel. In this third topic in the 77-727 Microsoft Excel series, customize the toolbar, hide or unhide worksheets, columns or rows, change workbooks and windows views, and display formulas.
Calculating Functions in Microsoft Excel. In this fourth topic in the 77-727 Microsoft Excel series, perform calculations on arrays of numbers. These functions include SUM - for summing, MIN and MAX - for getting minimum and maximum value in an array, COUNT - for counting numbers in an array, and AVERAGE - for getting an average value of an array.
Applying Conditional Operations using Functions in Microsoft Excel. In this fifth topic in the 77-727 Microsoft Excel series, analyze the IF for logical conditions. The more complex logical functions are explained, such as SUMIF, COUNTIF and AVERAGEIF for summing, counting, and calculating average with a condition.
Leveraging Text Functions in Microsoft Excel. In this sixth topic in the 77-727 Microsoft Excel series, practice working with texts (strings). You will learn how to use RIGHT, LEFT and MID functions to divide texts or UPPER, LOWER and PROPER functions to convert texts. Also, the CONCETANE function is explained for joining multiple texts.
DOWNLOAD

Sakriveni sadžaj

    Dajte reakciju na ovaj post pritiskom na "Like dugme", da biste videli sakriveni sadržaj.



Sakriveni sadžaj

    Dajte reakciju na ovaj post pritiskom na "Like dugme", da biste videli sakriveni sadržaj.



Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×