## Mastering Excel

In this excel blog, you will learn some of the amazing things which will add real value to your professional career. You are going to learn right from basic to some of the advanced stuffs with this blog.

We have covered formulas, Tools, charts, productivity techniques,Useful Excel Tips, Different kinds of formula with practical approach…

Excel is the universal language which speaks in all the offices. So learning this software tool is key at your workplace to go a long way. Efficient ways of using excel is vital in increasing productivity at your workplace.

### Microsoft Office Tools

#### WHAT YOU’LL LEARN

Microsoft Office Tools plays a vital role in almost all the offices in modern days. I would this is like how our universal language “English” is for communication, similarly for all kinds of data driven work Microsoft Office Tools are universal products.

This is one aspect of Microsoft Office Tools and on the other hand knowing how to work with them will give you an edge at your work place. Mastering Microsoft Office Tools will definitely add value to your professional “CV”.

#### 15 RESOURCES

- Powerful Features of Microsoft Access
- Create Database Using Microsoft Access
- How to Unlock the Potential of OneNote
- Project Plan In MS Project
- Creating Amazing MS PowerPoint Presentations
- Get Started with Microsoft Word
- Exciting Things About Microsoft Office
- Ms Word Software
- Office Suite Applications For Your Android Device
- Image In An InDesign Document
- You Wanted to Know About MS Office
- Microsoft Word Features you Easy Working
- Powerful Features of Microsoft Access
- Presentation Using Powerpoint
- Cheat Sheet Word

### Excel Formula and Functions

#### WHAT YOU’LL LEARN

Once you finish basic stuffs with excel learning how do we advance to next level, is the common question runs in every advance excel aspirant.

After the basic thing you need to understand the version of excel you are working on and what the additional formulas in that version are of excel. You need to concentrate on some of the essential formulas which will be used day in day out at your work place for smooth operating of work. In this blog you will see some of the important formula, automation through VBA macros, new features of Excel 2016 version, interactive dashboards, efficient shortcut keys etc…

#### 21 RESOURCES

- Excel SUM MAX MIN AVERAGE
- Excel Print Command
- Common Excel Errors
- Excel Made Easy For Dummies
- Basic Excel Formulas Useful
- Improve Work Performance
- What’s New In Excel 2016? Know Its 10 Wonderful Features
- Create Interactive Excel Dashboard
- Microsoft Excel Shortcuts
- Improve your Microsoft Excel Skills?
- How to Use Microsoft Excel – For Beginners
- Advanced Excel Formulas and Functions
- Features of 2016 Excel Workbook
- Pivot Chart in Excel 2016
- Excel Sum Time
- Excel Function for Range
- Excel Calculations
- Payroll in Excel
- Complex Formulas in Excel
- Advanced Formulas in Excel
- VLOOKUP Names

### MS Excel Shortcuts

#### WHAT YOU’LL LEARN

How can we work faster in Excel, is the common question we all have asked experts while learning excel at the beginning. If you are still struggling to find the best resource to learn MS Excel Shortcut keys then this blog is right up there with a wide variety of shortcut keys. In this blog, you will learn shortcut keys case study, selection shortcut keys, formatting shortcut keys, how to navigate in excel worksheet through shortcut keys, and also this blog covers data inputs in excel worksheet.

#### 4 RESOURCES

- Excel Tutroial Case Study
- Excel Tutorial Data Inputs
- Excel Shortcuts format and navigation
- Best Excel Shortcuts Selection, data and formula

### Workplace Productivity

#### WHAT YOU’LL LEARN

Productivity is the something your hiring manager expects from you on an hourly basis. Only way you can increase your work place productivity is by mastering the tools you working on.

Often times we follow the old traditional methods to work but we don’t realize the fact that we can minimize those steps to increase our productivity. Keeping this in mind in this blog we will show you “tricks that we can use in Microsoft Office Tools”, “tricks that can be vital in operating system Windows 10”, “office product productivity tools”.

And some of the must know productivity tools related to Microsoft products category.

#### 4 RESOURCES

- Office Productivity Tips
- Improve Productivity in Office
- Productivity tricks and Tips for Windows 10
- Software Tools to Create Great Presentations

