Excel 2016/2019 Programming with VBA
Standard Price: $1495.00
Course Length: 3 Day
PivotTables may be Excel’s most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That’s because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. This course goes beyond merely explaining PivotTables and PivotCharts and includes step-by-step lessons using realistic business scenarios that any Excel user can understand.
This 1-day course covers those features of Microsoft Office 2010 that are new to the Office system, with dedicated units for the new features of each application. In Word, students will learn to use the Navigation pane and apply new text effects. In Excel they will use sparklines, filter data with slicers, and create a PivotChart. In PowerPoint they will organize slides into sections, edit movie clips, apply animation effects, and learn how to broadcast slide shows. In Outlook they will manage e-mail conversations, create Quick Steps, and use the People Pane. In Access, they will learn how to use the tabbed document window, create Lookup list fields, and use the data type gallery. In addition, students will learn about ribbon customization and Backstage view, and save a file as a PDF.
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
This course is designed to teach you how to customize your Windows SharePoint Foundation 2010 Web site, beyond the Team Web site template, to meet the specific needs of your users. Students will learn to add components to a site, to apply site themes, and to change site components and navigation options. They will then learn to edit pages in SharePoint Foundation and SharePoint Designer, manage content controls, and modify RSS feed settings. Finally, students will learn to use workflows and site galleries.