The charts we create in Excel often end up either in Word documents or PowerPoint presentations.
We will also look at the amazing new Power Pivot feature of Excel, which can handle immense industrial-size databases. In this session we will explore the basics of a relational database and see how the Data Model will help us manage large tables and data sets. The newer versions of Excel have some amazing database features provided by a technology called the Data Model.
In this session, we will take a close look at Macros and the Visual Basic for Applications (VBA) programming language and see how these tools can enable us to be more effective Excel users. In this session, we will explore how these tools can be used in business applications. The latest versions of Excel has some new powerful tools for displaying data. Giorgi’s Spreadsheet: DATA-NCC-RM2 Session 6: Power View & Dashboards
#Ncc budget workbook pdf how to
Get & Transform – Directions: How to Use Get & Transform in Excel Power Query Magic Trick: Power-Query-Magic-Trick.xlsx Get & Transform – Files: Get and Transform Files (zip) We will explore some amazing Get & Transform (“Power Query”) tools to bring data into a spreadsheet automatically. Workbook File: Workbook Session 4 Session 5: Power Query We will see how these relatively new features in Excel not only look good but are also extremely functional. In this session we will explore the advanced features of the amazing Excel Tables and Slicers. Workbook File: Workbook-Session-3.xlsx Session 4: Excel Tables Here we will examine some of advanced charts and graphs along with some powerful advanced functions in Excel, such as: SUMIFS and AVERAGEIFS, INDEX and MATCH, and Array formulas. Workbook File: Workbook Session 2.xlsx Session 3: Advanced Charts & Formulas In this session we will review Pivot Tables and the VLOOKUP function and then explore some powerful advanced skills in both these topics. Slide Show (PDF): Slideshow–Tips & Tricks Session 2: Pivot Tables & VLOOKUP This session covers over 50 tips in categories such as: Navigating a Workbook, Selecting Cells, Using Paste Options, Handling Absolute References, Entering Data, Displaying Data, Printing, and so forth.Įxcel Shortcut Keys: Excel Keyboard Shortcuts Rich Malloy Session 1: Tips, Tricks, and Shortcuts If you have any additional topics that you would like to cover, please let me know. This Advanced Microsoft Excel 2019 course is comprised of ten sessions:
0 kommentar(er)