### Excel Functions

#### WHAT YOU’LL LEARN

Is it necessary to all the functions in excel??

Simply the answer is “not necessary”. Imagine you are an accounting professional and by learning engineering functions nowhere going to help you. Yes it is good know new things outside your professionalism but at the start not required.

In this blog we will show you formulas like MOD Function, SWITCH Function, AVERAGIF Function, FV Function, etc… And part from these functions you will also learn different types of charts like “bar chart, scatter chart as well.

#### 14 RESOURCES

- Excel MOD Function
- RANK Excel Function
- LINEST Excel Function
- Excel Bar Chart
- Excel Scatter Chart
- Simple Formula in Excel
- Excel SWITCH Function
- Excel AVERAGEIF
- Excel FV Formula
- User Defined Function in Excel
- Sentence Case in Excel
- VLOOKUP to Return Multiple Values
- Excel Column Total
- Excel Shortcut Paste Values

### Lookup & Reference Functions in Excel

#### WHAT YOU’LL LEARN

Out of all the excel functions lookup and reference category functions are the most often used functions. VLOOKUP rules all the lookup functions. In this blog we dedicatedly discuss the formulas in the category of lookup and reference functions.

We will see some of the important lookup functions like VLOOKUP, HLOOKUP, INDEX, IFERROR with VLOOKUP, LOOKUP function, CHOOSE function etc.…

And also we will see some of the reference functions like COLUMN, TRANSPOSE, and VALUE etc… We will also cover practical examples like “How to Match Data in Excel”, “Error Fixing in VLOOKUP function”.

#### 35 RESOURCES

- LOOKUP in Excel
- TRANSPOSE in Excel
- Choose Function in Excel
- COLUMN Function in Excel
- INDIRECT Function in Excel
- HLOOKUP Function in Excel
- MATCH Function in Excel
- VLOOKUP Function in Excel
- OFFSET Excel Function
- Excel VALUE Function
- Excel GETPIVOTDATA Function
- Excel REPLACE Function
- Excel COLUMNS Function
- Address Excel Function
- HYPERLINK in Excel
- Excel ROW Function
- IFERROR with VLOOKUP in Excel
- Fixing VLOOKUP Errors
- Excel VLOOKUP From Another Sheet
- VLOOKUP with Sum
- Excel Alternatives to VLOOKUP
- HLOOKUP Examples
- Excel INDEX Function
- CHOOSE Formula in Excel
- Excel Match Function
- Excel Lookup Function
- Excel OFFSET Formula
- Excel COLUMN to Number
- IF VLOOKUP Formula in Excel
- Mixed Reference in Excel
- VLOOKUP Table Array
- How to Match Data in Excel
- VLOOKUP For Text
- ROWS Function in Excel
- VLOOKUP True

### Financial Functions in Excel

#### WHAT YOU’LL LEARN

If you are working in any back or financial institutions then you must know financial functions in excel. Just imagine yourself in a loan department of the bank and you are required to tell the monthly EMI amount to the customer based on loan amount, tenure and interest rate. With the help of PMT function in excel you can quickly tell the monthly EMI amount to the customer.

In this blog we will show you Present Value Function (PV), Future Value Function (FV), Net Present Value Function (NPV), Payment Function (PMT), investment function like IRR, MIRR, RATE function, XIRR, IPMT function etc.…

#### 19 RESOURCES

- FV Function in Excel
- IPMT in Excel
- XIRR In Excel
- PMT Function in Excel
- IRR Function in Excel
- RATE Function in Excel
- NPV Function in Excel
- YIELD Excel Function
- PV Excel Function
- MIRR Excel Function
- Excel PRICE Function
- Standard Deviation in Excel
- Excel PV Formula
- Excel RATE Formula
- NPER in Excel
- MIRR Formula in Excel
- NPV Formula in Excel
- PPMT Function in Excel
- NPER Function in Excel

### Maths Function in Excel

#### WHAT YOU’LL LEARN

Excel formula has categories based on the result of each function, so similarly we have a group called “Math Functions in excel”.

