Courses / Office Automation / Advanced Excel
Office Automation

Advanced Excel Course

Salim Rana
Couse Completed

105

Category

Data Science

Upcomming Batch

15 Sept, 2024

Review

About Course

Microsoft Excel is a powerful tool for data organization, analysis, and visualization. The software's powerful formulas, functions, and charts are well-known for their adaptability, and they play an important part in jobs ranging from budgeting to complex data-driven decision-making across a wide range of fields. Excel includes a large collection of built-in formulae and functions that cover everything from basic arithmetic to complicated statistical and financial calculations. Pivot Tables are powerful tools for summarizing and analyzing large datasets, allowing users to create customized reports and insights. Excel's visualisation tools, such as sparklines, slicers, and 3D mapping, improve the ability to present data visually appealingly.

Show more

Course Objectives

  • Master Advanced Formulas and Functions: Develop expertise in complex functions like INDEX-MATCH, XLOOKUP, and array formulas for efficient data manipulation
  • Enhance Data Analysis Skills:Perform in-depth data analysis using PivotTables, Power Query, and Excel’s data analysis tools.
  • Automate Tasks with Macros and VBA: Automate workflows by recording macros and writing basic VBA scripts.
  • Manage Large Data Sets: Handle and analyze extensive datasets with Power Pivot, advanced filtering, and data models.
  • Advanced Charting and Visualization:Create and customize advanced charts and develop interactive dashboards.
  • Collaborate and Integrate: Share workbooks, collaborate in real-time, and integrate Excel with other applications like PowerPoint and databases.

Course Curriculum

Introduction
Creating Conditional Formatting using color scales
Using Icon sets
Conditional formatting using New rule
Conditional formatting using manage rules and clear rules

Specifying a valid range of value of a cell
Specifying a valid value for a cell
Specifying custom validation based on formula for a cell
Prevent duplicate entries

Using Range names
Creating range names
Using range names in formulas
Deleting range names
Advanced Range Options

Creating Tables
Naming the Tables
Changing the Table style
Creating a total row
Creating a calculated column
Using FIltering in Table
Removing the duplicate record

Array functions using CTRL+SHIFT+ENTER
One Dimensional Array
Two Dimensional Array
Single cell and Multi cell Array

Text Function
Logical Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and reference functions

Creating a chart
Formatting a chart
Adding Labels
Changing the chart type, Data source
-->

Creating Pivot tables
Adding Pivot table Report Fields
Refreshing Pivot table Reports
Changing the summary functions
Creating report filter page
Creating Subtotals
Multiple Level subtotals
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of pivot table
Pivot charts

Protecting your work sheet
Protecting range with password
Protecting your Workbook and Excel Files
Sharing a workbook
Opening and editing a shared workbook

Goal Seek
Data Tables
Scenario Manager

Import a text file by opening it in excel
Import a text file by connecting to it
Export data to a text file
Changing the delimiter
Change the separator in all .CSV text file

Display the developer Tab
Changing Macro security Settings
Recording and running a Macro
Delete a Macro
VBA (Visual Basic Application)
Advantages and features
VBA Message Box , Comments
InputBox using VBA
Sub and Functions using VBA
VBA Constants , variables
VBA Operators
Loops
VBA Decisions
User form in VBA

Ratings & Reviews

4.5

Rated 4 out of 1 Rating

5 star
82%
4 star
30%
3 star
15%
2 star
6%
1 star
10%

Featured review

Kaviya

2 weeks ago

The advanced Excel course took my skills to the next level. I can now build complex formulas, create dynamic dashboards, and analyze data like a pro. It's been a game-changer for my productivity.

Helpful?

Divya

2 weeks ago

The course covered everything from advanced functions to data visualization. The practical exercises helped me apply what I learned immediately. I now feel much more confident using Excel at work.

Helpful?
This course includes:
Duration 40 hrs
Skill Level Beginner
Language Tamil / English
Certificate Yes