Excel Skills for Business: Intermediate I - Course Final assessment ǀǀ Macquarie University скачать в хорошем качестве

Excel Skills for Business: Intermediate I - Course Final assessment ǀǀ Macquarie University

Excel Skills for Business: Intermediate I - Course Final assessment ǀǀ Macquarie University Excel Skills for Business: Intermediate I Offered By: Macquarie University Available At: Coursera This course is part of the Excel Skills for Business Specialization Enrollment Link: https://www.coursera.org/learn/excel-... Course goals and weekly learning objectives : When you have successfully completed the course you will be able to Manage large datasets efficiently (Weeks 1, 2, 3, 4, 5) Extract meaningful information from large datasets (Weeks 4, 5, 6) Present data and extract information effectively (Weeks 2, 4, 5, 6) Work with datasets from a variety of sources (Week 1, 3) Week 1 - Working with multiple worksheets and workbooks Compare the different methods of combining data from multiple sources Use a variety of techniques to perform calculations across workbooks/worksheets Manage datasets across multiple workbooks/worksheets Week 2 - Text & Date functions Explain the use of Date and Text functions in Excel Understand how to work with Nested functions Use Date functions to extract additional business intelligence Use Text functions to combine or split text strings Week 3 - Named Ranges Describe the use of Named Ranges Use different methods to create Named Ranges Enhance calculations through the use of Named Ranges Week 4 - Summarising data Explain the syntax of more advanced formulas Use functions to extract summary information from data Generate graphical representations of data Week 5 - Tables Create and modify Tables in Excel Apply formatting, sorting and filtering to Tables Add data to Tables Explain terminology specific to Tables in Excel Week 6 - Pivot Tables, Charts, and Slicers Create Pivot Tables, Pivot Charts, and Slicers Use Pivot Tables to extract meaning from datasets Create visual dashboards with slicers and Pivot Charts Use Slicers to filter information from multiple sources source: https://www.coursera.org/learn/excel-... Excel Skills for Business : Essentials: Final Assessment -    • Excel Skills for Business: Essentials ǀǀ F...   Intermediate I - w1: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Intermediate I – w2: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Intermediate I – w3: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Intermediate I – w4: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Intermediate I – w5: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Intermediate I – w6: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Intermediate I - Course final: Final Assessment -    • Excel Skills for Business: Intermediate I ...   Contact me through: Fb -   / ayeman.ibna.hasan   LinkedIn -   / ayemanhasan   Twitter -   / ayemanhasan   Tumbler - https://www.tumblr.com/blog/view/ayem... #coursera #coursera_excel #macquarie_university #excel_intermediate_1 #microsoft_excel #free_online_course