Advanced Microsoft Excel 2019 / Deborah Ashby, Excel instructor ; Simon Sez IT.

Format:

Video

Contributor:

Ashby, Deborah, speaker.

Simon Sez IT (Firm), production company.

Series:

Academic Video Online

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets--Computer programs.

Electronic spreadsheets.

Genre:

Instructional films.

Physical Description:

1 online resource (486 minutes)

Other Title:

Microsoft Excel advanced 2019

Place of Publication:

Birmingham, England : PACKT Publishing, 2019.

Language Note:

In English.

System Details:

video file

Summary:

Learn: What's new/different in Excel 2019; Advanced charting and graphing in Excel; How to use detailed formatting tools; Lookup and advanced lookup functions; Financial functions including calculating interest and depreciation; Statistical functions; Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web. How to create awesome visualizations using sparklines and data bars; Mastery of PivotTables and Pivot Charts; Scenario Manager, Goal Seek, and Solver; Advanced charts such as Surface, Radar, Bubble and Stock Charts. About: Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information. Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively. You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.

Participant:

Deborah Ashby, instructor.

Notes:

Title from title screen (viewed May 04, 2020).

OCLC:

1142817844