In this blog you will learn how to convert negative numbers to positive numbers using ABS function, how to generate random fraction numbers using RAND function, how to sum numbers using SUM function, how to round down decimal numbers using ROUNDDOWN function, how to round up using ROUNDUP. Apart from this you will learn functions like POWER, TAN, LOG, LN, SUMPRODUCT etc.…

#### 48 RESOURCES

- EVEN Function in Excel
- SUM Function in Excel
- POWER Function in Excel
- SUMIF Function in Excel
- LOG Function in Excel
- FLOOR Excel Function
- AGGREGATE Function in Excel
- SUBTOTAL in Excel
- LN Function in Excel
- Excel RAND Function
- ODD Excel Function
- COS Function in Excel
- COMBIN Function in Excel
- ABS Function in Excel
- INT Excel Function
- Excel TAN Function
- SUMPRODUCT Function in Excel
- ROUND Excel Function
- Excel ROUNDDOWN Function
- Excel ROUNDUP Function
- Excel Square Root Function
- Excel Running Total
- Excel Exponents
- Excel SIN Function
- SUMPRODUCT Formula in Excel
- Excel Rounding
- Excel SUMIF with OR
- Excel SUMIFS with Dates
- SUMIF with Multiple Criteria
- Sumif Between Two Dates
- SUMIF Formula in Excel
- How to SUM in Excel
- Calculations in Excel
- Sumif Function Examples
- ROUND Formula in Excel
- Matrix in Excel
- PRODUCT Function in Excel
- How to Sum Multiple Rows in Excel
- Calculate Income Tax in Excel
- RANDBETWEEN in Excel
- MROUND in Excel
- SUMIF with Text
- Excel DEGREES Function
- Trunc in Excel
- MMULT in Excel
- MINVERSE in Excel
- SUM Cells in Excel
- Calculating Investment Return In Excel

### Excel Tools

#### WHAT YOU’LL LEARN

Knowing what are the tools excel has and how to work with plays a key role in how long you go in your excel learning. Using excel tools is key in increasing the work productivity at your work place.

So keeping this in mind we have created this blog which will cover some of the key excel tools like What-If-Analysis in Excel, Quick Access Toolbar (QAT), Advanced Filter, Data Sorting, Conditional Formatting, Combining two columns data into one etc…

#### 111 RESOURCES

- TANH Function in Excel
- Scrollbar in Excel
- Excel List box
- Excel Solver Tool
- CheckBox in Excel
- Text to Columns in Excel
- Excel Combo Box
- Excel Table
- Goal Seek in Excel
- Data Table in Excel
- Excel Radio Button
- Excel Data Validation
- Excel Data Filter
- Advanced Filter in Excel
- Auto Format in Excel
- Excel Lock Formula
- Excel Fill Handle
- One Variable Data Table in Excel
- Two Variable Data Table in Excel
- Merge Cells in Excel
- Excel AutoFilter
- Record Macro in Excel
- Excel Forms for Data Entry
- Excel Dynamic Range
- Excel Sort by date
- Dynamic Tables in Excel
- Excel Wrap Text
- Excel Conditional Formatting in Pivot Table
- Excel Merge Two Tables
- Excel ANOVA
- Excel Quick Access Toolbar
- Excel Auto Fill
- Excel Tool for Data Analysis
- Excel Exponential Smoothing
- Excel Flash Fill
- Excel Data Bars
- Excel Sort by color
- Excel Sorting
- QUOTIENT in Excel
- Excel Drawing
- Protect Sheet in Excel
- Convert Numbers to Text in Excel
- Range in Excel
- Timeline in Excel
- Excel Table styles
- Insert New Worksheet in Excel
- Excel Column Lock
- Print Gridlines in Excel
- Excel Calendar
- Check mark in Excel
- Excel Header and Footer
- Excel Column Filter
- Excel Developer Tab
- Spelling Check in Excel
- Excel Error Bar
- Excel Enable Macros
- Excel Status Bar
- Excel Spreadsheet Formulas
- Excel Gridlines
- Excel Sort By Number
- Excel Merge and Center
- Excel Freeze Rows
- Excel Toolbar
- Excel Heat Map
- Excel Autosave
- Excel Freeze Panes
- Excel Import Data
- Excel CTRL D
- Excel Accounting Number Format
- Excel Regression Analysis
- Excel Named Range
- Excel Concatenating Columns
- Excel AutoCorrect
- Excel Icon Sets
- Conditional Formatting For Blank Cells
- Excel Create Database
- Excel Conditional Formatting for Dates
- Excel TRANSPOSE Formula
- HLOOKUP Formula in Excel
- How to Print Labels From Excel
- Solve Equation in Excel
- Excel Quick Analysis
- What If Analysis in Excel
- Excel Spreadsheet Examples
- Pivot Table Filter
- Name Box in Excel
- Pivot Table Examples
- Freeze Columns in Excel
- Watch Window in Excel
- Examples of Excel Macros
- Slicer in Excel
- Pivot Table Slicer
- Power View in Excel
- Data Model in Excel
- Consolidation in Excel
- Ribbon in Excel
- Power Query in Excel
- XML in Excel
- Excel Evaluate Formula
- How to Unhide All Sheets in Excel?
- Timecard Template in Excel
- Compare Two Lists in Excel
- Form Controls in Excel
- Excel Repair
- Color in Excel
- Pivot Table Count Unique
- Excel Business Plan Template
- Estimate Template in Excel
- CSV Files into Excel
- Excel Export to PDF
- Free Excel Template

