panel_start Course content panel_end
Incl Google Sheets
Course Content-
Microsoft Excel is one of the most ubiquitous /widely
used software in workplaces across the world. Learning to confidently operate Excel
has become crucial for success in the increasingly digitized corporate world.
This practical, hands on workshop will set you
up with a solid foundation to gather,
transform, analyze and visualize data.
Easy Editing Techniques
- Using the Advanced Filter
and AutoFilter to display the information you need
- Controlling multiple
ranges with AutoFill
- Extracting filtered
ranges
- Using multiple criteria
for creating advanced filters, and list management
- Time-saving keyboard
shortcuts
Sharing Workbooks
- Setting up shared
workbooks
- View users sharing a
workbook
- Change the updated
frequency
- Merging shared files
- Creating pull-down menus
for shared workbooks
Formulas and Functions
- Building complex formulas
quickly and easily
- Using the Function
Palette and cutting your work time in half
- Using key logic functions
IF, AND, OR and NOT to make data more usable
- Creating conditional
formulas
- Using MATCH, INDEX,
VLOOKUP and HLOOKUP in large worksheets
- Manipulating text entries
with Excel®’s extensive set of functions and formulas
Using Analytical Options
- Using Goal Seek and
Solver
- Working with scenarios to
analyze data and equations
- Working with view options
Charting, Tables, and Lists
- Using auditing to create
a visual map of your data
- Creating custom charts
for added interest and relevance to your reporting
- Working with data forms
- Pivot Tables –
Summarizing your data
- Creating data tables
- How to create and manage
PivotCharts and Tables
Special Section: Data Exchange, the Web and Excel
- How to do a quick
Internet search for informationâ€â€For solving excel problems
- Creating hyperlinks in your
spreadsheet that will take users straight to a Web page
- How to publish your Excel
charts and data on the Web more quickly
Working with Google Sheets
- Connect multiple Google Sheets together using a single formula
- Learn formulas that work in both Google sheets & Excel!
- Analyze data sets with ease using complex functions &
formulas
- Converting
other files formats such as Microsoft Excel to Google Sheets
Pivot
Tables – Effective summarized representation of data using Pivot
Tables
panel_start Time & Duration panel_end
Timings : 2:30 pm to 5 pm
Duration : 3 Sessions of 2 hours 30 minutes each
panel_start How to Register panel_end
How to Register :
- Fees: Rs. 3,500/- + 18% GST Per Person
- Please write to register@princetonacademy.co.in / Call -022 67256200/ 9769579090
- Mention the name of participant, company, contact details.
- Fees include course material, participation certificate etc.
Course Content
Please add detailed course content using the "Course Content" field in the course editor.
DOWNLOAD COURSE CONTENTS
Please click the button below to download the course content. You'll need to provide your contact information to receive the document.
REQUEST MORE INFORMATION
Please fill out the form below to request more information about this course.