Advance Excel
(Knowledge Level)
Smart Skill Council Certification. In Advanced Excel 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.
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
- 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
- Text Wrapping
- 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
- Calendar
- Holidays
- Meal Planner
- Automated Invoice
- 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 & Center
- Borders
- Auto sum
- Quick Insert
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.
- SSC Completed / HSC Completed
- Pursuing or Completed B.COM / BMS / BBA / BBI / BAF / BFM / M.COM / CA / CS.
- Accounting Students
- Other Undergraduates / Graduates.
- SSC : Smart Skill Council Certification.
OR
- DiTRP ( Digital Information Technology & Research For Professional)
OR
- CBITVT : Central Board of IT & Vocational Training.
OR
- MKCL : Maharashtra Knowledge Corporation Limited
45 Days
- Overview
-
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.
- Eligibility Criteria
-
- SSC Completed / HSC Completed
- Pursuing or Completed B.COM / BMS / BBA / BBI / BAF / BFM / M.COM / CA / CS.
- Accounting Students
- Other Undergraduates / Graduates.
- Certification
-
- SSC : Smart Skill Council Certification.
OR
- DiTRP ( Digital Information Technology & Research For Professional)
OR
- CBITVT : Central Board of IT & Vocational Training.
OR
- MKCL : Maharashtra Knowledge Corporation Limited
- Duration
-
45 Days