### TEXT and String Functions in Excel

#### WHAT YOU’LL LEARN

Working with strings and numbers two different things in excel. So we have category of text and string functions in excel.

How do you substitute one string with another?? We can do this with SUBSTITUTE formula which is covered in this blog. Similarly to combine different cells data into one we will use CONCATENATE function, to remove unwanted spaces we use TRIM function, to find the number of characters in a cell we use LEN function, to extract number of characters from the left side of the string we have LEFT function, to make the string or text proper sentence we use PROPER function and many more TEXT and String functions are covered in this blog.

#### 25 RESOURCES

- TEXT Function in Excel
- FIND Function in Excel
- CONCATENATE Function in Excel
- MID Function in Excel
- Search Function in Excel
- LEN Function in Excel
- RIGHT Function in Excel
- SUBSTITUTE Function in Excel
- Excel LEFT Function
- Excel CLEAN Function
- Excel CHAR Function
- PROPER Function in Excel
- Excel EXACT Function
- Excel TRIM Function
- Excel CODE Function
- Excel REPT Function
- Substring Excel Function
- Excel Find
- TRIM Formula in Excel
- Left TRIM in Excel
- LEFT Formula in Excel
- VALUE Formula in Excel
- Opposite of Concatenate in Excel
- Concatenate Strings in Excel
- Extract Numbers From String

### Logical Functions in Excel

#### WHAT YOU’LL LEARN

Calculations are easy in excel but if you want to do the calculations based on some logic then it requires logical functions to be used in excel.

We have different kind of logical functions like AND, OR, IF, TRUE, FALSE, XOR, NOT, IFERROR. We will show you all of these formulas with practical approach. You will get to know the scenarios of using these logical tests at your work place.

#### 11 RESOURCES

- AND Function in Excel
- NOT in Excel
- OR Function in Excel
- TRUE Function in Excel
- IFERROR Excel Function
- Excel XOR Function
- Excel Logical Test
- Excel IF AND Function
- Excel IF Function
- FALSE Function in Excel
- Logical Functions in Excel

### Excel Tips

#### WHAT YOU’LL LEARN

You must have come across many tips with excel. On similar note in this blog we are providing some of the important tips with regards to excel.

Number Formatting with Excel, Switching Columns to Row, Protecting and unprotecting the sheet, Excel vs CSV, Concatenation in Excel, Errors in Excel, Working with unwanted spaces, References, Drop Down List, Chart Wizard to create charts in excel, sorting data, working with external links with excel.

#### 220 RESOURCES

