Power Yourself with MS Excel
( 
Microsoft Certified Training)
Microsoft Certified Training)with
Certificate of Excellence from Microsoft &
Official Courseware from Microsoft
( Microsoft Course Code:55271)
Course outline
- Creating a Microsoft Excel Workbook
- The Ribbon
- The Backstage View (The File Menu)
- The Quick Access Toolbar
- Entering Data in Microsoft Excel Worksheets
- Formatting Microsoft Excel Worksheets
- Using Formulas in Microsoft Excel
- Working with Rows and Columns
- Editing Worksheets
- Finalizing & Print Microsoft Excel Worksheets
Delivery Type: Live Online (VILT)
Date and Time
11th to 12th July, Sat and Sun ( 9am to 12 pm)
(Total 2 sessions of 3 hours each) – 6 hours of Learning Content
COMPLIMENTARY
with either of the Modules – Intermediate & Advanced/ Data Analysis, Dashboard, Power BI with MS Excel
( Microsoft Course Code : 55269 & 55270)
Course Outline
- A. Intermediate (Microsoft Course Code : 55269)(6 Hours)
- Advanced Formulas
- Working with Lists
- Working with Illustrations
- Visualizing Your data
- Working With Tables
- Advanced Formatting
- B. Advanced (Microsoft Course Code : 55270) (9 hours)
- Using Pivot Tables
- Auditing Worksheets
- Data Tools
- Outlining & Grouping Data
- Working with Others (Protecting Worksheets and Workbooks, Tracking Changes, Marking a Workbook as Final etc.)
- Recording and Using Macros
- Sparklines
- Microsoft Translator
- Importing &. Exporting Files
- Using the Cloud
Delivery Type: Live Online (VILT)
Date and Time
13th July to 17th July – 6 pm to 9pm
(Total 5 sessions of 3 hours each) – 15 hours of Learning Content
Price : Rs.5,000/- Rs. 2,499/-
( Microsoft Course Code : 22779)
Course Outline
- Data Analysis in Excel
- Building Dashboard
- The excel Data Model
- Importing data from Files
- Importing Data from Databases
- Importing data from Excel Reports
- Creating and Formatting Measures
- Visualising data in Excel
- Data Modeling with MS Excel
Delivery Type: Live Online (VILT)
Date and Time
20th July to 29th July (excluding Sat & Sun) 6 pm to 9pm
(Total 8 sessions of 3 hours each) – 24 hours of Learning Content
Price : Rs. 7,500/-Rs. 3,499/-
On purchasing both, additional discount of 10% – Use code: SPECIAL10
Enquiry Form
Disclaimer:
1. Course coverage’s are indicative and all the trademark, courses, modules, products, logo, names, brands, contents etc belongs to their respective owners/company.
2. Training are organized by TAI and delivered by TAI Associates and Partners viz. RPS, QUINT, Tecnocrate, Red Education etcwho are Authorized Training Partners of respective OEM’s
