EXCEL 2016 ADVANCED

EXCEL 2016 ADVANCED


Take This Course $750

by iCoursetraining

By completing our Excel 2016 Advanced Course - you will be fully prepared to pass the Microsoft Office Specialist exam in Excel; Exam-427 and Exam-428.  This course teaches the intermediate to advanced functions and features of Excel and includes the new additional project requirements in the newest exam releases.

MODULE 1: COURSE INTRODUCTION

MODULE 2: MACROS AND CUSTOMIZATION

MODULE 3: INTERMEDIATE WORKSHEET SKILLS

MODULE 4: MANAGING WORKBOOKS

MODULE 5: INTERMEDIATE FORMULAS

MODULE 6: ADVANCED FORMULAS

MODULE 7: CHARTS, GRAPHS, AND OBJECTS

MODULE 8: APPLYING CUSTOM FORMATS AND LAYOUTS

MODULE 9: CONCLUSION

MODULE 10: PROJECTS

View All Users Who Viewed This Course Also Viewed

iCoursetraining

iCoursetraining

iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules.  Our online classes allow students to take courses at their own pace and schedule with step by...More

Other Courses from iCoursetraining

 
Average Rating:

Reviews

  • Muhammet
    Module 8, Lesson 1 is wrong located. Please check.
  • Sandra OBrien
    It would be very helpful to have some of the data workbooks to actually perform some the functions being taught, while being taught. 2 tutorials did not start. It would have been helpful to have
  • Takudzwa Mandizha
    Amazing information