- Microsoft Office Tricks
- CEILING Function in Excel
- Unhide Columns in Excel
- Excel Absolute Reference
- Excel Data Formatting
- Excel Insert Multiple Rows
- Excel Combine cells
- Superscript in Excel
- Subscript in Excel
- Remove (Delete) Blank Rows in Excel
- Relative Reference in Excel
- Remove Hyperlinks in Excel
- Excel Drop Down List
- Cheat Sheet of Excel Formulas
- Column Sort in Excel
- Excel Spell Check
- Print Comments in Excel
- Excel CAGR Formula
- Page Numbers in Excel
- Count Unique Values in Excel
- Excel Pivot Table
- Subtraction in Excel
- Excel Delete Pivot Table
- Errors in Excel
- Highlight Every Other Row in Excel
- Basic Excel Formulas
- Random Numbers in Excel
- Copy Excel Sheet
- Excel Highlight Duplicates
- Excel Conditional Formatting Based on Another Cell Value
- Excel Remove Duplicates
- Excel Calculate Age
- Excel Remove Spaces
- Not Equal To Excel
- Excel Compare Two Columns
- Excel Filter Shortcuts
- Divide in Excel Formula
- Excel Unmerge Cells
- Excel Circular Reference
- Excel Split Cell
- Excel Cell Reference
- Excel Insert Row Shortcut
- Excel Extensions
- Excel Rows to Columns
- Excel Paste Shortcut Option
- Excel Columns to Rows
- Excel Autofit
- Excel Format Painter
- Excel Separate text
- Excel Absolute Value
- Print Area in Excel
- Excel Row Limit
- Excel Moving Averages
- Protect Excel Workbook
- Excel Hide Formula
- Excel 3D Reference
- Excel Show Formula
- Excel Sparklines
- Excel Track changes
- Excel Drawing a line
- Multiple IFS in Excel
- Formula Bar in Excel
- Strikethrough in Excel
- Excel vs Access
- Numbering in Excel
- Share Excel Workbook
- Excel Row vs Excel Column
- Excel Shortcut For Merge Cells
- Excel OneDrive
- Excel Unprotect Sheet
- Count Characters in Excel
- Excel Group
- Excel Rows and Columns
- Excel Move Columns
- Excel Translate
- Excel Row Height
- Excel Text Compare
- Excel Uppercase Function
- Excel Auto Numbering
- Watermark in Excel
- Excel Word Count
- Excel Delete Row Shortcut
- Excel Percentage Difference
- Excel Header Row
- Calculate Percentage Increase in Excel
- Fractions in Excel
- Excel Format Phone Numbers
- Excel Search Box
- Excel Print
- Excel Add a Column
- Borders in Excel
- Excel Formula of Percentage
- Excel Row Count
- Excel Grade Formula
- Excel Operators
- Excel Keyboard Shortcuts
- Create Excel Template
- Excel Greater than or Equal
- Excel Change Case
- SUMPRODUCT Function with Multiple Criteria
- Excel Leading Zeros
- Excel Bullet Points
- Excel Remove Leading Spaces
- Combine First and Last Name in Excel
- How to Calculate Ratio in Excel
- Calculate Compound Interest in Excel
- Excel Concatenate Date
- Find External Links in Excel
- Excel Comma Style
- Convert Excel to CSV
- Excel vs CSV
- Excel vs Numbers
- Excel Sum by Color
- Timesheet in Excel
- Excel vs Google Sheets
- Text Formula in Excel
- Nested IF Formula in Excel
- Concatenation in Excel
- LEN Formula in Excel
- Excel Insert Page Break
- Insert Comment in Excel
- Themes in Excel
- Group Worksheets in Excel
- Excel ISNUMBER Formula
- 3D Maps in Excel
- VLOOKUP Tutorial in Excel
- Moving Columns in Excel
- Grouping Columns in Excel
- Excel IRR Formula
- OR Formula in Excel
- Pivot Table Sort
- WEEKDAY Formula in Excel
- Pivot Table Formula in Excel
- Time Difference in Excel
- Chart Wizard in Excel
- How to Edit Drop Down List in Excel?
- Lookup Table in Excel
- SUBTOTAL Formula in Excel
- LOOKUP Formula in Excel
- SEARCH Formula in Excel
- Pivot Table with Multiple Sheets
- HYPERLINK Formula in Excel
- COLUMNS Formula in Excel
- INDIRECT Formula in Excel
- DAY Formula in Excel
- RIGHT Formula in Excel
- Evaluate Formula in Excel
- TODAY Formula in Excel
- Poisson Distribution in Excel
- YEAR Formula in Excel
- Excel Text with Formula
- REPLACE Formula in Excel
- Create Spreadsheet in Excel
- How to Find Mean in Excel
- How to Add Cells in Excel
- Project Timeline in Excel
- Excel Insert Button
- Database Function in Excel
- Budget in Excel
- Alternate Row Color Excel
- Switching Columns in Excel
- VLOOKUP Examples in Excel
- Checklist in Excel
- Column Header in Excel
- 3D Cell Reference in Excel
- Matching Columns in Excel
- Roadmap Template in Excel
- Break Links in Excel
- Cell References in Excel
- KPI Dashboard in Excel
- Excel Automation
- Insert Calendar in Excel
- Page Setup in Excel
- Search For Text in Excel
- Wildcard in Excel
- Excel Mortgage Calculator
- Line Break in Excel
- NULL in Excel
- Family Tree in Excel
- Excel Hacks
- Invoice Template in Excel
- Find and Replace in Excel
- PowerPivot in Excel
- Delta Symbol in Excel
- Linear Interpolation in Excel
- Excel Not Responding
- Project Management Template in Excel
- Embedded in Excel
- Count Colored Cells in Excel
- INDEX MATCH Function in Excel
- Shade Alternate Rows in Excel
- Excel Database Template
- Inverse Matrix in Excel
- Format Cells in Excel
- Vlookup vs Index Match
- Blank Invoice Excel Template
- Excel Expense Tracker
- New Line in Excel Cell
- Weighted Average in Excel
- CTRL Shift-Enter in Excel
- Excel Timesheet Template
- Exponential Moving Average Formula
- Write Formula in Excel
- Excel Reverse Order
- Drag and Drop in Excel
- Percent Change in Excel
- Negative Numbers in Excel
- Worksheets in Excel
- Excel Match Multiple Criteria
- Carriage Return in Excel
- Unprotect Excel Workbook
- Subtract Date in Excel
- Excel Troubleshooting
- Autofit Row Height in Excel
- Formatting Text in Excel
- Divide Cell in Excel
- Add Rows in Excel Shortcut
- Compare Two Columns in Excel for Matches
- Auditing Tools in Excel
- Recover Document in Excel

