- Create and format charts.
- Work effectively with multiple sheets in workbooks.
- Use productivity tools.
- Quick analysis tools and work with the Excel list/database features.
This course will teach students about the functions and features of MS Office Excel. After completing this course, Students will learn how to: create elaborated worksheets and workbooks to display data in an effectual way, use functions and formulas, use PowerPivot to access data sources, create relationships, utilize the PowerPivot DAX expressions and create format reports.
- Bussiness Users.
- Students who are interested in Excel.
- AImporting data into Excel.
- Protecting specific data and formulae.
- Tracking changes in a workbook.
- Hiding elements of a workbook.
- Workbook security.
- Merging and sharing workbooks.
- Connecting with hyperlinks.
- Preparing workbooks for distribution and review.
- Sharing Excel data externally.
- Using name ranges in formulae.
- Text functions (upper, lower, proper, transpose, concatenate etc.)
- Time & date functions.
- Logical formulae (and, if, not, or, etc.).
- Array formulae.
- Lookup formulae (vlookup, hlookup, index, match etc.).
- Statistical formulae (round, average, max, min, sumif, countif, counta, etc.).
- Complex nested formulae.
- Circular references and other errors.
- Formulae auditing.
- Creating & maintaining data tables.
- Sorting & subtotalling data.
- Auto filter and custom filtering.
- What-if analysis.
- Scenario manager.
- Goal seeker function.
- Solver function.
- Pivot Tables & Charts.
- Creating a pivot table.
- Defining the layout and the presentation of a pivot table.
- Pivoting data elements.
- Selecting, copying, moving or deleting in a pivot table.
- Filtering, sorting and slicing data in a pivot table.
- Pivot charts.
- Selecting the right chart.
- Formatting the labels, titles and legends.
- Managing the axis, data series and scale.
- Modifying and updating source data.
- Saving custom charts.
- Inserting graphic objects.
- Formatting dates, numbers and text.
- Using functions to format text and data.
- Creating and applying custom formats.
- Conditional formatting.
- Installed templates and workbook design.
- Styles & themes.
- Splitting windows and freezing panes.
- Headers, footers and repeated rows/columns.
- Page setup and printing.
- What is a macro?.
- Recording a macro.
- Running a macro.
- Assigning a macro to a button.
- Macro security.
- Editing a macro using VBA.
- Macro security.
- Editing a macro using VBA.
- Writing a macro in the Visual Basic Editor.
- Creating custom functions using VBA.
- Design of dashboard applications.