You need to take this course before viewing its lesson.
Take This Course $750
(default) 22 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Advertiser`.`id`, `Advertiser`.`title`, `Advertiser`.`description`, `Advertiser`.`link`, `Advertiser`.`button_title`, `Advertiser`.`logo`, `Advertiser`.`logo_blob`, `Advertiser`.`status`, `Advertiser`.`created`, `Advertiser`.`modified` FROM `1337iot`.`advertisers` AS `Advertiser` WHERE `status` = 1 ORDER BY rand() ASC LIMIT 1001
2SELECT `Configuration`.`id`, `Configuration`.`heading`, `Configuration`.`default_header`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `1337iot`.`configurations` AS `Configuration` WHERE 1 = 128280
3SELECT `Cmspages`.`name`, `Cmspages`.`seourl` FROM `1337iot`.`cmspages` AS `Cmspages` WHERE `Cmspages`.`showinfooter` = '1' AND `Cmspages`.`status` = '1' ORDER BY `Cmspages`.`name` ASC550
4SELECT `UserViewCourse`.`id`, `UserViewCourse`.`user_id` FROM `1337iot`.`user_view_courses` AS `UserViewCourse` WHERE `UserViewCourse`.`course_id` = 154510100
5SELECT distinct(`UserViewCourse`.`course_id`), `Course`.`id`, `Course`.`title`, `Course`.`subtitle`, `Course`.`price`, `Course`.`coverimage`, `Course`.`user_id`, (select count(*) as countstudent from user_learning_courses as UserLearningCourse where `UserLearningCourse`.`course_id` = `UserViewCourse`.`course_id`) AS `UserViewCourse__students`, (select avg(rating) rating from course_reviews CourseReview where `CourseReview`.`course_id` = `UserViewCourse`.`course_id`) AS `UserViewCourse__review`, (select concat(`Userdetail`.`first_name`,' ',`Userdetail`.`last_name`) as name from userdetails as Userdetail where `Userdetail`.`user_id` = `Course`.`user_id`) AS `UserViewCourse__name` FROM `1337iot`.`user_view_courses` AS `UserViewCourse` LEFT JOIN `1337iot`.`users` AS `User` ON (`UserViewCourse`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`courses` AS `Course` ON (`UserViewCourse`.`course_id` = `Course`.`id`) WHERE `UserViewCourse`.`user_id` in (29914,30099,31312,29754,32069,32072,29583,31247,29013,30547) LIMIT 3332
6SELECT `CourseReview`.`rating`, `CourseReview`.`Created`, `CourseReview`.`review_text`, `Userdetail`.`first_name`, `Userdetail`.`last_name`, `Userdetail`.`image`, `Userdetail`.`user_id`, (select avg(rating) from course_reviews CourseReview where `CourseReview`.`course_id` =1545) AS `CourseReview__avgrating` FROM `1337iot`.`course_reviews` AS `CourseReview` LEFT JOIN `1337iot`.`userdetails` AS `Userdetail` ON (`Userdetail`.`user_id` = `CourseReview`.`user_id`) WHERE `CourseReview`.`course_id` = 1545 LIMIT 3330
7SELECT COUNT(*) AS `count` FROM `1337iot`.`course_reviews` AS `CourseReview` LEFT JOIN `1337iot`.`users` AS `User` ON (`CourseReview`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`courses` AS `Course` ON (`CourseReview`.`course_id` = `Course`.`id`) WHERE `CourseReview`.`course_id` = 1545110
8SELECT `CourseSection`.`id`, `CourseSection`.`course_id`, `CourseSection`.`heading`, `CourseSection`.`section_index`, `CourseSection`.`prev`, `CourseSection`.`created`, `CourseSection`.`modified` FROM `1337iot`.`course_sections` AS `CourseSection` WHERE `CourseSection`.`course_id` = 154510100
9SELECT `CourseLecture`.`id`, `CourseLecture`.`course_id`, `CourseLecture`.`course_section_id`, `CourseLecture`.`heading`, `CourseLecture`.`course_description`, `CourseLecture`.`content`, `CourseLecture`.`content_type`, `CourseLecture`.`content_title`, `CourseLecture`.`content_external_link`, `CourseLecture`.`content_source`, `CourseLecture`.`supplimentary_material`, `CourseLecture`.`lecture_index`, `CourseLecture`.`prev`, `CourseLecture`.`live_status`, `CourseLecture`.`file1_upload`, `CourseLecture`.`file2_upload`, `CourseLecture`.`created`, `CourseLecture`.`modified` FROM `1337iot`.`course_lectures` AS `CourseLecture` WHERE `CourseLecture`.`course_section_id` IN (2817, 2818, 2819, 2820, 2821, 2822, 2823, 2825, 2826, 2827) 34340
10SELECT `CourseQuiz`.`id`, `CourseQuiz`.`course_section_id`, `CourseQuiz`.`course_lecture_id`, `CourseQuiz`.`heading`, `CourseQuiz`.`content`, `CourseQuiz`.`publish`, `CourseQuiz`.`created`, `CourseQuiz`.`modified` FROM `1337iot`.`course_quizzes` AS `CourseQuiz` WHERE `CourseQuiz`.`course_section_id` IN (2817, 2818, 2819, 2820, 2821, 2822, 2823, 2825, 2826, 2827) 000
11SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`category_id`, `Course`.`language_id`, `Course`.`instruction_level_id`, `Course`.`title`, `Course`.`subtitle`, `Course`.`keywords`, `Course`.`summary`, `Course`.`lincence_logo`, `Course`.`lincence_url`, `Course`.`source_title`, `Course`.`source_url`, `Course`.`coverimage`, `Course`.`promovideo`, `Course`.`visibility`, `Course`.`pricetype`, `Course`.`price`, `Course`.`privacy_type`, `Course`.`publishstatus`, `Course`.`status`, `Course`.`created`, `Course`.`modified`, `InstructionLevel`.`id`, `InstructionLevel`.`title`, `InstructionLevel`.`created`, `InstructionLevel`.`modified` FROM `1337iot`.`courses` AS `Course` LEFT JOIN `1337iot`.`instruction_levels` AS `InstructionLevel` ON (`Course`.`instruction_level_id` = `InstructionLevel`.`id`) WHERE `Course`.`id` = 1545 AND `Course`.`status` = '1' LIMIT 1110
12SELECT `CourseAudience`.`id`, `CourseAudience`.`course_id`, `CourseAudience`.`title`, `CourseAudience`.`created`, `CourseAudience`.`modified` FROM `1337iot`.`course_audience` AS `CourseAudience` WHERE `CourseAudience`.`course_id` = (1545) 000
13SELECT `CourseGoal`.`id`, `CourseGoal`.`course_id`, `CourseGoal`.`title`, `CourseGoal`.`created`, `CourseGoal`.`modified` FROM `1337iot`.`course_goals` AS `CourseGoal` WHERE `CourseGoal`.`course_id` = (1545) 000
14SELECT `CourseRequirement`.`id`, `CourseRequirement`.`course_id`, `CourseRequirement`.`title`, `CourseRequirement`.`created`, `CourseRequirement`.`modified` FROM `1337iot`.`course_requirements` AS `CourseRequirement` WHERE `CourseRequirement`.`course_id` = (1545) 000
15SELECT `Userdetail`.*, `User`.`id` FROM `1337iot`.`users` AS `User` LEFT JOIN `1337iot`.`userdetails` AS `Userdetail` ON (`Userdetail`.`user_id` = `User`.`id`) WHERE `User`.`id` = 3385 LIMIT 1110
16SELECT `Course`.`id`, `Course`.`title`, `Course`.`subtitle`, `Course`.`coverimage`, `Course`.`summary`, `Course`.`price`, `Course`.`user_id`, (select count(*) as countstudent from user_learning_courses as UserLearningCourse where `UserLearningCourse`.`course_id` = `Course`.`id`) AS `Course__students`, (select avg(rating) from course_reviews CourseReview where `CourseReview`.`course_id` = `Course`.`id`) AS `Course__avgrating`, (select concat(`Userdetail`.`first_name`,' ',`Userdetail`.`last_name`) as name from userdetails as Userdetail where `Userdetail`.`user_id` = `Course`.`user_id`) AS `Course__name` FROM `1337iot`.`courses` AS `Course` WHERE `Course`.`user_id` = 3385 AND `Course`.`publishstatus` = 'Publish' ORDER BY (select count(*) as countstudent from user_learning_courses as UserLearningCourse where `UserLearningCourse`.`course_id` = `Course`.`id`) desc LIMIT 2220
17SELECT COUNT(*) AS `count` FROM `1337iot`.`courses` AS `Course` LEFT JOIN `1337iot`.`users` AS `User` ON (`Course`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`languages` AS `Language` ON (`Course`.`language_id` = `Language`.`id`) LEFT JOIN `1337iot`.`instruction_levels` AS `InstructionLevel` ON (`Course`.`instruction_level_id` = `InstructionLevel`.`id`) WHERE `Course`.`user_id` = 3385 AND `Course`.`publishstatus` = 'Publish'110
18SELECT `Userdetail`.`user_id`, `Userdetail`.`first_name`, `Userdetail`.`last_name`, `Userdetail`.`image` FROM `1337iot`.`user_learning_courses` AS `UserLearningCourse` Inner JOIN `1337iot`.`bundles` AS `Bundle` ON (`Bundle`.`status` = 1 AND `UserLearningCourse`.`bundle_id` = `Bundle`.`id`) LEFT JOIN `1337iot`.`userdetails` AS `Userdetail` ON (`UserLearningCourse`.`user_id` = `Userdetail`.`id`) WHERE `UserLearningCourse`.`course_id` = 1545 LIMIT 1414140
19SELECT COUNT(*) AS `count` FROM `1337iot`.`user_learning_courses` AS `UserLearningCourse` LEFT JOIN `1337iot`.`users` AS `User` ON (`UserLearningCourse`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`courses` AS `Course` ON (`UserLearningCourse`.`course_id` = `Course`.`id`) Inner JOIN `1337iot`.`bundles` AS `Bundle` ON (`Bundle`.`status` = 1 AND `UserLearningCourse`.`bundle_id` = `Bundle`.`id`) WHERE `UserLearningCourse`.`course_id` = 1545119
20SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`category_id`, `Course`.`language_id`, `Course`.`instruction_level_id`, `Course`.`title`, `Course`.`subtitle`, `Course`.`keywords`, `Course`.`summary`, `Course`.`lincence_logo`, `Course`.`lincence_url`, `Course`.`source_title`, `Course`.`source_url`, `Course`.`coverimage`, `Course`.`promovideo`, `Course`.`visibility`, `Course`.`pricetype`, `Course`.`price`, `Course`.`privacy_type`, `Course`.`publishstatus`, `Course`.`status`, `Course`.`created`, `Course`.`modified`, (select count(*) as countstudent from user_learning_courses as UserLearningCourse where `UserLearningCourse`.`course_id` = `Course`.`id`) AS `Course__students`, (select avg(rating) from course_reviews CourseReview where `CourseReview`.`course_id` = `Course`.`id`) AS `Course__avgrating`, (select concat(`Userdetail`.`first_name`,' ',`Userdetail`.`last_name`) as name from userdetails as Userdetail where `Userdetail`.`user_id` = `Course`.`user_id`) AS `Course__name` FROM `1337iot`.`courses` AS `Course` WHERE `Course`.`id` = 1545 AND `Course`.`publishstatus` = 'Publish' LIMIT 1110
21SELECT `UserLearningCourse`.`id`, `UserLearningCourse`.`user_id`, `UserLearningCourse`.`course_id`, `UserLearningCourse`.`completed`, `UserLearningCourse`.`created`, `UserLearningCourse`.`bundle_id`, `UserLearningCourse`.`modified`, `UserLearningCourse`.`payerid`, `User`.`id`, `User`.`fbid`, `User`.`username`, `User`.`password`, `User`.`remembertoken`, `User`.`loginfrom`, `User`.`status`, `User`.`passwordstatus`, `User`.`newsletter`, `User`.`profiletype`, `User`.`created`, `User`.`modified`, `Course`.`id`, `Course`.`user_id`, `Course`.`category_id`, `Course`.`language_id`, `Course`.`instruction_level_id`, `Course`.`title`, `Course`.`subtitle`, `Course`.`keywords`, `Course`.`summary`, `Course`.`lincence_logo`, `Course`.`lincence_url`, `Course`.`source_title`, `Course`.`source_url`, `Course`.`coverimage`, `Course`.`promovideo`, `Course`.`visibility`, `Course`.`pricetype`, `Course`.`price`, `Course`.`privacy_type`, `Course`.`publishstatus`, `Course`.`status`, `Course`.`created`, `Course`.`modified`, (select count(*) as countstudent from user_learning_courses as UserLearningCourse where `UserLearningCourse`.`course_id` = `Course`.`id`) AS `Course__students`, (select avg(rating) from course_reviews CourseReview where `CourseReview`.`course_id` = `Course`.`id`) AS `Course__avgrating`, (select concat(`Userdetail`.`first_name`,' ',`Userdetail`.`last_name`) as name from userdetails as Userdetail where `Userdetail`.`user_id` = `Course`.`user_id`) AS `Course__name`, `Bundle`.`id`, `Bundle`.`title`, `Bundle`.`is_expired`, `Bundle`.`status`, `Bundle`.`expired_on`, `Bundle`.`created`, `Bundle`.`modified` FROM `1337iot`.`user_learning_courses` AS `UserLearningCourse` LEFT JOIN `1337iot`.`users` AS `User` ON (`UserLearningCourse`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`courses` AS `Course` ON (`UserLearningCourse`.`course_id` = `Course`.`id`) Inner JOIN `1337iot`.`bundles` AS `Bundle` ON (`Bundle`.`status` = 1 AND `UserLearningCourse`.`bundle_id` = `Bundle`.`id`) WHERE `UserLearningCourse`.`user_id` IS NULL AND `UserLearningCourse`.`course_id` = 1545 LIMIT 1001
22SELECT `CourseUserQuestion`.`id`, `CourseUserQuestion`.`user_id`, `CourseUserQuestion`.`course_id`, `CourseUserQuestion`.`course_lecture_id`, `CourseUserQuestion`.`heading`, `CourseUserQuestion`.`question`, `CourseUserQuestion`.`created`, `CourseUserQuestion`.`modified`, (select `Userdetail`.`first_name` from userdetails Userdetail where `Userdetail`.`user_id` = `CourseUserQuestion`.`user_id`) AS `CourseUserQuestion__firstname`, (select `Userdetail`.`last_name` from userdetails Userdetail where `Userdetail`.`user_id` = `CourseUserQuestion`.`user_id`) AS `CourseUserQuestion__lastname`, (select lecture_index from course_lectures where `course_lectures`.`id` = `CourseUserQuestion`.`course_lecture_id`) AS `CourseUserQuestion__lectureindex`, `User`.`id`, `User`.`fbid`, `User`.`username`, `User`.`password`, `User`.`remembertoken`, `User`.`loginfrom`, `User`.`status`, `User`.`passwordstatus`, `User`.`newsletter`, `User`.`profiletype`, `User`.`created`, `User`.`modified`, `Course`.`id`, `Course`.`user_id`, `Course`.`category_id`, `Course`.`language_id`, `Course`.`instruction_level_id`, `Course`.`title`, `Course`.`subtitle`, `Course`.`keywords`, `Course`.`summary`, `Course`.`lincence_logo`, `Course`.`lincence_url`, `Course`.`source_title`, `Course`.`source_url`, `Course`.`coverimage`, `Course`.`promovideo`, `Course`.`visibility`, `Course`.`pricetype`, `Course`.`price`, `Course`.`privacy_type`, `Course`.`publishstatus`, `Course`.`status`, `Course`.`created`, `Course`.`modified`, (select count(*) as countstudent from user_learning_courses as UserLearningCourse where `UserLearningCourse`.`course_id` = `Course`.`id`) AS `Course__students`, (select avg(rating) from course_reviews CourseReview where `CourseReview`.`course_id` = `Course`.`id`) AS `Course__avgrating`, (select concat(`Userdetail`.`first_name`,' ',`Userdetail`.`last_name`) as name from userdetails as Userdetail where `Userdetail`.`user_id` = `Course`.`user_id`) AS `Course__name`, `CourseLecture`.`id`, `CourseLecture`.`course_id`, `CourseLecture`.`course_section_id`, `CourseLecture`.`heading`, `CourseLecture`.`course_description`, `CourseLecture`.`content`, `CourseLecture`.`content_type`, `CourseLecture`.`content_title`, `CourseLecture`.`content_external_link`, `CourseLecture`.`content_source`, `CourseLecture`.`supplimentary_material`, `CourseLecture`.`lecture_index`, `CourseLecture`.`prev`, `CourseLecture`.`live_status`, `CourseLecture`.`file1_upload`, `CourseLecture`.`file2_upload`, `CourseLecture`.`created`, `CourseLecture`.`modified` FROM `1337iot`.`course_user_questions` AS `CourseUserQuestion` LEFT JOIN `1337iot`.`users` AS `User` ON (`CourseUserQuestion`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`courses` AS `Course` ON (`CourseUserQuestion`.`course_id` = `Course`.`id`) LEFT JOIN `1337iot`.`course_lectures` AS `CourseLecture` ON (`CourseUserQuestion`.`course_lecture_id` = `CourseLecture`.`id`) WHERE `CourseUserQuestion`.`course_id` = 1545 AND `CourseUserQuestion`.`user_id` IS NULL ORDER BY `CourseUserQuestion`.`created` desc001