What You Will Learn Include:
- What is Office 365
- Setting up Office 365
- Excel 2016 user interface
- Exploring the Excel Ribbon
- Customizing the Quick Access Toolbar
- Keeping Tabs on the Ribbon
- Entering Data
- Opening a new workbook
- Entering Data in Excel
- Basic Data entry
- Entering Data with Autofill
- Entering Date
- Entering Time
- Undo and Redo Changes
- Adding Comments
- Giving your worksheet a title
- Saving your work
- Creating Formulas and Functions
- Using formulas for arithmetic tasks
- Re-using Formulas
- Calculating YTD Profits
- Calculating Percentage Change
- Using Relative and Absolute Reference
- Using RANK Function
- STD Function
- Small and Large Functions
- Median Function
- Count and counta functions
- Formatting
Exploring Fonts - Adjusting Column Width and Row Height
- Using Alignment
Designing Borders - Formatting Numbers
- Conditional Formatting
- Creating Tables
- Inserting Shapes
- What VBA is and why it is so incredibly useful
- What are Macros
- Creating Macros using macro recorder
- Creating macro manually from scratch
- Editing Macros
- Debugging Macros
- How to write VBA code and execute it in Excel
- How to make your macros work with workbooks, worksheets and the data on them
- How to find and eliminate errors in your programs and make your macros run
- Automation using macros.
- Analyse the macro from the Developer tab or the View tab.
- Examine the VBA window and VBA components.
- Distinguish between absolute and relative references.
- How to save workbook with macros
- Create a module
- Create procedure
- Create a sub
- Understand the difference between a module and sub
- Run the code in a sub
- Preparing queries
- Cleansing data with Power Query
- Enhancing queries
- Creating a data model in Power Pivot
- Building relationships
- Creating Pivot Tables and Pivot Charts
- Creating Lookups
- Using DAX to link data
- Creating data model
- Creating relationship between data sources
- Analyzing data with PivotTables and PivotCharts
- Using Power Query with PowerPivot
- Connecting to a variety of data sources with Power BI
- Create and publish reports to Power BI Service
- Refreshing Data Source
- Updating Queries
- Using Conditional statements
- Using quick and dynamic measures
- Transforming data on connected datasets
- After completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more.
Who this course is for:
- Beginners to spreadsheets and excel
- Those who need a refresher to excel.
Also learn Java Automation