### Statistical Functions in Excel

#### WHAT YOU’LL LEARN

Statistics plays a vital role in decision making. Before we make the report ready we must use some of the statistical functions in excel.

How do you find the maximum value from the lot??? Use MAX function.

How do you find the Xth small value from the lot??? Use SMALL function.

How do you find the Xth largest value from the lot??? Use LARGE function.

Like this we can use statistical tests like P Value, F Test, Trend line, Frequency function, Forecast function etc.…

#### 56 RESOURCES

- Excel AVERAGE Function
- Excel CORREL Function
- Excel Count Function
- COUNTIF Excel Function
- FREQUENCY Excel Function
- Excel LARGE Function
- SMALL Excel Function
- Excel MIN Function
- MAX Excel Function
- Excel Forecast Function
- SLOPE Excel Function
- Excel TREND Function
- MODE Excel Function
- Excel PERCENTILE Function
- Excel QUARTILE Function
- Excel T.Test Function
- Excel Median Function
- COUNTIF with Multiple Criteria
- DCOUNT Function in Excel
- Excel Frequency Distribution
- Excel STDEV Function
- Excel F-Test
- Excel Trendline
- Excel Formula For Rank
- Excel MAX IF Function
- Z TEST in Excel
- COUNTIF Examples in Excel
- Excel Average Formula
- Excel Correlation Matrix
- Excel Z Score
- Excel Percentile Formula
- Excel Frequency Formula
- Excel Variance
- COUNTIF Formula in Excel
- Excel Standard Deviation Formula
- Excel GROWTH Formula
- COUNTIF Not Blank in Excel
- Excel P Value
- Excel Median Formula
- Excel Chi Square Test
- Count Formula in Excel
- Lognormal Distribution in Excel
- FORECAST Formula in Excel
- Normal Distribution Formula in Excel
- Count Cells with Text in Excel
- Count Names in Excel
- COUNTA Function in Excel
- MAX Formula in Excel
- Excel NORMSINV
- Linear Regression in Excel
- COUNTIFS in Excel
- Interpolate in Excel
- Linear Programming in Excel
- Confidence Interval in Excel
- Statistics in Excel
- COUNTIFS with Multiple Criteria

