Excel & PowerPoint for Business - For Medical Field
4.6 (60 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.
204 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.6 (60 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.
204 students enrolled
Last updated 6/2017
Arabic
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 14 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • nothing .. just have Microsoft Office 2007 or 2010 or 2013 installed
Description

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
69 Lectures
05:51:33
+
1- Excel for Medical Rep : Getting Started
4 Lectures 16:40

Using fill handle to save time
04:17

Using Freezing pane
04:08

How to take screenshoots from Excel to PowerPoint Presentations
01:29
+
Sorting and Filtering Data
3 Lectures 19:33
Sort Data
03:07


Using Conditional formatting for business analysis
09:57
+
Market Share Dashboard
2 Lectures 20:08
What is Market Share mean ?
03:13

Start creat marketshare dashboard step by step
16:55
+
Using Charts
6 Lectures 29:27
Analyze your data by using Column Charts
07:17

Modify chart Design
04:32

Modify chart Layout
01:41


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

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

Advanced techniques to filter your data by using pivot table slicer
03:59

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

Calculate totals and add functions to Salessheet
06:02

Create and manage Doctor List
09:11

Create and manage Daily/Weekly Visits
16:02

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

Create Total Sheet that collect data from all other sheets
06:13

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

Save presentation as a picture
03:37

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

Change Font Size
01:43

Change Font Color
01:06

Bold , Italic and Underline
02:41

Setup Character Spacing
00:57

Remove Formatting
01:09

Change Paragraph Spacing
02:21


Bullets and Numbering
03:06


Using Format Painter
02:31

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

Design Charts
06:32

Format Charts
01:57

Chart Layout
12:21

Using Pie Chart
03:00

Pie Chart Options
02:12

Using SmartArt to present your data
05:05

Format SmartArt
07:25
6 More Sections
About the Instructor
Officeawy for learning solutions
4.7 Average rating
203 Reviews
1,404 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