Únete y Recibe Nuestras Publicaciones Por Correo (GRATIS)

Escribe tu dirección de correo:

Verifica en el correo no deseado.

FACEBOOK

Mostrando las entradas con la etiqueta Microsoft Office. Mostrar todas las entradas
Mostrando las entradas con la etiqueta Microsoft Office. Mostrar todas las entradas

DOWNLOAD COURSE
Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Eng Course- Excel 2010: Basics Learning Guide- Download Free PDF


DOWNLOAD COURSE
Contents:
Course Information  ...................................................................................... 3
Chapter 1 – Excel Advanced Concepts.......................................................... 4
Chapter 2 – Excel & the Internet................................................................... 9
Chapter 3 – Functions................................................................................. 18
Chapter 4 –The =IF Functions ..................................................................... 37
Chapter 5 – Using Functions to Clean & Crunch data ................................. 42
Chapter 6 – Data Commands...................................................................... 58
Chapter 7 – Macros..................................................................................... 95
Chapter 8 – Solver..................................................................................... 100
Chapter 9 – Example Case Studies............................................................ 103
1. Gantt Chart 104
2. Combo Chart 105
3. Organizational Chart 106
4. Portfolio – Investment Mix and Performance Tracking 107
Chapter 10 –Digging Deeper into Excel’s Fundamentals .......................... 122
Chapter 11 –XML ...................................................................................... 128
Chapter 12 – Using Excel with Your Accounting System........................... 136
Appendix ‐ Instructor’s Biography ............................................................ 173
Course Evaluation Form............................................................................ 175


Eng Course- Excel For Advanced Users- Download Free en PDF


DOWNLOAD COURSE

 TABLE OF CONTENTS 
SECTION 1. TABLE OF CONTENTS........................................ 4
INTRODUCTION.........................................................................................9
How To Use This Guide.........................................................................9
Instructions ........................................................................................9
SECTION 2. THE BASICS.................................................... 11
WHAT IS POWERPOINT? ...........................................................................12
Launching Powerpoint ........................................................................13
The Powerpoint Screen.......................................................................13
Toolbars...........................................................................................15
Status Bar ........................................................................................16
Task Pane ........................................................................................16
ABOUT SMART TAGS.................................................................................16
Autocorrect Options Smart Tag............................................................17
Paste Options Smart Tag ....................................................................17
Autofit Options Smart Tag ..................................................................17
Automatic Layout Options Smart Tag ...................................................17
TO ACCESS HELP: ....................................................................................18
SECTION 3. CREATING A PRESENTATION.......................... 19
CREATING PRESENTATIONS .......................................................................20
Adding New Slides .............................................................................21
Entering And Editing Text ...................................................................21
Multi-Level Bullets .............................................................................23
Editing Text ......................................................................................24
Adding Free Form Text .......................................................................24
CHANGING THE SLIDE LAYOUT ...................................................................25
SAVING A PRESENTATION .........................................................................26
Name And Save A Presentation File......................................................26
Subsequent Saves .............................................................................27
Saving A Presentation With A New Name ..............................................27
SECTION 4. POWERPOINT VIEWS ..................................... 29
DIFFERENT WAYS TO VIEW SLIDES.............................................................30
The Normal (Tri Pane) View ................................................................31
WORKING WITH OUTLINE VIEW.................................................................32
The Outline Tab ................................................................................32
Creating Slides In Outline View ...........................................................32
The Outlining Tools............................................................................33
Expand Or Collapse Text ....................................................................33
Demote Or Promote Text ....................................................................34
Creating A Summary Slide ..................................................................34
Importing An Outline .........................................................................35
Add A Slide From Another Presentation File ...........................................36
SLIDE SORTER VIEW................................................................................37
Working With Slide Sorter View ...........................................................37
Moving & Copying Slides In A Presentation............................................38
Moving And Copying Between Presentations ..........................................39
View In Black And White.....................................................................40
To Print Grayscale .............................................................................41
SLIDE SHOW VIEW ..................................................................................42
Viewing A Slideshow ..........................................................................42
Print Preview ....................................................................................43

Eng Course- Power Point 2010- Download Free in PDF



DOWNLOAD COURSE

 Find popular commands quickly on the ribbon.
 Learn how to use the File menu (Microsoft
Office Backstage view).
 Learn essential tasks such as opening existing
workbooks, creating new workbooks, setting up
a spreadsheet, formatting, saving, and printing.

Eng Course- Excel 2010- Download Free in PDF

Ultimos Documentos en PDF