### Date and Time Function in Excel

#### WHAT YOU’LL LEARN

To work with date and time in excel you must know how excel works with them. Excel stores date and time as serial numbers.

How do you add two dates, will be covered in this blog. How do you know the current date, this will be done by using TODAY function, How do you know the current date and time, this will be done by using NOW function.

NETWORKDAYS to calculate the number of days between two dates excluding weekends and holidays. EOMONTH to calculate the end of the month date for the provided date, subtracting time values etc.…

#### 23 RESOURCES

- Excel Date Function
- Time Function in Excel
- TODAY Excel Function
- NOW Excel Function
- DAY Excel Function
- YEAR in Excel
- WEEKDAY Function Excel
- WORKDAY Excel Function
- EOMONTH Function Excel
- Excel Month Function
- NETWORKDAYS Excel Function
- EDATE Excel Function
- Excel DATEVALUE Function
- Excel DATEDIF Function
- Excel Formula for Weekday
- Excel Add Months to Dates
- Excel Week Numbers
- Excel Insert Date
- Excel Date Format
- Excel Subtract Time
- Date Formula in Excel
- EOMONTH Formula
- Compare Dates in Excel

### Information Functions in Excel

#### WHAT YOU’LL LEARN

In order to get the information regarding to specific cell we have certain built-in formulas in excel.

How do you identify whether the cell is blank or not???

Whether the value in the cell is number or not???

Is the value in the cell is #N/A or not???

Check whether the cell contains an error or not???

All these things can be done by using information function like ISBLANK, ISNUMBER, ISNA, and ISERROR functions.

#### 4 RESOURCES

### Excel Charts

#### WHAT YOU’LL LEARN

Charts tell the story better than the numbers alone can tell. So in excel we have variety of built-in charts to show the numbers. Charts are mainly used for presentation and dashboard purpose.

In this blog you will learn built-in charts like Pie Chart, Stacked Area Chart, Bubble Chart, Clustered Chart, etc.…

On top these built-in charts we can create our own charts like Waterfall Chart, Gauge Chart, Dynamic Chart, Pivot Chart, Combination Charts and many.

#### 56 RESOURCES

- Excel Pie Chart
- Excel Column Chart
- Excel Clustered Bar Chart
- Excel Area Chart
- Excel Gantt Chart
- Excel Waterfall Chart
- Excel Stacked Area Chart
- Histogram Chart Excel
- Excel Stacked Column Chart
- Excel Bubble Chart
- Excel Dynamic Chart
- Clustered Column Chart in Excel
- Excel Pivot Chart
- Excel Gauge Chart
- Excel Combination Charts
- Excel Scatter Chart
- Excel Line Chart
- Excel Flowchart
- Excel Types of Graphs
- Excel 3D Plot
- Excel Doughnut chart
- Excel Organization Chart
- Legends in Excel Chart
- Excel Chart Templates
- Excel Normal Distribution Graph
- Excel Stacked Bar Chart
- Excel Bell Curve
- S CURVE in Excel
- Pie Chart Examples
- Box and Whisker Plot in Excel
- Map Chart in Excel
- Candlestick Chart in Excel
- Contour Plots in Excel
- Marimekko Chart Excel
- Combo Chart in Excel
- Radar Chart in Excel
- Control Charts in Excel
- Dot Plots in Excel
- Dashboard in Excel
- Project Management with Gantt Chart
- Change Chart Style in Excel
- 3D Scatter Plot in Excel
- Venn Diagram in Excel
- Grouped Bar Chart
- Excel Animation Chart
- Box Plot in Excel
- Excel Calendar Template
- Bullet Chart in Excel
- Thermometer Chart in Excel
- Comparison Chart in Excel
- Pareto Analysis in Excel
- Add a Secondary Axis in Excel
- Surface Charts in Excel
- Plots in Excel
- Interactive Chart in Excel
- Excel Data Visualization