Course Syllabus
- Apply custom formats and layouts
- Create advanced formulas
- Use of Scenario
- Pivot tables and charts
- Manage and share workbooks
- Introduction to Data Management
- How do professionals organize their data?
- Meta Data and Big Data
- Freelance Data Entry Jobs
- Apply Custom Data Formats
- Use Advanced Fill Options
- Apply Advanced Conditional Formatting and Filtering
- Apply Custom Styles and Templates
- Use Form Controls
- Prepare Workbooks for Internationalization
- Use Outlines
- Use Custom Views
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
- Pivot Tables
- Use Pivot Charts
- Create Dashboard using Pivot Table
- Using Power Query
Data Visualisation and Data Analysis
▲
- Use of Macros
- Using Data Tables
- Create Dashboard using Pivot Tables
- Using Power Query
Use Scenarios
- Use What-If Analysis Tools
- Create Scenarios
- Merge Scenarios
- Create Scenario Summaries
- Use Data Tables
Manage and Share Workbooks
- Manage Workbook Versions
- Copy Styles between Workbooks
- Copy Macros between Workbooks
- Use Track Changes and Comments
- Merge Workbooks
- Protect Workbooks for Sharing
- Connect To External Data
Typical Data Entry Projects
Create advanced formulas
- Functions
- Apply functions in formulas
- Mathematical Functions
- Financial functions
- Useful Data Functions
- Some Other Useful Functions
- Look up data by using functions
- Apply advanced date and time functions
- Functions for Manipulating Text
- Arrays
Bestseller
