Excel & PowerPoint for Business - For Medical Field
4.5 (67 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
224 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel & PowerPoint for Business - For Medical Field to your Wishlist.

Add to Wishlist

Excel & PowerPoint for Business - For Medical Field

Everything every Medical Rep , Senior , Team Leader and Manager have to know about Excel & PowerPoint for business
4.5 (67 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
224 students enrolled
Last updated 6/2017
Current price: $12 Original price: $20 Discount: 40% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 6 hours on-demand video
  • 14 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Create and manage Doctors list
  • Create and manage Sales sheet
  • Create total sheet for Quarters and full year sales
  • Calculate your target and manage all the process professionally
  • Create and manage Daily / Weekly Sheets
  • Use charts and Graphs in a professional way
  • using pie chart for Market Share analysis
  • Use Pivot tables for business analysis
  • Use data Filters , and Sorting data
  • Use Conditional formatting
  • protect work sheets with all possible ways
  • Create and design your presentation
  • All PowerPoint basic tools for amazing look and feel for your presentation
  • Use shapes , graphs , charts , pictures , backgrounds and themes
  • Use master view to save time
  • Objects animation and transitions
  • Set timing for your presentation
  • Use SmartArts
  • protect presentations
  • using powerpoint templates
View Curriculum
  • nothing .. just have Microsoft Office 2007 or 2010 or 2013 installed

We providing Online Courses to all who are working in the medical field ( medical rep , senior , supervisor , team leader
or any managerial level ) with all they need to know about Microsoft
office products (excel and  PowerPoint ) that related to their
career and job needs

-- This course is specially customized for Medical reps and all workers in sales field.

-- We are realizing how busy you are that’s why we are not distracting
you with useless details and stick to the points that will serve you ,
your business field and your daily tasks directly

نحن نقدم
كورسات اون لاين متخصصة للعاملين بمجال المبيعات بوجه عام و والخاصة
بالمجال الدوائى بشكل خاص فهى كورسات مخصصة لخدمة مندوبى الدعاية ,
والمدريين فى مجال المبيعات بشكل عام بشركات الادوية لتقدم دورات فى
برمجيات مايكروسوفت اوفيس (اكسيل , ورد , باوربوينت ) التى تخدم احتياج
الوظيفة والمهام التى يتطلبها مجال المبيعات .
هذه الكورسات صممت خصيصا للعاملين بمجال مندوبى الدعاية الدوائية ومفيد ايضا للعاملين بمجال المبيعات بشكل عام

نحن على علم تام بمدى مشغولياتكم ولذلك صممت هذه الكورسات لخدمة
احتياجاتكم فقط دون الخوض فى تفاصيل بيعيده تمام البعد عن مجال عملكم فنحن
ملتزمون بتقديم مادة علمية احترافية تخدم احتياج عملكم وتسهل اتمام مهامك
اليومية فيما يخص برامج مايكروسوفت اوفيس اكسيل و باوربوينت

Who is the target audience?
  • anyone working in sales field (Sales rep , Sales manager , etc )
  • Medical Reps
  • Managers in the medical field
  • Students in Sales , Commerce major
  • Student at the College of Pharmacy and Veterinary Medicine and Science
Compare to Other IT Certification Courses
Curriculum For This Course
69 Lectures
1- Excel for Medical Rep : Getting Started
4 Lectures 16:40

Using fill handle to save time

Using Freezing pane

How to take screenshoots from Excel to PowerPoint Presentations
Sorting and Filtering Data
3 Lectures 19:33
Sort Data

Using Conditional formatting for business analysis
Market Share Dashboard
2 Lectures 20:08
What is Market Share mean ?

Start creat marketshare dashboard step by step
Using Charts
6 Lectures 29:27
Analyze your data by using Column Charts

Modify chart Design

Modify chart Layout

Move your data and charts from Excel to Powerpoint in dynamic way

Using SparkLines for Fast Data Analysis
Using PivotTable/Chart for advanced business analysis
3 Lectures 22:13
Using Pivot table to analyze your sales , work performance

Advanced techniques to filter your data by using pivot table slicer

Using Pivot Chart to Analyze & present ur sales visually
Main Sheets for Medical Reps
7 Lectures 01:12:22
Create and manage SalesSheet

Calculate totals and add functions to Salessheet

Create and manage Doctor List

Create and manage Daily/Weekly Visits

Create &Manage Coverage Sheet (automatically generate monthly coverage sheet)

Create Total Sheet that collect data from all other sheets

Accomplish your target in one week by using 20/80 Rule
Protect your excel sheets
1 Lecture 10:06
Protect Your Excel Sheets with all possible ways
2-PowerPoint for Medical Rep:Presentation bases
3 Lectures 10:20
Save presentation

Save presentation as a picture

Save presentation as a PDF
Format Text and Paragraphs
12 Lectures 24:28
Change Font Style

Change Font Size

Change Font Color

Bold , Italic and Underline

Setup Character Spacing

Remove Formatting

Change Paragraph Spacing

Bullets and Numbering

Using Format Painter

Undo and Redo - Restore previous actions without repeating
Create and Manage Charts and SmartArts
8 Lectures 45:47
Charts - Column Chart

Design Charts

Format Charts

Chart Layout

Using Pie Chart

Pie Chart Options

Using SmartArt to present your data

Format SmartArt
6 More Sections
About the Instructor
Officeawy for learning solutions
4.6 Average rating
212 Reviews
1,424 Students
5 Courses
High Quality Training

Officeawy is a Egyptian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos .We specilized in Microsoft office products , The emphasis is on teaching real life skills that are essential in today's commercial environment. All Officeawy courses are taught by experts who have a true passion for teaching and certified from Microsoft to teach these materials