Certificate in Advance Excel
In Advanced Excel (Fundamental Course) Short term program, you will learn the most advanced formulas, functions and types of financial analysis which will help you be power user of MS Excel. This Advanced MS Excel training course will build on MS Excel Crash Course and is designed specifically for Excel Spreadsheet users who are already proficient and looking to take their skills to an advanced level. This advanced tutorial will help you become a great MS Excel user. Our instructors will build all the formulas and functions right on for you and, you can easily learn them and master within the time span.
₹3400.00 ₹7000.00 51% OFF
/CourseBundles(18215)/1974997-Advance_Excel_-_Knowledge_Level1.png)
What You’ll Learn
- Understanding Workbook and Worksheet
- Understanding the Ribbon
- Ribbon Tabs
- Accessing the Ribbon by using keyboard
- Customizing the Ribbon
- Customizing Quick Access Toolbar
- Exploring the types of data
- Entering Text and values
- Entering Date and Times
- Modifying cell Contents
- Fundamentals of worksheet
- Controlling the worksheet view
- Working with rows and columns
- Rename Worksheet
- Changing Sheet colour
- Hiding rows and columns
- Freeze Panes
- Understanding Cell and Ranges
- Copying or Moving Ranges
- Adding Comments to cell
- Fill series
- Creating Tables
- Formatting Table
- Table Name
- Converting a table back to a range
- Understanding Formula basics
- Editing Formulas
- Using Formula in Table
- Entering Formulas in worksheet
- Entering formulas manually
- Using relative, Absolute and Mixed reference
- Reference data in a table
- Using Different fonts to format worksheet
- Text Alignment
- Colour and shading
- Text wrapping
- Adding Borders and Line
- Adding background image to worksheet
- Customising Workbook
- Customise colour of cell borders
- Customise column in to numbers
- Customise appearance of Workbook
- Customise List range
- Data entry Form Creation
- Design Bank ATM Form
- Design Receipt
- Design Voucher
- Company Logos
- Design Data Chart
- Design Company Invoices
- Calendar Design
- Budget Template
- Calendar Template
- Holidays Template
- Meal Planner Template
- Invoice Template
- Automated Invoice Template
- Changing page view
- Adjusting common page setup settings
- Adding header or footer to report
- Printing multiple copies of a report
- SUM
- SUBTOTAL Function
- SUBTOTAL command
- Auto sum
- IF statement
- Freezing panes and view option.
- Sorting data
- Filtering data
- Format Column Heading and Totals
- Bold Format
- Data Alignment
- Wrap Text
- Merge & Centre
- Borders
- Auto sum
- Quick Insert
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy