Hands on Training of MS Excel 2013
Sunday, 14 May 2017 from 9:30 AM to 4:30 PM (EDT)
MS Excel 2013
Attend full-day course to learn all what you need to know to start using MS Excel 2013 with confidence. You can also earn 7 PDUs.
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel,
This course covers all the basics you need to start entering your data and building organized workbooks.
You will learn How to enter and organize your data, Perform calculations with simple functions,
Work with multiple worksheets, Format the appearance of your data, and build charts and PivotTables.
We will cover the powerful functions like
Using the Formula bar
Using the Status bar
Entering data with AutoFill
Working with dates and times
Creating simple formulas: Totals and averages
Copying a formula for adjacent cells
Working with relative, absolute, and mixed references
Using SUM and AVERAGE
Formatting numbers and dates
Adjusting Worksheet Layout and Data
Hiding and un-hiding rows and columns
Creating in-cell charts with spark lines
IF, VLOOKUP, and Power Functions
Using IF functions and relational operators
Using the COUNTIF family of functions
Inserting subtotals in a sorted list
Splitting data into multiple columns
Removing duplicate records
Manipulating PivotTable data
Grouping by date and time
Grouping by other factors
Using slicers to clarify and manipulate fields
Using Pivot Charts
You may bring your own laptop preferably with MS Excel 2013 version installed. We will provide PCs if required.
Course Completion Certificate 7 PMI PDUs
Registered courses can be cancelled up to 3 business days before the course start date. Administrative charges equivalent to 10% of the course fee will apply.
* Special Ramdhan timings available
* Due to limited seats, rescheduling is possible
* Course Fee to be paid in advance
Save This Event
When & Where
Uloom Training in Project Management, Business Administration and IT
Uloom training is a seasoned institute with experienced professionals from Project Managment and IT Industry. Our instructors posses over 20 years of IT experience, several years of coaching and training experience and teaching project management and business courses at Uloom Training. Our instructors a PMP certified project managers with additional qualifications like MBA, ITIL Foundation, CISA, Scrum Master and Agile project Management.
We create enriching learning environment using interactive course material, professional discussion and encourage inquiry from students. you may conatct us via firstname.lastname@example.org