Advanced Excel
Formulae that Add / Subtract / Multiply / Divide /BODMAS / Formula Error Checking/The Sum Function/ VLOOKUP/ HLOOKUP Functions/Creating, Formatting Simple PivotTables/Page Field in a PivotTable/Formatting a PivotTable / Creating / Modifying a PivotChart……
Trending New Courses !
Choose The Best for Bright Career.
Learn how to think like Excel, and write powerful and dynamic Excel formulas from scratch.
Excel Details...
- Apply Custom Formats and Layouts
- Apply Custom Data Formats
- Use Advanced Fill Options
- Apply Advanced Conditional
- Formatting and Filtering
- Apply Custom Styles and Templates
- Use Form Controls
- Prepare Workbook
- Use Outlines
- Use Custom Views
- 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
- Use Scenarios
- Use What-If Analysis Tools
- Create Scenarios
- Merge Scenarios
- Create Scenario Summaries
- Use Data Tables
- Create Advanced Charts
- Basic Excel Charts
- Use Area, Scatter & Stock Charts
- Use Surface, Radar & Combination Charts
- Create Custom Chart Templates
- Work with Sparkline’s
- Pivot tables & charts
- PivotTables
- Use Pivot Charts
- 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
- Automate, streamline, and completely revolutionize your workflow with Excel
- Write advanced conditional, text, date and lookup functions, including XLOOKUP & Dynamic Arrays
- Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
- Create your own formula-based Excel formatting rules
- Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions
- Manipulate dates, times, text, and arrays
Course Designed and Authorised By Maharashtra Knowledge Corporation Ltd YCMOU
who can apply for this course
- Excel users who want to learn how to write advanced formulas from scratch
- Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level
- Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
- Excel users looking to build powerful analytical thinking and business intelligence skills
- Anyone looking to pursue a career in analytics, data science or business intelligence